J
JenPavey
I noticed this problem months ago, but didn't really think much of it until
now: I developed a FE/BE database in Access 2003. Users overwrite their FE
as I complete design upgrades. This has worked well for us... Although on a
few computers, of which I've determined have Access 2000 9.0.2720, whenever
they overwrite their FE, on the first time of opening, it does not want to
work properly until you close the database and open it a second time.
In more detail: I have an autoexec macro opening a form where the user
selects their name from a drop down. Then they hit "OK"... On Click VBA code
runs to open up another form (Main Menu) and then hide the user name form.
On the Access 2000 machines, once the FE has been overwritten, the user can
select their name from the drop down but the "OK" does not work. We close
the database at this point and re-open and everything then works fine...?
Here's the OK button code if this has anything to do with the problem:
Private Sub Command5_Click()
DoCmd.OpenForm "Search Form"
Me.Visible = False
End Sub
I usually can find all the answers I want in this forum - it's just been a
matter of asking my question correctly, but I can't seem to find anything
related to this issue... hence - here's my first post.
Any and all help is greatly appreciated.
Thanks
JP
now: I developed a FE/BE database in Access 2003. Users overwrite their FE
as I complete design upgrades. This has worked well for us... Although on a
few computers, of which I've determined have Access 2000 9.0.2720, whenever
they overwrite their FE, on the first time of opening, it does not want to
work properly until you close the database and open it a second time.
In more detail: I have an autoexec macro opening a form where the user
selects their name from a drop down. Then they hit "OK"... On Click VBA code
runs to open up another form (Main Menu) and then hide the user name form.
On the Access 2000 machines, once the FE has been overwritten, the user can
select their name from the drop down but the "OK" does not work. We close
the database at this point and re-open and everything then works fine...?
Here's the OK button code if this has anything to do with the problem:
Private Sub Command5_Click()
DoCmd.OpenForm "Search Form"
Me.Visible = False
End Sub
I usually can find all the answers I want in this forum - it's just been a
matter of asking my question correctly, but I can't seem to find anything
related to this issue... hence - here's my first post.
Any and all help is greatly appreciated.
Thanks
JP