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

Hi, im pretty new with access 2007, i decide to use northwind template. In order detail both form, i have 2 different Qty, the original Qty is the Qty that...

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

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

IN THE TABLE DESIGN VIEW, CAN I PRINT THE FIELD NAME LIST?

Greetings, We have an Access database that was originally designed back in Access 2.0 days. It's since been added to and convert numerous times; today it's an...

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

Hi all, Wonder how a table design for a menu system that can support unlimited amount of categories and subcategories would look like. That is a category can...

i have created a table with all the necessary fields which I then created two forms, both including different data, apart from four fields which I want on both...

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

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

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.

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 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 databse with a table called Expenses. In that table I have a field calles Vendors which is a text field and a field called Cost which is a currency...

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

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

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