Acceess MDB is unreliable

you're probably runnning out of space or soemthing; MDB is bloatware
move to SQL Server

On May 14, 3:55 pm, lovespar <loves...@discussions.microsoft.com>
wrote:

I need more information.

1. What does the event on the Switchboard form say? These are normal:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

   ' Move to the switchboard page that is marked as the default.
   Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
   Me.FilterOn = True
   
End Sub

Private Sub Form_Current()
' Update the caption and fill in the list of options.

   Me.Caption = Nz(Me![ItemText], "")
   FillOptions
   
End Sub

There are also FillOptions() and HandleButtonClick() subs that are suppose
to be there.

2. Any Autoexec Macros?

3. Go to Tools, Startup. What is listed under Display Form/Page? Is it
something different than Switchboard?

4. What macro do you run manually? How do you run it normally? How do you
know that it isn't working?

5. What tables and stuff did you add and where did you add it?

6. What does the macro do and what did you add? Post the code for the macro
by going to Macros on the Objects bar and clicking once on the macro. Next go
to File, Save As and change the drop down from Macro to Module. Say Ok and
then Convert. Next close the Macro then go over to Modules on the Objects
bar. You should see one named something like Converted Macro- TheMacroName.
Open it in design mode and post the code here.