I am in the process of creating a new database that will house 9 normalized
tables with 3 main parts. First a membership table containing around 30,000
records, a provider table containing roughly 50,000 records, and an encounter
table that contains roughly 450,000 records. I ...

I do a scheduled dump via task scheduler from Access to Excel.
One of the columns of data is the Zip Code.
Is there a way I could dump it so that the numerical zip codes are numbers,
but the non-number zip-codes like Canadian Zip Codes or the Zip Codes with

I have a list of about 400 diagnosis that I would like to make available on
one of my forms. A combobox would be ok if the list wasn't so long. What I
would like to do is have a textbox where the user could type part of the
diagnosis and have a "Verify" command button that would ...

If this post's twice I apoligize but I have not seen the original I posted.  
I need to calculate the Mid Range of three numbers(I've implemented the
MaxofList/MinofList,which work great). I added the following line :
-- If varMax > Values(intLoop) Or varMax < Values(intLoop) Then

I have a combo box on a form whose selected value I'd like to use as a
variable to populate the criteria for a query I've written.
How do I do this???
So far, I've manually created a new label object that I've set to

I am trying to compact another database from VBA, but when I run the
following code, I get this error:
3734 The database has been placed in a state by user 'me' on machine
'mymachine' that prevents it from being opened or locked.

OK, I have done this in Access 97 but for some reason my query no longer
works.  I have a standard query (basic) that has the following elements.
cpva, feature, option, item
My end result should be this:

How to set db where two users can both make entries at same time?  I've done
this before w/ great success. New db however just will not let us both open
at same time???????????????

I have an Access application that need to close any non-visible instances of
Word running in the background. This is to tidy up any Word objects that have
been left behind. Any visible instances of Word must be left open. In
essence, the VBA equivalent of 'End Process' on Winword ...

Any suggestions on how to print Jukebox title cards in MS Access.  There are
4 cards per sheet.  The width for each card is 4.375 inches.  There may be 7
to 30 titles on a card.  I tried using the Label page setup but I couldnt
control the print for each card.  HELP please.

I have: a long list of OR conditions
e.g., var = apples OR var = bananas OR var = oranges
Is there a compact way of expressing this, like in SQL
e.g., var In (apples, bananas, oranges)

I have: a table with many fields.
I want: to create a list of the field names in a new table.
Any suggestions?

In Access XP is there a way to programatically execute a long running stored
procedure on a SQL 2000 server and have the ability to stop it at will?
ADO?  DAO?  DAO w/Workspaces and ODBCDirect?
Please point me to a working example if possible.

I've written a query that selects one record from a table and sets the query
itself in a variable.
Now, I want to use the query's fields values individually to populate some
label captions on a form.

how does access2003 know where to find the "Excel " program from in the code
below ?
If Me.List23 = "Project8" Then
   ' Excel Application on Project 8