Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Akron, Ohio Area
    Posts
    1

    Question Unanswered: Report Problem, Novice user, Help DESPERATELY needed

    Greetings, this is my problem:

    I have a MS Access 2000 Database with the following tables.

    Quote
    Quotees
    Quoters
    Alloys


    I have just one form, Quote Form.

    I have just one Report, Quote Report.


    Now on the Quote form, I have places that allow you to select values from all 4 tables.

    Once complied, they make a price quotation, that needs to be printed/emailed/faxed. (I can handle the email/fax part).

    My problem is, I cannot figure out how to transfer the various data from the form to the report, which must be
    laid out like a business letter for printing.
    (IE: No combo boxes, list boxes, no borders around text boxes, clean business letter type).


    I see several ways to solve this problem.

    1: Set each report text box to equal the current value(current record) of the main form, but I cannot figure out how.

    2: Using VBA code, populate each textbox in the report with the current values, but if I add ANY code, it crashes out, telling me there is an error in the code, EVEN COMMENT lines give me this!

    3: Output the data, and the formatting needed (company address, sig block, etc), to html and open a browswer.
    Again, I am unable to add any CODE at all, it simply tells me the code is bad, and points to the first line of code, even if its a comment line.


    Anyone know how I would solve this problem?

    Copy of the files in questions are availble, with sample data in the tables.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Send me your base in Access 97 and an sample of your report.
    Them I see how you cant do it.
    Saludos
    Norberto

  3. #3
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111

    Talking

    Norberto, I'm very curious with your mess... Why do you use Access 97? Am I missing something?

    Saludos

    Ruas

    Originally posted by Norberto
    Send me your base in Access 97 and an sample of your report.
    Them I see how you cant do it.

Posting Permissions

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