Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box (2000)

    I have a combo box so the user can select the pay terms for the customer but on the report and form I want them to be able to see the pay term description and not the assigned pay term id number. I know I have the code in my class files somewhere at home but unfortunately I'm at work and need it by end of day. Please go easy on my, I'm not too techy and it's been awhile since I've used Access.

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

    Re: Combo Box (2000)

    You can use a combo box on a form and report too.
    Set the properties of the combo box as follows:
    On the Format tab:
    - Number of Columns: 2
    - Column Widths: 0"; 1"
    On the Data tab:
    - Control Source: the Pay Term ID field.
    - Row Source Type: Table/Query.
    - Row Source: the table (or query) that lists the pay terms. I have assumed that the Pay Term ID is the first field, and the description the second field.
    - Bound Column: 1

    The combo box will store the Pay Term ID value, but display the corresponding description.

  3. #3
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    I can't thank you enough!

  4. #4
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    They would like to have the sales reps select the product that they want to add to a quote. They could be selecting 3 items or 300. Once the product has been selected, they want to print it out and send it. Should I have them work in a form or a report or won't that matter?

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

    Re: Combo Box (2000)

    Forms are intended for entering, editing and viewing data, but although you can print a form, the result is usually not ideal.
    Reports are intended to be printed - you have very good control over the layout. But you can't enter or edit data in a report.
    So you should use a form to let the sales reps select products, and a report to print the data.

  6. #6
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    That sounds simple enough. Thanks again.

  7. #7
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    I've inserted the product subform onto the report. My question is, is there a way to not predefine the space. One quote may have 3 items on it while others may have 100. Can the subform automatically size to fit? It looks kind of tacky. Perhaps it should be approached from a different angle. I'm open to suggestions.

    Thanks again.

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

    Re: Combo Box (2000)

    Open the main report in design view.
    Make the height of the subreport (subform) quite small.
    Adjust the height of the section that contains the subreport to fit tightly.
    Set the Can Grow and Can Shrink properties of that section and of the subreport to Yes.

  9. #9
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    Perfect!

  10. #10
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    I hope I haven't reached my limit on questions! I can work around this next one but before I do the tap dance it might be better to find out if there's a better fix. The quote that the sales rep is putting together will need to be printed in triplicate. The footer on one will read Original - Return to File, the second will read Sales Copy and the third Customer Copy. Is there a way to do this without putting together three separate reports?

  11. #11
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    Yikes! I thought this was coming to a close. So far, Access has been able to do everything that they need...but, they want the final quotes to print in pdf. Can it do that?

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

    Re: Combo Box (2000)

    Access 2000 has no built-in convert/print to PDF feature.
    You can create a PDF file from a report if you have a third-party utility that creates PDF files, such as Adobe PDF (powerful but expensive), pdf 995 (free), or Stephen Lebans' ReportToPDF (free).

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

    Re: Combo Box (2000)

    To do this in one report would require VBA. It's probably easier to create three reports. If you still need to modify the design of the report, wait until the design is fixed, and only then create copies.

  14. #14
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    I didn't realize that there was free software to convert to pdf. This is going to help in many ways.

    It's been awhile since I've worked in Access so three copies of the final report works fine with me!
    Thanks again.

  15. #15
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (2000)

    This worked well for my product fields but the text boxes with the terms are not growing. Does it have to be a certain type of form. I would like the default view for the terms to be a single form but it won't seem to grow.

Page 1 of 2 12 LastLast

Posting Permissions

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