I would like to share the following code I developed for retrieving and
populating standard Holiday dates in the U.S. for any given year.  It is
built around the general protocol where holidays falling on Saturdays are
usually taken off on the Friday before and Sunday holidays ...

Does anyone know why I'm getting a type mismatch error in the following code?
rivate Sub cmdOK_Click()
On Error GoTo Err_cmdOK_Click
   Dim FrmName As Form_frmLEAK_FILE_FORM

I have a database that is set up as an MDE file with security logins etc.  
The program has been "locked down" meaning there has been no coding changes
made and it has been working fine for several months.  A couple days ago I
tried to login and go the following message:

I am not an expert at Access, I simply created a form / report I use at work
as an order form. When I want to print the report (order form) I must be
careful to remember and set print properties to "Page 1 of 1" or I end up
printing all the pages in my  report. Is there a code to ...

I am setting up a database and have had a request the data entry forms be
center aligned across resolutions - this is a from that is full screen on 800
x 600 can be viewed at 1600x1200 in the center of the screen rather the the
top left corner

Im having a problem making a form open up in add mode. I went through all the
steps and the save record button isnt functional.  

I have five tables:
Vehicles (PK VRM)
Drivers (PK DriverID)
VehiclesDrivers (PK VRM and DriverID)

How do I code a button on a form to run a query and display the results in a
text box (on the current form)?
thank you!

I want to pass an active form to a subroutine, and have some action
taken on some fields on the form, but am unsure about the syntax.  Let's
say I have a form, 'frmABC'.  On the form is a field, txtXYZ.  I want to
pass the form to a subroutine named ProcessStuff.  Would I use:

I have a table with Alpha client ID. I have a datasheet form that opens
displaying records starting at "A". What would be the best way to display a
range of clients if I wanted (maybe C to L), and all (A- Z) of them if I
didn't want a range. I think I could create a query that might ...

I am creating a database to track drivers of vehicles.  The drivers will be
identified by the vehicle they are seen driving.
I am using three tables:
vehicle details (VEHICLE ID is the key)

I heard or saw a rumour that everytime you open a recordset it bloats
your database is this true?
Private Sub List52_AfterUpdate()
  Me.RecordsetClone.FindFirst "[LineId] = " & Me![List52].Column(0) & "

I am trying to get the following query to work with my form
SELECT CheckRegisterPre.EntryBlankID, CheckRegisterPre.MoneyID,
CheckRegisterPre.Amount, CheckRegisterPre.Note, CheckRegisterPre.entrydate
FROM CheckRegisterPre

How can I display a form's Modified date in the form footer ?

I would like to have fields in a table show when one is selected. OK I have a
table called tlbfacility, if has a field with a Facility name and a Code for
each facility. When entering records in a form I would like to enter the
facility and have the facility code auto enter. I ...