VB & Database problem!!!!!!

joePC

Hy,

Im trying to display using the FlexGrid Control only certain entries in a database,



Instead of all values I only want to display the ones with YES in the overdraft coloum.

Heres the code to display all values.

[PHP]

Private Sub cmdShow_Click()

If cmdShow.Caption = "Show Database" Then

datCities.RecordSource = "SELECT Name, Accnumber FROM Cities"
datCities.Refresh
cmdShow.Caption = "Show Database"

End If

End Sub

[/PHP]


I Know it has something to do with this line

[PHP]

datCities.RecordSource = "SELECT Name, Accnumber FROM Cities"

[/PHP]

Thanks in advance

joePC

dazberry

datCities.RecordSource = "SELECT Name, Accnumber FROM Cities WHERE overdraft = 'YES'" ?

D.

joePC

I keep getting an error message, "Object Required",

Anyone have any ideas,

Thanks joePC

LastIrishMonkey

joe m8 im doing the same project for college atm i could email u my code and take a look at it ?:D

bonkey

Originally posted by joePC
I keep getting an error message, "Object Required",

Anyone have any ideas,

Yeah. You need an object

Seriously? If you're getting that error, you're not making the suggested change, or the code you posted originally doesn't work anyway for a completely seperate reason.

If its the latter, I'd suggest you go back to what you showed us at the start and explain why thats not working as well....

jc

bonkey

Originally posted by LastIrishMonkey
joe m8 im doing the same project for college atm i could email u my code and take a look at it ?:D

Thats a great way to learn how to code.

Don't get me wrong....I hope you guys keep it up....it helps ensure that I'll never be out of a job.

jc

joePC

OK got it sorted last night,

[PHP]

Private Sub cmdover_Click()

If cmdover.Caption = "Show Clients with Overdraft" Then

datCities.RecordSource = "SELECT Name, Name, Accnumber, Balance, Sortcode, Overdraft FROM Name WHERE Overdraft = 'YES' "

datCities.Refresh

MSFlexGrid1.Refresh

cmdover.Caption = "Show Clients with Overdraft"

End If

End Sub

[/PHP]


LastIrishMonkey: Thanks for the offer you can send the code here: alpha1_2_32000@yahoo.co.uk

Thanks joePC

The Corinthian

Originally posted by bonkey
Don't get me wrong....I hope you guys keep it up....it helps ensure that I'll never be out of a job.

Roffle

If I had a penny for every CS graduate I'd interviewed who'd gotten their degree by cogging other people's work... :rolleyes:

watty

I'd create that SQL as a "view" and use an ordinary bound datagrid. No VB programming at all!