Search:

I'm trying to record the date and time when the user press the "Enter" button into my database (access)

here my code:

Private Sub tmrdate_Timer()
txtdate.Text = Format(Now, "dddd ,mmmm dd ,...

There is no error and no display.

There is not dispay in txtName.Text and txtAge.Text.

Did u mean this?

Private Sub Form_Load()

Dim Name As String
Dim Age As String
Dim ID As String

adoRecord.Refresh
ID = txtID.Text

Here is my code for for the login(Form1):

Private Sub cmdLogin_Click()

Dim ID As String
Dim psword As String
Dim status As String
Dim Msg As String

Hey!
I have build a program(Form2) to view the database in access using ADODC.
There are text boxes representing each field in the access database.
There is also a login page(Form1) before enter...

yap!
That all the code in my form.
i set the adodc in the properties, the Name: adoRecord

Private Sub cmdCal_Click()
lblBalance.Caption = Val(txtCredit.Text) - Val(txtDeduct.Text)
adoRecord.Recordset![Credit Point] = Val(lblBalance.Caption)
adoRecord.Recordset.Update
End Sub

This...

ya...its work now!
Thanks!

But there is abit unlogic . After it updated the credit field with the current balance.....the txtCredit is also changed to the updated value. Meaning that before...

Hey!
I have a program, Credit Point. I'm using VB6 + Access. In the form, there are:
1) 3 Text boxes ( txtName, txtCredit and txtDeduct)
2) 1 Label (lblBalance.Caption)
3) 1 Command box (cmdCal)...

Hey again!

I have manage to use the ADO to link with my access.
it was cool, to achieve the 1st step of my project.
Now i'm able to display all the data in the access in my vb form.

The...

i had changed as u guys teach, the field name logname and pword and the table name tbllogin. but when i key in number in the password textbox the is an error message pop up, "Compile error: Syntax...

ops...ya! i had downloaded and didn't uncompressed the file. No wonder it can't work.

anyway, now it works!
this program seem useful but i don't understand how the form link with each other....

I have found a code from the net

Private Sub txtpwd_KeyPress(KeyAscii As Integer)
If KeyAscii = vbEnter Then
If Len(Trim(txtlogin)) > 0 And Len(Trim(txtpwd)) > 0 Then
If...

can u show me the right way to use the program?
i have installed the .zip file and in the folder there are many form. how do i use it? can u pls teach me.

ya, at 1st i thought that the DAO does not understand the access. but i have an example of access database file from my friend. by using his file i'm able to link it but not for my own access...

I'm trying to do a login page. The login page form consist of:-
1) Text box - Student ID
2) Text box - Password
3) Command button - Login

I have a database which consist of student ID and...

i just created a simple database which have 3 field in a table1. they are:-
1) Name
2) Student ID
3) Password

I have try to create a new database but is still the same.

i have try a simple exercise by using the "Data" bar to link with vb6 and access 03 in the "Data" bar properties, i have set the configure of DatabaseName, Connect and RecordSource as follow:
...

Hey!
Recently i'm doing a project that need to deal with database.
can u guys show me the right way to link between VB6 and MS Access?
As i know, MS Access is a place to store data, where else VB6...

Hey!
Recently i'm doing a project that need to deal with database.
can u guys show me the right way to link between VB6 and MS Access?
As i know, MS Access is a place to store data, where else VB6...