Hi, I have developed a database for a small electronic shop. It works quite well except that I need to address to some areas such as managing items...

Is there a club membership management template for Access?

Hello all, I created a database on a corporate server with 20 users, 4 tables, 30 forms (that contains simple code) and 20 queries. Size prior to split is 14...

The following code worked for a while and now I get an error: Couldn't create; no modify design permission for table or query Any Ideas. Thanks in...

Hi folks, When i have multiple table links together, i make the link in the query each time i need it. I have a lot of query with different kind of...

i have made a mailing database in access. when i merge it with an msword document embedded with merge fields, no matter what i do, it only generates a list of...

i have made a mailing database in access. when i merge it with an msword document embedded with merge fields, no matter what i do, it only generates a list of...

I'm trying to set up referential integrity between two tables. Here's what I have: Table 1: Primary key is made up of two fields: Field 1: Month * Field 2:...

I have a air conditioner friend who has scanned all of his invoices into his PC. They are in folders by town, then street address. He has about 4000 of...

I have a database that we use to track circuit status, to this point we have been using it as a one to one relationship. Now we need to track what are called...

I there any way to set a date field to allow incomplete dates? Most of the dates I have would have a format like: 10-25-2004 But sometimes It could be...

Hi I have a problem With Access, I have 1 combobox and 1 subform and I want to filter the objects in subform due to combo choice, but I didn't know how start...

How do you create a header on a table? Thanks in advance

My objective of this project is to have my co-workers, who are not familiar with Access, to input data in Excel. Meanwhile I will either establish a link or a...

Am working in an Access tracking program at my office. I have to go through several levels to finally get to the cost information on a tabbed screen behind...

Two types of numbers. First type: I have a 20 digit number that will be scanned into the database and it can store with or without spaces (I am presently...

Hello, I have updated a text field with one of a memo field. There are entries that have been truncated. Is there a way to search for all fields with 255...

Here's the code to create a table "tblTest" and create two fields (ID and Name). I want to set the first field "ID" as Primairykey and also set it as...

I cannot print the table design in Access 2000 Database Table.Is there a way to print the table design to printer

I had a value list for several fields. When I created a graph the plot points were not correct so I deleted the value list for those fields. Now all of the...