I use this command to run a make table query without opening it...
CurrentDb.Execute "make table query name"
Access tells me that it can't execute a select query...? Its a make
table query not a select? Or are those two the same.

Hi I need to perform following query
Richard 3
Damian 4
I need to get result

Ok, I have read this group until I think my eyes are ready to bleed, so
I would be most appreciative of some help.
I have a form, on it are 3 combo boxes, and 3 text boxes
I have 1 table, with about 20 columns

I have never used the MSDE as a backend for a database but I am considering
dipping my foot in the SQL waters and trying out SQL Server Express.
I remember that the MSDE had certain limitations (limited users?) that
stopped me from using it. Does SQL Server Express have similar ...

Could someone please point me to a function/module for Access 2000 that will
enable me to parse a string field.   So if a field consists of "word_1
word_2  ...... word_n", I would like to be able to select either the first
or the last or any number of consecutive words from the ...

Hi - I have a master/detail form with a combo box (AssetCode) on the
master form which uses a query as its Row Source. I can choose a
selection from the AssetCode combo box which fires an AfterUpdate event
to find the correct record and refresh the detail form.

I have been connecting to this group through Rogers cable my internet
service provider. However, Rogers has announced that effective Dec 15th they
will no longer providing access to "usenet".
What is your preferred method of accessing this group?

The conversion of my department's 12 machines has gone really well and
I have had no big problems with any of it.  Now for another question --
Are there any new "goodies" in Access 2003 that are really helpful.
And I guess that I could say in 2002 as well as I started with 2000

I'm trying to create a database that has the following features but
don't know the best way to go about it.
1. When a user opens the database, I'd like that user to enter a 3
letter code to identify the user.

I'm having the following issue;
I'm having trouble referencing  these public variables after they are being
set, and I'm not sure why.  I use the code below to set open a connection to
a database.  The variables are public variables and I hadn't had any

In copying tables i use the command Transferdatabase shown below.It is
a good command, but i need the following refinement.
I want to copy the table only when the Yes/No field "accepted" in the
table Unis is set to  Yes.Can i do it in the command, and if not,

I'm working at a simple Access '97 + VB4 application, and I ran into a
terrible problem: something I never modified now gives me a totally
unwanted "Invalid use of null" error.
It happens in a Text.LostFocus event, this block:

If you can import the images, then where to I go to find out how to do
this correctly.

I invoked the combo-box wizard today, telling it to use a 4-table
union query as a row-source for the combo-box it was assisting
me in building. The error I got was without number and stated,
"Data cannot be retrieved from the source you have selected.

How can I find out the maximum or minimum values out of many values in
an array. I have an array in Access that loads upto 20 values depending
on a sql query. I would like to find out the min and max values from
this array. Is there like a function thats like Max(array()) that can