Giday Spacey,<br>
<br>
The SQL that is built on the fly, gets it's customer number from an everyday textbox. The first time I enter a number into the text box it works fine for whatever number and the report displays fine. The problem occurs when I close the report and enter a new number into...
giday all,<br>
<br>
Hope someone may have they answer to this one. I have a form where the user enters a customer number then hits a print button. behind the print button it changes commandText property's sql statement to retrieve that customer's personal details - all is fine the first time...
Giday wish3,<br>
<br>
Thanks for the advice. I have since gone back to Office 97 for the time being, however I will look at the 'wizards' code later next week. <br>
<br>
Cheers<br>
<br>
Brendan<br>
(Australia)
Code fragment:<br>
<br>
Public dbDynamic As Database<br>
Public recCustomers As Recordset<br>
<br>
Set dbDynamic = OpenDatabase("c:\db1.mdb")<br>
Set recCustomers = dbDynamic.OpenRecordset("Tcustomer")<br>
<br>
<br>
Giday,<br>
I'm programming in VB6 and had Office97 installed which the above...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.