Search results

Good morning, I am trying to use a Public Function to determine the result of a field value in a query. Select Case notetypeid Case "1" fsort = [ValuationProperty].Value Case "2" fsort = "Property" Case Else fsort = "ValProperty" End Select End Function...

Hi, Could someone assist with helping me to know the code for displaying the Word Print dialogue box instead of sending it straight to the printer. I have the following code: 'Open Word Set objWord = New Word.Application 'Letter document would be open Set objletter =...

Hi, I have lots of queries, 100 plus and some of them have Environ("Username") in them as the criteria. Is there a way, other than going into each query to see if that criteria exists to update it from vba code to search that string in the queries one by one and replace with the modern...