Hello, I have two fields, one is Name and the other is Site. The Name field can contain pharmacy, pharmacies, drug, or drugs in any length of text string,...

Where can I downlaod an Access 2003 templagte with User-Level expalined.. thanks

hi, I have an primary key autonumber field that goes from 1, 2, 3... - 115+ records. I have manually deleted alot of rows till currently left about 45...

I have a report and a sub report running from two queries for which the criteria in both is Betweenn one date and another date. When running the report,...

I need help with planning and creating a good data base in Access 2007 for the following situation. There are approximately 50 employees. On each day they...

This is similar to an earlier thread about Teams and Games. I have a table for Firms which contains Subcontractors, Suppliers, Owners, Designers, Insurance...

Hey you guys. I'm really stuck. I am trying to design tables for work. The problem is that there are several vendors/suppliers that have a different...

Suggestion: When you have a website such as this forum, make it when you click on a link it usually opens the page that you clicked for instead of very...

What is the easiest way of amending a Field in a table that has thousands of entries in it to be Autonumber? I have managed to copy structure and amend an...

setting up fields and would like drop down lists rather than typing in same information constantly

I have developed an application in Acces using DAO. I want to be with the times and convert to ADO. Is There a program to change all my code to ADO ? And...

When I split my database I lost my custom ribbons. I had to import the callback modules into the database. My ribbon shows up on the backend database but I...

can you copy hundreds of fields from a column in excel to a column in an access table? -- Message posted via...

I am going to ask this of everyone. I am building tables and relationships for a company. This is the information. We have a product which has 3-5...

I have an access 07 database that I attach PDF files to. So far it has worked fine until recently it started giveing me error when i try to attach more...

Is there a way to restrict data entry into a table via a form to one entry. I want user to be able to change a date and amount monthly, but not allow the...

How can I lock just one table with password protection from other users. It is OK if other users read the data, but they should not be able to modify the...

I have to copy Access97 databases to Oracle. To do so I need access to the Access97 metadata. I have found the table names in MSysObjects but cannot find the...

You didn't say what you data source is. Assuming it's a date/time field, try sorting by format(,"mm")

How to create a command button without using the wizard? Thanks