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

Sorry, ment to include SQL table field of greater then 256 chars. THanks.

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 reference to q1: I was using recordsets because I need to lookat all rows in a table, based on a criteria in many fields, I would "print out" beginning inv # and ending inv # on the same output line. This "stage" of the report is not the final version for the end-user. In reference to...

I changed this over to the Access VBA area.

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

As a FYI, here is the attached code: Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "query1", CurrentProject.Connection, adOpenKeyset, adLockOptimistic, adCmdTable rs.MoveFirst Do While ((Not rs.Status) And (Not rs.EOF)) [FormName]!fielda =...

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 cannot thank you enough

Bob, can you give a quicke example of what you mean? I understand that you probably want code like : Public cnn As ADODB.Connection Public Function SQL_Login() Set cnn = New ADODB.Connection With cnn .Provider = ("SQLOLEDB") .Properties("Data Source") = "dbserver"...

You may want to try the following url for the excel send mail issue. I modified this sites code and it worked great. http://www.exceltip.com/excel_tips/Mail_-_Send_and_Receive_in_VBA/211.html

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