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