I want to allow for default shortcut menu's. But when that is enabled it allows the user to right click on the form and go to design view - which I obviously...

Hi, i am having some trouble decided how to design this database. I have attached an excel spreadsheet with all the requirements. So far this is what i have...

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...

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...

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...

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 .......

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...

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...

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 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 was just finalizing a good and working database so i tried using the startup option directing it to startup on the switchboard manager form i created.I must...

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...

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...

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,...

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

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...

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...

Hi all, We have just made the transfer to Access 2007. Apart from the ribbon layout, which I believe only requires some time to get used to, I have a question...

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....

I am using Access 2003 I have a table of nearly 10,000 records which I have transferred from Excel to Access. The table consists of contact names, company...