Problem 1: I am attempting to get a message box (OKonly) to pop up when a
user clicks a certain tab of a tab control. Is this possible? It looks like
each tab of a tab control is not a control in itself.
Problem 2: I also would like another message box (OKonly) to pop up when a

I'm using the DoCmd.TransferSpreadsheet acExport,etc... to export a table to
excel. This gives me a spreadsheet with one worksheet.
Is there anyway to export more than one table to an excel file where each
table would have its own worksheet?

I have a photo database program which requires that the photo name be
appended to a text field containing the path to the photos. I would like to
have the photoname copied and pasted onto the default filepath as soon as it
is entered into the photoname field.

Access97
I am creating a table in an external MDB using
DoCmd.RunSQL "SELECT tbldata.JobId , tbldata.CustomerId, tbldata.[Date
Received], tbldata.OrderNo INTO tblHistory From tbldata WHERE

Access 97
I'm struggling with this one. I have a list box with Limit To List set
to Yes. On the Not In List event procedure I have:
Private Sub lstCallType_NotInList(NewData As String, Response As Integer)

I have set up a "Find" box in a data entry form to search for existing
customer names. If a name contains an apostrophe, such as O'Neill or Zeke's,
I recieve a runtime error 3077. I don't speak VBA and am hoping that there is
a simple solution short of renaming my customers.

Access 2003.  Have a large table of data with 32 fields without a key field.
Table has no primary key because it is the repository of a financial data
download.  There is a potential of having duplicate records in spite of the
many safe guards incorporated into the program.  ...

I am using ADO code to create a data connection and then to create recordset
objects. My question is ... Do I actually need to create a connection to the
current database project before declaring and creating the recordset object.
My form seems to work fine without the connection ...

I have a continuous subform on a main form with a combo box on the subform
that triggers three additional "pop-up" forms in succession so users can
select items from additional combo boxes.  I'd like the user to have the
ability to copy a record and paste it as a new one.  The ...

In Access XP, does anyone know how can I double-click the [EmailAddress]
field of a form and have it copy the contents of that field into the "TO"
line of the default email program?
Many thanks in advance.

I am trying to create a temporary table to use in a datasheet subform, the
subform is bound to the table, and would like to do it in one of the methods
of either the parent form or the subform.
The 'open' methods in both forms seem too late.  I receive the error that

When setting focus to an active control, I'm trying to read\extract text from
a label's caption property...but just can't seem to get this piece of the
procedure right programmatically. I'm currently copying the text into the
control's TAG property in order to extract information ...

I have a listbox1 that holds 500+rows of clients.  I need the end user to be
able to multiselect client names and have those names appear in listbox2 on
form.  I am able to populate a textbox from listbox1, but it does not allow a
scrollbar if the end user exceeds the the size of ...

I am using a form bound to a single table to add mutiple records to the
table. The addition of records works well, but since the records themselves
are a custom schedule table created day by day, I need a mechanism to allow
the user to create a re-designed schedule for a given ...