I have an input form in which the user can select a job title from a combo box list to be applied to a field in the query the form is based on. The query...

I have a question on normalizing tables that has come up several times. As an example: If I have ten pieces of equipment with ten guages and I want to record...

i have created a database which has huge table, i need to add more fields to this table (really does need to be in the same table as i have some very complex...

My fishing club sells bait to members. I want to print receipts for each purchase listing items purchased and log the sales for stock inventory. Each product...

Hello there! I'm having an issue with access 2000. I'm trying to make one form where I can select from different tables from list boxes, and then have my...

How do I set it up so that there is no referential integrity in a rtelationship of mine, but the related records in the 'many' table, will still delete if I...

hi, i just want to know how and where to write the DMax function? i have this table TblInvoice InvoiceID InvoiceNumber InvoiceDate

Hello, Is there a 'best practice' when it comes to creating forms based on many different tables? Generally I try to use as few subforms as possible, using...

Hey - Access 2003, vista, I have a DB that manages reports of researches. Each research is in a separate report (same access report, but printed in a filter...

I have two separate tables in Access that are both relevent to my Excel spreadsheet. Using a unique ID, I would like to match records from one table to...

Working with Access 2007. I have a new database and would like to know how to begin my auto number field (which is also my record identifier) at a number...

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: Can anyone describe how one can add a field to a table (in code) for a linked table? Thanks, Richard

I have a problem with a combo box on a form which is bound to a query. I have used On Got Focus in the combo box to set values based on other fields in the...

Can someone help? I'm being asked to create a training database. There are 129 employees and 14 sets of work instructions. One set has 208...

On 27 June I posted asking for advice on why a query would be running very slowly and yet at the same time, not troubling the CPU greatly. I still don't know...

I am trying to repeat data from one record into other records. For example, I have created a table for ticket sales, where the ticket number is the primary...

I am creating a multi-function database containing the following tables (key=agency): 1.AGENCY Headquarters Contact Info 2.with multiple SITES for each...

I'm completely confused about relationships between tables. Bassically, I have 4 types of transactions made by the same group of people. However, not every...

I need to have a table with 1.3 million records ( only one field table ). Can Access 97 holds that much of records? Thanks. - sl -- Thanks.