25 posts tagged with msaccess.
Displaying 1 through 25 of 25. Subscribe:

How do I handle the contract work

I have been recently out of job since july, and now have an opportunity to get a contract work for an NGO. [more inside]
posted by jassi on Oct 11, 2013 - 1 answer

Data overload

I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore. [more inside]
posted by nosila on May 30, 2013 - 6 answers

MS Access remains not user friendly for printing

I've switched my Access 2010 database from using Switchboard to using a Navigation Form. It's prettier and faster and it makes it impossible to print reports properly. [more inside]
posted by jeather on Nov 7, 2012 - 6 answers

Accessible Access Training?

Microsoft Access Training/Classes in New York City (Manhattan), or your best suggestion of online materials. [more inside]
posted by rosswald on Jul 20, 2012 - 4 answers

Classes for programming Access forms - Toronto

Where in Toronto can I take a class on programming Access 2003 forms? [more inside]
posted by jb on May 24, 2012 - 1 answer

Formatting MS Access report with subreports and subforms in pivot views

Microsoft Access: Help me streamline (or completely automate) creating weekly reports that include tables and charts. I'm almost there, but I just can't wrangle the formatting. Is it me or is it Access? [more inside]
posted by GPF on Mar 17, 2012 - 6 answers

MS Access is making things harder than they need to be

MS Access: I have responsibility for a large database in Access 2007. How can I create a dev copy to experiment with changing forms/layout/queries, etc. which shows record data, but does NOT link to and make changes to data in the tables in the "real" original database? I do not know SQL. [more inside]
posted by cuddles.mcsnuggy on Jun 9, 2011 - 4 answers

Build an Access database to display survey results

I've never used Access; I'm a SQL snowflake and don't take naturally to its norms. Pretend I'm your technology-challenged elderly relative, and tell me how to set up tables to run queries on survey results. [more inside]
posted by heigh-hothederryo on May 14, 2011 - 4 answers

Need help formatting an Access report from a query and SQL help

I'm having trouble formatting a report in Access that ONLY shows checkboxes that are not checked. I probably need some help on the SQL front. [more inside]
posted by desjardins on Dec 20, 2010 - 4 answers

MSAccess, php and empty date/time fields

How do I check (using php) the existence of data in a date/time field in an access database? [more inside]
posted by monkey closet on Oct 11, 2010 - 8 answers

Your advice for finding a new databse guru, please...

I need to find a new database guy/gal. Where do I look and how will I know when I've found a good one? [more inside]
posted by Vavuzi on Jul 30, 2010 - 15 answers

MS Access: copy data?

I can't get my Access database to do what I thought I could. Lots of details inside, again. [more inside]
posted by jeather on Jun 21, 2010 - 5 answers

Access database design help

I need to create an Access 2007 database to confirm tuition payments for students and I am not sure how to set up the tables. Details within. [more inside]
posted by jeather on May 5, 2010 - 2 answers

AccessN00bFilter: How do I replace data in a report, and limit the results in my report to a single day/week/month?

AccessN00bFilter: How do I replace data in a report, and limit the results in my report to a single day/week/month? [more inside]
posted by Seeba on Apr 29, 2010 - 2 answers

How do I make a DB faster?

MS Access: How do I turn my database from a tortoise to a hare? (Or, if not a hare, a chipmunk?) [more inside]
posted by Vavuzi on Mar 26, 2010 - 8 answers

How do I validate a field in Access to DEMAND unique values?

MS Access Filter: How do I set a validation rule for a field in a form or table so that Access will immediately recognize that the same value has been used before and tell the user to generate a unique value? [more inside]
posted by man down under on Jan 11, 2010 - 4 answers

Querying the hive mind...

DatabaseFilter: I know more about Access than the average person, but I'm at the point where I need to know more than what I am finding on the Access db sites and in books. I need a faster and more reliable response than I would get from posting on forums. [more inside]
posted by sio42 on Jan 11, 2010 - 8 answers

How to export csv with variable number of columns?

Using a relational table in a one-to-many relationship in Access, what is the best way to export a csv file with one row per record (from the one half) with a variable number of columns (from the many half)? [more inside]
posted by JeremiahBritt on Aug 19, 2009 - 6 answers

MS Access...Access Problem

Microsoft Access question: I have an Access 2007 database hosted on a server. I have 10 staff members who use the database. I can get in the database even if someone else is in it. One of my coworkers cannot. Is this typical? [more inside]
posted by bibbit on Jul 14, 2009 - 9 answers

Alternatives to MS Access?

MS Access Alternatives? I have a user that needs to keep data in a relational database, but I'd like to advise her against Access because of it's various limitations. She has no programming knowledge. Any suggestions? [more inside]
posted by SpecialK on May 19, 2009 - 13 answers

Help a stupid noob find a good MySQL GUI program

Stupid MySQL noob question: is there a free/free (or at least free-as-in-beer) win32 MySQL frontend that will show graphical representations of tables, allow drag-and-drop editing of their relationships, actually import all of my data, and use MySQL vocabulary and syntax for its queries? [more inside]
posted by Tuwa on Feb 18, 2007 - 13 answers

MS Access query - finding the reocrd with a maximum value

In MsAccess, how can I choose the record where a certain value is maximum or minimum? [more inside]
posted by buildmyworld on Jan 23, 2007 - 3 answers

I seek it here, I seek it there. But mainly in this column.

Calling MS Access wizards... A batch find and replace conundrum. [more inside]
posted by snailer on Jul 11, 2006 - 13 answers

Access Database Problems

Access database problems... [more inside]
posted by benjh on Jan 7, 2005 - 9 answers

MS Access

MSAccessFilter: I give up...how can I have the current selection in one control dynamically re-configure the choices available in another? [more inside, obviously] [more inside]
posted by LairBob on Aug 20, 2004 - 5 answers

Page: 1