Group:  Microsoft Access ยป microsoft.public.access.odbcclientsvr
Thread: Form Not Loading or Not Visible

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Form Not Loading or Not Visible
Rick 14.07.2006 14:46:01
Request Assistance:

Has anyone had a problem where most forms in a database will load but one
won't? I have some users, including myself, who can open all forms without a
problem but I also have a few who can open the databse, open/manipulate data
in every form except for one. The one form does not appear, it gives the
impression that the form is trying to load but won't. Have pop-up and model
on every form.

We've tried everything we can think of to resolve this. We've un-installed
and re-installed office 2003, we've re-run ODBC connections, we've copied dns
files from my machine to others, we've looked at the registry to ensure
everyone was creating pipe connections instead of np. We have tried changing
security from medium to low. Nothing is working on the systems that won't
load/display the one form.

I know the form and code is working properly since most users can
open/manipulate the data on the form.

System: We are running an Access 2003 front end, SP2, with an ODBC
connection to a SQL 2000 server. All users have XP w/SP2 as well.

Any troubleshooting recommendations are greatly appreciated. Thanks in
advance.
Re: Form Not Loading or Not Visible
Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 14.07.2006 15:51:22
hi Rick,

Rick wrote:
[Quoted Text]
> Has anyone had a problem where most forms in a database will load but one
> won't?
Most commen problems:

- wrong data sources and an exessive use of On Error Resume Next
- form opens, but is out of the normal window view port, try on form
load MoveTo 0,0



mfG
--> stefan <--
Re: Form Not Loading or Not Visible
Rick 14.07.2006 17:59:01
Stefan,

Thanks for the help, it worked. A simple resolution we overlooked. We
thought for sure it was a system issue considiner I always set my forms to
auto center. In this case, I didn't and the MoveTo 0,0 worked perfectly.

Thanks

Rick

"Stefan Hoffmann" wrote:

[Quoted Text]
> hi Rick,
>
> Rick wrote:
> > Has anyone had a problem where most forms in a database will load but one
> > won't?
> Most commen problems:
>
> - wrong data sources and an exessive use of On Error Resume Next
> - form opens, but is out of the normal window view port, try on form
> load MoveTo 0,0
>
>
>
> mfG
> --> stefan <--
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net