User Profile

Collapse

Profile Sidebar

Collapse
suzanne099
suzanne099
Last Activity: Aug 15 '13, 02:45 PM
Joined: Mar 29 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • suzanne099
    replied to Is it Possible to Output Query Parameters into Report Title?
    in Access
    Thanks so much!!!!!!
    See more | Go to post

      Leave a comment:

    • suzanne099
      started a topic Is it Possible to Output Query Parameters into Report Title?
      in Access

      Is it Possible to Output Query Parameters into Report Title?

      Good Morning,

      I have a report populated by a query with a date range parameter (begin/end date). Is there a way to output the selected date range into the report title (i.e., include the selected begin and end date by the user into the report title).

      I haven't been able to figure out how to do this, since the parameters are not saved.

      Thank you in advance.
      Suzanne
      See more | Go to post
      • suzanne099
        replied to Sorting List Box Choices
        in Access
        Thank you so much. I guess that was a stupid question. But I was stumped for days....
        See more | Go to post

          Leave a comment:

        • suzanne099
          started a topic Sorting List Box Choices
          in Access

          Sorting List Box Choices

          Hello Everyone...

          I have been trying to figure out how to sort the data in a list box. (I want the data in the Pick_Batch list box to be sorted by batch_num.) I've tried the following code, but have been unsuccessful.

          [Pick_Batch].RowSource = "Select [batch_num], [batch_receive], [count], [tag_batch] From [tbl_batch] WHERE idnum = '" & Me![Pick_Facility] & "' SORT ORDER [batch_num] "          ...
          See more | Go to post
          • suzanne099
            replied to How to popupate a subform based on a field selection
            in Access
            Thanks so much. I was trying to figure this out for days! Just wanted to let you know you really helped me so thank you for posting your solution!
            See more | Go to post

              Leave a comment:

            • suzanne099
              replied to ListBox Limit
              in Access
              Thank you for your thoughts. I am actually trying to mimic a program that is already in place with a new database that can be modified. I realize that I am trying to create a very large list box that will not be very efficient.
              See more | Go to post

                Leave a comment:

              • suzanne099
                started a topic ListBox Limit
                in Access

                ListBox Limit

                Hello,

                I am trying to use a list box based on a large query of records within an access form. The query contains 95,738 records, but the list box only lists 65,536.

                Is there a default limit on the number of records shown in an access list box? If so, is there anyway to change this default to allow all the query records to be access via the list box?

                Thanks.

                Suzanne
                See more | Go to post
                No activity results to display
                Show More
                Working...