Kamis, 04 Februari 2016

RE: Re: [MS_AccessPros] Some forms won't open


When this happens to me it is because I forgot to make sure all the code was compiled successfully before creating the accde file.


Open any form with code in Design View. Open the code editor by clicking the view code button on the Design Tab of the ribbon.


Select the Debug Menu. If the first item "Compile Database" is not grayed out then click it to compile the project. It won't compile if you have errors in your code but it will show you where the errors are. If it compile successfully then save and close the editor and re-create the accde file.


Bob Peterson



From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, February 04, 2016 7:16 AM
To: MS_Access_Professionals
Subject: Re: Re: [MS_AccessPros] Some forms won't open



After clicking on some forms, it pops up messeges like:

"Ivalid use of Null"

"The expression is typed incorrectly, or it is too complex to be evaluted, for example, a numeric expression may contain too many complicated elements. Try simplifying expression by assigning pars of the expression to variables."

I think the database is broken, right? What shall I do? Please help!

Best Regards,




Date: 2016-02-04 18:39

Subject: Re: [MS_AccessPros] Some forms won't open




Please explain what you mean by "some forms won't open."  Note that when you're running in an accde file with the Nav Pane hidden, you must provide command buttons on forms to be able to open forms and reports in your app.  You basically need a Switchboard form that opens on startup that lets you get to all the bits and pieces.


John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

(Paris, France)




On Feb 4, 2016, at 9:35 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


I found out that after turning off the "Display Navigation Pane". Some forms won't open. Please help!

Best Regards,




Date: 2016-02-04 16:17

Subject: [MS_AccessPros] Some forms won't open


Dear All,

After saving the database as "Make ACCDE", some forms won't open. What should I do? Help!

Best Regards,





Posted by: Robert Peterson <bob@alternatefinishing.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (13)



Tidak ada komentar:

Posting Komentar