I have developed 2 tables. One is an inventory of sorts table with a medication name, dose, lot number, and expiration date. There may be many entries with...

The symbol b with a line through it is used for our AS/400 programming and we are trying to do documentation. Does anyone know if there is a symbol for this? ...

I had to copy a mail log database. The users who have XP can not acces it any longer (created in Win 98). They can access the new "copied" database but they...

I'm really hoping someone can help me out there 'cos i'm lost!!! I've designed and set up a database in access 2002, however i'm having real difficulty trying...

If you have a table with records that correspond to records on another db how can you combine them? Example DB1 has 3 fields - Field1, Field2, CODE DB2 has 2...

Have small Access 2003 application (3-5 users). Have 3 computers in the office, and would like users to be able to access database from home or...

Hi all, I was wondering if someone can help me with my problem. I'm creating a database for our little department receiving documents. I have three...

Is @@IDENTITY thread safe in that it returns the autoincrement value for the most recent insert for that thread or just the most recent insert by...

I want to calculate the difference between two dates in Access. How do I enter the expression formula? I am at the Table Design only.

Hello, I have a couple of questions I hope someone can answer for me. I wrote a database for our parts room and we have been using for the past few months;...

I'm getting an error when I run a query that says "Not enough space on temporary disk." Admittedly, I am using a large dataset (~1.3 gigs currently). Anyone...

I want to know the creation date/time of a record but the record itself does not have a field to indicate when it is created. Is the creation date/time is...

Access97 with SP2 running on WinNT. I'm trying to split my database using the Access97 database splitter. (Tools|Add-Ins|Database Splitter) The first thing...

how do I erase what I originally typed that is showing in my document after I have made changes in tracking.

I have created a database 'Input Form' relating to all the fields that I need in order to input a new Contact into my database. Now I need to create a blank...

Hello all, I am trying to create a quality database. I have created a couple tables and run some queries to do some simple math. The tables store information...

I want to know the time, date, and the user's name who last edited or modified a record in microsoft access 2000 database. Please help. Thank you very much!

I will like to set up an automatic purchase order number on access. Example number Ranges from 0005-0001 to 9999-9999 to automaticly change and increase by 1...

I'm trying to setup validation for a field in a table. The user will be entering only four digits of a year; ie: 2006. I need to be sure they enter only...

if any one can help me setup a way to inpot my work in the market in the excil work book and find the profit and lose at the end of the qulom