Search results for query: *

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...

thanks spacey,<br> <br> will look into the DAO 3.6 <br> <br> <br> regards<br> <br> Brendan<br> (Australia)

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...