 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2006Access 2000
I am in the mid of writing a database using Access. A problem occurs. I have created Tables and Queries. One Queries with a field Criteria : >=[form]![FmProposal Date]![StartDate] And <=[form]![FmProposal Date]![End Date]. This form is link to the qurries and the form is link with the report. When I open the Queries and Forms there is this Error Message that occur "Enter Parameter Value" that require me to fill in the data. No data is capture by Access that fall between this period. What I wish to obtain? I wish to create a form that have a Start date and End date that can draw the date from the queries for normal user to key. But I am unable to link the queries and form together. There is always this error message that occur "Enter Parameter Value". I really appreciate your Professional Advise as I may have missed out certain minor criteria that is required for execution of this function. Thank you Doris, don't know if this will solve your problem, but your form reference should be [Forms], not [form]. HTH, Brian > I am in the mid of writing a database using Access. A problem occurs. > [quoted text clipped - 18 lines] > > Thank you I have a couple of quick suggestions. Check that [StartDate] and [End Date] are the names of controls that can deliver values, such as List Boxes. Labels probably won't do that. Is the name of the Form, "FmProposal Date", spelled correctly? You might, for debugging purposes, add a field to your Query with a value of DebugDateStart: [form]![FmProposal Date]![StartDate] With the Form open in Design View, you might open your Query in Query Design View and, in a blank field, choose Build. Or open a new Query and do that. The wizard will allow you to insert the names of controls from your Form, properly spelled, by clicking on them. The list of controls should make it obvious which ones are available to use in your Query. Then you can open the Query in Query Datasheet View and check that the value of [StartDate] is reaching the Query correctly. -- Vincent Johns <vjohns@alumni.caltech.edu> Please feel free to quote anything I say here. > I am in the mid of writing a database using Access. A problem occurs. > [quoted text clipped - 21 lines] > > Thank you Woops! I think Brian Bastl is correct, that you should use [Forms]. However, if you use Build, as I suggested, to run the expression wizard, that will be done automatically for you. -- Vincent Johns <vjohns@alumni.caltech.edu> Please feel free to quote anything I say here. > I have a couple of quick suggestions. > [quoted text clipped - 44 lines] >> >> Thank you > Woops! I think Brian Bastl is correct, that you should use [Forms]. > However, if you use Build, as I suggested, to run the expression wizard, > that will be done automatically for you. Shouldn't the OP also be using "between" and not ">=" and "<="? Keith. www.keithwilby.com The ... Between ... And ... construct may work OK (I think it's a part of Microsoft Jet SQL), but a short search of the documentation didn't reveal to me when it's available and when it isn't. I don't see a huge advantage to using it over using ">=" and "<=", as the length of the expression will be about the same in either case. One possible (semantic) problem with Between might be that it could be unclear, if one is using only integer Date values, how to distinguish between ">=" and ">". What I think is vitally important is that it be quite clear, to anyone reading the code, what is meant by each expression in the program. -- Vincent Johns <vjohns@alumni.caltech.edu> Please feel free to quote anything I say here. >>Woops! I think Brian Bastl is correct, that you should use [Forms]. >>However, if you use Build, as I suggested, to run the expression wizard, [quoted text clipped - 4 lines] > Keith. > www.keithwilby.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.