User Profile
Collapse
-
Error Handling in VB 6
i need to handle the runtime error in vb 6 that is generated when you input value an existing value from a textbox to n primary key field in access database. the "duplicate value" error. I've tried the On Error handling but I can't quite get how the syntax works. can you give a sample code for this. Thank you. -
problem solved thanks -
How to get the max value from query in ms access with visual basic
i need help in sql query for getting max value in ms access with visual basic 6.
i have a table named book_info where it has a a column name "Accession Number" that has 5 inputs in it "1,2,3,4 and 5", i've tried to get the max value on it:
Code:dim a as long a = adoAdd.RecordSource = "Select MAX(Accession Number) from book_info" lblAccNo= a
No activity results to display
Show More
Leave a comment: