Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How Do I ? (2000 (9.0.2720))

    I wish to use an exiting report with a new query. How do I attach the new query to a copy of the report ?
    Many thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I ? (2000 (9.0.2720))

    Make a copy of the report.
    Open it in design view.
    Open the Properties window.
    In the Tab Data, you can select the recordsource to the new query by clicking the little down arrow on the right side of the line.
    Francois

  3. #3
    New Lounger
    Join Date
    Mar 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I ? (2000 (9.0.2720))

    Many thanks - it works.
    In my query, in the criteria box I have entered the following [Which Post Code?] and the user enters in caps alphanumeric characters like 'SE1 5JX' - How can I format the box so that the user needs only enter the first three characters ? Thanks

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I ? (2000 (9.0.2720))

    I don't think this is possible without VBA.
    Maybe someone else ?
    Francois

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I ? (2000 (9.0.2720))

    As Francois suggested, VBA is the most efficent answer, but you can think about a custom dialog form, instead of placing the criteria directly in the query.

    In Access Help, search on "criteria" and then choose "use a form to enter report criteria". Instead of placing a textbox on the form, like the help text instructs, use a combo box and that will allow you to position via initial characters. Instead of running a report, you could then run the query.

    This is not the smoothest and requires adjustments to the help instructions, but it is the only alternative that comes to mind.

    HTH

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I ? (2000 (9.0.2720))

    I may be missing something, but why not set the default to the first 3 char's and in the field just before this box, use the send key option.

    i.e. if the default is ABC of txtBox2 (tab order 2) in the afterupdate event of txtBox1(tab order 1) put the send key code to go to txtBox2. Using this method the user would only have to enter the last 3 digits as he/she enters that field.

    Like I said, I could be missing something, if not, I'm sure this will do exactly what you're looking for.

    Good Luck.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I ? (2000 (9.0.2720))

    I read your question a little bit differently than the others. Did you mean that you want to be able to enter the first three characters of the postal code and have it match all postal codes that start with those characters?

    Off the top of my head I can't think of a way to force the user to enter exactly three characters under those circumstances, but if you want the user to be able to enter the first few characters of the postal code and have it match all codes that start with those characters, use something like

    like [Which Post Code?] & "*"

    in your criteria.

  8. #8
    New Lounger
    Join Date
    Mar 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I ? (2000 (9.0.2720))

    Many thanks - its just what I wanted and it works.

Posting Permissions

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