ppoindexter
Registered User.
- Local time
- Yesterday, 22:54
- Joined
- Dec 28, 2000
- Messages
- 134
Here it is....
I have a report based on a querry
The user must enter 2 paramaters
Parameter 1:
Like [Enter Grade Level (text)] & "*" Or Is Null
Parameter 2:
Like [Enter City's Name] & "*" Or Is Null
The REPORT HEADER also has a Label
Control source set to 'Enter Title'
AND
The PAGE HEADER has a Label
Control source set to 'Enter Title'
that should prompt the user to enter the name they prefer for this report
This report worked for several weeks now i get the following message when i pompt to view the report:
Enter Grade Level
(i enter a grade level click OK) no probs this far
THEN, I get
Enter City Name], 2 [Unknown]=['Enter Title'
(I enter a city's name)
THEN i get
Enter Grade Level
(i enter the same grade level again click OK)
THEN, i get
Enter Sites Name], 5 [Unknown]=['Enter Title'
THEN the report appears...it looks okay
the title that appear is the the CITY's Name i type the second time.... (City name and Title are usually the same name)
this will be tooo confusing for the users who will be using this form...any ideas as to why this is happening???
and while am i on this topic....i am having problems with the page orientation of the reports...initially i set the page orientation to landscape and saved....and it stayed landscape for a spell...now when i preview the report it is portrait...i changed it back and it changes for awhile but this doesnt happen to ALL reports ALL of the time...
Thanks in advance for any ideas/replies
I have a report based on a querry
The user must enter 2 paramaters
Parameter 1:
Like [Enter Grade Level (text)] & "*" Or Is Null
Parameter 2:
Like [Enter City's Name] & "*" Or Is Null
The REPORT HEADER also has a Label
Control source set to 'Enter Title'
AND
The PAGE HEADER has a Label
Control source set to 'Enter Title'
that should prompt the user to enter the name they prefer for this report
This report worked for several weeks now i get the following message when i pompt to view the report:
Enter Grade Level
(i enter a grade level click OK) no probs this far
THEN, I get
Enter City Name], 2 [Unknown]=['Enter Title'
(I enter a city's name)
THEN i get
Enter Grade Level
(i enter the same grade level again click OK)
THEN, i get
Enter Sites Name], 5 [Unknown]=['Enter Title'
THEN the report appears...it looks okay
the title that appear is the the CITY's Name i type the second time.... (City name and Title are usually the same name)
this will be tooo confusing for the users who will be using this form...any ideas as to why this is happening???
and while am i on this topic....i am having problems with the page orientation of the reports...initially i set the page orientation to landscape and saved....and it stayed landscape for a spell...now when i preview the report it is portrait...i changed it back and it changes for awhile but this doesnt happen to ALL reports ALL of the time...
Thanks in advance for any ideas/replies
Last edited: