Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

my report is loseing its columns

Status
Not open for further replies.

PWise

Programmer
Dec 12, 2002
2,633
US
how do i keep my report from loseing its columns when i run it with "DoCmd.OpenReport reportname, acPreview" this is in a2k i work mostly in a97 never had this before i dont know if this always happens
 
Hiya,

Please explain in more detail what you mean by 'losing columns'.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
 
HI Darrylle
I have a report that I created with the label wizard I selected a three column label. The record source is a query when I open the report from the database window it has its columns as many times as I open it. The way my client should open it is from a form that has a 2 column combo box and a command button it the on click event I can change the sql of the query with
Dim mydb As Database
mydb.QueryDefs("queryname").SQL = sqlstring
DoCmd.OpenReport "reportname", acPreview

The first time I open it works fine (3 columns and the margins the way I set then) the next time it only has one column and the margins are 1". When I reset the margins and the columns and open it thru the form the first time it work fine and next time the margins and columns are reset

pwise
 
i found a answer in
thread703-418647
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top