Help

DB Self-destructed! <GRRRR>
(See earlier post "Record Is Too Large") This morning I just wiped out all earlier tables, kept the original tab delimited table and Form, then went back in and did a complete new DB split and accepted all defaults. Got the thing split, fields changed to date/time & memo as appropriate, field sizes trimmed to re... 19 Jun 2008 01:14

Access 2007 Creating a Report from Multiple Queries
Hello, I just started using Access 2007 after using Access 2003 for a long time. I've created all my queries and they work fine. However, either I forgot or it has changed but, how do I create a report based off of multiple queries? I tried using the report wizard using one query. In the Properties sheet of t... 19 Jun 2008 01:14

Is this an acceptable way to design an accounting, purchasing set of tables?
For an accounting / banking database, I have the following in a two transaction tables showing what someone spends or credits: Transaction Table //one only -- TransactionID UserID TransactionItemID Table //many -- TransactionItemID TransactionID ItemID AccountTable //one to one from TransactionID ... 19 Jun 2008 01:14

creating an import for Access 2000 from a PA 600 mobile device
Hi, So I'm created an MS Access Database for a manufacturer. One of the things that it does is tracks information about massive metal coils (including part number, weight, order number etc.). The user wants the ability to use a scanner to capture all of this information remotely while they are moving around from... 19 Jun 2008 01:14

Update a field color based on field contents
Hi guys, I'm using a subform to display a list of values from a single table. The form is showing the values in "continuous forms" view and there will only ever be two different values for the form. The form show 2 fields, 1 is a number and the second is a calculated field that says either "Valid" or "Invalid" ... 19 Jun 2008 01:14

MS Access SQL 'Deep-copy' Query Help...
MS Access Database I'm working on a 'Reorder' function for my friend's database. Essentially, it is a 'deep-copy' of several related tables. Here is the table setup... tblSalesOrder SalesOrderID (PK) Field1, Field2, etc tblWorkOrder WorkOrderID (PK), SalesOrderID (FK), Field1, Field2, etc tblOperati... 19 Jun 2008 01:14

lost records appearing in table
Rick, I will try this, thanks for your help.... Rick A.B. wrote: Shannan, I don't see anything in your code, I would suspect that it's something [quoted text clipped - 8 lines] Rick Sorry for blowing your name Tony, It's Tony Toews. My fingers are constantly getting ahead of what lit... 19 Jun 2008 01:14

Aggregate help
I am trying to count the total number of units for a given part number that have a Priority rating of 1. Based upon some research, this is what I came up with for my query. Access says that I have invalid bracketing in the Select Distinct statement. The only brackets I inserted were to delimit the table's field nam... 19 Jun 2008 01:14

Gaps in a Sequence Number
Hi, I'm in need of some expert help in sorting a numerical/alphanumerical employee ID field (5&6 characters in length). Also seperating the alphanumerical IDs and finding the gaps in the sequence numbers (These numbers will always begin with a "C"). Reason for this is to assign an unused alphanumeric number t... 19 Jun 2008 01:14

Multi-User Access Database - Tracking who makes changes
If you set up user level security (not easy, mind you), you could set it so that only the db owner can update data in the tables. The rest of the users will be prevented from making unauthorized changes unless they know how to circumvent user level security (even advanced level people have trouble with security). ... 23 Jun 2008 23:00