Hi. I’m trying to create a new db. And when I think of the trauma I had initially with my last db, I realize I could really use some input during the...

Can anyone please tell me where i can find good basic information on how to build an accounting (invoice, payment) database? i have a client database that i...

I want to link to my business contacts in BCM. I can do this on fine on my personal computer but can't do it on a different computer. In Access I set up the...

I have seen this in other programs so I know it's possible. Is there a way to populate a combo box to look something like: Utilities Water Gas ...

Hi, I am probably missing something obvious here. I have personal data for a form broken down into 7 different tables since there are so many fields. The PK...

i put "=Sum(Abs()" in controlsource but it is not working.How can i do it right.plz help.

my table tblClients has too many indexes. I've deleted and deleted indexes just to make the tables that I absolutely must enforce RI. Some I will just have...

Very much a newb with access and have the need to improve upon a db created by another that has grown in popularity by the big guy (boss)... looking at it i...

Hi: I have a question on how to set up running total field in a table. More specifically, i have a "Bank" master table and I want the "Balance to date"...

I have a "Check Work" button a user can click to see if they've completed a record. Can anyone show me a bit of code that simply pops up a list of skipped...

I'm in design view creating a table. When I tried to save the table, I get the following error message: Cannot define field more than once. (Error 3191)...

Can I use Access to store workplan that have the following structure? If yes how? N° Main Activities Year 2009 Lead (Support) Jul Aug Sep ...

I have an existing inventory database that is used for spare parts for other equipment. There are currently about 7000 spare parts for about 50 different...

Is there a way to have Access display user-created fields from Outlook? I have added user-defined fields to Outlook 2007 to capture addtional contact...

Hello, I have been challenged with making a yes/no field either stay on or off based and contract end date field in my table. I am using Access 2003. So for...

I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a...