- Office XP sp3
- Coding an event on a button on an Access Form
When looking at the Locals Window in debug, varSQL is truncated after 255 characters and so the rs never gets created. I've read many many posts like this on the net none of which that I've seen has a solution.
Would someone be willing to create a variable just like I have and then look in the Locals Window to see if it contains all the data, Please?
Thanks in advance.
Darin
- Coding an event on a button on an Access Form
Code:
[font=Verdana]Dim db As DAO.Database 'Database connection[/font]
[font=Verdana]Dim rs As DAO.Recordset 'RFMS, Access recordsets[/font]
[font=Verdana]Dim varSQL, varSQLlist As Variant[/font]
[font=Verdana]...[/font]
[font=Verdana]...[/font]
[font=Verdana]...[/font]
[font=Verdana][font=Verdana]varSQL = "SELECT PriceList.Private_Style, ColorDesc.PrivateColor, PriceList.PrivStyleNum, PriceList.Price1, PriceList.Price2, PriceList.SeqNum " & _[/font][/font]
[font=Verdana][font=Verdana]"FROM PriceList INNER JOIN (ColorDesc INNER JOIN ColorAdd ON ColorDesc.ColorSeqNum = ColorAdd.ColorSeqNum) ON PriceList.SeqNum = ColorAdd.PriceListSeqNum " & _[/font][/font]
[font=Verdana][font=Verdana]"WHERE PrivStyleNum = '" & Left(Me.listSKU.ItemData(intLine - 1), InStr(Me.listSKU.ItemData(intLine - 1), " ") - 1) & "';"[/font][/font]
[font=Verdana][/font]
[font=Verdana][font=Verdana][font=Verdana]Set rs = db.OpenRecordset(varSQL)[/font][/font]
[/font]
When looking at the Locals Window in debug, varSQL is truncated after 255 characters and so the rs never gets created. I've read many many posts like this on the net none of which that I've seen has a solution.
Would someone be willing to create a variable just like I have and then look in the Locals Window to see if it contains all the data, Please?
Thanks in advance.
Darin