Kamis, 04 Februari 2016

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

 

John, 
I just did it, then I found that the criteria ">=Date()" in the query cause the problem "Invalid use of Null". What Shall I do? Thanks.
Best Regards,
Kevin


 
Date: 2016-02-04 20:43
Subject: Re: [MS_AccessPros] Some forms won't open
 

Yes, you will get an error if PartID is Null.  You could try:


Start: CDate(DMin("PartItineraryDate","tblPartItinerary","PartID=" & NZ([tblPart].[PartID], 0)))

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 1:33 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John, 
I found that the problem is caused by:
Start: CDate(DMin("PartItineraryDate","tblPartItinerary","PartID=" & [tblPart].[PartID]))
What Shall I do?
Best Regards,
Kevin


 
Date: 2016-02-04 20:22
Subject: Re: [MS_AccessPros] Some forms won't open
 

Kevin-


Not necessarily.  Are you doing this in the .accde or the .accdb?  If in the .accdb, you should be able to go into Design view to try to figure out what's wrong.  You can't use Design view in a .accde file.

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 1:15 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,
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,
Kevin


 
Date: 2016-02-04 18:39
Subject: Re: [MS_AccessPros] Some forms won't open
 

Kevin-


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,
Kevin


 
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,
Kevin






__._,_.___

Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (11)

.

__,_._,___

Tidak ada komentar:

Posting Komentar