I'm using MSAccess 2003 for a database that I create with multiple users.
One main table and form is used.
tblLog
frmPrepUser

Repost of earlier, no response, Thanks.
Hello,
I have constructed combo boxes as previously instructed, have worked through
debugging the code but the combo box is not updating. Here is the code as

What I am tyring to do is have access automaticaly update a field on my
subform with data from my master form whenever the user makes changes to the
field on the master form.  There is a one to many relationship between the
record on the main form and the record on the subform.  ...

I would like to save changes to the form without using a separate [Save]
command button.
Using a macro. [Tried]
Save

Okay, here is my question. I am creating a lot of forms for users, and I need
them to be able to select Clients through a Lookup field, which selects the
first and last names from the main client table. The Lookup field is working
fine, and all of the client names show up when ...

I'm working on a budgeting database.  I have a Purchases form where purhcases
are entered.  The person will put in their clock number, purchase date,
amount, etc.  When the person puts their clock number in I want a subform to
fill up with all of the purchases related to that ...

I have a form that displays multiple records (form A). I also have a form
that displays the record with all its fields in a single view (form B)
providing more detail.  
Is there a way to have form A display a hyperlink in each of the records so

I am having a problem getting a list box to show only the records that are
determined in a previous form.  
Specifically, form1 (search) allows selection from a list of variable names.
The event procedure is upon dbl click form2 (results) opens and has a big

I received the following message:
File sharing lock count exceeded.  Increase max locks per file registry
entry.  
Is there a way to prevent this from happening ?  If not how would I increase

I have a combo box and a list box on a form.  The combo box lists tech names
from a tech list table.  The list box lists jobs related to each tech as
they are selected in the combo box.  What I want to be able to do is click
on one of the jobs in the list box and have it open the ...

I'd like to update a column in my table when a report that prints labels has
been run.  I've used the label wizard (reports) to use a query that returns
all addresses that haven't been printed to a label.  Once I print those
labels I'd like to update the column (Yes/No) to show ...

Hi,
I've begun building a database which contains peoples information, pretty
standard really. I know how i would do this with asp if i was building it
online, however for once im able to just use access as an environment which

I have used an input mask on my form for Zip Code (xxxxx-xxxx).  If I only
have a zip 5, it will still display the "-".  Is there a way to display just
the zip 5 if no zip 4 exists (without the hyphen)?

First let me say that I really don't know how to put this problem into words.
So I am sorry if this is extremely confusing.
I have form that contains a subform with a continuous forms view.  The
subform has 4 data fields in it.  Data has been entered from the main form

We have more than 1 user at the end of a shift that enter data. It seems that
when we have more than 1 person using the form, data entry gets very
slow....any ideas out there?