.

I use Acc2000, but the question is general
I have a MDE file with the application, connected to the MDB data file.
When I want to start a transaction in my application, I write:
Dim wks As DAO.Workspace

I have a list of companies, what I would like to do is have alternating
colours & have the entire record change colour when selected, also I do not
want the cursor the appear in any of the fields.
Thanks

Is there a way that I can create a drop down list (drop down box) that would
give a listing of all the forms and/or reports in the database - so that
when the user click the desired one from the list it opens that form or
report?

I'm having a problem where a user is entering information into a datasheet
view (so he can enter information faster)and on occasion the user is
entering duplicate information for the same person id.  My table looks like
this,

I lost my product key no I have a problem trying to install it on my laptop
the product is Microsoft Windows xp Proffesional, please help me do this

I have developed an application which, among other things, uses DoCmd.,
OpenReport  to display a report selected from a list.  Prior to that the
application has assembled both WHERE and ORDER BY strings for the sequel
command.  DoCmd.OpenReport has a parameter for including the ...

I created a long expression on a form that outputs xml text. The XML appears
in form view exactly as I want it. My next step is to export the contents of
this field into a txt file. It is important that the output formats exactly
as the text in form view. PROBLEM: using the txt ...

I have a query about displaying a popup custom menu bar in Access 2003.
Well, by query what I mean is that I can't get it to work ...
I have created the new CommandBar to drop down off the main menu. [It's
effectively a popup menu plus cascading sub-menus to open most of the

I am using Access 2002 and I have a problem using MS Calendar Control,
unfortunately I have been asked to used this type of control only,
although I much pefer using Allen Browne calendar control. My problem seem
when I add a new record using a simple command button (see below) I ...

I am using the following code to delete a query:
DAO.Workspaces(0).Databases(0).QueryDefs.Delete qry.Name
which works if the query already exists, but crashes the subroutine if it
does not.  I can't figure out a way to check if the query exists that doesn't

Can you set the on timer event to do more then one thing and at different
times?
example;
every 3-min check my reminders (run some code or something)

How do you place information from 2 or more tables on one form.  I want to
count the records from one table, count the records from another table,
divide one by the other but place all the information on a form.  I get one
total but the source of the form is one of the tables.  ...

I want the user to be able to click a protect option that will dissable
controls on that form. Then un-protect if they need to upadate missing info.
The only reason for this is so they will be focused on what they are doing
when changing data. the only problem is after clicking ...

I have a text field that I would like to receive the cureent date if the user
selects "order placed" from the combo box. the following is what i tried and
it won't show the date. can you tell me what i am missing.  Thank you for
your help