I have a subform, and i have 3 fields doing a DLookup.  They work, but in the
last row each one that i have the DLookup function it's displaying #error.
How do i get rid of this?
Thanks

I am trying to set a recordset programtically referring to a remote SQL server.
I have been sucessfull in setting the recordset but it does not apear to be
updatable. Is it posible to make a dynamic recordset that is updatable?
I am using the method descibed in the Access VBA help ...

Is there a method or property that can be manipulated with VBA to switch a
form from Single form view to Continuous forms view (and vice versa) without
first switching to design veiw?

i am looking for the number of records that satisfy 2 criteria:
(both Manufacturer and CatalogNumber are text fields)
this line of code works:
   x = DCount("[Manufacturer]", "FixtureCataloges", "[CatalogNumber]= '" &

Hi. Working on a split db 2000 and have a form with a subform where
I want some special action to take place. (frontend on local machine -
and backend on shared folder).
On my main form I also have a sub form. Applying a new record in

I have a datasheet which contains a combobox. The combobox is filled with
values via a function. Is there any way I get can get the list to refill for
each row in the datasheet? The function only seems to refill the list each
time the form is opened even if I put the code in the ...

I try to open a form.
The recordsource contains this code:
    t_hefte.gesamt_kuerzel="lsf100"
When I try to it with a form field like this, it is not working:

I am using Access 2003. I would like to use vba code so that when a user
clicks in an empty text box, a bullet (Alt-0149) is inserted first and then
the user can enter text. When the user then hits the enter key, another
bullet is inserted and they can type more text. If there is ...

I am attempting to lock a transaction record after i key in the first value
in this case the length of a wire recieved into the inventory.  The following
are the details of my database.
I have a table Rawmaterial_Items and Rawmaterial_Tran

Help:
I have a replicated databse that is used in both 2003 and 2007. Most
development is done in 2003. I have stability problems with
replicated/synchronised databases when running in 2007. The database normally

I have a table that contains a cryptic code that represents a state/county
combination.  On my form, I want to display combo boxes that allow the user
to pick the state and then the county in a non-cryptic form that will then
build the needed code.  Also, if a customer is on an ...

Using Access XP.
I am creating a student survey. A form, [TeacherNSubjects],  shows all the
student's teachers. They click on a teacher's name and the form,
[TeacherSurvey], is displayed, a [Return] button takes the student back to

Two questions -
1.  How do I change the alignment for a column in a listbox?  Right now
everything is left justified and I would like some columns to reflect
different justifications (right, center, etc.).

I have a form that I am trying to change the background color for the
controls on that form if the name of the control (text or combo boxes) exist
in a query called "qryauditFieldNames" I am getting an error message on the
dlookup statment. It seems that I have the --- ("" & txt ...

Have several pop up calendars on my Form.  However, when I click on the
calendar for the date I want it enters Dec 99 in the text field but if I go
to choose the date for the second time on the same calendar, it enters the
correct date in the text field.