Hi, I looked at your project history and felt that this is something I would like to support. So I would like to help you get started with your database!~)
Do you have the mda file and/or do you know what functionality it holds?
You probably have to remove the reference in vba and build the function yourself.
You can try and upload the database here if it's less than 2mb otherwise you could upload it somewhere else and "write" the link here (you...
When you click on the combobox in question all relevant code is showed in the box on the right!~)
The trick to that specific combo is to have a field in your query that combines the 2 columns. Then you set the column width to a very small number. Access doesn't show columns in the dropdown if...
When you use the concatenate module you need to add all the levels to the where clause in the call!~)
I believe in this instance you only got job number, you need to add seq.
It only shows the first column that's not 0 in width. There's different solutions to that. I have made a db with examples of various uses of comboboxes.
Check out the download section!~)
Hi, here's a bit to work on... just to show a quick way of getting up and running.
Without any data I can't be sure of your structure or you work flow...
If you want to go behind the scenes you need to hold down shift when you open the database.
Just a comment...
This is an excellent opportunity to show the difference between data in Excel and data in Access...
This is how you would use the data in Excel:
Person Year 1 Year 2 Year 3
Person1 a b c
Person2 x y z
This is how you would do it...
Between Date() and Date() + [Enter days:]
You have to use Date() and not Now(). From now is 02/12/2012 21:28:00 (where I am!~) but the date is actually 02/12/2012 00:00:00 so you would miss today in the result!~)