Visual basic 6.0 help please.?

Question

I am needed to create a database in access then link it with visual basic, i have done that everething works i can scroll through the records all fine. But i have the following problems.

1. When i add custom buttons, such as "Next" "Back", say if its the first record and i go backwards, i get an error then i am asked to debug, how can i fix this?
2. If i have no records in access i cant seem to add any new records from visual basic to access, like i run the program, if there are 0 records in the database i click my add new button but whenever i enter something inside the text box then select the 2nd one the data disaprears.
3. How can i make the ADO link invizible? so you cannot see it when you run the program?

thanks for any help!

Answer 1

For #2, There's a glitch in VB 6 that it sometimes doesn't like an empty database. When I've had issues with this in the past, I just put a dummy record in. If you don't want junk data, then put an if statement in to check for the dummy record and replace it with the first good record.

IF Column1 = "Dummy Record" then
Update MYtable
SET Column1 = "New Good Rcord"
End if

As long as you put somethng in the dummy record that can't ever possibly be a valid record, this will work fine.

Answer 2

Are you using the visual basic that is part of Access, or are you talking VB the external program that you can purchase separate from Access?

Either way for #1 an if statement to test if the record is the first one should be possible, if it is the first record simply do nothing, else perform logic to go to previous record.

The other 2 questions I'm afraid it's been too long since I touched access or visual basic to try and help you :(.

Answer 3

Check out the book "Learn to Program With Visual BASIC Databases" (ISBN 1-9296-8517-3) by John Smiley. One in a series on VB 6, this book deals with that exact issue.
I have linked to this book's Barnes and Noble page in the sources section.

Answer 4

I think that you just use the property inspector for 3 but its been awhile. Unless this is a school project I suggest learning something else. I have a friend who used VB still but other languages are easier for database manipulation. Sorry that I couldn't be of more help.

Answer 5

Do you mean the ADO Control?

You can go to the properties of it, make the visible false, so that if you will run your program, no one can see it...

or you can simple code it

Private Sub Form_Load()
ADOName.visible = False
End Sub

Answer 6

if index > (1 or zero) regardin your index
step backwards