My database works in a multiuser environment where different people may
create simustaneously records to be written to the same table. It happens
that if one person creates a record and fills in data, another person
sometimes overwrites that record while creating her own a few ...

i have created an access table and i'm now in the from that i designed. in
one of the data entry fields named "name" i'm trying to use an if statement
so that when a user enters the first initial of his first name (validation
text will ask user to enter this info) when he enters ...

We have two Access apps running on Citrix, each one is used by about 15
people at a time.  The back end Access databases are both about 120 meg, and
doubling every year for the past four years.  It's grown more than we
thought.

I had to build a query to which a form is bound in order to view data based
on criteria that I could not get to work any other way.
The qurey takes [VehicleNumber]  and limits the query to the specific
vehicle, then takes [txtStartDate] and [TxtEndDate] and searches for entries

I am using a label as a menu button and need the OnClick event to set the
source object for a subform and then set focus to a certain control in the
subform.
Please see code below (Form1 has a control called TextBox2)

The code below doesn't work out:
Forms!"Name of Main Form!Name of Subform!Name of Textbox= Value
Could you tell me the correct way of inserting data into a textbox in a
subform?

Please excuse my multiposting, I just learned how to simultaneously post to
more than one newsgroup.
I need to be able to click on a subform control and open a form in acDialog
mode. A subform control only has an Enter event and when I try that the code

Form 1 (record source is a table) has a combo box that that is used to search
for records.  The row source for the combo box is a query.  If the desired
record is not found, Form 2 (record source is same table as Form 1) opens to
allow entry of the new record.  After adding the ...

MS Access 2000, Windows XP
=======================
Hi,
I have a custom toolbar (Custom_ReportToolbar) with 3 buttons (Magnify,

To improve data quality, I put code in the BeforeUpdate event of my main form
to check for certain items the user left blank, cancel the update, and inform
the user. This works well except an error occurs when there's missing info.
and the user tries to navigate to a new record ...

I am trying to offer a multiple column combo box drop-down in one control on
an ACCESS form and have it automatically insert the other column data into
several respective controls on the same form in the same user step.

I have the following code which when run prompts to the value of
'strLocation'. Can someone tell me what I am missing. Thank you in
advance.....
-------------------

For some reason, I'm having difficulty verifying whether or not a text box is
populated.  Here's what I have:
Text Box "faxnumber"
Check Box "sendfax"

I'm not sure if this is possible but I hope so! I have an append query which
is run by a button on  a form. This query moves "Confimed Records" to another
table. Is there any way I could delete the same records from the old table
without the user clicking another button to run a ...

Below is a function that I found in a sample application.   This function
works well and checks the validity of correct passwords.
Now, I need some help with modifying it... currently, when a user enters a
"Division" and "Branch" plus correct password the line "MsgBox "Login