I created 5 Tables: 1)Office with Primary Key as auto number named Office ID 2)Marketer with Primary Key as auto number named Marketer ID 3)Currency with...

I have an Access 2003 database to split into a front and back end. I expect to use the wizard to accomplish that task. The database is on one computer on my...

Hi, I am learning in Access 2007.... Through John and Jeff Book......Have two tables.... e.g. 1. AllItems 2. ItemsCategories Both has Primary keys .......

I am fairly new to Access and am designing a new database. I retreive all of the data from various Excel worksheets. I have 5 tables that I will update from...

I have a table that populates specific data from a SQL view when I manually run an append query - works fine. What I really need to do is have that table...

http://find-stolen-laptops.com/wp-content/uploads/2010/03/never_know.jpg Use Snuko Anti-Theft Software to trace your lost or stolen laptop. It's easy to use,...

We have created a new project use SQL. When I create tables in import data we get a Message that says "Recordset is not updatable". What are we...

project number in my data table will be truncated. I know that it will be impossible to establish referential integrity Use an Autonumber field as primary...

Hi, I am trying to create an access database that has historical data and new data is imported in monthly. I need it to be able to check each time if it's a...

I am building an automotive shop database. I have a table that lists all of the services and the prices. I have the main form created where all of the...

We have an access database on our server. We recently installed a new server. The links in the split database from the front end to the back end all reference...

I am hoping someone can help me, I am trying to create a relationship in a database and I am having a lot of trouble. I am trying to make is so in my database...

My last two posts (on the "microsoft responds...." thread never showed up.

I am trying to find the easiest method to write code which would allow me to open a report from a form linking up to five fields. For example: I have a...

I am using a simple form for the user to enter data into the main table. one of the fields available is "Box Number" and each of these boxes holds 16 items....

Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it...

Office 2007, just upgraded from 2000 ( OMGOODNESS!! What a flippin' NIGHTMARE!!) I am simply trying to import a tab delimited text file into an existing...

I am using the lookup wizard to create a lookup column using an existing table within my database however I get an "automation error". I can get as far as...

I have a table that lists employee names, employee ID, Badge numbers and other info on the employee. This table is used in multiple queries. When employees...

Hello all, This question takes a complicated setup, but I'll try to keep it brief. I have a database with a main table (tblMain) and a lookup table...