UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Startup Form Not Opening, Access 2003    
 
   
ecovindaloo
post Jul 10 2019, 10:21 AM
Post#1



Posts: 230
Joined: 1-November 08
From: New York Area, USA


I inherited an Access 2003 database. In the start up options a form is set to open on the start up.

The issue is that this form is not opening. If I go into the Database Window and click on the form it still doesn't open. I'm able to get into the Design View of the form, but if I try to change to Form View nothing happens and it stays in Design View.

I haven't used this version in awhile. I'm probably just missing something simple.

Any ideas?
Go to the top of the page
 
theDBguy
post Jul 10 2019, 10:26 AM
Post#2


Access Wiki and Forums Moderator
Posts: 75,699
Joined: 19-June 07
From: SunnySandyEggo


Hi. While in design view, are there any code behind the form? If so, what do they do?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Jul 10 2019, 10:27 AM
Post#3


UA Admin
Posts: 35,290
Joined: 20-June 02
From: Newcastle, WA


The most likely explanation is either a corrupt form (it can happen), or code that should be running in the form's Open event which raises an error of some sort.

Can you compile the VBA for this mdb?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
ecovindaloo
post Jul 10 2019, 10:31 AM
Post#4



Posts: 230
Joined: 1-November 08
From: New York Area, USA


It turned out that there was a missing reference for the mousewheel. Once I unchecked that reference the form opened.

Thanks for the quick responses.
Go to the top of the page
 
dale.fye
post Jul 10 2019, 02:11 PM
Post#5



Posts: 66
Joined: 28-March 18
From: Virginia


be careful about deleting the reference to the mouse wheel. After removing that reference, your code may not compile.

It has been a while, but as I recall, using the mouse wheel dll was the only way to prevent users from accidentally changing records in a form by simply scrolling with the mouse wheel.


--------------------
Dale Fye
Microsoft Access MVP 2013-2016
Developing Solutions, LLC
Go to the top of the page
 
ecovindaloo
post Jul 10 2019, 04:06 PM
Post#6



Posts: 230
Joined: 1-November 08
From: New York Area, USA


Dale,

Thanks for that information. I'm updating this 2003 database to the 2016 version. I'll keep an eye out for this issue.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th July 2019 - 05:13 AM