MDE -vs- MDB (office 97 on NT4.0)

Topic

New Reply

THis is really strange to me. I have a database which I made an MDE from. The MDB version works perfectly. The MDE version gives me an error message when it is closed via the close button “x” at the top right of the screen. I know where the error is generated but don’t know why. The scenario is as follows: when the user opens the db and opens a form based on a table and closes it via the “x” at the top right of the screen, a requery error messages is generated which is triggered from an “on close” event. I need this requery to take place since there are other processes in the onclose event which follow it. All things being equal the MDB which was used to create this MDE does not generate this message. I have fully compacted (several times) prior to making the MDE. What would cause this to happen and is there a fix?

Thank You

Reply | Quote

Replies

Do you have an example of the on close event event procedure or even attach a demo of the form.

Reply | Quote

The following is a snippet of the on close event:

‘Me![Date_Priced] = Now()
‘DoCmd.Requery

The “Date_Priced” is used to toggle an archieve procedure. If the record is not used for 90 days it rolls into an archieve list so it inserts the date everytime the record is opened.

Thanks

Reply | Quote

Not really getting involved in the archive procedure, perhaps your line of would be better located some-where before the form is closed.

see the attached zip.

I’ve added a button on the form which when clicked, creates a message box asking the user if he wants to close the form, if he selects YES, then your code will be run. If NO, the form stays open.

Hope this helps.

Check the code behind the button and change the field names to what you need.

If this is ok, you can then disable the crosshair thru properties.

Dave

p.s Put the Me.requery before the DoCmd.close bit.

Reply | Quote

I’m not sure exactly what your problem is, but for one thing DoCmd.Requery is not the recommended way to requery a form. In fact, the correct syntax is DoCmd.Requery {controlName}, and if no controlname is specified, the current active control is used. If you want to requery the form, use Me.Requery.

And this form only displays a single record? And when you close the form you update that record to show that it has been looked at? And why is the requery needed?

Reply | Quote

Sorry Hadn’t noticed you are running A97

Here’s the code behind the button;

Private Sub YourButtonName_Click()
Dim intButSelected As Integer, intButType As Integer
Dim strMsgPrompt As String, strMsgTitle As String

strMsgPrompt = “You have Selected To Close This Form, Do You Want To Continue”
strMsgTitle = “Close Form”

intButType = vbYesNo + vbQuestion + vbDefaultButton1
intButSelected = MsgBox(strMsgPrompt, intButType, strMsgTitle)

If intButSelected = vbYes Then
Me.[YourDateFieldName] = Now()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Me.Requery
DoCmd.close

Else
‘ NO button code…
End If
End Sub

Hope this helps

Dave

Reply | Quote