Search results

Hi Bod, Yes, I do! When I step through the code and I place my curser on, Me.Building_NO Then iCounter = iCounter + 1 I get a value for what is in the Building_NO Field. The actual field name is "Building NO" - I don't know if that makes a difference.

Hi, I keep getting an "item not found in collection error"! Can anyone please spot my mistake? I do have a textbox name "Building NO". When I step through, it seems that this line is causing the error. Thank you for any help. MyRecordset!Building_NO Private Sub Form_Current()...

That is perfect Bob! Thank you Sir!!

Hi, I am trying to use TWO multiselect listboxes to filter a report before opening. I get a Typemismatch error at this line. Rem OPEN THE REPORT LIMITED TO SELECTION DoCmd.OpenReport "UNIQUE REPORT", acViewReport, , "[Year] IN(" & strWhere & ")" And _ "[Building] IN(" & strWhereB &...

PERFECT! Thank you for the lesson - now I know!!

Thank you Bob!!! Your response solved the problem! The brackets were missing!

Hello - I found this code that seemed to meet my need in allowing me to filter a report through a multi-select list box prior to opening the report. For some reason, I keep getting a "Syntax Error missing operator in query expression." Can anyone please help?? The error is on the Docmd line . ...

Okay, I think understand. The data in the table is downloaded from a company system - there is little I can do about that part. Ufortunately, though I am on the road to learning, I am not experienced enought to interpret the second paragraph in you helpful post. I thought maybe I could run...

Thank you Namliam - so then this is an Access rule, if you group a query and base a form on that query, you cannot edit / add new records. How would you recommend I handle this if I must remove duplicates? Thank you!

Hello! I have a small issue that I need help with. I posted for help on the ExcelForum last week, the link is below, but no one was able to answer my question and a friend recommended this site...