My rule for the Serial Number is:
<first letter of First Name> <first letter of Last Name> <next sequential
number>
I would like to automate the Serial Number by extracting the first

Hi I have a form which I use to update a table.  When I
add to the table through the form the form I return to on
completion the combo box does not show the record entered
on the previous form.

I've done this before but for some reason I can't get the syntax right. I
have a public procedure in a form that I'm trying to call after the user
clicks a button on another form.
The form that has the button is frmMain_CommPkg. The form that has the

Hello, I have the attached code in AfterUpdate of a field that selects a
project number.  What I would like to have happen is when the land on the
field, select 0080 and it is incorrect and they say No, that it goes back to
the field and stays there until they change it, but this ...

Using Installer2Go to install an Access2003 db on a computer I get an  
error telling me that msado25.tlb failed to register. Does this file load  
automatically when I install the Access runtime. I have it loading and  
self registering through the installer so I thought that may ...

I have a data input form and need to automatically duplicate the existing
record as a new record by clicking a button.  The main purpose to duplicate
the record is that the new record is very similar to the existing record
with minor differences.  It will save the data input ...

I read through a previous post on this same subject, but this is a different
"twist":
I would like to highlight the active control as I tab through my forms, but
I don't like using the transparent property to do it because I don't want the

I have a subform that will have its SourceObject change depending on what a
user selects in a combo box. the source object changes but how do i set the
"Link Child Fields" and "Link Master Fields" thru code?
Ted

i hava a form in my a2k app'n called "RECIST Disease Evaluation: Nontarget
Lesions" from which i select a value of "Patient Number". there's a cmdbox on
it which launches a macro which opens a form called "Lesions: Nontarget -
Baseline" which has a matching control called ...

Hello, I recently make a simple database for a co worker to track returns,
I set it to open up in the form mode only.
Later on he asked me to modify a report for him and I went to do so.  I hit
the Ctrl key as I opened up the program and a dialog box came up (I didn't

The following code works for 2002 and prior, but not in
2003:
 areaID = [Forms]![form1]![subform1]![areaID]
this line, after the equals, was used as criteria in a

Is it possible to have a checkbox on a continuous form that behaves
separately on each row without bounding the it to a field?
I cannot have it bound even to a temporary table because many users will
work on it at the same time, so if one user

I have five queries that I would like to export into one Excel document
(have each query be a separate tab).  Is there a way to write code for a
command button that will automatically export these queries to Excel?
Thank you in advance for any assistance.

I have a field in our database that is a TEXT field that has numeric values
in it stored as follows: 000013, 000014, 000015, 000016, etc.
I want to be able to add a new record and have the next velu be 000017. I
tried using dmax() + 1 and it gives the next record as 17 and not ...

I am attempting to have the status of a checkbox dictate what appears in a
particular text box.  I used to the following code:
If Checkbox = True Then
   Textbox = "Comment 1"