I am looking for a script that I can use to compact the Access database
before the database is backup.
Thanks,

Here's the criteria:
Forms!frmStoreMaster.tabYears.pages(Forms!frmStoreMaster.tabYears).name
When I put it in the immediate window with a question mark, it returns "2004".
When I try to use it as criteria for the year field in a query, I get "The

Green VBA user here.  I know there is a lot of the 'Operation not
found' issues out there and I have tried several solutions to get this
simple key check to work to no avail.
Here's the code:

I've got some automation code that errors out when it's called from a form,
displaying error #3021.  However, if I insert break points and step through
the code with either F8 or F5 it runs just fine.
The sequence of event is:

i have two questions. first is regarding my errors. i am trying to close the
excel spreadsheet if sub errs. I am not sure how to test the variable
MyWorkbook or MyExcelSpreadsheet.
Exit_GenerateInvoice:

A lot of my AOL software is corrupt and unreadable according to my computer.  
A yellow box pops up at the bottom of my screen all the time (which is
annoying and interrupts all that I do) indicating that a particular file or
directory involving AOL files are corrupt and ...

I need to find a way to keep my main form (frmIntake) open when another form
is opened and have any form that is currently open to close and save data.  
For example, I need frmIntake to be open when frmDemographics is open.  When
I click the command button to open frmVisits, I ...

I developed a program in Access, and now I am implementing it I got one PC
with 15inch screen my forms are big for that monitor (all command buttons are
not showing on the screen) but working good on 17 inch where I developed.
Please advise solution which fits all size of screens.

I have written a VBA program within Access 2003 to gather data from user
maintained spreadsheets.  I am using the following code within a loop to
iterate through spreadsheets within a folder, open the sheet and extract
information into an Access database.  Recently some of the ...

What im trying to is when a person logs in it updates the loged_in column for
that person. The code is running but notthing happens.
strSQL = strSQL & "UPDATE Analyst SET Analyst.[Loged_IN]" & "Where Analyst.
GID ='" & Environ("username") & "';"

Please advise I developed a program and now implementing but some small size
screens are not showing complete form on the screen but regular size screens
are good with same program??
Thanks for help in advance

When I open my Access2003 database (in Access2007), the Visual Basic editor
window also opens. How do I prevent this from opening. The users don't need
to see the code.
I have an autoexec macro that opens the main form. The following is the macro:

I have a main form that when it opens, it opens another form for searching.  
When a value is typed into this form and you hit enter, it looks up the value
and displays its record on the main form > works fine.
I have several button in this main form.  Each button opens a separate

I inherited an Access 2000 database that needs to have tables imported into
a SQL Server 2000 new database.  The Access database has approximately 30
tables.  The Access database has approximately 10 forms, 10 reports, and 10
modules. I would like to import Access database tables ...

I have some code where I set various fields to record set values, i.e.:
IN1MI = rs.Fields("IN1_MI")
My issue is that if this field is null, it kicks out as invalid use of null.
I'm not sure how to cleanly handle this...I'm trying to avoid and if