Can anyone help me code the following. I have picked up help on various bits of this in other forums but would like to see an example of coding from start through to finish so I am posting on this forum which may be more appropriate since it deals with databases...
From a Control Button on a VB6 form I want to...
1) Connect to an Access 2000 Database named "QC6.mdb"
2) Open Table named "JobDetails"
3) Search for a record in field named "JobNo" for a job number variable (ex. 245001)
4) Go to another field named “DocumentPresent” in the same record which is of Yes/No field type and have the record marked as “TRUE”
5) Save and close the Table
6) Close the database “QC6.mdb”
When I refresh/return to the VB6 Form I then would see that the CheckBox bound to the field “DocumentPresent” would then have a tick in it.
Any help is much appreciated
Thanks
From a Control Button on a VB6 form I want to...
1) Connect to an Access 2000 Database named "QC6.mdb"
2) Open Table named "JobDetails"
3) Search for a record in field named "JobNo" for a job number variable (ex. 245001)
4) Go to another field named “DocumentPresent” in the same record which is of Yes/No field type and have the record marked as “TRUE”
5) Save and close the Table
6) Close the database “QC6.mdb”
When I refresh/return to the VB6 Form I then would see that the CheckBox bound to the field “DocumentPresent” would then have a tick in it.
Any help is much appreciated
Thanks