Windows 7 & Access 2007

[Rick A.B.]

I've been playing with Windows 7 RC and Access 2007. I've loaded a
secured split database with the back end on the Network. When I go to
close my main form with out making any changes by clicking the close
button it takes about 15 seconds for the form to close. If I click
the X in the upper right corner it closes immeadiatly. I have the
following behind the close button.

Private Sub Close_Click()
On Error Goto Err_Close_Click
DoCmd.Close
Exit_Close_Click:
Exit Sub
Err_Close_Click:
MsgBox Err.Description
Resume Exit_Close_Click
End Sub

Is there something I'm missing? Is there some other event that runs
when the form closes without being dirty? There is nothing in the
UnLoad event. All references are good. I've compiled with no
errors.

Rick

 

[June7 via AccessMonster.com]

Try:
DoCmd.Close acForm, Me.Name, acSaveNo
I put the acSaveNo parameter in all my Close events.

 

[Rick A.B.]

Try:
DoCmd.Close acForm, Me.Name, acSaveNo
I put the acSaveNo parameter in all my Close events.

Thanks for the suggestion but had no effect. This is the only form
that does this, all the others close upon click. This database works
perfect with windows xp. I put a pause break on that line of code and
there seems to be nothing else happening. I have full permissions on
the folder it's installed on. Any other suggestions appreciated.

Rick

 

[June7 via AccessMonster.com]

Not much, because code looks good, other than rebuild the form. I have a
couple of times had a form or report 'go bad', not work quite right and could
find no reason for it. Finally resorted to rebuilding. Either start a new
form or copy one that works properly and delete the controls, in either case
copy controls from bad form/report, copy RecordSource, copy code, rename. Had
to do this with a report last week, afterwards it worked normal.

 

[Rick A.B.]

Not much, because code looks good, other than rebuild the form. I have a
couple of times had a form or report 'go bad', not work quite right and could
find no reason for it. Finally resorted to rebuilding. Either start a new
form or copy one that works properly and delete the controls, in either case
copy controls from bad form/report, copy RecordSource, copy code, rename.Had
to do this with a report last week, afterwards it worked normal.

Thought I'd post in case anyone was interested. I solved the problem
by just deleting the Close button and the code behind it then
recreating it. It now works perfectly. I have to say so far I'm
impressed with windows 7, I'm running it on a 3 year old box with
just 1 gig of memory and it's pretty snappy