I have a form with a set of unbound checkboxes representing dates a building
was in use.  I want to use the results from this to fill in the linking table
between 2 tables (buildings and eras).  However, I don't want to have to
store all of the values of the checkboxes in one of ...

I want to use the following check sum routine to check for the validity of
newly input medical record numbers (MRN). Problem is that some of the MRN's
have leading zero's so the routine won't work. If I change the MRN field to a
txt field, then it doesn't work at all.

I have a combobox valuelist field that is needs to be enabled in my subform
when another field is selected (Yes/No)
Eg:
If [Field A] = true then [Field B] = enabled otherwise [Field B] is not

I'm having a heck of a time with this form & form-switching.
I have a form called "tablepeople" (I didn't name it- I know, I know), in
which the user chooses a person or creates a new one.  When this is done,
they hit a button, which checks to make sure that they have, in fact, done

From an Access database which stores lists of email addresses, I need to be
able to email groups of people certain emails. I know how to do this but I
need to do it without listing the addressees in the cc field. I need to
somehow dynamically set up an email group, add all the ...

Got a question I have a large table that I need to create a form for, when I
create the form Access will only allow me to make the page so long. How if
possible do I setup a multiple page form?? I tried using a command box at the
bottom that on click it opens a 2nd defined page, ...

I created 2 forms, one being a dialog box and when a value is selected & user
clicks OK, then the second form opens up with results. It has a macro running
on the back end. I developed these forms in the desktop copy of my database
and the forms run fine without any error. But ...

I need to be able to set a record to allowEdits=False if the creation of the
record is over 1hr old. I'm not sure how to do this. It needs to be just the
record that can't be edited, not the entire form.
Your help is greatly appreciated. Thanks, Rob

Wondering if someone can point out some starter code on passing multiple
values from a list box to a table?
I have a form that has some listboxes containing data from different tables.
I'd like to be able to collect multiple values from each box and pass the

I have model numbers with central numbers, surrounded by letters, like this:
AP9056X
RIC90
HIP80900GXS

Is it possible to run a piece of code when the last user exits my multi-user
database? The code is likely to take a minute or so to run so I'd like it to
run and then close the database so the user does not have to sit waiting for
it. It's going to export some data to a file for ...

Since under Access 2007 reports can no longer be exported to Excel, I'm
attempting to open the query that the report is based on so that I can
export the query to Excel. I'm wondering, though, about the best way to open
the query since I need to apply a filter. It was easy enough ...

I would like to use the value of a variable in a statement within a module
like
Dim strTestvariable as string
strTestvariable = "Chicago"     '  This value will be passed by another

Some function does not work in all Access versions. How can i check which
version of Access,  the user has.
We have office- 2000 and -2003.
In Access 2003 i can use Application.version to see it, but when i use the

I have a form control button that when pressed, parses the following seperate
address controls into a googlemaps browser box. At the moment the code
references the open form address controls; I now want to be able to reference
the controls via an underlying query. Can someone ...