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:22Subject: Re: [MS_AccessPros] Some forms won't openKevin-
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, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL 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:39Subject: Re: [MS_AccessPros] Some forms won't openKevin-
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, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL 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:17Subject: [MS_AccessPros] Some forms won't openDear All,
After saving the database as "Make ACCDE", some forms won't open. What should I do? Help!Best Regards,Kevin
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar