Re: Blank Forms

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" <commerce@xxxxxxxxxxxxxx> wrote in message news:1188501096.014589.281540@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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.
.

Quantcast