I am working on a class assignment. We had to create a queries dialog box.
Then create a load event. It is to select the first query in the list. This
is the code the book says to use:
Private Sub Form_Load()

Dim Y As String
X = Forms!frm1!Combo0.Column(1)
Y = "SELECT Bid FROM" & X & "ORDER BY Bid;"
z = "SELECT table1.feild1, table2.feild1, ..., ..., FROM table1,

I am trying to run the following (all these are dimmed at the beginning):
audent = RST!txtAENO
audgrp = RST!Auditgroup
yr1sc = Nz(RST!YR1SCOPE, "X")

I have a table that I've created and I'm trying to do an append query to an
existing table...all my fields match the existing table.  One of my fields
"ItemNo" looks like this...       CRIA3DA000
My question is...

I need to count no a nulls on a field call [MergeLetter]. This field is a
boolean.
I tried this syntax. It returns a zero value if it is null or if it is not
null.

I an using the upsizing wizard to transfer my backend data to SQLServer. If
I use the wizard to write to a new database it works ok, but if I attempt to
upsize to an existing database I get the error
'[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This error

I track vehicle mileage on all our work vehicles.  I have been creating
double entries by entering beginning and ending.  How would I create a box to
display the ending mileage from the previous record?
Now my vehicles are sorted by numbers ... unit 12, 21, 22 etc. and how would

I have a table which has a field that carries the Y/N (-1 or 0) value. I am
updating to a table that has the same field but is an text field that is
manually put in as a Y or N. I want to put an expression in the default value
of the fieled which turns the Y/N (-1 or 0) into a Y ...

I added a custom msgbox to the notinlist event of a combo box, but I can't
figure out how to get rid of the built in error message.  
Private Sub cboAddress_NotInList(NewData As String, Response As Integer)
   MsgBox "The address you typed is not in the city." & Chr(13) & "Please

I would to know how retrieve all the table names in an application open or not.
I am using access 2002 xp

Is there a way to loop through a directory and find the path, name, version
nymber, last used date (and any other properties) for any Access .mdb's,
.mde's or mda's?
Also, will accessing these properties modify any of the above?

Hi all, i've got a problem with the excel file which is created on a click of
a "export to excel" button. Apparently when i double click on it, it doesnt
launch but if i open it within excel i get a  "file is Locked for editing"
msg and the options for Read only and Notify. but this ...

I have an app that is being distributed as an MDE with Access RT. In the app
I am using a function from Stephen Lebans to display linked JPGs. At one
point the users can move through items in a list box and a JPG is displayed
with each change. If the user changes too quickly they ...

I'm trying to create a central reporsitory of code some of which is
shared between 4 MS Access applications.  At the moment each app has
its own copy of the code, so we have to take care that when changing
one app we change the other 3.  I'm thinking of creating a single mde

I have limited experience of progamming, and have been trying to figure out
how I can use VB to really increase the access benefits.  I have 2 main
questions that I think can be answered w/ programming.
1)I have a list of products in a table, some of which contain sub assemblies