Hi, This is just a point of curiosity for me. I realize that Access works the Access works. Does any one know if the rows are stored in the database as...

I have this code on my database that show certain records based on a training modules completed selected by the user from a drop down list. SELECT...

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

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

My database has been split. I used JStreet Access Relinker to set up the linkage. I now want to add a URl (hyperlink) field to the Back End Contacts table so...

Allen Browne wrote a response called "Creating an Audit Log" in which he states that if the database is distributed (front-end forms, back-end tables) the...

I have designed a database to produce a random number beteween 0000 and 9999 as unique client number. I used =Int((1000-1+1)*Rnd()+1) under default value in...

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

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 the following tables and keys and am seeking a way to easily populate Table 2 with values from Table 1. Table 1: PK1, PK2, F1, F2, ... Table 2: ...

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

Hi, I’m using Access via XP Access Pro running in XP Pro with SP3. Please note that this question was posted in both the Database design and Form coding...

Re-posting in the correct sub-section. I originally posted in "Queries" where it obviously shouldn't be. I'm not a serial-poster, honestly (:o). I need to...

Hi I am designing a classical music database and am a bit stuck on how to manage the movements of a work. I have a table Work (primary key WorkID and linked...

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 have 3 tables (Models, Check Items & Parts) Models Table has fields; , , (e.g. 120 records) Check Items table has; , , (e.g 40 records) Parts Table has;...

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

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

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

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.