Recent content by Lstclair

  1. L

    Select Case and Query Field Values

    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...
  2. L

    Displaying Word Print Dialogue Box from VBA

    The code works fine. However it sends it straight to the default printer. I need it to come up with the print options so I can select the printer to send it to and also then possible trays in the printer driver.
  3. L

    Displaying Word Print Dialogue Box from VBA

    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 =...
  4. L

    Query Criteria

    Thanks. Just downloaded and won't install because it is version 2013 i am using.
  5. L

    Query Criteria

    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...
See more
Back
Top Bottom