Hi All A database I created for a client some years ago has a macro which contains an append query. This macro repeats itself until a condition is met and...

I have setup 2 separate queries to get specific totals. It is impossible to combine them into 1, as they both use 1 key field with different criteria to get...

I see two weakness in my db design. BTW I'm self taught so there are two I'm aware of and many I'm not. I make a folder for my test db I can only run so many...

I have upgraded my frontend & backend .mdb from 2000 to 2003. Do I also upgrade the .mdw in the same way? Thanks so much. Mary

I am trying to run a scheduled task to run a macro with updates, but have to enter my Password as soon as Access opens, is there a way around this so it can...

I need a Bill of Material template. I have built everything but this in Access 2002. Can someone please help me?

I have most of my tables in my front-end Access 'linked' to a sql server back- end. I have some reports that take a couple of minutes to run (sql reports, not...

start here maybe: http://office.microsoft.com/en-us/templates/TC102512251033.aspx?CategoryID=CT102512241033 -- Message posted via...

Correct me if I misunderstood, but I read that one should index fields that are used as criteria in queries. With this in mind, when one does a caculated...

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

I have the same problem. All of the underlying Excel spreadsheets are maintained by other people. If one them opens the file for editing, you're locked out. I...

I have a small database and I want to record, in a table field, the date at which a record is added (but not edited). I want this to be permanent. Should I...

Can anyone advise me how to create a search field to open first and find specific record to then open

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

I didn't normalize my database as well as I wish I had. I have a table called EmpInfo that's built essentially as...

I thought it best to start new from the thread "Items Table help" that I originally posted. Original Post: I have a photography business that I am setting...

I am designing a custom database for tracking various pieces of software we use at my job. Each user has access to different pieces of software and many...

Hi All, I am doing a project to get started on Access. I am a tinkerer, and have a lab and garage full of storage boxes, component chests, tackle boxes,...

Is there code out there that can create an audit log on Tables? The only thing I've seen out there is based on Forms, not Tables. Thanks, Gina Grafilo --...