Form won't open

[Edwinq]

Hi there,

I have an application that opens a form with a simple "docmd.openform("formname")"

On two out of four machines the form opens. The other two systems only say "calculating" for a few seconds and nothing else.

pretty sure it's a pc or user setting, but which one ??

thanks in advance.

Edwin

 

[Jrenter2]

Hi Edwin,

I may be way off here, but others are sure to chime in....I know that this will happen if the machines are running different versions of MS runtime or full versions.

In example, for me, I know that happened when a user had upgraded to 2007 version, but the db was created in 2000.

I ended up converting the db to 2007 and then all was well.

Two more things off the top of my head first being, is whether or not users are trying to access the same form at the same time.

The second one being whether or not your db does a compact/repair upon closing.

These may be some items to look at and like I said, someone else may be able to shed some light on the subject as well.


HTH,

Joe

 

[ghudson]

Hi there,

I have an application that opens a form with a simple "docmd.openform("formname")"

It could be the format of your command for it should look like this...

DoCmd.OpenForm "formname"

Notice, no parenthesis and a space after OpenForm

 

[Edwinq]

thanks for your reply Joe and ghudson
Users are all using Office 2007, only the OS is different sometimes, but to get confused ..... There are two computers were all works fine. One is Windows7, the other one is XP....

I will try without the parenthesis today .
Will post results later...

 

[Edwinq]

Solved ... just let you know in case someone else has the same problem...
The database is on an sql server, users were logged in locally, so they had no rights on the sql server. Did not get odbc error though ...

thanks for help anyway !! lots appreciated
edwin

 

[Jrenter2]

Glad you got it worked out and thanks for the final resolution.



Joe