y,只是想问你一个我知道你重新熟悉的简单问题。 我正在使用VB6,我只是想从我的数据库获取一套记录。 我的意思是,我有用户信息数据库,其中一部分编码如下:它只有一套记录<>。 同例如,用户信息数据库的价值是<>>>
With datPayroll
.RecordSource = "select * from tblpayroll where empid like " & UserID & " "
.Refresh
Me.txtRegularHours.Text = .Recordset.Fields!reghours
End With
- datPayroll: DataControl
-txtRegularHours : 文本箱
- UserID: Variable
你或许想看MoveFirst、MoveNext等,以及EOF。
这里是联系的,或是联系的两条,以便你开始:
You need to check that you have some data in your Recordset using EOF, then MoveFirst to move to the first record, and loop through using MoveNext.
Win.ShellExecute 0, "open", "C:dirprogram.exe", "arguments", vbNullString, SW_SHOWNORMAL Win.ShellExecute 0, "open", "http://www.google.com", vbNullString, vbNullString, SW_SHOWNORMAL I want google....
I have a stored procedure in Sql Server 2005 with a varchar input parameter defined as: @Value varchar(24) = NULL in my VB6 application I try to set the parameter with an ADO function: Set ...
Using VB6 In a folder, i have n number of files, i want to delete a 0 kb files code Dim filename5 As String filename5 = Dir$(txtsourcedatabasefile & "*_*", vbDirectory) MsgBox filename5 Do ...
Using VB6 I have the text file with different sizes, so i want to delete the file where filesize = 0 kb. How to make a vb6 code for deleting the 0 kb files. Need vb6 code Help
I m using VB6 and I have a folder where I have n number of files. I want to change the file extension to .txt. I used the code below to change the extension of all .fin files to .txt. Dim filename1 ...
I m using Crystal Reports in my VB6 project, but I m facing error while loading the report in crystalreport1.action=1; Please give me some solution for this problem. It is showing the error as Error ...
When running my vb6 application I am getting error like, runtime error 53 : file not found: rscomclNoMsg.dll then i tried to register that dll from cmd line using regsvr32. Then I am getting ...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8