I have a report that when it is opened up, it starts out with a dialog box I
made from a form.  It has a list box and a date to and date from field.
The list box works ok when it is set to NOT allow multiple selections.
When I set it to allow multiple selections it doesn't return ...

I give the user the option to NOT save a new record if they've changed their
mind by using the following code in the BeforeUpdate event of the form:
   If Me.NewRecord Then
   If MsgBox("Do you want to save this new document?", vbYesNo) = vbNo Then

I need help and suggestion on inventory form that require to combine 2 combo
box value that will determine the result on the subform

how to save the combobox contents in a form

I have a Memo Field in my table called Directions. In my form the user must
capture the directions on how to get to a client. I would like the ability to
paste a link from a website i.e. maps.google.com which would have the
directions. When I do this it does not recognise the ...

I have a combo box, and I want to be able to display the number "1" in a
textbox in  the case I select the value "USD" ifrom my combo box.
This is what I have right now and it is not working...
=IIf([Currency_Code]="USD",[Exchange_Rate]=1,[Exchange_Rate]=0)

I'm not sure how to do this exactly, but it seems like either Iif or After
Update someow might work.
I have two combo boxes on a form with values that I entered.  The first one
is then entered into the Ad Size field.  The second one is then added into

I am using Access 2002  in my form I have many text boxes.  I set the tab
order how I want it, but my problem is after pressing the enter key the
cursor will not go on to the next field (text boxes) only on some text boxes
it will, but not all text boxes.  All I want is to have ...

Does anyone know if it's possible to create a form for users where they can
attach a document such as word or excel and the file be stored in the Access
database.  I've read threads on possibly using hyperlinks to point to
documents, but nothing about if its possible to import ...

Could anyone please help me? I have a subform linked to a main for
Master link is a text field on the main form while child link is
unique column on the subform. The RecordSource of the subform is
query. What I want to do is to populate other unbound textfield

Is there a VB function which can be used to check that a date is valid?
Thanks,
Seth

I have 4 option buttons within a frame (fraDateRange). I want to determine if
option button optLast3Years is set.
The following code is producing an error
If Me!optLast3Years.Value = True Then strData = "Option2 detected "

u have 31 buttons on a form with captions 1 to 31. When the cursor hovers
over each botton I want the controltiptext to display the day of the week of
that day.
What event can I use to reset the controltip text so that it refreshes on

I have a data entry form that I have automatically run a spell check before
it saves the data.  However, if I select the Cancel option from the spell
check dialog box, instead of just cancelling the spell check operation, my
data edits get cancelled/undone.  Is there a way that I ...

In my DB I have users enter data through a form that puts the data into a
temp table before appending the data to a main table called Details.  The
Details table serves as a history of all edits to a particular record.  Each
record includes a field called [Activity Name].  I want ...