Input from Form to Query

D

dkillam

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And [Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with dates in the
required fields.
When the query is called by way of a report, the following error is generated.
"The Microsoft Jet database engine does not recognize
"Forme!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
 
D

Duane Hookom

Is the form open? Are there dates in the text boxes? A query will not open a
form.
Is the query a crosstab? Have you entered the data types of the parameters?
 
D

dkillam

Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


Duane Hookom said:
Is the form open? Are there dates in the text boxes? A query will not open a
form.
Is the query a crosstab? Have you entered the data types of the parameters?

--
Duane Hookom
MS Access MVP
--

dkillam said:
I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And [Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with dates in the
required fields.
When the query is called by way of a report, the following error is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
 
D

Duane Hookom

I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

dkillam said:
Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


Duane Hookom said:
Is the form open? Are there dates in the text boxes? A query will not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

dkillam said:
I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with dates in
the
required fields.
When the query is called by way of a report, the following error is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

dkillam

Fat fingers, typo in e-mail.
--
Dave


Duane Hookom said:
I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

dkillam said:
Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


Duane Hookom said:
Is the form open? Are there dates in the text boxes? A query will not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with dates in
the
required fields.
When the query is called by way of a report, the following error is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

How about sharing your SQL view? Are you entering your dates in the format
mm/dd/yyyy?

--
Duane Hookom
MS Access MVP
--

dkillam said:
Fat fingers, typo in e-mail.
--
Dave


Duane Hookom said:
I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

dkillam said:
Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


:

Is the form open? Are there dates in the text boxes? A query will not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with dates
in
the
required fields.
When the query is called by way of a report, the following error is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

dkillam

Here is the query which does work, except when I try to create a report using
chart wizard.
SELECT Count(Jamups.Location) AS CountOfLocation, Jamups.Location,
MachSetup.Machine, MachSetup.Mould
FROM Jamups INNER JOIN MachSetup ON Jamups.MachSetup_ID =
MachSetup.MachSetup_ID
WHERE (((Jamups.TimeStamp) Between [Forms]![Startup]![txtDateFrom] And
[Forms]![Startup]![txtDateTo]))
GROUP BY Jamups.Location, MachSetup.Machine, MachSetup.Mould
HAVING (((Jamups.Location) Like "blank side" Or (Jamups.Location) Like "mold
side") AND ((MachSetup.Machine) Like [Forms]![Startup]![cboMachine] & "*")
AND ((MachSetup.Mould) Like [Forms]![Startup]![cboMould] & "*"));

--
Dave


Duane Hookom said:
How about sharing your SQL view? Are you entering your dates in the format
mm/dd/yyyy?

--
Duane Hookom
MS Access MVP
--

dkillam said:
Fat fingers, typo in e-mail.
--
Dave


Duane Hookom said:
I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


:

Is the form open? Are there dates in the text boxes? A query will not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with dates
in
the
required fields.
When the query is called by way of a report, the following error is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

I missed any earlier mention of a "chart". It is common that the row source
of a chart is a crosstab query. As my first reply suggests, enter the data
types of your query parameters.
[Forms]![Startup]![txtDateFrom] Date/Time
[Forms]![Startup]![txtDateTo] Date/Time
[Forms]![Startup]![cboMachine] Text
[Forms]![Startup]![cboMould] Text

--
Duane Hookom
MS Access MVP
--

dkillam said:
Here is the query which does work, except when I try to create a report
using
chart wizard.
SELECT Count(Jamups.Location) AS CountOfLocation, Jamups.Location,
MachSetup.Machine, MachSetup.Mould
FROM Jamups INNER JOIN MachSetup ON Jamups.MachSetup_ID =
MachSetup.MachSetup_ID
WHERE (((Jamups.TimeStamp) Between [Forms]![Startup]![txtDateFrom] And
[Forms]![Startup]![txtDateTo]))
GROUP BY Jamups.Location, MachSetup.Machine, MachSetup.Mould
HAVING (((Jamups.Location) Like "blank side" Or (Jamups.Location) Like
"mold
side") AND ((MachSetup.Machine) Like [Forms]![Startup]![cboMachine] & "*")
AND ((MachSetup.Mould) Like [Forms]![Startup]![cboMould] & "*"));

--
Dave


Duane Hookom said:
How about sharing your SQL view? Are you entering your dates in the
format
mm/dd/yyyy?

--
Duane Hookom
MS Access MVP
--

dkillam said:
Fat fingers, typo in e-mail.
--
Dave


:

I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


:

Is the form open? Are there dates in the text boxes? A query will
not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with
dates
in
the
required fields.
When the query is called by way of a report, the following error
is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

dkillam

Never mind, I found it.
Thanks
--
Dave


dkillam said:
Ok, i'm really new at this, how do I set the data types? Sorry if this is a
stupid question.
--
Dave


Duane Hookom said:
I missed any earlier mention of a "chart". It is common that the row source
of a chart is a crosstab query. As my first reply suggests, enter the data
types of your query parameters.
[Forms]![Startup]![txtDateFrom] Date/Time
[Forms]![Startup]![txtDateTo] Date/Time
[Forms]![Startup]![cboMachine] Text
[Forms]![Startup]![cboMould] Text

--
Duane Hookom
MS Access MVP
--

dkillam said:
Here is the query which does work, except when I try to create a report
using
chart wizard.
SELECT Count(Jamups.Location) AS CountOfLocation, Jamups.Location,
MachSetup.Machine, MachSetup.Mould
FROM Jamups INNER JOIN MachSetup ON Jamups.MachSetup_ID =
MachSetup.MachSetup_ID
WHERE (((Jamups.TimeStamp) Between [Forms]![Startup]![txtDateFrom] And
[Forms]![Startup]![txtDateTo]))
GROUP BY Jamups.Location, MachSetup.Machine, MachSetup.Mould
HAVING (((Jamups.Location) Like "blank side" Or (Jamups.Location) Like
"mold
side") AND ((MachSetup.Machine) Like [Forms]![Startup]![cboMachine] & "*")
AND ((MachSetup.Mould) Like [Forms]![Startup]![cboMould] & "*"));

--
Dave


:

How about sharing your SQL view? Are you entering your dates in the
format
mm/dd/yyyy?

--
Duane Hookom
MS Access MVP
--

Fat fingers, typo in e-mail.
--
Dave


:

I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


:

Is the form open? Are there dates in the text boxes? A query will
not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with
dates
in
the
required fields.
When the query is called by way of a report, the following error
is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

dkillam

Ok, i'm really new at this, how do I set the data types? Sorry if this is a
stupid question.
--
Dave


Duane Hookom said:
I missed any earlier mention of a "chart". It is common that the row source
of a chart is a crosstab query. As my first reply suggests, enter the data
types of your query parameters.
[Forms]![Startup]![txtDateFrom] Date/Time
[Forms]![Startup]![txtDateTo] Date/Time
[Forms]![Startup]![cboMachine] Text
[Forms]![Startup]![cboMould] Text

--
Duane Hookom
MS Access MVP
--

dkillam said:
Here is the query which does work, except when I try to create a report
using
chart wizard.
SELECT Count(Jamups.Location) AS CountOfLocation, Jamups.Location,
MachSetup.Machine, MachSetup.Mould
FROM Jamups INNER JOIN MachSetup ON Jamups.MachSetup_ID =
MachSetup.MachSetup_ID
WHERE (((Jamups.TimeStamp) Between [Forms]![Startup]![txtDateFrom] And
[Forms]![Startup]![txtDateTo]))
GROUP BY Jamups.Location, MachSetup.Machine, MachSetup.Mould
HAVING (((Jamups.Location) Like "blank side" Or (Jamups.Location) Like
"mold
side") AND ((MachSetup.Machine) Like [Forms]![Startup]![cboMachine] & "*")
AND ((MachSetup.Mould) Like [Forms]![Startup]![cboMould] & "*"));

--
Dave


Duane Hookom said:
How about sharing your SQL view? Are you entering your dates in the
format
mm/dd/yyyy?

--
Duane Hookom
MS Access MVP
--

Fat fingers, typo in e-mail.
--
Dave


:

I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


:

Is the form open? Are there dates in the text boxes? A query will
not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with
dates
in
the
required fields.
When the query is called by way of a report, the following error
is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

dkillam

Setting data types didn't help.
--
Dave


dkillam said:
Never mind, I found it.
Thanks
--
Dave


dkillam said:
Ok, i'm really new at this, how do I set the data types? Sorry if this is a
stupid question.
--
Dave


Duane Hookom said:
I missed any earlier mention of a "chart". It is common that the row source
of a chart is a crosstab query. As my first reply suggests, enter the data
types of your query parameters.
[Forms]![Startup]![txtDateFrom] Date/Time
[Forms]![Startup]![txtDateTo] Date/Time
[Forms]![Startup]![cboMachine] Text
[Forms]![Startup]![cboMould] Text

--
Duane Hookom
MS Access MVP
--

Here is the query which does work, except when I try to create a report
using
chart wizard.
SELECT Count(Jamups.Location) AS CountOfLocation, Jamups.Location,
MachSetup.Machine, MachSetup.Mould
FROM Jamups INNER JOIN MachSetup ON Jamups.MachSetup_ID =
MachSetup.MachSetup_ID
WHERE (((Jamups.TimeStamp) Between [Forms]![Startup]![txtDateFrom] And
[Forms]![Startup]![txtDateTo]))
GROUP BY Jamups.Location, MachSetup.Machine, MachSetup.Mould
HAVING (((Jamups.Location) Like "blank side" Or (Jamups.Location) Like
"mold
side") AND ((MachSetup.Machine) Like [Forms]![Startup]![cboMachine] & "*")
AND ((MachSetup.Mould) Like [Forms]![Startup]![cboMould] & "*"));

--
Dave


:

How about sharing your SQL view? Are you entering your dates in the
format
mm/dd/yyyy?

--
Duane Hookom
MS Access MVP
--

Fat fingers, typo in e-mail.
--
Dave


:

I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


:

Is the form open? Are there dates in the text boxes? A query will
not
open a
form.
Is the query a crosstab? Have you entered the data types of the
parameters?

--
Duane Hookom
MS Access MVP
--

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with
dates
in
the
required fields.
When the query is called by way of a report, the following error
is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

Share your SQL view of your chart's Row Source and possibly the SQL view of
query the Row Source is based on.

--
Duane Hookom
MS Access MVP
--

dkillam said:
Setting data types didn't help.
--
Dave


dkillam said:
Never mind, I found it.
Thanks
--
Dave


dkillam said:
Ok, i'm really new at this, how do I set the data types? Sorry if this
is a
stupid question.
--
Dave


:

I missed any earlier mention of a "chart". It is common that the row
source
of a chart is a crosstab query. As my first reply suggests, enter the
data
types of your query parameters.
[Forms]![Startup]![txtDateFrom] Date/Time
[Forms]![Startup]![txtDateTo] Date/Time
[Forms]![Startup]![cboMachine] Text
[Forms]![Startup]![cboMould] Text

--
Duane Hookom
MS Access MVP
--

Here is the query which does work, except when I try to create a
report
using
chart wizard.
SELECT Count(Jamups.Location) AS CountOfLocation, Jamups.Location,
MachSetup.Machine, MachSetup.Mould
FROM Jamups INNER JOIN MachSetup ON Jamups.MachSetup_ID =
MachSetup.MachSetup_ID
WHERE (((Jamups.TimeStamp) Between [Forms]![Startup]![txtDateFrom]
And
[Forms]![Startup]![txtDateTo]))
GROUP BY Jamups.Location, MachSetup.Machine, MachSetup.Mould
HAVING (((Jamups.Location) Like "blank side" Or (Jamups.Location)
Like
"mold
side") AND ((MachSetup.Machine) Like [Forms]![Startup]![cboMachine]
& "*")
AND ((MachSetup.Mould) Like [Forms]![Startup]![cboMould] & "*"));

--
Dave


:

How about sharing your SQL view? Are you entering your dates in
the
format
mm/dd/yyyy?

--
Duane Hookom
MS Access MVP
--

Fat fingers, typo in e-mail.
--
Dave


:

I expect there is a spelling error "Forme!Startup!txtDateFrom"

--
Duane Hookom
MS Access MVP
--

Yes, the form is open with dates in the text boxes.
The query is not a crosstab.
--
Dave


:

Is the form open? Are there dates in the text boxes? A query
will
not
open a
form.
Is the query a crosstab? Have you entered the data types of
the
parameters?

--
Duane Hookom
MS Access MVP
--

message
I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And
[Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active
with
dates
in
the
required fields.
When the query is called by way of a report, the following
error
is
generated.
"The Microsoft Jet database engine does not recognize
"Form!Startup!txtDateFrom' as a valid field name or
expression".
What am I missing here?
Thanks
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Creating a Chart on form from selected data in query. 0
Crosstab query error 1
Multiple entries per day.. 2
QBF & Query Malfunction 0
How to get a query to call the parameter form 6
date range question for todays date 0
Crosstab query... 2

Top