Search results for query: *

I have a combo box on a form, frmBxA and I want it to populate 2 other boxes,frmBxB and frmBxC, when a user select a row in the combo box for a report to be run in Access 2000. Is requery the how-to-do answer with a unique key? or is there a simple way with somehow addressing the record sets...

Can crystal 8.5 display a fielda greater then 256 chars? I feel it does but am unable to test this out due to out-of-town situations. Thanks.

In creating a recordset for use in a MS Access 2000 report, I am going through the recordset OK. I know this because I use debug.print and everything looks good. I take the query results and put them into unbound fields on the report but the the report only displays the last line. As a FYI...

In creating a recordset for use in a MS Access 2000 report, I am going through the recordset OK. I know this because I use debug.print and everything looks good. I take the query results and put them into unbound fields on the report but the the report only displays the last line. Can you give...

What am I doing wrong, it keeps coming up with a status 130172 error code. Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "tblReceivings", CurrentProject.Connection, adOpenKeyset, adLockOptimistic, adCmdTable rs.AddNew rs.Fields("VendorProductID") = 1...

For my simple form, after I display a msgbox error message, I need to put the cursor at a field different then the one they entered data into. Sorry, I dont know what to set to make this happen. Thanks :)

I was using the following code on a MS Excel 2003 spreadsheet to do initial logon to Microsoft SQL off a user form command box: Public Sub SQL_Login() Dim cnn As ADODB.Connection Set cnn = New ADODB.Connection With cnn .Provider = ("SQLOLEDB") .Properties("Data...