Clear DayI'm using the Northwind sample database. How can I link Quantity
field in Orders Details subform with the stock level in Product table so
that every time I make orders and input some quantity in the orders form,
the same amount will be deducted from the products stock ...

I am using Access 2000, and trying to use two table. In a form trying to find a record in one table, if it is exist then get the value and put values in the form fields to update the second table. If it is not exist then create record in table1 and update the table two also.....

?s there a way I can relink all tables to a new folder, I seem to always get prompted for one at a time and I have over 50 tables! I never had to do this in Access 97.

Is there a simple way to return the logged in user name
(the username logged onto the PC not the Access user)?
The currentuser() function is not returning what I want -
it returns the default "Admin" Access user.

I have a Update query that is openned via a form name Updateform
I really want to have a message box tell the user that how many records have been updated. How can I do this? the following is the code that John help me with.
Private Sub cmdUpdate_Click()
Dim qd As Querydef

I can't declare a database object such a
dim dbs as databas
because database is not on the list that shows up.
In another database I do have it showing up. It is the same machine. I am puzzled. Help please. Is it a parameter that I need to set?

I convert the application from Dbase to Microsoft Access. It has a field name field name Plist (Hazardous Materials) Data type is Yes/NO (Yes=-1, No=0).
In a form. When the cursor is in this field (Yes/No) if I click on it. It turns to -1 or 0 depends on if it is Yes or No.
What I ...

Does anyone know of a good Access accounting database out there?  Unless I
want to pay several hundred dollars for Quickbooks, I have been unable to
find a decent program and really don't want to build one from scratch.  I
figure I could find a starting point and work from there.  ...

I've been trying to figure out how to protect tables from
modifications. I must be missing something obvious; other than through
forms and VB script I don't see ways to write-protect a table, much
less a column.

I display records on the form. Then I delete one of the records directly
from the table. Then I want the form to redisplay the records except the one
that is deleted. However, I click on the form after the delete event I get
the error saying that the "Record is Deleted" and the ...

I have a table that contains data from one month, several rows for each day.
Like this:
2004-05-01       5
2004-05-01       7

  Recently moved my Access97 mdb applications from a Win98 system to a new
XP Pro system with 1GB of memory.
  Both Access97 and Access2K are installed on the new machine, in seperate
directories, with seprate System.mdw's.

In Excel 2002, auto data tips and auto syntax checks in
the vba environment are not working. In Tool-Options-
Editor these options can switched On or Off. They are ON.
Any clues as to why they not working?

Hi, Does anyone know how to change a line of code Someone
gave me. I have a code which I need to change the
background colour to, instead of alternating each line, I
need to alternate by 2 text feilds.  The ones I wanted to

How do you change the path to linked files used to import data?
-erik