The following code in Access 97 will not work unless I remove the
relationships from the table (the recordset being updated).  I've even tried
doing an update query instead, same results.
       With rst6

I have a database that stores plant capacity information (tblCapacity)
and region sales information (tblSales). The Table that stores plant
capacity info includes the following fields; regionCode, plantCode,
recordedYear and plantCapacity. The table that stores the sales in the

I have 37 records with a field yes/no and I need to set all these fields back
to no. I need to have this done automatically.
Please help

ONce I modify the system, I need to move only the non-data portion to a new
machine so I can retain the existing data that has already been entered.  How
can I easilyu do this.  I don't have the developer tools.

Using MS A97, how would I go about shrinking the main Access Window to a
specific size?
I do not want to shrink/stretch any forms based on screen resolution,
rather resize the Access Window to the size and the currently opened

First post, please be kind.
Have just dived into the world of VBA, quite facinating I must say. Have
found this board VERY useful. I have searched for answers to my problems and
have always found the answers, but not for this one, even though there are

I designed an append query in Access to add records to a SQL table. The PK in
the SQL table is an identity column. There are no null values in any column
or record. I get an error message "you tried to assign a null value to a
variable that is not variant type data". I presume ...

I have this
Private Sub eksporter_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"tblSportsgren", "C:\valutakurser.xls"

I use
http://www.mvps.org/access/api/api0001.htm
Working fine
But how do i get the path into a tekstbox in my form?

I desigend a simple application to run in Access XP. It works perfectly,
however, when some tries to open the same database in Win2000 (access 2000 or
2002) it will not work. Is there a difference between Object Library 10.0 and
OL9.0 that is causing the problem?

just curious.....i see code using either of the above "Me!" or "Me." when
referring to forms in code.
what's the difference between using the "!" or "."?
thanks, and this is definitely NOT an urgent question...

I have a form that I am operating ONLY in datasheet view with the following
information:
Records/Rows
Registered Dietician

I posted a question on this topic before but got no response.  Perhaps I need
to be more clear.
We have a Visual Fox Pro system (with a database container) that we connect
to for data mining and reporting.  We are currently using ODBC drivers for

I need major assistance. I am trying to build a security log on screen. I got
some assistance yesterday on how to create the form. Now I need to bring it
to the next step. What is required is that:
First off, I need to build a form where the admin of the database will setup

How can I Call the standard Windows Date/Time dialog box to obtain a date
selected from it?
Thanks,
Double