Code:
intRecNum = rs.RecordCount - 1
For intCnt = 0 To intRecNum
strComVal = rs!clnt_LastName & "," & rs!clnt_FirstName
cbxSearch.AddItem (strComVal)
rs.MoveNext
Next
MikoKitty
Last Activity: Jan 10 '07, 06:18 PM
Joined: Nov 21 '06
Location:
-
Tried that and got the same error as the original code. I [i]did[i] get it to work usingThanks for trying... -
Combo Box Problems
I'm trying to populate a combo box using the following code:
My problem is when it hits .EOF rather than exiting the Loop it tries to go through and throws an error NO current record. Why won't it stop?Code:Do Until rs.EOF strComVal = rs!clnt_LastName cbxSearch.AddItem (strComVal) rs.MoveNext Loop -
That did it, Thank you SO much!Leave a comment:
-
Passing Values
Okay, now I'm embarassed. I'm having trouble passing and returning values from a function. The Function call is
strTempDate contains a SQL date that needs some work before it will fit into a VB Date format. the work is done by the TimeCon functionCode:Dim w As String w = TimeCon(strTempDate)
...Code:Private Function TimeCon(ByVal strTempDate As String) Dim strDate As String
-
Yes, it's numeric....Leave a comment:
-
Um, 28 columns consisting of strings, dates, and numbers which I want to pass from the SQL Server to Access in intervals of about 200 at a time?
Other than that I really don't know what you mean....Leave a comment:
-
Client information, you know names, addresses etc....Leave a comment:
-
Parsing from SQL Server to Acces with VB
I'm writing a program to transfer many files from SQL Server to Access via VB6. One of my guidelines is to parse it so only a certain amount of records are transferresat a time, (Since there are a lot of them). I have absolutly no clue how to go about this! -
strTempDate = nodeClient.sele ctSingleNode"cl nt_RecAddDate") .nodeTypedValue
dteRecAddDate = CDate(Left(strT empDate, InStr(1, strTempDate, "T", vbTextCompare) - 1))
rs!clnt_RecAddD ate = dteRecAddDate
It doesn't throw the error until it hits the update statement....Leave a comment:
-
That's what I thought, but when I commented out the date transfer the program worked fine...Leave a comment:
-
Date Tranfer from VB to Access
I'm trying to transfer a date from VB6 to MS Access but keep getting "Runtime Error 424: Object Required" All the other data transfers fine, just the date gives me problems. As Access not reading the format -
Better way to Populate a Database
I'm using XML to transfer the contents of a database from SQL Server to MS Access.
Doing it column by column is easy enough, but what I'm trying to do is fit it into a For Next Loop to pseudocode:
FOR each column in the table
Input value into cell
move to next column
NEXT
Is this even possible?
No activity results to display
Leave a comment: