I was entering the same code on two different forms.  I thought it would be
easier and create a module and in the module write the code once.  Then I
thought I could just "call" the routine as a Public Sub.  This the code
currently on my form called Hiring is:

I have code in one place that checks the color of a person's name from many
different forms by using a with statement and a variable (MeForm) to pass the
form name, the code will execute from any form. This cuts down on duplicate
code. However, I have one subform and I can't get ...

I need to replace a date in one table of my database. I made the following
code: Dim ApptDate As String
ApptDate = Replace("Forms!ModificarFecha!FechaActual",
"Forms!ModificarFecha!NuevaFecha")

I have a dell computer with 612 mb ram, why does publisher lock up each time
i use it?

I created a form and the concerning macro that open another form in read only
mode displaying a specific record. On this last form I want to be able to
click on a button and change the data mode from read only to edit so I can
make changes to the information displayed. Can you ...

This may be a duplicate - I have a strange error when posting...
My Goal: A form has 1 command button, 2 list boxes and 1 combo box (and 2
text boxes for the start & stop dates).  When the user clicks the command
button the results are (DoCmd.SendObject acReport) but before that = ...

I am looking for a way to open saved Snapshot Reports from Access.  I want
to allow users to select a saved report (e.g., TestReport.snp) from within
Access using the File Dialog box and then have that report open up in a
separate window.

I have a list box that is getting its contents from a table for the type of
insurance coverage (CH, EE, EE&SP, EE&CH, EE&FAM) I attached an after update
event procedure to update the table as follows:
Private Sub lstType_AfterUpdate()

Wasn't quite sure how to search this topic.
My (1st) db is about to be distributed to multi-users.  I would like to make
all my forms read-only and add an "Edit" button on each users can't
accidentally overwrite existing records. Also lock older records as per

I need to hide a column in a subform that is in datasheet format if there is
no data in the column that is if there is nothing greater than 0.  I have
tried both of these:
Me.ControlName.Visible = False

I have a database we use at work to track multiple items.  I have it set to
maximze on the AutoExec macro so everything is maximized...obviously.  I do
this as I use a lot of screeen space for all the data fields we display.
I would like to open a form through a command button and ...

I'm new to Access.  I've created a form with a subform/subreport using
the wizard.  The subform field displays in Datasheet View and I want
that changed to Form View.  Everything I've read says to simply edit
the Properties of the Subreport Control and change the Default View to

Using Access 2003.
What is the maximum value that can be entered in the Timer Interval?
Thanks for any help.
Adrain

I have an MDB that I support for a group of users that need to
periodically link about 15 dbf files into. These files vary month to
month. And their location varies each time. The user has to copy an
empty version of my MDB into a new folder along with that month's DBFs

I have a "ProductName" table with two fields: "Product" and "ProductCode".  
I have this because the product name tends to be very long and I have
thousands of products.
I have a form that populates fields in a "Customer" table listing the