form strategy (a2000)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote