Copy field to the Clipboard

[vb_Dumb]

I have a form based on a table called CAR and on that form I have a
field called 'to' that is a combo box based on a table called
'customers address' I have two fields in that table one for the
address and one for the email address i was wondering if there was a
way to copy the email address to the clip board that is related to the
customers address after i select the customers address from the combo
box any help would be cool

Thanks,
Dan Lavish
vb illiterate

 

[tkelley via AccessMonster.com]

Try this:

If IsNull(YourField) Then
MsgBox "Field is empty. Nothing copied!", vbExclamation, "Copy"
Else
YourField.SetFocus
DoCmd.RunCommand acCmdCopy
End If

 

[vb_Dumb]

no that doesnt work what i need is after the update of the field
called 'to' on my form is for the code to go to 'to's' source table,
customer address, and go to the record that was selected and then go
to the next field called 'email' and copy that record to the clipboard
their is no text box on my form for the email
thanks dan

 

[tkelley via AccessMonster.com]

You've kind of lost me. I'm not sure what you're trying to accomplish with
putting it on the clipboard. Is it because you're then going to launch an
email? If so, is it in Outlook?

Since there is no e-mail field on the form, does that mean that you
absolutely don't want one there?

Anyway, to do it the way you want to, I'd add the e-mail column to your combo
box's dropdown as a second column that can be width of zero. Then you can
have an e-mail field with a control source of:

=YourComboBox.Column(1)

Then you can use my method to copy that value to your clipboard.

no that doesnt work what i need is after the update of the field
called 'to' on my form is for the code to go to 'to's' source table,
customer address, and go to the record that was selected and then go
to the next field called 'email' and copy that record to the clipboard
their is no text box on my form for the email
thanks dan

Try this:

[quoted text clipped - 19 lines]

 

[vb_Dumb]

yes i want it to go to the clipboard because after the person fills
the form out they export it to msword to further edit it and then
they send the word document to the receipent the problem is that there
are 100 customers and it is hard to look that up so copy it to the
clipboard paste it in easy enough i dont mind having a hidden textbox
somewhere on the document either but thanks i will try your solution
tomorrow at work

Thanks, dan

You've kind of lost me.  I'm not sure what you're trying to accomplish with
putting it on the clipboard.  Is it because you're then going to launchan
email?  If so, is it in Outlook?

Since there is no e-mail field on the form, does that mean that you
absolutely don't want one there?

Anyway, to do it the way you want to, I'd add the e-mail column to your combo
box's dropdown as a second column that can be width of zero.  Then you can
have an e-mail field with a control source of:

=YourComboBox.Column(1)

Then you can use my method to copy that value to your clipboard.

no that doesnt work what i need is after the update of the field
called 'to' on my form is for the code to go to 'to's' source table,
customer address, and go to the record that was selected and then go
to the next field called 'email' and copy that record to the clipboard
their is no text box on my form for the email
thanks dan

[quoted text clipped - 19 lines]

 

[tkelley via AccessMonster.com]

Hidden textbox won't work because my method of copying something to the
clipboard requires that the focus be set to that box first ... just like you
have to select any value in any Windows program to copy it to the clipboard.

yes i want it to go to the clipboard because after the person fills
the form out they export it to msword to further edit it and then
they send the word document to the receipent the problem is that there
are 100 customers and it is hard to look that up so copy it to the
clipboard paste it in easy enough i dont mind having a hidden textbox
somewhere on the document either but thanks i will try your solution
tomorrow at work

Thanks, dan

You've kind of lost me.  I'm not sure what you're trying to accomplish with
putting it on the clipboard.  Is it because you're then going to launch an

[quoted text clipped - 26 lines]

 

[vb_Dumb]

Works great Thanks!!
Dan

Hidden textbox won't work because my method of copying something to the
clipboard requires that the focus be set to that box first ... just like you
have to select any value in any Windows program to copy it to the clipboard.

yes i want it to go to the clipboard because after the person fills
the form out they export it to  msword to further edit it and then
they send the word document to the receipent the problem is that there
are 100 customers and it is hard to look that up so copy it to the
clipboard paste it in easy enough i dont mind having a hidden textbox
somewhere on the document either but thanks i will try your solution
tomorrow at work

Thanks, dan

You've kind of lost me.  I'm not sure what you're trying to accomplish with
putting it on the clipboard.  Is it because you're then going to launch an

[quoted text clipped - 26 lines]