User Profile

Collapse

Profile Sidebar

Collapse
MRA2
MRA2
Last Activity: Jan 3 '18, 02:17 AM
Joined: Oct 2 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MRA2
    replied to Changing a default value in a table
    in Access
    Worked GREAT!

    Worked Great Thanks so much!!!!...
    See more | Go to post

      Leave a comment:

    • MRA2
      started a topic Spliting a Name into two fields
      in Access

      Spliting a Name into two fields

      I have names in the form:

      Smith, Robert Jones, Frank

      I want to convert all the names in the db to 2 fields. One containing the first name and one containing the last name.

      Anyone out there have some quick code for this???

      Thanks,
      Alan
      Staten Island, NY
      See more | Go to post
      • MRA2
        replied to Space After Every 5th Record
        in Access
        Putting a Page Break anywhere in the detail section results in only 1 record per page being printed!!!!...
        See more | Go to post

          Leave a comment:

        • MRA2
          replied to Space After Every 5th Record
          in Access
          Yes I tried that but that effects Page 2, 3 etc.........
          See more | Go to post

            Leave a comment:

          • MRA2
            started a topic Space After Every 5th Record
            in Access

            Space After Every 5th Record

            My Report should have 30 records on Page # 1 and 35 records on every other page. This is due to the report header on Page # 1.

            I have been using this code but I end up with 38 records on page #1. Apparently my routine does not recognize the page breaking...

            I have been using on the report

            General:
            Code:
            Dim fBlankNext As Integer ' Flag: Print next line blank? (True/False)
Dim intLine As Integer
            ...
            See more | Go to post
            Last edited by NeoPa; Oct 27 '07, 08:35 PM. Reason: Please use [CODE] tags
            • MRA2
              replied to How to control the image in reports
              in Access
              I created a tiny Access 2000 database with 2 records that does what I think you wish to do.
              If anyone wishes to see it, Email me at:

              belong5774@mypa cks.net

              and I will gladly Email you this little database...

              Alan
              Staten Island, New York
              See more | Go to post

                Leave a comment:

              No activity results to display
              Show More
              Working...