Search results

Look at TransferDatabase in Help (or TransferText)

Dunno what a RichEdit is either, I'm afraid.

What is a 'ReachEdit'?

Your code ... Private Sub work_orders_button_Click() On Error GoTo Err_work_orders_button_Click Dim strMsg As String, strTitle As String, stDocName As String strMsg = "Please enter a " strTitle = " Missing Entry" stDocName = "Enter a New Work Order Form" If IsNull(Me![Clearance...

You can't. But you can simulate a check box with a label and use its On Click event to change its Caption (i.e. contents) and set the value in your (hidden) check box ...

If you have a button on the first form that opens the second form then the 'exit sub' in the code I posted earlier stops the code from going any further - it will never get to the part that opens the second form so there will be nothing to cancel.

A good way would be to create a query with the columns in the order you want and base the sbform on this query.

Sorry for the duplication - trouble with my keyboard

In the On Click event for the button start by checking the relevant field(s) on the original form ... If IsNull(Forms!MyFormName!MyControlName) then msgbox "Blah blah blah"

In the On Click event start off by checking the relevant field(s) If isnull(forms!MyFormName!MyFieldName) then msgbox "blah blah blah" exit sub end if

Well done. Another 'oddity' noted for future reference.

There is a simple of way of highlighting the active control on a form: Set the background colour (Back Color) of the fields to, say, yellow. Now make the Back Style transparent. Now, when the control receives the focus its background will be yellow.

I think maybe you are confusing two things here: You are Canceling the Update event, so the data is not changed, but you are doing nothing about the Close event. That's why the form closes. You need to put code in a 'cancelable' event concerning form closure ...

I can only guess at the situation, of course, but it sounds as if, if it were my problem, I'd be removing stuff from the form bit-by-bit to try and isolate what causes the difficulty. Good luck.

Don't really know if this applies to A2002 but it has been reported (frequently) that in earlier versions, if you create an object (eg a recordset) and do not explicitly close/destroy it yourself then Access can refuse to close. Also, I seem to recall a problem with testing for True under some...

It looks as if you have some incorrect or missing references. Open up any module in design mode (or create a new one - you won't have to put anything in it). Click on the Tools menu and select References. Look for any that state 'missing'. You will have to scroll down the list and select the...