Hi,

I am helping someone in remote location install and use an Access Application I wrote for him. When he click a button to open a form and add a new record, he gets a blank form without any controls at all. I have been unable to duplicate the problem, and was wondering if anyone had ever seen anything like this, or knew what might be causing this. The code used to call the table is...

    DoCmd.OpenForm "frmCorporate", acNormal, , , acFormAdd

Thanks in advance

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Mike,

When you say he gets no controls at all, do you mean he doesn't get any fields at all?

Kevin

dartcoach

Yep,

He tells me that he gets the title bar to the form, but the rest is just blank. I have tried to get him to send me a screen shot, but he has not yet been successful in doing that. I was thinking that my only option may be to try and establish a remote assistance connection through Windows, but would like to avoid that if possible.

Thanks

Mike

Mike
EchoVue.com

Mike,
Sorry for the stupid question, but I've had users, that when they see an add screen with no data in any of the fields, they think there is something wrong.

I've never seen this before. I think your screenshot is your best bet for now.

Kevin

dartcoach

Mike,

One other quick thing:
What OS?
What Version of Access?
What Screen Size?
What Screen Resolution?

If he has an old model, the screen resolution you designed in may be higher and he's only seeing part of the form.

Kevin

dartcoach

I believe he is on Office 2003, using XP, I'll confirm this thought. I wouldn't think that it would be screen resolution, since the other forms all show up.

I'll let you know though.

Mike

Mike
EchoVue.com

OK, I just got a screen shot from him, and he is using Windows XP in Classic Style, with Access 2003. His screen resolution is really high as well, I would guess 1024x768 at least, and I designed each form to fill an 800x600 screen. The problem only appears to be happening when the form is called to add a new record. I also had him test it on two other computers with the same results.

I just sent him a new database. I upgraded the mdb to 2003 format, and added the acWindowNormal parameter at the end of the DoCmd.openform command.

There are two buttons that open similar forms, both of which were showing up blank, so I have switched one to FormEdit mode to see if that makes a difference.

I'll let you know, unless you have any other ideas that I might be able to try.

Thanks

Mike

Mike
EchoVue.com

Hi ya,

This forms record source wouldn't happen to be based on a query would it???

J

No - My personal belief is that Queries are of the Devil!! I still haven't figured it out, partly because the computer that is giving the problem is on the other side of the country. It works just fine on the 5 or so machines I have tried that I actually have access to.

I have however gotten it to work, but it isn't real pretty. It's a Client management Application and the problem was adding a new client, so what I did was to call a function when the button was clicked. The function checks to see if there is a record with 'New Client' as the name, if there isn't it inserts the new record using SQL and then passes the value of the Primary key to that record, or the one with the 'New Client' name back to the called Sub, and then opens the Client form for editing. It worked great, which was a huge load off my shoulders - Nothing quite like a wierd and wacky problem like this to make you feel very insignificant and humble!!

Thanks for all your suggestions

Mike

Mike
EchoVue.com

Hi I realize this post is quite old (2005) but, echovue I was wondering if you could provide the code u used to solve the problem. I am very new to access and I am experiencing the exact same issue.

Any help/pointers would be much appreciated!