Hi, Iam trying to do a project for uni and i need to have a letter infront of the id number that is generated. pls help! I have 15 unique ids and 3...

I'm working on a Project Manager DBase for our engineering department. One of the things they want to be able to record within each project is the Size,...

Hello, I've split a database, but now need to unsplit it so that I can add a password to the back end database (and have the application work without...

I want to keep an inventory Database. One of the inputs will be daily sales. I can either keep track of the amount on hand (simple solution) or try to keep...

Hello: I want to tell you about a great site I found. They pay me to read e-mail, visit web sites and much more. It's free to join and easy to sign up! CLICK...

Hi all, I'm new to databases and have a question that's hard for me but may be easy for someone else. I have a database where patients are assigned two...

Ever since Access 2.0, i have been using fields of type long integer as a subsitute for date fields, since I don't need the time part most of the time. Setting...

I've been collecting genealogy records of baptisms, marriages, burials and monument inscriptions and have them stored on Excel (over 15000 records up to...

I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use...

I have appended query that scans a part number as shown below: INSERT INTO Triggers ( , , , , Qty, , Supplier, ) SELECT Products., Products., Products. ,...

I am trying to build a database that will measure performance management in the delivery of a service The table I have built so far allows the user to...

Hi, whenever i select the Lookup Wizard in Design view, i keep getting the error message "Method'Currentdb of object'_Application' failed" Before when i tried...

Hi, I'm wanting to know (preferably step by step), how I can access an Access file I have on one pc via other pc's in the office (upto 3). I'm running XP pro,...

Hi, Does anyone know if I can download a template for a race pool. It has to have spaces for the people in my neighborhood and the car numbers that are picked...

I have a datasheet (e.g., table1) with a sub table inserted. I could delete records from table1 OK for awhile. But now I can not delete records from...

Hello: I want to tell you about a great site I found. They pay me to read e-mail, visit web sites and much more. It's free to join and easy to sign up! CLICK...

Zenith Port Royal Stainless Steel Mens Watch 03.0550.400/22.C503 Discount Watches Site : http://www.watchespurchase.com/ Zenith Port Royal Stainless Steel...

I am in the process of designing an access file to sort and analyze data from a survey. There is one survey question that has multiple answers (respondent can...

Here's my table: CREATE TABLE Test1 ( employee_ID INTEGER NOT NULL, start_date DATETIME NOT NULL, end_date DATETIME, PRIMARY KEY (start_date,...

I am creating a table, which includes a field titled Problems. This field needs to handle multiple entries, e.g., 1. Called vendor 01/02/03 2. Called vendor...