Hi, I am using a form and would like to run certain code each time another
record is selected (and also to run this code when the form is opened which
loads a record). Can someone show how to do this please?
Thanks.

I thought I knew the answer to this! I have tried
If ChartNo = Null then
....
which doesn't work.

If I highlight anything in a Word document and change the formatting the
whole document changes, and I have to click on 'undo' to keep just the
changes I want.

I have created a form with 4 combo boxes on it (1, 2, 3, 4) and the row
sources for combo boxes are queries.
The selection made in Combo box #1 will act as a criteria for the query
being used as a row source for combo #2 (after the Click event on combo #2).

I have a select query which return a dataset which i would like to be
presented in a form.  I have started to build a macro to run the query and
then to open the form to show results.  I based the form on the select query
but am having problems getting the data to complete.  am i ...

I'm an advanced user of Excel VBA, but a newbie to Access VBA, and I'm still
trying to figure out the object model, method of selecting objects to perform
actions, etc.  Can someone please either point me to a online resource with
explanations & code samples (other than the ...

I am trying to display a dialog box that pops up when you first open an excel
file.  I want it to say...
Starting June 2005 we will be receiving a print out list of ATS (Application
Toolig Solutions) invoices that paid sales tax.  This will be reported

Does anyone know how to use macro or code to automatically
import a text file into Access.  The file is a delimited,
comma file.  I've tried the transfer text macro but cannot
get it to work.  Any suggestions and examples would be

I use Access 97 and would like to create a macro to hide columns and sort by
eg.field1,and field 2,ascending. Is a macro the best way to do it?and if so
how do I do it?

My VB code returns incorrect LastUpdated date for reports. Some dates are way
off, some are DateCreated. Tried using VBA in an Access module and tried
upgrading from Access 2000 to 2002/3 format - problem persists.  Can you help
or explain ?

I am writing a macro to automate importing data from an Excel spreadsheet
into a table when a button on the main form is pressed.  I want to check to
see if the first record contains text after the import.  If it does not, I
want to alert the user.

I created two new macros to pull from two make table queries.   We have one
macro to run all of the macros.   The only way that the two new macros pull
information is if I run the two make table queries first.   The one macro to
run all macros was created, so we wouldn't have to ...

When I run a macro (that takes awhile, several append queries, and exporting
of files) from a command button on the switchboard access stops responding
(locks up) I have to exit the program and go back into it.  It does not do
that when I run the same macro from tools, then run ...

I created a database that logs the status of multiple projects.  The DB is
on the LAN at work and can be accessed by all.
The problem I have is it's too easy for folks with limited integrity to
change the status of a project (dates, % complete, etc).

how can i get access to change the excel page view to landscape view, is it
possible