I have a compiled Help file that I created with MS HTML Help Workshop. How do
I call this file from within Access. This is not a Context Sensitive Help
File. I want it to function much like a standard Windows Help System. I could
use this as a stand alone file but I would rather ...

Hi, I'd like to have the password stored as the character, but displayed as
asterisk(*) as the user enters the password. What code would I add to the
following code?Many thanks for your time and help
Private Sub Form_Open(Cancel As Integer)

Hi all, I have a form with a two page Tab control.  I am trying to use VBA to
change the name of these pages without any success.  Access error said that
the control is in use.  I have tried the following
Forms("Form 1").controls("TabCtl").pages(0).name = "ABC"

I have a table with an AutoNum field. Periodically, the table gets emptied
and reloaded from external data. The AutoNum is in my table but not in the
external data. When I clear out the table, I want the Autonum to restart at
1, but it continues from the last value generated. How ...

any suggestions for addon software or other to assist with resizing forms for
a variety of screen resolutions.  my users are from 800X600 to 1280x768.    
this is a real oversight with access.   any help is greatly appreciated!

I had an access application that was working on NT - it is connecting an
access form to a Sybase database.
Now that I moved to XP I am getting the following error:
ODBC--call Failed.

I want to allow users to select a date from a list of dates beginning with
today and ending atter approximately 30 days. If anyone can help I would
appreciate it

How does one go about setting up a primary key for a table in a separate db
through Visual Basic where the table is not linked to the current db? Thanks
in advance for your help.

Using Access 97. I am in database 1. I am trying to create a primary key in a
table in database 2 where the field already exists. The code I have come up
with is as follows:
 Dim db As DAO.database

Can somebody help me to automatically rename files.
I've files with names like A1.txt in several folders which has a date in
their name, like 20041111-52365.
What i would like is to rename them like A<foldername (without

I would like to hide the menu bar on click of a button. I thought I could
just use the following line of code: currentdb.MenuBar.Hide but Access
doesn't recognize MenuBar as a valid method. Is there a way to do this?

How can I delete all table in a database except for tblTEMPIMPORT and
tblSuppliers?

  Can some clever dude out there please enlighten me about how to get the
formatting  tools in Outlook Express to work. It's so frustrating ! We have a
brand new PC with 200 gb HD and all the latest whizz-bang gear and up to date
programs including SP2 etc.

I run a few databases in a mutiuser enviroment. I always have problems trying
to get everyone out of database for maintenance purposes. As soon as you have
logged them out they are trying to log back in. Is there any code that will
place the database in a locked state. So that ...

Hello, I'd like to read mails from Access(VBA). In order that I can do it I
have to establish a reference to Outlook's object library, but I can't find
any appropriate library. I 've found only  Outlook express 5.0 type library.
Why? What can I do to have an appropriate one?