Recent content by Antti

I just noticed that I had 4 instead of 3 double quotes in one place and that's why that line gave me an error. Now I know what to fix to get this working. Thanks for the answers, they sure helped me.

Hi. I'm having problems with filtering a form. What I'm trying to achieve is having two combo boxes, one with number value (Employee ID) and another with text value (Item code). User should be able to filter both simultaneously, so that it would be possible to show records of a certain item...

Okay, got it working with the Dlookup. Thanks a lot for the help!

Made no difference.

I'm having problems with this one. This worked for a while but then the Access file probably got corrupted since I can't open it anymore. Now in my backup I can't get the query editable this way. Here are also my SQL and screenshot of my datasheet: SELECT a.ActionID, a.ItmBarcode, a.ActionQty...

Thanks, this worked!

Hi. (All my tables are linked SharePoint lists) I have an InvoiceDetails Query that gets data from InvoiceDetails Table. That data is edited via an Invoice subform. However, I would also like to get each item's name and category from Stock Table, which is linked to InvoiceDetails Table by...