Access 2000

[Guest]

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

 

[Brian Bastl]

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.

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

 

[Vincent Johns]

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 <[email protected]>
Please feel free to quote anything I say here.

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

 

[Vincent Johns]

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 <[email protected]>
Please feel free to quote anything I say here.

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 <[email protected]>
Please feel free to quote anything I say here.

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

 

[Keith Wilby]

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

 

[Vincent Johns]

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 <[email protected]>
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,
that will be done automatically for you.

Shouldn't the OP also be using "between" and not ">=" and "<="?

Keith.
www.keithwilby.com