Capture query parameter form > tab

[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?

 

[Douglas J Steele]

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.

 

[Guest]

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 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?

 

[Douglas J Steele]

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!)

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 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?

 

[Guest]

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?

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!)

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 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?

 

[Douglas J Steele]

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!)

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?

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!)

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

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?