one user cannot open form

[pbuethe]

When one user clicks on the button to open a particular form, she gets a blank gray screen. The second form opens fine for me and for another user. The code behind the button makes the first form invisible then opens the second form. It seems to be doing the first but not the second for this user. Why would this happen for just the one user and how could it be fixed? Thanks for any insight into this problem.

 

[missinglinq]

When one user clicks on the button to open a particular form, she gets a blank gray screen. The second form opens fine for me and for another user. The code behind the button makes the first form invisible then opens the second form. It seems to be doing the first but not the second for this user. Why would this happen for just the one user and how could it be fixed? Thanks for any insight into this problem.

When Access opens a form with bound fields and there is no available data in these fields, and the Add Records option is set to False, the controls are invisible, leaving only the background of the form. Sounds to me like the afflicted user's machine doesn't have a valid path to the underlying data. Is this DB set up as a one piece (with forms and tables in one unit) or as a Front end/Back end (with forms on the user machine and tables on a server) ?

The Missinglinq

 

[pbuethe]

When Access opens a form with bound fields and there is no available data in these fields, and the Add Records option is set to False, the controls are invisible, leaving only the background of the form. Sounds to me like the afflicted user's machine doesn't have a valid path to the underlying data. Is this DB set up as a one piece (with forms and tables in one unit) or as a Front end/Back end (with forms on the user machine and tables on a server) ?

The Missinglinq

There is a front end and back end, however:
1.Both are on the server and the user has only a shortcut on their machine.
2.Some of the tables reside in the front end, including the table on which this form is based.

 

[SQL_Hell]

Firstly, you should not have the front end on the server, as this defeats the point of having a front and backend, also you should not have tables in the front end as this also defeats the object.


Are you sure this is not a permissions issue?

 

[pbuethe]

Firstly, you should not have the front end on the server, as this defeats the point of having a front and backend, also you should not have tables in the front end as this also defeats the object.


Are you sure this is not a permissions issue?

Front end and back end on the server seems to be the practice in this department. (However, I did not design this database). As for the user, she has used other functions in the same database successfully in the past. I believe this was the first time she was trying to use this form. What else would I need to check for permissions?

 

[SQL_Hell]

Ok, if its their practice then its the wrong practice, you definitely want to consider sorting it all out, having a proper front end on the users machine and all the data and tables on the server.


To check security find out which table or query the form uses, then go to tools/security and check whether the user has permissions for this.

 

[pbuethe]

I checked the permissions (for the table and the form) and it looks the same from my machine and the user's. What else can I do? Thanks for your responses.

 

[pbuethe]

I tried opening the form and the underlying table directly from the database window on the user's machine. The results were:

- Opening the form in Form View: a message pops up: "There is no object in this control." When I click OK, I get the message:

"The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events.
The expression may not result in the name of a macro, user defined function or Event Procedure.
There may have been an error evaluating the function, event, or macro."

The only statement in the On Open event for this form is Docmd.Maximize.

- Opening the form in design view: again I get "There is no object in this control." On clicking OK, it does display the form in design view.

- The table opened fine and all the data was there.

Can anyone enlighten me as to the solution to these errors? Thanks for any suggestions. I need to solve this ASAP.

 

[SQL_Hell]

Have you tried re-installing access, it sound like you're missing some active X controls