Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    form strategy (a2000)

    I've experimented with splitting up Address Line 1 and Address Line 2 into smaller pieces so that I can use the US Post Office's standard abbreviations for primary and secondary addresses as combo boxes. The abbreviations were all over the place when the users were left on their own. It looks like text box, combo box, text box, combo box, and text box.

    Unfortunately, addresses are just not standardized enough that they all fit. So, I'm planning to use concatenation in a make table query to join the address fields back into Line 1 and Line 2. I'd like to have a resource available for the person doing data entry to be able to look up any abbreviations they are unfamiliar with. I was thinking of a pop up form that loads when the user tabs into the address subform. Is it possible for the user to lookup up an abbreviation, click it and have it appear as the next word in string in the text box that was active before abbreviation was looked up?

    E

  2. #2
    Star Lounger
    Join Date
    Sep 2003
    Location
    Houston, Texas, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: form strategy (a2000)

    Why not have an unbound combo box with the choices on the subform. Then create the address by setting the value of the text box to contain the looked up abbrev. If no selection has been made, ignore the combo box; otherwise use the selection to create the text to include the selection. Let me know if this make no sense and I will explain further.

    deutsch

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: form strategy (a2000)

    Sounds like a good plan. Could you spell it out a little more? How would you do it? Do you have a code snippet or sample I could look at for some ideas?

    E

  4. #4
    Star Lounger
    Join Date
    Sep 2003
    Location
    Houston, Texas, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: form strategy (a2000)

    I am showing an example below:
    (The picture does not show and when I attach the file it is toobig)
    Let me know if this does not make sense.


    The first combobox on the left is always selected. The other three are optional. The Up button combines the text

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

    Re: form strategy (a2000)

    If you wanted to attach a screenshot: it should be 100 KB max. If it is too large, open it in a graphics application, and save it as a .png file; this often results in the smallest file size for screenshots. Trimming away parts not essential for what you want to illustrate may help too.
    Warning: if you preview a post, the attachment box will be cleared. You must fill the attachment box immediately before posting.

  6. #6
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: form strategy (a2000)

    I'd love to see the picture. If you're will to send re email you can send to ppem@cfu.net.

    Thanks for your help,

    E

Posting Permissions

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