Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help for the next step, and more (Access03)

    Question 1:
    I have a report that reports individual staff members and due dates for several different certifications. The problem is that each date is on a different line when it goes to a report. How can I get it so multiple record values get reported on the same line?

    Question 2:
    I want to send data out of the main database to another vehicle (which type is up for grabs) that will be reported on team pages in SharePoint 2007. I want the material to be pushed out of Access03 everytime the database is closed. How do I go about that?

    Thank you for your time and direction.

    Fay

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

    Re: Help for the next step, and more (Access03)

    Question 1:

    The attachment to <post#=301,393>post 301,393</post#> contains the code for a function named Concat that you can use to concatenate values into one long string. Copy the function into a standard module. You can then use it in expressions in queries and in the control source of text boxes on forms/reports.

    Question 2:

    Access doesn't have an event at the database level that fires when the database is closed, so you'll have to use a form event. Do you have a form that is open whenever the database is open? If so, you could use the On Close or On Unload event of the form.
    You can export a table or query to a text file or Excel worksheet using DoCmd.TransferText and DoCmd.TransferSpreadsheet, respectively.
    If you need to export a formatted report, PDF is the best format. You can either use a PDF writer such as Adobe Acrobat, or the free Access-specific tool ReportToPDF from Stephen Lebans.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help for the next step, and more (Access03)

    Thanks Hans. I will get to work. Thanks for the help. Fay

Posting Permissions

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