Ops..forgot to mention.. Grd is the name for that MSFlexGrid..

Let's try this code.. I've been using it and it works excellent!!


Private Sub cmdPrint_Click()
'Print the grid with the top row as a title row
FlexGridPrint Me.Grd, , , , , 1
End Sub

...

Ops... Actually it's because of my own mistake.. :D I have put 'kategori', a field that is not in the data1 itself. Haha!

Hello everybody.. I have tried to use these codes that I got from a book. I'm using MSFlexGrid, with the Grd name. It was set to be invisible (false visible). And when i enter the year (tahun) needed...

Private Sub cmdPapar_Click()
If optall.Value = True Then
Data1.RecordSource = "SELECT Hari, Bulan, ID, Kategori, Status, Jumlah_lulus, Nama FROM permohonan"
Data1.Refresh
Grd.Visible = True
Else...

Hello everybody.. I have a form in my project, that's having a Grd name MSFlexGrid and a Data1. Besides, it also have a cmdCalculate and cmdExit button. Their codes are below.

Private Sub...

Ok, i've got the answer.. It's just about to link the TextBudget08 on each forms to the sama database.. It's that easy.. Hehe..

Thanx bro for your useful info. It works well, that i used code as below, modifying the code u gave.

In form 1
Private Sub cmdConfirm_Click()
Dim Budget08 As Currency
Budget08 =...

Hello everybody.. Here I have a question regarding my “Budget System” project. It’s about to link the annual budget amount (txtBudget) from form 1 to the (txtBudget) in the form 2. It means that the...

Thanx to all of you, teachers... I'm sorry for being so dumb before this.. Hehe.. It was alreasdy solved.. But, the 8th column need to be changed ti 7th column.. K, thanx lot..

[Private Sub...

What if like this... I have to put the budget value first in the txtBudget, then I need to click the cmdCalculate to have the balance calculated being in the txtBalance.... I really need a detail...

Plz sumbody.... Plz tell me, how to use the codes Venna gave me.. I really don't have the idea where to put the codes.. FlexGrid is a new thing for me.. It looks come to the solved, but i can't make...

Sorry... But, it didn't work.. Maybe, because i don't know how and where to use it.. I copied and pasted the latest codes by Venna in the private Sub Grd_Click like below..

Private Sub Grd_Click()...

Thank you Comatose,
After i rename it to Grd, the error disappear..
But still, i can't figure out how can it works..
What if my plan being like this..
I have to put first, the value of budget...

Actually, I'm using FlexGrid to display the budget database records. I've tried the codes given by Veena, but it displays the 424 error, and debug at the line below..

For i = 1 To Grd.Rows-1
...

Hello there,
I am doing my 'budget control system', and I want to make substraction from the value i entered in a textbox (budget for the year), with the sum of all the value in the 8th column of...

Both of u are great VB teachers! Thanx lot for your generously help and guides. May God bless u always...

Thanx lot Juanon for the knowledges given to me.. I tried it... But VisData cannot even display the database. It said,"Unrecognized database format. Number 3343, Display the data access errors...

So far, i had used [Data1.Recordset.Seek "=", "'" & SearchStr$ & "'"] as recommended. And then, the recordset was and is in TABLE mode.. But, the result is still the same error.. Which is 'Run-time...

Thanx for your reply.. Could you plz tell me how to define the INDEX, and what is it actually? plz...

Hello everybody...
I'have bound a database to my form, and it displays the record of some fields from my database. I want to make the displayed record so that it can be searched by clicking the...

Thank you sir.. Now I've already found the Data Combo Control.. But, there were problems occured in this trial project. I can't list the lists of month and year that i put in the "Month and year"...

I'm using VB 6.0 with service pack 6.0, but i found there are no such Data Combo Control in the Components option. There are only things like Data Bound, DataGrid, DataList and DataRepeater.. Can u...

I see... Thank you sir, for your kindly explaination...

Bcoz i've read that using the ADO in more complex... What's meant by that complex?

Thank you brother for your explaination.. But, is there any differences in writing the database coding, between those two?

As a beginner VB 6.0 user, i have tried to make a simple database-link VB project. There were problems when i used a Microsoft Access Database which have some combo-boxes field (made by look-up...

Hello,
I'm a beginner VB 6.0 user, and I would like to know something about it. Is there any difference in coding (for the same purpose) between a database oriented VB projects using the Data...