Blank Forms

[AllenWhite]

Hi all,

I have a problem that I haven't been able to resolve. I have a form
that is opened by clicking a command button which does a simple
DoCmd.OpenForm action. The form being opened is a fairly simple form
with the Data Entry attribute set to Yes.

On my machine, it works fine. On other users' machines, it comes up
totally blank - just a grey square with no controls at all. I did
search for similar problems and found some discussions of the
parameters used to open the form for data entry, but I removed all
parameters from the DoCmd.OpenForm to no effect. And of course, a
compact and repair for good measure.

The JET versions are all the same (4.0.8618.0). I have Access version
10.0.2616.0, while everyone else has 11.0.5614.0 - any suggestions?

[Ed Robichaud]

It's quite possible that the form is corrupt. Try importing it into a new
database, compact/repair it and see if it now displays correctly. If so,
delete the original form in the original database, and import the new copy
back into the original database.
-Ed

"AllenWhite" <co******@allenwhite.netwrote in message
news:11**********************@r23g2000prd.googlegr oups.com...

Hi all,

I have a problem that I haven't been able to resolve. I have a form
that is opened by clicking a command button which does a simple
DoCmd.OpenForm action. The form being opened is a fairly simple form
with the Data Entry attribute set to Yes.

On my machine, it works fine. On other users' machines, it comes up
totally blank - just a grey square with no controls at all. I did
search for similar problems and found some discussions of the
parameters used to open the form for data entry, but I removed all
parameters from the DoCmd.OpenForm to no effect. And of course, a
compact and repair for good measure.

The JET versions are all the same (4.0.8618.0). I have Access version
10.0.2616.0, while everyone else has 11.0.5614.0 - any suggestions?

[Salad]

Ed Robichaud wrote:

It's quite possible that the form is corrupt. Try importing it into a new
database, compact/repair it and see if it now displays correctly. If so,
delete the original form in the original database, and import the new copy
back into the original database.
-Ed

"AllenWhite" <co******@allenwhite.netwrote in message
news:11**********************@r23g2000prd.googlegr oups.com...

>>Hi all,

I have a problem that I haven't been able to resolve. I have a form
that is opened by clicking a command button which does a simple
DoCmd.OpenForm action. The form being opened is a fairly simple form
with the Data Entry attribute set to Yes.

On my machine, it works fine. On other users' machines, it comes up
totally blank - just a grey square with no controls at all. I did
search for similar problems and found some discussions of the
parameters used to open the form for data entry, but I removed all
parameters from the DoCmd.OpenForm to no effect. And of course, a
compact and repair for good measure.

The JET versions are all the same (4.0.8618.0). I have Access version
10.0.2616.0, while everyone else has 11.0.5614.0 - any suggestions?

Another possibility is that if the form uses a query as the recordsource
and the query uses inner join for everything and not everything is
available.

What I might do is put a Debug.Print on the SQL, maybe in the OnCurrent
event and open/close the form. Then grab that SQL and copy/paste it
into a new query and see what that query shows.