User Profile

Collapse

Profile Sidebar

Collapse
MsTGordon
MsTGordon
Last Activity: Dec 1 '11, 10:34 PM
Joined: Nov 7 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MsTGordon
    replied to Extract Parts of a Memo Field into Separate Fields
    in Access
    I'm going to try this in a sample.
    This is a new request from the user that will more than likely get repeated. I was able to give them a final product today using Excel (Data, Text To Column Feature) but would like to program something in Access to do it.
    Thank you for responding.
    See more | Go to post
    Last edited by NeoPa; Nov 22 '11, 12:23 AM. Reason: Removed quote

      Leave a comment:

    • MsTGordon
      started a topic Extract Parts of a Memo Field into Separate Fields
      in Access

      Extract Parts of a Memo Field into Separate Fields

      I have a table where the data (memo field) contains various names seperated by the dreadful wildcard key (*). This data comes from another program using ODBC connection. Here is my issue.
      I need to seperate each portion of it into a different text field. For example:

      Engine Room/Starboard/Drawer-2 should be
      Engine Room
      Starboard
      Drawer-2
      In 3 seperate fields.

      The data is not consistent....
      See more | Go to post
      • MsTGordon
        replied to Print Report based on Form Sort Order
        in Access
        I appreciate your efforts. I am not using a code for the user to sort but the standard MS Access sort buttons. I've arranged custom tool bars to allow the stadard "A-Z" button and "Z-A"....
        See more | Go to post

          Leave a comment:

        • MsTGordon
          replied to Print Report based on Form Sort Order
          in Access
          I'm sorry this is so confusing. My form is based on a qry which is set to sort by Part Number then Manufacturer by default. The user can then click in any one of the 8 fields on the form to sort and filter should they desire. The print button is a command button on the form which opens a report built on the same qry as the form.
          If the user filters the form and hits the print button, the report reproduces the form. The user wants to be...
          See more | Go to post

            Leave a comment:

          • MsTGordon
            replied to Print Report based on Form Sort Order
            in Access
            I get the following message:

            Orderby= OrderByOn= False...
            See more | Go to post

              Leave a comment:

            • MsTGordon
              replied to Print Report based on Form Sort Order
              in Access
              I almost there. I posted the code exactly where you told me on the print button on the form. However when the report opens in Print Preview it is still not sorted like the form.

              Should I have a code on the "On Open" event of my report?...
              See more | Go to post

                Leave a comment:

              • MsTGordon
                replied to Print Report based on Form Sort Order
                in Access
                Thank you Stewart for your response. Your second solution seems to be the one that may work for me considering the fields are manually sorted and the same on the report. Where should I put the code you listed? On the print command button or on the "on open" event of the report?
                See more | Go to post

                  Leave a comment:

                • MsTGordon
                  started a topic Print Report based on Form Sort Order
                  in Access

                  Print Report based on Form Sort Order

                  I have a form based on a query where the user can filter and sort in any of the fields of the form. I am able to print preview a report once the user filters the report but if the user sorts the report it does not sort on the report.
                  I have a button on my form with the following code on a print button which opens the report:

                  Code:
                  Private Sub Command11_Click()
    Dim strWhere As String
    If Me.Dirty Then Me.Dirty
                  ...
                  See more | Go to post
                  Last edited by Stewart Ross; Nov 7 '11, 11:13 PM. Reason: code tagged
                  No activity results to display
                  Show More
                  Working...