How can I clear this message that I am getting everytime that I try to
compile.
"Error accesing file. Network connection may have been lost."
Thanks in advance,

I copied this directly from MS Access Help, substituting my data, but it does
not work.  I keep getting #Name.
=DLookUp("[RecvgHull]","LIDetails","[id_LI] = " & Forms!LineItem!id_LI)
My understanding of this formula is:

I have an Access application where I use a Date picker (mscomct2.ocx).
I have newly installed Vista Ultimate on my computer and suddenly this
controlø has disappeared.
Is it replaced with something else or what?

keep getting an error when I use the folloeing code.  This code is a refresh
button that takes you back to the last record you were viewing when you
presses refresh.  Please can some one help me.  Below is the error type as
well as the code:

My question is quite simple. I have frontend databases in 8 locations in a
network. Do I have to go to each computer and update each one when I make
changes to the forms?
Thanks,

A report is based on a query and this query should be generated by a form.
The problem is the controls on the form can not be assign to the query as a
parameters becasue some transformation must be applied to the controls input.
Clara

I have a combo box on my form. It is unbound to form. I am obtaining cboBox
data from another table in database. However I need to the cboBox to only
list records that match the customerID from the form it on and the customerID
in the cboBox data.

I have a continuous subform (modal pop-up) in a database.  I want to copy
some of the fields into a temporary table.  As the user does data entry they
are in the last record in the subform.  I want to move the record selector to
the top but the code I have has been tempermental.  ...

I have to do what I thought would be a simple task.
I have a continuous form that maintains a table containing one column.
I need to trap 3 possible errors.
(1) Records cannot be deleted if they are used in another table

There are three combs and each of them may be a criterias in where clause.
The key point is I want to generate a query object which can  and appear in
the database object window and can be referred by a report.How can i do it
thank you so much for your help

Does anyone have experience using FMS's Total Access Ultimate Suite? Would it
be better to get Visual Studio?
I would appreciate any input. Thanks, Rob

Is there a way to format the color of the choices in a drop down list?  I
have a combo box that provides four choices; when a choice is picked, the
conditional formatting shows the color for that choice, but what I want is to
have the color show on the four choices themselves ...

This procedure is on the Keypress event and limits the text going into a
textbox to allow a custom message (I understand that I can limit the len in
the table).
The problem I am having is that the line

I have code in my main form BeforeUpdate Event that asks the user if they
want to save their changes (and if they don't, I undo the changes before
closing the form).
I recently added a sub form.  If the user clicks on one of the fields on the

I am using Duane Hookom's method for concatenating a string reproduced below
but I would like to simply pass the name of a query to the function rather
than sending the whole SQL statement. But when I try to do this I get
"Run-time Error 3078 -  The Microsoft Jet database engine ...