I have an Access 2000 database that has worked OK for some years, but about
once a week or so, when I open it, none of the butttons on the main menu
form work. I click them and nothing happens. Their function is to open
other forms or run reports. However, if I close the form and reopen it from
the database window the buttons work fine.

What can cause this kind of "freeze-up"?

Mich

I have this happen to me occasionally after I compact the database. Opening
the form in design view, then returning to form view, then saving, usually
fixes it. I don't know what causes it though.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"M Skabialka" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have an Access 2000 database that has worked OK for some years, but
about
> once a week or so, when I open it, none of the butttons on the main menu
> form work. I click them and nothing happens. Their function is to open
> other forms or run reports. However, if I close the form and reopen it
from
> the database window the buttons work fine.
>
> What can cause this kind of "freeze-up"?
>
> Mich
>
>

Any code running in the main menu form when it opens? Or is there additional
code running after that code opens the main menu form?

--

Ken Snell
<MS ACCESS MVP>

"M Skabialka" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an Access 2000 database that has worked OK for some years, but about
>once a week or so, when I open it, none of the butttons on the main menu
>form work. I click them and nothing happens. Their function is to open
>other forms or run reports. However, if I close the form and reopen it
>from the database window the buttons work fine.
>
> What can cause this kind of "freeze-up"?
>
> Mich
>

This is all the code running on open... all other code is triggered by user
input. Nothing seems lethal here!

Private Sub Form_Load()

'Show only one windows in the taksbar, not one per form, tables, report,
etc
Application.SetOption "ShowWindowsInTaskbar", False
Application.SetOption "Log Name AutoCorrect Changes", False
Application.SetOption "Perform Name AutoCorrect", False
Application.SetOption "Track Name AutoCorrect Info", False
DoCmd.MoveSize 0, 0 'Move to top left of screen

' Minimize the database window.
DoCmd.SelectObject acForm, "frmMainMenu", True
DoCmd.Minimize
LineNum = Null
RealRate = Null

End Sub

"Ken Snell (MVP)" <(E-Mail Removed)> wrote in message
news:eO4LS$(E-Mail Removed)...
> Any code running in the main menu form when it opens? Or is there
> additional code running after that code opens the main menu form?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "M Skabialka" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have an Access 2000 database that has worked OK for some years, but
>>about once a week or so, when I open it, none of the butttons on the main
>>menu form work. I click them and nothing happens. Their function is to
>>open other forms or run reports. However, if I close the form and reopen
>>it from the database window the buttons work fine.
>>
>> What can cause this kind of "freeze-up"?
>>
>> Mich
>>
>
>

Another ACCESS MVP has reported that he's seen similar behavior in ACCESS
2000, and the "fix" for him in that situation was to run the form in Restore
size mode, not maximized. Is this form maximized when the problem happens?

--

Ken Snell
<MS ACCESS MVP>

"M Skabialka" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> This is all the code running on open... all other code is triggered by
> user input. Nothing seems lethal here!
>
> Private Sub Form_Load()
>
> 'Show only one windows in the taksbar, not one per form, tables,
> report, etc
> Application.SetOption "ShowWindowsInTaskbar", False
> Application.SetOption "Log Name AutoCorrect Changes", False
> Application.SetOption "Perform Name AutoCorrect", False
> Application.SetOption "Track Name AutoCorrect Info", False
> DoCmd.MoveSize 0, 0 'Move to top left of screen
>
> ' Minimize the database window.
> DoCmd.SelectObject acForm, "frmMainMenu", True
> DoCmd.Minimize
> LineNum = Null
> RealRate = Null
>
> End Sub
>
> "Ken Snell (MVP)" <(E-Mail Removed)> wrote in message
> news:eO4LS$(E-Mail Removed)...
>> Any code running in the main menu form when it opens? Or is there
>> additional code running after that code opens the main menu form?
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "M Skabialka" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I have an Access 2000 database that has worked OK for some years, but
>>>about once a week or so, when I open it, none of the butttons on the main
>>>menu form work. I click them and nothing happens. Their function is to
>>>open other forms or run reports. However, if I close the form and reopen
>>>it from the database window the buttons work fine.
>>>
>>> What can cause this kind of "freeze-up"?
>>>
>>> Mich
>>>
>>
>>
>
>

All my forms run in restore mode; when reports open they maximize but
restore on close, so forms are never maximized.


"Ken Snell (MVP)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Another ACCESS MVP has reported that he's seen similar behavior in ACCESS
> 2000, and the "fix" for him in that situation was to run the form in
> Restore size mode, not maximized. Is this form maximized when the problem
> happens?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "M Skabialka" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> This is all the code running on open... all other code is triggered by
>> user input. Nothing seems lethal here!
>>
>> Private Sub Form_Load()
>>
>> 'Show only one windows in the taksbar, not one per form, tables,
>> report, etc
>> Application.SetOption "ShowWindowsInTaskbar", False
>> Application.SetOption "Log Name AutoCorrect Changes", False
>> Application.SetOption "Perform Name AutoCorrect", False
>> Application.SetOption "Track Name AutoCorrect Info", False
>> DoCmd.MoveSize 0, 0 'Move to top left of screen
>>
>> ' Minimize the database window.
>> DoCmd.SelectObject acForm, "frmMainMenu", True
>> DoCmd.Minimize
>> LineNum = Null
>> RealRate = Null
>>
>> End Sub
>>
>> "Ken Snell (MVP)" <(E-Mail Removed)> wrote in message
>> news:eO4LS$(E-Mail Removed)...
>>> Any code running in the main menu form when it opens? Or is there
>>> additional code running after that code opens the main menu form?
>>>
>>> --
>>>
>>> Ken Snell
>>> <MS ACCESS MVP>
>>>
>>> "M Skabialka" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>>I have an Access 2000 database that has worked OK for some years, but
>>>>about once a week or so, when I open it, none of the butttons on the
>>>>main menu form work. I click them and nothing happens. Their function
>>>>is to open other forms or run reports. However, if I close the form and
>>>>reopen it from the database window the buttons work fine.
>>>>
>>>> What can cause this kind of "freeze-up"?
>>>>
>>>> Mich
>>>>
>>>
>>>
>>
>>
>
>

I'm sorry... I don't have another suggestion at this time.

--

Ken Snell
<MS ACCESS MVP>

"M Skabialka" <(E-Mail Removed)> wrote in message
news:OJUE%(E-Mail Removed)...
> All my forms run in restore mode; when reports open they maximize but
> restore on close, so forms are never maximized.
>
>
> "Ken Snell (MVP)" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Another ACCESS MVP has reported that he's seen similar behavior in ACCESS
>> 2000, and the "fix" for him in that situation was to run the form in
>> Restore size mode, not maximized. Is this form maximized when the problem
>> happens?
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "M Skabialka" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> This is all the code running on open... all other code is triggered by
>>> user input. Nothing seems lethal here!
>>>
>>> Private Sub Form_Load()
>>>
>>> 'Show only one windows in the taksbar, not one per form, tables,
>>> report, etc
>>> Application.SetOption "ShowWindowsInTaskbar", False
>>> Application.SetOption "Log Name AutoCorrect Changes", False
>>> Application.SetOption "Perform Name AutoCorrect", False
>>> Application.SetOption "Track Name AutoCorrect Info", False
>>> DoCmd.MoveSize 0, 0 'Move to top left of screen
>>>
>>> ' Minimize the database window.
>>> DoCmd.SelectObject acForm, "frmMainMenu", True
>>> DoCmd.Minimize
>>> LineNum = Null
>>> RealRate = Null
>>>
>>> End Sub
>>>
>>> "Ken Snell (MVP)" <(E-Mail Removed)> wrote in message
>>> news:eO4LS$(E-Mail Removed)...
>>>> Any code running in the main menu form when it opens? Or is there
>>>> additional code running after that code opens the main menu form?
>>>>
>>>> --
>>>>
>>>> Ken Snell
>>>> <MS ACCESS MVP>
>>>>
>>>> "M Skabialka" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>>I have an Access 2000 database that has worked OK for some years, but
>>>>>about once a week or so, when I open it, none of the butttons on the
>>>>>main menu form work. I click them and nothing happens. Their function
>>>>>is to open other forms or run reports. However, if I close the form
>>>>>and reopen it from the database window the buttons work fine.
>>>>>
>>>>> What can cause this kind of "freeze-up"?
>>>>>
>>>>> Mich
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>