User Profile

Collapse

Profile Sidebar

Collapse
roryok
roryok
Last Activity: Nov 21 '07, 11:55 PM
Joined: Nov 13 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • roryok
    replied to VBA filtering vs Form filters
    in Access
    Thanks FishVal.

    Following your suggestion I've put the whole SQL statement as below but getting "Syntax Errors" when I compile it in VBA.

    To be honest, I've been playing around with the " and & symbols following the structure as shown in the VBA help topic.

    Code:
          stDocName = "Orders by date form"
      DoCmd.OpenForm stDocName
      Forms(stDocName).RecordSource="SELECT
    ...
    See more | Go to post

      Leave a comment:

    • roryok
      started a topic VBA filtering vs Form filters
      in Access

      VBA filtering vs Form filters

      Hi,

      (Access 2002 & Windows XP Pro)

      I have a Select query and one of the columns has the following criteria: (from SQL view)
      Code:
      HAVING (((order.orderDate)>=[Forms]![Date Filter]![txtDateFrom] And (order.orderDate)<=[Forms]![Date Filter]![txtDateTo]));
      This works OK when I'm using the Date Filter form with two unbound boxes which ask for the start and end dates. The query dynaset appears correctly....
      See more | Go to post
      • roryok
        replied to Query by Form
        in Access
        Thanks to you both for the replies. They were extremely useful.

        Fiddled around with Sierra7's code and got what was required. Client wanted separate forms so kept it that way.

        Thanks again.

        I've got a further query about filtering but will make a new post.
        See more | Go to post

          Leave a comment:

        • roryok
          started a topic Query by Form
          in Access

          Query by Form

          Hi.

          (Access 2002 - Windows XP Pro)

          I have a select query called "Find Suppliers". One of its fields is "supplierNa me" which is derived from a linked "Suppliers" table.

          I have a form called "Select Suppliers" which has a combobox which lists all the suppliers names and is derived from a small select query.

          I have a second form called "Show Suppliers"...
          See more | Go to post
          • roryok
            started a topic Drawing lines on a report
            in Access

            Drawing lines on a report

            I've got the following to draw a vertical line on each control followed by a rectangle around the Details section in a report.

            What I cannot seem to find in Access VBA Help is how to set the thickness of the lines in this instance using VBA. I want to set the thickness at 1pt.

            Can anyone suggest a way of doing this please?

            Code:
            ' This is the spacing between the right edge of the
' control and
            ...
            See more | Go to post
            No activity results to display
            Show More
            Working...