I am using a form with a series of list boxes in an option group that allows
users  to select criteria for their reports.  Here is a snippet of the code I
am using to pull up the report.
Sub PrintMasterReports(acViewPreview As Integer)

I asked this in an different MS Access newsgroup without much
success so I thought I would try here.  
I am looking for a VBA "format" or "template" function, that is,
a function that takes a format string and a varying number of

I am trying to display a date like 04.05 (standing for april 2005)
I have changed the date from date,short to this format in the MOT field of
the table CAR
so it changed from "dd.mm.yyyy" to "mm.yy"

I'm using MS Access ver2000 and Windows XP. I have a form with two bound
text controls - txtStartTime and txtEndTime. Both of them have been formatted
as "Medium Time" and have an Input Mask of "09:00\ >LL;0;_ ".
When I enter a value that does not conform to the Input Mask, I get ...

I have tried to use a query to transfer data from one table to another by
using the Update to query howevever the information doesn't transfer to the
other table. I have also link the feilds to each other.
Can someone please help me iin advising what I am missing here.

Hi
I'm working on Access 2000 DB, in a multi-users environment.
The first form when the users access the DB is the logon form, which will
capture the logged on user name and put it in the user name field then asks

How would I code for an input mask for a password? I have the following
behind a command button, but I want it to only show asterisks (*), not the
actual password.
Any help would be appreciated.

I have a table "Application" where sometimes two agents share equally in a
insurance application. I need to divide percentage between them equally so
both agents get a fifty, fifty slice.
Right now I have a combo box that I select an agent name from. I can add one

I am trying to create a form that will show me the drives on my computer so
that I can go and select multiple files.
How do I do this?

I am running some imports and exports and want to ensure users can stop the
action at stages.
I have added vbMsgBox's to my code and would like to use the vbOkCancel
button to allow a user when they select the cancel the import/export will

Anybody have any ideas how to "select" an item in a multi-select listbox
through code in Access 2000?
I have a listbox that displays a bunch of items, in a particular sort order.
I have buttons to the side of the listbox to move the selected item up/down

I have a FormHeader_Click event handler. In the header is a text box name
nfc and when I break in the event handler my watch window will show me a
Object/Textbox for me.nfc.
I have a procedure declared as

I have a "Preview" subform in which I need to have around 300 bound object
frames that will be linked and filled with jpegs that are located in a
directory. Single column, one below the other.
This subform will scroll when placed in a parent form, and 3 jpegs will fit

I have a form that displays/updates records in a table.  I need to control
the when the form moves to the next record.  I have done this partially using
the cycle property.  However I notice that if I press PGDN or PGUP on the
keyboard, the form changes.

I assume this simple issue has been covered before, but every email FAQ seems
to describe how to do everything but this:
How can I send one email to multiple recipients listed in an Access query?
I have select query which includes the emails of people I need to email