But, I know about setWarnings, and they are set, off then on.
I am capturing a Delete event, when the user clicks the row header in a
subform detail section, and allowing a delete under certain conditions.  If
the condition is met, I do a Cancel = False.  If they are not allowed ...

On a continuous form I have an unbound combo box in the Detail Section which
displays 3 columns from a query (makes up unique key). When a selection is
made from the combo box, 3 fields in the same row on the form automatically
populate. This works. I am using a continuous form ...

The two fields are customer and BookingNo.  IF the customer = "A" then I need
the BookingNo to be populated with any five digit character.  IF the customer
is anything else, I need the same BookingNo to = null.   Please include code
in your answer.

I have text boxes labeling the title and subtitle of a report that I want to
change after a person selects a value from a drop-down list in a combo box on
a form.  Please help with sample code references and/or tips on how to change
the values then open the report!

Some of our fields are numeric based such as PO#s.  Should I define these
fields as numeric?   If so, how do I limit the number of characters allowed
in this field?

How do I set up a report to automatically run every Monday morning for Monday
through Sunday of each week.
Also, How do I set up a report to automatically run on the last day of each
month?

I have a command button where I want to leave the OnClick Event Blank.
I want to set it from the previous form.  If I open it from form1 the
the OnClick event is This.......
If I open it from form2 then the OnClck event is that.  How would I do this?

why intLogonAttempts  never become greater than 3... all other code works
great, but intLogonAttempts sets itself back to 1 after every button
click...
Private Sub Login_Click()

I have converted an Access 2003 BE to SQL Server and am keeping my FE as an
MDB.
I have a form with several sub forms that use various filters and
master/child links to determine which data to display.  In one particular

I have a form with a subform.  Sub shows aggregate sums.  Also on main
form is a list box to show the details of the aggregate sums.
List box is filtered based on subform and all works well..
If I click on aggregate on subform, click a refresh button on main

I have an application with several custom menu bars.  I want to be able when
a user minimizes a particular form to display the main menu bar, instead of
still displaying the form's menu bar.  I tried on Deactiavate, but that only
works if some other window is open that the focus ...

Is there a way to show a detailed schedule without buying a separate program?
Here is my table:
[patientId]
[date]

I have a form that's been set to fit the entire screen, hiding the desktop
beneath it (including the Start taskbar). To do this, I made the form as
modal, popup, no borderstyle, no minmax and close buttons (there's a command
button on the form that replaces this function), etc. And ...

If i email a report (as .rtf) from a form e.g.
DoCmd.SendObject acSendReport, "STATS", acFormatRTF, "someone@email.net", ,
, "Please Find Stats"
...the report doesn't fire either the Report Open/Activate event

Have created 2 seperate reports that have different images as
backgrounds. Would like to have both pages print out as 1 print job (so
duplex printer will make each report page on opposite sides of page) -
I tried placeing both reports as subreports in a single report (lets