Recent content by Vulcan1500

Thanks for all information and possible solutions. Val-function did stop the error, but didn't result in a recordset. Replace was the solution.

In VBA I would like to filter a recordset using the comboboxes on a form. I have three comboboxes. One for the year, one for the quarter and one for VAT. The comboboxes are populated correctly. Afrte selecting a value for the year the recordset is filtered. This also is done when the quarter is...

SOLVED. I didn't requery cboKwartaal after updating cboJaar. Now data matches!!!

After checking in spreadsheets the data set after updating the second combo box (cboKwartaal) the result is not correct. To filter on a second combo box I added a line to the code similar to the first combo box: Set qdf = CurrentDb.QueryDefs("qryMijnKlantenRecordSource")...

I selected your generic form for my application. Once this was working the idea came to include a combo box to filter the year. At that moment in time I was totally focussed on what was working and didn't think about the other forms you gave. Sorry for that. Anyway I'm very happy it's working...

I needed some time to understannd and implement. It is all working now as expected. Thanks for your time and detailled advices. Maybe you can give me a last advice. I've added a combo box to the form that gives all the years in which an invoice is prepared and issued. After updating the year...

Happy New Year! Many thanks Steve. This is realy a good start of the year for me with such a detailled answer including instructions. Implementation is now easy for me although I will need some time to understand your solutions fully. You even thought about small, but beautiful, details like...

Basic example attached in which the names are made unreadable.

Recordsource is a query called 'qryMijnBesteKlantRecordsource' and includes: pkKlant, Naam, SomExBTW, SomBTW and SOMInBTW (BTW is VAT).

Sorry, I wasn't able to answer the asked questions earlier. The graph in the form is a graph with horizontal bars. On the Y-axis the names of the clients are shown and on the X-axis the revenu in €. I started with 10 clients, but decided later to go to 5 as a maximum to display. It is just a...

If the query with the recordsource is ordered (e.g. city) this is not done as such in the form. How can it be organised that all records are ordered before step by step 10 records are displayed?

Indeed Steve, that was the error I made. Thanks again!

I've a problem. As soon as I want to go to the next 5 clients and their remuneration as displayed in a graph with horizontal bars I get the message that 'CurrentTopKey' is not a member. Whem I type 'me.cur' this paramater is also not availlable in the presented list. The code is added to the...

Thanks Steve. It's working perfect now. Thanks for your time and excellent advices!

Thanks again Steve. I think I prefer your last option. Like you wrote, if I understand you correct, my table/query has not an ID that starts with 1 and every next record it is 1 up. I have gabs in that. Do you mean that due to the gabs I have to go for the second option? Or can I add a...