Capture query parameter form > tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having difficulties capturing query parameters from my form. I just
added a tab (it was working fine before the tab) and I think this is causing
the problems. Here is the criteria that I was using for the query:

[Forms]![Report Generator]![ClientName]

Now that I have added a tab, it seems like this should be changed to:

[Forms]![Report Generator]![Tab Name]![ClientName]

However, I cannot find any documentation to tell me how to correctly do
this. Can anyone help?
 
The fact that you've added a tab is irrelevant. The name of the controls
cannot be repeated from tab to tab, so using strictly the control name is
all you need do.
 
Okay, this is good know. But query is not working with the old
parameter...not sure why??

Douglas J Steele said:
The fact that you've added a tab is irrelevant. The name of the controls
cannot be repeated from tab to tab, so using strictly the control name is
all you need do.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


dmericksen said:
I am having difficulties capturing query parameters from my form. I just
added a tab (it was working fine before the tab) and I think this is causing
the problems. Here is the criteria that I was using for the query:

[Forms]![Report Generator]![ClientName]

Now that I have added a tab, it seems like this should be changed to:

[Forms]![Report Generator]![Tab Name]![ClientName]

However, I cannot find any documentation to tell me how to correctly do
this. Can anyone help?
Click to expand...
Click to expand...
 
Any error messages? Do you get a prompt for a missing parameter? If so, are
you sure you didn't change the spelling somehow?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


dmericksen said:
Okay, this is good know. But query is not working with the old
parameter...not sure why??

Douglas J Steele said:
The fact that you've added a tab is irrelevant. The name of the controls
cannot be repeated from tab to tab, so using strictly the control name is
all you need do.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


dmericksen said:
I am having difficulties capturing query parameters from my form. I just
added a tab (it was working fine before the tab) and I think this is causing
the problems. Here is the criteria that I was using for the query:

[Forms]![Report Generator]![ClientName]

Now that I have added a tab, it seems like this should be changed to:

[Forms]![Report Generator]![Tab Name]![ClientName]

However, I cannot find any documentation to tell me how to correctly do
this. Can anyone help?
Click to expand...
Click to expand...
Click to expand...
 
No error messages, no prompts. The query just runs as if no criteria were
present.

This is my where clause:

WHERE (([Tracking].startDate)>=[Forms]![Report Generator]![startDate])

This is the name of the form: [Report Generator]
This is the name of the control: [startDate]


I also plugged this into an entirely seperate query to see what I would get:

SELECT [Forms]![Report Generator]![startDate] AS test, [Tracking ].trackingId
FROM [Tracking];

The result: many records that look like this

NULL, number#


Any other ideas?



Douglas J Steele said:
Any error messages? Do you get a prompt for a missing parameter? If so, are
you sure you didn't change the spelling somehow?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


dmericksen said:
Okay, this is good know. But query is not working with the old
parameter...not sure why??

Douglas J Steele said:
The fact that you've added a tab is irrelevant. The name of the controls
cannot be repeated from tab to tab, so using strictly the control name is
all you need do.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I am having difficulties capturing query parameters from my form. I just
added a tab (it was working fine before the tab) and I think this is
causing
the problems. Here is the criteria that I was using for the query:

[Forms]![Report Generator]![ClientName]

Now that I have added a tab, it seems like this should be changed to:

[Forms]![Report Generator]![Tab Name]![ClientName]

However, I cannot find any documentation to tell me how to correctly do
this. Can anyone help?
Click to expand...
Click to expand...
Click to expand...
 
When you say that "the query just runs as if no criteria were present", do
you mean that all rows are returned?

The fact that you're getting Nulls in your second query implies that there's
nothing in the field!

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


dmericksen said:
No error messages, no prompts. The query just runs as if no criteria were
present.

This is my where clause:

WHERE (([Tracking].startDate)>=[Forms]![Report Generator]![startDate])

This is the name of the form: [Report Generator]
This is the name of the control: [startDate]


I also plugged this into an entirely seperate query to see what I would get:

SELECT [Forms]![Report Generator]![startDate] AS test, [Tracking ].trackingId
FROM [Tracking];

The result: many records that look like this

NULL, number#


Any other ideas?



Douglas J Steele said:
Any error messages? Do you get a prompt for a missing parameter? If so, are
you sure you didn't change the spelling somehow?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


dmericksen said:
Okay, this is good know. But query is not working with the old
parameter...not sure why??

:

The fact that you've added a tab is irrelevant. The name of the controls
cannot be repeated from tab to tab, so using strictly the control
Click to expand...
name
is
all you need do.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I am having difficulties capturing query parameters from my form.
Click to expand...
I
just
added a tab (it was working fine before the tab) and I think this is
causing
the problems. Here is the criteria that I was using for the query:

[Forms]![Report Generator]![ClientName]

Now that I have added a tab, it seems like this should be changed to:

[Forms]![Report Generator]![Tab Name]![ClientName]

However, I cannot find any documentation to tell me how to
Click to expand...
correctly
do
this. Can anyone help?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top