Hey Gallowgate
You can find the datagrid in the references as Microsoft datagrid. If it's not on that list, you should find it under C:\Windows\System32\MSDATGRD.OCX. If it's not there also, do a search with the file search facility under the start menu. Your copy may not be registered in the...
Hi EnKay62
You can reference the text in a textBox by using the TextBox<NumberHere>.Text method. This can be placed inside a variable of the string or variant type.
anvil19
Hi akinia
When you do an autolookup, you must create a join with a one to many join. For your combo lookup, I would create a query with this join, and use the query as your rowsource.
The many side of the join must be on the right of the join, and the join must have a common field with exact...
Hey jd20005
The correct way to use the AutoExec in Access is as follows:
To use AutoExec you need a MACRO called AutoExec and not a module called AutoExec or a module with a sub called AutoExec.
Go to the macros tab, click new, and put a few functions together, one at a time. Save the macro...
Hey Pete
I've found that the best way to fill a comboBox with a list from a database is to write a SQL statement directly into the ComboBoxs' RecordSource Property space.
You will need to use the IN clause as your ComboBox is in Excel and the data is in an Access Database, eg...
SELECT...
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.