A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Stray Field



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2004, 03:46 PM
Mark Hubbard
external usenet poster
 
Posts: n/a
Default Stray Field

Everything you mentioned is in good shape. Thanks for your reply. Any
ideas on renaming the rogue field or other method of tearing stuff down
and rebuilding it would be greatly appreciated.
Mark

Wayne Morgan wrote:

When "hidden" parameters such as this pop-up, I frequently find them in the
Sorting and Grouping dialog. Also, check your spelling on the field names in
the control sources of the controls on the report and look for any hidden
controls. Open the report, go to the immediate window, and type

?Reports!ReportName.Controls.Count

Press Enter, what is the number that is returned? Count the controls in the
report, can you account for all of them? Lines, shapes, labels, everything
should be included in the count.




  #2  
Old May 18th, 2004, 04:09 PM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default Stray Field

If the query isn't prompting for the parameter, then it doesn't appear to be
in the query. So it has to be in the report. The only way to get the report
to prompt for the value is to have it listed as a field that isn't available
in the query feeding the report. I don't know if the wizard is doing
something strange, have you tried creating the report manually? Perhaps just
a quick report, dragging and dropping all of the available fields into the
report and open it just to see what happens.

Do you have any comboboxes on the report? This may have happened if you
defined a lookup field in the table or query and it propagated to the
report. If so, is this rogue field in the Row Source of the combobox?

--
Wayne Morgan
Microsoft Access MVP


"Mark Hubbard" wrote in message
...
Everything you mentioned is in good shape. Thanks for your reply. Any
ideas on renaming the rogue field or other method of tearing stuff down
and rebuilding it would be greatly appreciated.



  #3  
Old May 18th, 2004, 08:41 PM
Mark Hubbard
external usenet poster
 
Posts: n/a
Default Stray Field

Ah, in creating the test report manually when I went to bind it to the
query I noticed it had dragged the rogue field into the 'order by'
parameter. I still do not know why It did this but at least the real
report I am using is fixed now. Thanks again.
Mark

Wayne Morgan wrote:

If the query isn't prompting for the parameter, then it doesn't appear to be
in the query. So it has to be in the report. The only way to get the report
to prompt for the value is to have it listed as a field that isn't available
in the query feeding the report. I don't know if the wizard is doing
something strange, have you tried creating the report manually? Perhaps just
a quick report, dragging and dropping all of the available fields into the
report and open it just to see what happens.

Do you have any comboboxes on the report? This may have happened if you
defined a lookup field in the table or query and it propagated to the
report. If so, is this rogue field in the Row Source of the combobox?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.