I Have two Tables. the first holds various information with it's own Primary Key and also a Supplier ID "SW_Opp" that identifies a Supplier. The second...

Hi there Currently I am getting the following message: "The operation failed. There are too many indexes on table 'Orders'. Delete some of the indexes on...

How can the instances of a textbox control on an continuous form be addressd? Can a specific instance be addressed? For example, a continuous form has ten...

I need immediate help. I accidently deleted a table and I have no back-up. I know that there is no excuse but I learned the hard way. Please tell me that there...

How do I go about assigning a button to clear the 4 other text boxes on that form? Thanks in advance.........Bob Vance

I'm trying to enter a Validation rule that states the following: AgeofChild =3 and =20... what is the appropriate way to enter this range for the rule? -Ray

I do not have time...can anyone suggest partners/MVP's that will create for fee a small business solution using Access 2000.

I need a way for one of my fields to change incrementally as new records are created. This field will always have 9 numbers max. It must start with todays date...

Hi, I'm creating a database to store weather data. The data is organized in a table by Date, Station Name, MaxT, MinT and Rain. The Reports for the data are...

I have a form in datasheet view which when opened I need the focus to go to a new record. I already have a command "GoTo Field". How do I do...

I have an Access 2000 database that was developed on Windows XP, and runs find on other XP systems. But when we tried to run it on a Windows 2000 system, we...

I'm working on a record-keeping system for a traditional Chinese medicine practice and am trying to work out a way of recording the needle points used in each...

I have two tables- main table is tblEnquiry with EnquiryID as Primary key, autonumber and several fields. Second table is tblContact with Primary key...

If I have the Date of Birth in a field, what expresion can I use in another field, say AGE field, that would calculate the actual age automatically? Like DOB...

In my Employee database, not everyone has a pager number but we need to know the pager numbers of the flight therapists so we can page them when they are...

This has got to be really simple... but I give... what is the secret to getting a data access page to allow me to edit a record in a table? I can edit the...

We've just installed Access 2003. In a table that has 4 consecutive fields of 3 characters each (which are all nullable), if you put 11 in the first, 12 in...

I am very new to Access so I appologise if this is a stupid question but it has stumped me!! I have started a new database and have created a table, I have...

You design and create your own form that allows a user to enter the parameters of a search, and then click a button. You have the form perform the searches and...

I'm an intermediate excel user and would like to learn access for the first time. A site or link for the best or easiest basic tutorial will be appreciated..