I have read articles upon articles on relationships. Just when I think I got it I cant create more then 1 record. I know this doesn't make a lot of sence. In...

Isn't there an input mask so that a phone number has to be entered as (111)111-1111? In a table of names and addresses, is there a way (in Access) to have...

Hi, I am trying to locate the expressions: IIF, Count, Sum, in the Expression Builder window opened through Validation Rule in TableDesign. (Access 2002...

Is there a way to do the following? The scenario: The “Animals� database contains the “AnimalsInfo� table. tblAnimalInfo contains the “AnimalType�...

Is it possable to set up a relationship between two different tables. Requests REQIMEI (15 digit serial number) Custoemr...

I have a form that has options to choose different reports. I want to add a comment to certain reports. What I would like to happen is when I click on a...

My switchboard on an existing database has suddenly stopped working. Everytime I try to open it I get the following message: "Compile Error: Function or...

Hello, I have a web based program with asp that uses Access. How can I make sure that I am backed up regularly? Thanks, Dave

I need to set up a billing, payment(which also posts financial charges every 30 days after the first 30) I have the following tables: Billing Table , ,...

I have two .mdb files with exactly the same structure (Tables,...) but the second database has a data subset of the first (base)data. I need to merge these...

I have set up 5 different queries to calculate one specific total each. I have also set up 5 accompaning forms. They work great. When I try to produce a...

I am trying to set up a dtabase of Students who must be retrained in 3 years. At present we are having to type in the retraining date when in table mode I...

How do I make one database that can be used by different groups so that they can change either the field names in the database (maybe by using a form) or...

Hi, Can someone tell me if there is any known difficulty between subreports and SQL. I saw a post on this board (can't remember where but I saw it)...

I have designed a database that is functioning well. Now I found that it needs to be changed for some expansion and I can't seem to find the solution, even...

in microsoft access in my tables database, i have 4 fields. Name, Gross Score, Course Handicap, and Net Score. How do calculate Net score? I would like to...

Hello, I have several tables of data in my access database and they are from different sources. How can I keep a reference or track or add a note to the table...

Does anyone have a home video database?

Im a final year university student trying to create a access database and need to know if a form can enter information into more than one table?

I have 3 computers with front end databases where the user can choose a backend data file that is stored on computer A. If any one of the computers reconnects...