I have an Access (2003) frontend db using Oracle backend (10gR2). I
wish to lock records such that if another user tries to edit a record
already "opened" it would give them a message indicating try again
later. I have written the followng vba to acheive this without luck in

I was looking at some code for validation.... like this....
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
If ctl.Tag = "*" And Trim(ctl & "") = "" Then

I have a form called "frm_report_select" where users make some selections,
then a generic report opens.  I would like to change the recordset of the
report based on users selections.  Is there any way to do this from code of
the form?  I know how to change on the OnOpen from the ...

I have a Main form with Individual information (First Name, Last Name,
Contact Info, etc) and a subform with Specialty Information (Surgeon,
Pharmacist, Dentist, etc).  I need to set this form up so that the specialty
field must be populated in the subform IF there is a phone ...

I have a form [FA1_OrgMaster] that has a Combo Box [cboCounties].
The cbo's Row Source is a Query with 2 columns - [TYaa_CountyNumber] -
Integer, and [TYaa_CountyName] - Text 50 characters. The first column -
CountyNumber - is Bound, but only the 2nd is displayed to the user in ...

I'm working with a database, where a user complete a form and upon
submitting, a email notice is sent to several people. Those people are
hardcoded into the form. Is it possible before the user submits the
information, that can choose who to send the form to using their Outlook

Could someone please shed some light and assist with the config on this one?
Here is the code I use,
=DLookUp("[NAME]","[BRAGG]","[SSN] = Forms![NAME]")
I want to scan a SSN using a Bar Code Scanner into the form called IAG, I

I am building a database for Car Rentals. I have two tables that I want to
communicate: tblRentalAgreement and tblCar. The relationship between the
tables in a one to many (one Car to many Rental Agreements). I need certain
information to flow back an forth between the two tables ...

I am trying to export a .txt query file with user specified data. A parameter
doesn't work because I get the error message when exporting that "too few
parameter. Expected 1" message. From reading other posts, I made a form that
will act as input for the query instead of just the ...

I'm have a button on a form that will transfer text from a query to a text
file on my c:drive named "testfile05-01-07.txt"
I need to transfer text everyday, once a day.  I don't want to overwrite the
file each time.  Instead I want to create a new file each day with the above

I've created a form to search another form.  The information the user
would enter into the field would be the unique id and then they would
press a button below to search.  The problem I have is that if the
unique ID does not already exist it will be created.  Is there a way

I am a new programmer with a question about comboboxes.  My combo has the
Limit To List property set to Yes.  When I enter a value not on the list, I
get the standard Access message, "The text you entered isn't an item... " .  
I'm trying to trap this error so I can use my own ...

How can the scrollbar on a Datasheet be manipulated using VBA?
I have a datasheet as a subform and want to scroll down a specific number of
rows when it is first displayed.

can i ask u another question?
I have a form with ItemID and another form with ItemID too. This means this 2
forms are linked based on the ItemID. So, when i want to add record in the
second form, i need to type in the itemID again although it is under the same

Below are my VBA coding:-
Sum=sum+1
Me!QtyKitted = sum
My textbox is QtyKitted.