I have a control in one of my forms that combines the street, city, state,
and zip fields from the same form, and formats them like you would for a
mailing label. The control is called [Full_Address] and here is the equation
it uses:

I have some batch procedures that involve making changes to multiple tables.
I want to make sure that I am able to "rollback" the changes if something
fails during the updates.
I have never used transaction processing withinVBA/Access and the help isn;t

I would like to execute code when exiting a subform:
Private sub MySubform_exit(Cancel as integer)
If the subform is dirty, this code executes, otherwise it appears that when
I move off the subform, nothing happens. Is there another event I can use or

When I was using Access 97, I was able to open a wizard that would write code
for me. I have moved to Access 2003 and can not find it.

Strange problem here.
When I hold down my shift key and bypass the startup sequence this
works fine.
When I open the database normally, hiding the database window, I

hi,
can any1 pls help me.
i have created a combo box and listed all of the letters (reports) that we
send to clients, which until now i have created a cmd button for each

I'd like to learn how to lock a certain record in a form. I have a table
with a field "Closed" (Yes/No). Whenever this value is YES, I'd like to lock
all fields in the form for that record - only the field "Zaklenjeno" should
be left unlocked. This rule should apply for the ...

I have the following code that is executed from a form that should print odd
or even pages but get a type mismatch at the Reports![Print...] command line.
What am I doing wrong?
Private Sub btnEvenOdd_Click()

I have a data filter built into my database for users to search all records.
I have used the following code:
If Len(Trim(Me.TextBox1)) > 0 Then stLinkCriteria = stLinkCriteria &
"[Field1] Like '*" & Me.TextBox1 & "*' AND "

I'm so close, but I can't get the dlookup to pick up the field "password"
from the table Employees.  
If InputBox("Please Enter a Password") =
"DLookup([Table]![Employees],[Employees]![Employee],[Employees]![Password]"

I have a main orders table that users can not update and another table for
order comments that the user can edit/add.  They are joined by order
number.  The user wants a quick way to update the order notes.  To start,
the comments table will be empty.  I would like to create form in ...

I have a form in which I run a Before Update event that verifies whether
certain fields contain data.  If they do not, the user needs to enter values
in those fields or the record will not be saved.  My Before Update event is
along the lines of:

I have a NotInList event which prompts the user if they want to add the
data to the combo box, exits if they don't, with Response =
acDataErrContinue and starts over.
If the user wants to add the data, I check with:

On a form, I have 100+ combo boxes.  To make sure that members not enter
additional data (beyond the options of the combo list), I set the combo's
property "Limit to List" = Yes.
Then, if a user attempts to type in an non-valid value, I'd like to throw a

How to highlight an entire row of records and hold this format while user
navigates to correct record, (6 fields) so an append query (via a control)
can then be run to append the selected row to another table.
I have a product search form with: