Search results

It Worked! You don't know how much I appreciate your time and patience. You have been a blessing!

Sorry about that. I was in a rush going to a meeting. Here it is.

I am selecting <Blanks>. That is a selection I added using a UNION Query. I attached a copy of the database. The CODE I am having trouble with is a private function.

This is all I got in the Immediate Window:

I tried the debug.print and I don't know how to make that work. I am completely green when it comes to VBA, as in I honestly don't know what any of the language means. I don't know how to type strings. Nothing. The only CODE I have ever used is stuff I have searched for that does what I need...

PR2 here is what I currently have: If Nz(Me.PR_Filter, "") > "" Then 'Puchase Request If Len(Nz(strFilter)) > 0 Then strFilter = strFilter & " And " If Me.PR_Filter = "<Blanks>" Then strFilter = strFilter & "IsNull(PR)" Else strFilter = strFilter & "PR = " &...

Wayne, Thanks for the response! I tried your suggestion. I'm getting this error now: Would this be because Access is looking for a number first and when it tries to find "<Blank>" it doesn't know what to do with text? How would I fix this?

I'm going to start off by saying I have no clue what any of the code I post means (I'm a complete newb when it comes to VBA). I'm learning using the "trial by fire" method. I found the code I'm using in this forum and it does part of what I need it to do. Here's the problem. I have a main form...

Hi all! I want to first off thank everyone for the wealth of information that is posted in this forum. The information that I have found has been extremely helpful. I have been working with Access for a long time, however, I've only performed basic database building. With that said....I am...