Posted on 2000-01-18
Hi, I am an experienced programmer but new to VB.
This is my first major project done on a learn as you go basis! But I have
The project comprises a VB6 front end to a ACCESS97 (Jet) databse.
I need to create a report from the result of a user query. I couldn't
figure how to get SQL parameters to work within the VB report writer so I have done it in two parts.
1. Get user input to build SQL to first empty then insert required records into a table(special table for the purpose)
2. Envoke report to read table and print.
> Ha ha does it work!!?? NO The data reported is always that which was
present at program start time and will not refresh during runtime, despite
trying resync and refresh in various places. The only progress I have made is by forcing Data Environment close in the report terminate proc, I then get the new data after TWO attemps of running the report. This is consistant!(always two times) The report is a databound report using a DE. The SQL that creates the new data is code in a proc.
Any suggestions ?? Many thanks...... Phil