I'm exporting the results of a querie into Excel...it works no problem using
the foillowing code:
DoCmd.TransferSpreadsheet acExport, 8, querie_sel, "D:\Documents and
Settings\cgorham\Desktop\" & tab_sel & " - " & querie_sel & " " & increm &

At one time I had a simple routine that changed the location of a linked
table with out deleting and re-linking (refreshing.)  I used it because I
didn't have to worry about losing permissions on that table once it was
deleted.

I need to randomise participants in an Access 2000 db into four groups.
Let's say these are 1, 2, 3 and 4. This in itself is not the problem as
it's pretty straight forward.
The problem is that I need to keep the numbers of participants in each

I have an access database for patients. In it I created a command button on
a form that when clicked, it collects data for the patient whose ID is on the
form and creates an automated merger to a word template to create "clinic
note" for that patient's visit. During a patient's ...

I have a problem using VBA code to read an Access table.  Below is an
explanation of the question and some code that shows the problem.  The
following code opens a table and reads each record in the field defined as
“Year” .  We know it is the field defined as “Year” because the ...

I've got a form that, on the click of a button, closes itself and opens a new
form with a filter value passed by a previous form. The code for that looks
as follows:
Private Sub btnOpenNext_Click ()

dear friends.
i want the code that can change the control backcolor and font color on
gotfocus and lostfocus events  on the form
at present im writing code to each and every control got / lost focus event

how to place command buttons on a form in datasheet view

dear sir,
i want an form wiyh out any commands on it even not the close button how to
get it please

I've got a form to which I've passed a filter using the DoCmd.OpenForm's
[FilterName].  The filter that is passed is the record from one table that
matches the record from the table associated with the form to which the
filter is passed. Once on the new form I'd like to be able ...

Is it possible to embed the startup application icon in an mdb as opposed to
specifying a path?
This is a multi user environment and it will be difficult to deploy an icon
file and know the location of it.

I want a sub form which is a continuous form to open with the focus on a
"new" record. So I created a macro consisting of SendKeys {^PDGN} (in proper
format).
I entered this in the properties of the sub form in the "On Open" selection.

Is it possible to suppress the "Type a question for help" frame, as well as
the minimize, restore and close boxes, on a custom menu bar?

I've looked at several posts, but can't seem to get exactly what I need.
I would like to delete any "*ImportErrors*" table that may get created after
a file is imported (doesn't matter what file type, etc).  My thinking is to
search for any table object that ends with ...

I am working on an appliation where I use a progress bar to indicate approx.
time until an operation is complete.  I will post the code below.  My concern
is that is seems that when I run the code... noting else is happening so the
operation that it is supposed to filling in time ...