Recent content by platedslicer

The unexplained error I'm getting is a NULL value in the last column that shouldn't be there. It's actually not null, because simply ignoring the error and clicking on the listbox again returns the right value in that column. So the code I posted was just trying to get the null value out of the...

This is one of those problems that appear for apparently no good reason. Essentially, I have a listbox with a _Click() sub that fills some text boxes and other controls with details from the selected register. The primary key to the register is in the hidden last column of the list box. What...

Thanks again for the replies. vbaInet, Query1 has 20 fields and returns 47 rows with my latest test table. I tried testing it with zero records in the base table but it still crashes whenever I try to run it. The query provided by boblarson works with hard-coded values for the Query1 fields. I...

Thank you for the reply sir. It's Access, I guarantee that. Never really had a problem with declaring aliases implicitly. Just in case, I went back and put AS in all the right places. Still the same thing. It crashes.

I need to do a comparison of a complex query and a table, bringing in results from the first in case there are no records in the second to match certain conditions. SQL below. I could swear it was working when I got here after lunch but then it started to complain about an "Invalid Function...