I'm so close. I've got a table full of parts that I have to marry up to table full of model numbers. I've gotten the two to link Via SELECT .ID, .PrtNum,...

Part of a database I'm working on has three tables: City, State, Country. For cities in the US I want to have a reference from City to State (stateRef in the...

Hi, I set a string variable equal to my "insert" query and run it with: DoCmd.runSQL myStr Everything works fine but there's alway an alert message that...

I want to set up a db that I can enter info into freehanded but also get standard responsed to a condition I need to respond to.

Hi. I am sad because I think I need a re-do. There are two inter-related criteria that need to be met. The current table structure takes care of one of the...

Hi, I have a table with a date field. In my form code I have a query with a WHERE clause that looks at this date. I want to check that date to see if it is...

I've noticed in one of my databases that it takes about 5 secondes to open any of the tables in datasheet view (after double-clicking on the table icon in the...

Is there any way I can edit the contents of the System table mSysRelationships (aka Change mode from readonly to read/write) so as I can edit...

I have the following problem. In a database, I want to keep records as historic, before making any changes to them (historic in the same table). One of these...

We have a peer to peer network in our office and use Access to store confidential information. I would like to create a secondary database with either a...

I have a church membeship database that I need to enter members pictures. Is there a way of doing it? If somplease help out. I am using MSOffice 2003. Thank you

What I have at the present is one database with my accounts receivable information. I am planning on creating another database with the accounts payable...

How do I mke sure that my related tables update the correct records in a one-to-many relationship. For example, I'm creating a database for teachers to use in...

The HELP documentation gives me the EXACT syntax for how to do this. CREATE and VIEW are even reserved words in the Jet Database. The DROP command even lists...

Hi, I'm using Access 2000. Ive got a table set up with a bunch of columns that hold numbers. What I want is to add another column that holds the sum of these...

I've inherited a database that we're using to record stats. Basicly its got customer details and a referance number and most importantly a few different dates....

I have several existing tables with data input. I need to convert an existing number field to an autonumber field. If I can not accomplish this and must...

Can someon please break down this code for me. I'm a little confused about what it's supposed to do. SELECT MdlLst.ID AS xyz_ID_xyz, MdlLst.MdlNum AS...