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

I have a simple database for keeping my checkbook (or all finances) straightened out. and i am looking for suggestions on how to make my deposits...

I have a yes/no field that I tag if I want to send a bill to various people. After I have sent the bill I want to clear the field so I can use the field at...

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

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

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 have two different ODBC tables and as a result of a make table query I'm trying to change the Data Type on both tables to read "text". One table already...

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

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

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

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

This is a simple question. Yesterday I needed help with adding date, time and user to a textbox. Today I am wondering if there is a way to make the info skip...

I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...

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

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