Search results

I haven't got a problem with getting the data that I need really, it is literally just getting the .additem function onto VBA. I can't understand why it isn't there. If it would appear if I were to create a subreport then that is they way that I will go. Thanks. Gareth.

The listbox is on a report, and the report is based on a query. All I want is for the listbox to be filled when the report is activated. I just want it to filter results from a query and put values into the listbox. Thanks. Gareth.

Hi, thanks for your reply. Yes I put me.listname before trying to use the additem feature but it still doesn't work. Thanks again. Gareth.

Hi, I am using MS Access 2003 and I wish to simply fill a listbox from VBA. I have read that you can just do listname.additem .... but I do not have the .additem option after inputting the list name and was wondering why this is? I believe it may just be a reference/component thing but I've no...

Hi, thanks for your reply. Sorry if I have been unclear, basically I have a query similar to the following: [name] [amount] [quantity] John 4 6 Dave 5 5 Emma 4 6 Steve 3 7 Louise...

Hi, I have a report that is based on a query and I wish to populate a list box on the report with a value from the query based on the values of 2 other query results, i.e. if [amount]=5 and [quantity]= 3 then add [name] to list box, where amount, quantity and name are query values. When I run...

Hi, I have a problem which should have a relatively simple solution, I just cannot find it. Please accept my apologies if this is in the incorrect forum, I wasn't sure whether to place it in the 'Reports' forum but I figured that my question was to do with the results of a query so I put it in...