I have an Access 2000 form that I open showing only the header. The
form's detail section visible property is set to false.
The detail section contains a subform. Using a command button, I use
the code:

I have tested using a single .ADP file on a Win 2003 TS server, and
have multiple people access this file.  The backend is SQL.  As I
suspected, the 2nd user gets a Read-Only warning on the .ADP file, and
cannot access the project.

Hello Again,
I want to assign a number to each record that will be part of a shipping
number.  I want the number value to count up until the contract number
changes. Then, I want the number to go back to 1 and start counting up again

A while back I got a requirement for the client to be able to adjust
the relative heights of two subforms by click-dragging the mouse and I
came up with a kludge solution using a border control between the two
subforms. But I put my mind to this again recently and came up with a

Trying to use the run code macro, but there seems to be problems with
connecting and running the function, in a module, I have selected.  It
seems there are problems in the arguments, which I am entering in the
"action window".  I am entering:

I don't know what step I am missing.  I have three tables, tbl_A, tbl_B
and tbl_C.  Common fieldnames for tbl_A and tbl_B is [bldgindex and
bldgnum], and [roomindex] is found in tbl_B and tbl_C.  On the main
form I have a combo box that list [bldgnum] that will search subform

I am currently working on converting a program from Access 97 to Access
2003. It all worked fine in 97, but there is some randomness in 2003
that I don't understand. I have a form, Main, that loads as follows in
the code:

Here is my problem :
The following  lign worked well. It created a file from a table.
File_mailing contains the string withe the path and the name of the file to
be created.. But now it fails :

I am using a timer to display the time it takes a user to complete a
file transfer using the code below.
The code below will display the total elapsed time, but is there a way
to update the time continuously as the file is being downloaded?

How to open a linked table in exclusive mode from a FORM in DAO ???
(but,...... please I need it in DAO.)
Thank you !
Javier Gomez

I have a DSL line coming in to my home/office into a
4-port router to which 3 windoze boxes and one linux
box are connected. My window$ boxes all see each
other, but I do not have a facility yet for attaching

I have a database that stores customer records and their associated
insurance details. I need to be able to track any changes made to that
record within a set time period ie if details are changed fine it is
reported next time report is run. But if details are changed more than

I have the classic Master/Child subform setup in an Access 2000.
Where the child subform properties are setup to connect the master
subform. The master subform has it's "OnCurrent" event set up to
requery the child.

1. I have a list of products in an excel spreadsheet, the fields are:
Prefix, Stock Code, Suffix and Description.  I want to import them into
Access and then merge the 3 fields Prefix, Stock Code, Suffix into one Stock
Code Field e.g. A 123456 A Becomes A123456A.  I presume I do ...

Using A2K.  I have a query with 2 tables with a one-to-one
relationship.  Is it possible to check the field on one table and if
it's null, use a field from the other table?  Both fields are of the
same type and size.  If so, how so?