Results 1 to 15 of 15
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Produce Report / Merge (2000)

    Trying to produce the following of all the records we have in a table in the following format as like a property listing. The list could go on for 10 + pages, is this possible?

    If so what would be the best route to go down, merge into word or report?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Produce Report / Merge (2000)

    You can create a report and set the number of columns to 3 in the Columns tab of File | Page Setup... You can also specify the space between the columns and rows there, and whether the page is filled across then down or down then across.

    See Multiple Column Reports in Microsoft Access or Multiple column reports for additional info.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Produce Report / Merge (2000)

    Managed that, the first page at the top has a bigger white space than subsequent pages, any ideas how to correct this?
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Produce Report / Merge (2000)

    That's probably the Report Header section. Either turn off the Report Header/Footer (in the View menu), or reduce the height of the Report Header section to 0.

  5. #5
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Produce Report / Merge (2000)

    I use the report now and it is all setup, which duuisplays a list of all the properties that are forsale belong to certain office and in price order. I want to be able to but randowm promotional blocks in, is this possible? Where the section would not be a properties but a image file completely?
    Best Regards,

    Luke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Produce Report / Merge (2000)

    You could put an image control on the detail section.
    Put code in the On Format event of the detail section to show or hide the image control as desired and to load a picture file into it.

  7. #7
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Produce Report / Merge (2000)

    So could you do it so that every 8 records it displays the image and not the record, but would the record automatically goto the next slot?
    Best Regards,

    Luke

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Produce Report / Merge (2000)

    You could define a variable at the top of the report module:

    Private lngCounter As Long

    In the On Format event procedure, do something like this:

    ' increase counter
    lngCounter = lngCounter + 1
    ' test if counter is a multiple of 8
    If lngCounter Mod 8 = 0 Then
    ' show image
    Me.ImageControl.Picture = "..."
    Me.ImageControl.Visible = True
    ' don't go to next record yet
    Me.NextRecord = False
    Else
    ' hide image
    Me.ImageControl.Visible = False
    End If

  9. #9
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Produce Report / Merge (2000)

    When you say at the top of the report module, where do you mean? I am slightly confused.

    Could I do it so that the images are on a loop, for example have 5 images and it goes through each one and then repeats itself if needed?
    Best Regards,

    Luke

  10. #10
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Produce Report / Merge (2000)

    Also is there a way to actually miss a page out, obviously to include what was on that page later on.
    Best Regards,

    Luke

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Produce Report / Merge (2000)

    By the report module I mean the VBA code module that is associated with the report. If you open the report in design view, and select View | Code, Access will open the report module.

    By "top" I mean the upper part of the module, near the upper edge. In other words, the beginning.

    You could use another counter variable to keep track of the images. How exactly to do this, depends on how things are organized. Without knowing that, it is impossible to give more specific help.

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Produce Report / Merge (2000)

    Please try to explain this more clearly.

  13. #13
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Produce Report / Merge (2000)

    Okay, sorry for confusion.

    I want to, say on Page three of the report instead of having the actual layout, have an A4 page for advertising (not in the blocks), then whatever was on page 3 would then be on page four.
    Best Regards,

    Luke

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Produce Report / Merge (2000)

    Aren't you reinventing the wheel? Although I have no personal knowledge about it, there must be dedicated software for producing brochures etc. for the real estate business.

    Access is not a page layout program, it doesn't easily lend itself to mixing different page layouts within a single report. A printing-only solution could be to produce two different reports, and to collate the printout. This can even be controlled in code, see How to use Visual Basic code to collate and to print two reports to get an idea of how this can be done; you can modify it to suit your needs of course.
    Or you could collate an Access report and a Word (or Publisher) document.

  15. #15
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Produce Report / Merge (2000)

    You are right in that there are software packages out there that provide some of the solution to what we want. However the cost and annual subscription for the software and more importantly the annoyingly fact that everyone else looks the same in terms of printed material, window displays, etc etc.

    We want to be a differentiator in the market place and make us stand out from the crowd and going down the bespoke route, admittedly is more expensive in development however the commecial gain will outweigh it completely.
    Best Regards,

    Luke

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •