I have an app that has run for years without problems. Recently I had an XP
Pro hang on startup an I was forced to reinstall Windows.  I reinstalled
Access 97 SR-2 and now all combo boxes generate an error saying the object
cannot be found in VB and the ampersand is highlighted ...

Not sure what I've managed to do, but maybe someone can help.
I have a form I use to select records for audit.  This form displays the
transaction type that then can be audited for multiple scenarios.
When the user selects the record to audit, it opens a new Audits form and

I am trying to hide submenus for people who don't have rights to do specific
things.  I can see how to hide the top level menu item (code below) but not
sub-menus.  Any help would be appreciated.
Application.CommandBars("Sales Journal").Controls("Management").Visible = True

I have scripts I need to display in a text box on a form.  The script to be
displayed is dependent on what option is chosen in an option group.  A given
script is about 500+ words.  Do you know how I can do this?

Not sure why I can't get this syntax right, but I'm sure someone in here
knows...
I'm on my main form [audits].  When I set off the LostFocus event, I want to
move to my subform [auditresults subform] and set the focus to a button on

Access 2000
What's the method or property to use to verify if a form is open or not? I'd
like to open a form if it isn't already and can't ferret out how to verify
if it is open.

I have
MainForm SubForm1 SubForm2
I have the following code to change the AllowAdditions property to False on
SubForm2  based on the value of the chkBox in SubForm2.  The code is on the

I have a form with two text boxes used to enter start and end dates as
report criteria.
I was wondering if there is a way to set default dates for these boxes; for
instance I would like box 1 to always display the First Date of the Current

I keep getting an ActiveX component can't create object error message (#429)
while trying to create a workbook instance. Google research leads me to
suspect some misconfiguration on my machine but I can't imagine what that
would be, since I'm having no other problems. The ...

When i run the delete command...
   DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
   DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
what is the best way to suppress the delete warning?

Got a problem
I thought I was doing good with this, guess not.
I am using;
Me.po = DMax("po", "po") + 1

Please help,
I have a database in to which start date/time and end date/time is entered,
from this I have calculated fields which calculate the timeDiff, also another
which calculates the time from a Midnight reference.

I am using the CDO object to send email automatically from an Access 2000
application. It has been working flawlessly until just recently, when users
have been experiencing a "transport unavailable" message.
After doing some debugging, I discovered that the strSch variable which I ...

I want to activate a button on form two from form one.  For the button I want
to activate, I changed the Private to Public and renamed the sub to make it
unique within the project.  I coppied the name of the sub and pasted it in
the sub on form one from which I want to activate ...

I have a filter on a form. The filter works perfectly until a value from the
query that controls the list contained an apostrophe. When selected the error
message "You can't assign a value to this object" appeared. When the
apostrophe is removed from the approporiate tables the ...