I have form1 based on query where you enter ID and retrieve list of
members with same ID.  If member not shown, I have command button to
open another form (form2) to add member and data to another table.  How
do I carry over the ID entered on form1 to form2, so user does not have

Is there a function similar to networkdays in Excel?
Basically count the number of business days between startdate and enddate.
Thank you,
David

Is it possible to create a query that selects from a table the group of
records that are equal to another group?
to make it clearer, the table looks like:
     ID Name

My code is as follows:
Private Sub NoOrdered_AfterUpdate()
DoCmd.OpenForm "frm_tu_rem", acNormal
DoCmd.GoToRecord , , acFirst

there are 7 reserves.
each reserve has 200 surevys.
each survey is 17 pages long.
i created a table for each page of the survey(also represents a section of

I have MS Access2K.
On the form I created a button named "Preview" when I click it I got an
error: "Run-time error '2427'
You entered an expression that have no value "

I have a Dsum field (NZ) which, before anything is entered shows #error and
the debugger comes up. As soon as I enter a row, it does go to zero.  How can
I trap the original #error and skip it?  I have tried checking for null, even
checking for = #error, but no luck.

I can use the expression builder in the properties fields to give an
expression such as
"=[Forms]![FrmCustPayments]![FrmCustPaySUB].[Form]![PaymentAmount]"
which is a great help.

I have got a hyperlink which gets generated based on values on one of my
forms.  I would like to have a button that opens the hyperlink in the
textbox when I click on it.  I have tried setting the "Is Hyperlink" option
of the textbox, but that doesn't seem to help

I have a form set up in tabular or table-like layout.  Basically, it is a
list or scrolling view of the data.  The data contains last names, and I
want to put an unbound text box at the top of the form and allow users to
type into that box and have Access search the initial part ...

can anyone tell me why my loop is not working to click on all the check
boxes within my form
Dim check, counter, flag, st, vf
check = "chk": counter = 0: flag = 1: vf = ".Value": st = check & "" & flag

I am creating an equipment inventory database. As part of the info that i
need to track, I have 3 types of lease agreements for printer devices. I
would like to create my new record data entry form so that the based on the
lease type selected by the user, only the appropriate ...

(Access XP 2002)  
Trying to determine if a linked table is still linked so that I can delete
the link and make a make a connection to a different database.  To do this
with regular tables, I use the following code:

I have a form, frmLevel3, that is a subform of frmLevel2, that is a subform
of frmLevel1.  When the user enters data into frmLevel3 and accepts the
current record, I run code to calculate and set the Default value of a field
on frmLevel3 for the next record.  Setting the Default ...

I have a form I use as a switchboard form, which I want to stay maximized
whilst the application is open.
However, I've recently found that the Restore Window button on the top left
hand side has appeared, which potentially allows users to interfere with