I have a ComboBox that has a query for the RowSource. It selects all customers that have a certain salesman code. I then pull down the list of customers and select the 1st customer that I want to place an order for and enter my order. At the end, I tab over the last field and my ComboBox goes...
I have a database and one of the fields is a date field. I would like to be able to select records for my combobox using only a 4 position year. If that year appears in the date, then I would like the record to show in my combobox.
The following highlighted code(>>>>>>>>>>>>>>>>) gives me:
"operation is not supported for this type of object"
I'm assuming the Edit & Update will give me the same error.
I got this code from RickSpr in response to Swiftraven(May 9, 2002--Saving calculated valued in an archive...
I want to create a form that is a grid, select certain records from a database, create an array, and then populate the form(data and properties) based on the info in the array. Can I populate the array using varaible numbers that relate the my array values without having to specify each and...
Following is the code that results in a run time error 13/type mismatch on the SET statement. It is right out of the "Access 97 programming for windows for dummies" book so I don't know what to do. Does this only work on Access 97? Is there a way to make it work on Access 2000...
Following is the code that results in a run time error 13/type mismatch. It is right out of the book so I don't know what to do.
Private Sub PLastFirst_AfterUpdate()
Dim PlayerInfo As Recordset, SQLText
SQLText = "SELECT * FROM [Players] WHERE " _
&...
I have a table of golf courses. Each table entry contains room for up to 3 tee boxes(ie. Blue, White, Red). I use a combobox to select a particular golf course. In the next combobox, I want to be able to select which one of the three tee boxes will be used. Note: These colors are not fixed, so I...
I have a table of golf courses. Each table entry contains room for up to 3 tee boxes(ie. Blue, White, Red). I use a combobox to select a golf course. In the next combobox, I want to be able to select which one of the three tees boxes will be used.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.