Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
TWO COMBO BOX
Listindex is read-only, so it will fail. What are you trying to do?- OurTone
- Post #2
- Forum: Microsoft: Access Forms
-
Combo boxes
On your first combo write code like this for the OnChange event: Combo2.RowSource = "SELECT ModelName FROM tblCPUModel WHERE CPUManufacturer = '" & Combo1.Value & "';" This is assuming you have 2 tables tblManufacturer that contains a list of CPU Manufacturers...- OurTone
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Check to see if a table exists. If so delete it.
Here is a function that will tell you if a table exists: Public Function TableExists(strTableName As String) As Integer Dim db As Database Dim i As Integer Set db = CurrentDb TableExists = False db.TableDefs.Refresh For i = 0 To db.TableDefs.count - 1 If strTableName =...- OurTone
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
