I am using VISUAL BASIC 6 as the front end application linking through to a Microsoft Access database.
I was wodnering how i would lookup information stored in a table in access and display the results on the fly.
i have a data control called: navRentals
linking to: Database.mdb
I then have a combobox called: cboRentalTitle
this is populated with rentals from (Database.mdb) tblRentals.RentalTitle by using the following code (On form load)
Loop Until navRentals.Recordset.EOF
what i am after is a way to LOOKUP the 'AgeCert' value and the 'Price' from tblRentals based upon the value selected in the combo box (this is needing to be updated if a new rental is selected in the combo box - i think its combo.change property?)
I have a command button that adds the selected film title to a list box. (lstRentedItems).
I have the ability to add and remove rentals using 2 buttons - this also deducts the price.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Here are a few simple, working, games that you can use as-is or as the basis for your own games.
This is one of the simplest of all games.
The game allows for a choice of who goes first and keeps track of the number of wins for…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…