NeedReplyFast!! Shifting between chooiseboxes and email results

[CPUbuster]

Greetings fellow sysoperators, >:O>

I am having a great haste on this problem. I need to have the EXACT code to put in my application. I have 2 scroll boxes one filled whit a table(DB) and an emty one. I need to fill the emty one using 2 buttons. An add and a remove button. The 2 boxes are called boxsrc and boxtrg. The buttons are called butadd and butrem. The email button is called butsnd whitch should bring up a box saying transfer made and mailing the former emty box to my email adress.

I am really new to adding VB to my buttons and stuff so please don't expect me to know it all right away.

If you can fix it for me and don't mind please mail me at CPUbuster@four.tmfweb.nl and I'll reply with a thank you message and the file linked to the mail. ;-)

Thanks for your responses.
CPUbuster [sig][/sig]

 

[DougP]

Well not knowing exactly what you want I will guess that you want to click on a item in the full list and click the add button to add it or the remove button to remove it from the new list???? Right.
then you want to e-mail everyone in the new list????
right?????

since most of what you are doing will be adding them to the new list I would forgo the add button and use the Click event in the first listbox to add them to the second box.
then ahve just the remove button to remove them.

And of course and e-mial button to send them.
OOOORRRR even better!!!!

Just have one box that has the multi select option turned on and have only one button and e-mail.
So you click on each name you want and it will highlight it, If you don't want them click again and it will un- highlight.
Click E-mial to send all of the highlighted ones an e-mail.

in your list box click properties and click 'Multi Select' and click the 'simple' option.

Then add a button to your form.
--------------------------------------------
Private Sub Command2_Click()
On Error GoTo Err_Command2_Click

' Note make sure the e-mial address is in the first column of the list box
Dim varItm As Variant
For Each varItm In List0.ItemsSelected

DoCmd.SendObject acSendNoObject, "", acFormatTXT, List0.ItemData(varItm), , , "Subject of e-mail", Message, False
'Debug.Print List0.ItemData(varItm)
Next varItm


Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

End Sub


Cool, I love it, I just tried it!!!!!!!!
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[CPUbuster]

In reply to your request, how can Bar-codes help me be more productive? ;-)

Thanks. I havn't got time to try. Gotta get home. But I'll mail you in the (what I concider) the morning. Thank anyway. I'll let you know! [sig][/sig]

 

[DougP]

e-mail me about barcodes
dposton@universal1.com
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[CPUbuster]

DougP,
I really can't figure this stuff out. You got moast of my point tho. I don't wand to add users to mail.

I want to select one user, select his region (boxes to be mailed nr. 1&2)

Then I wand a user to be able to select a couple of products from a DB in a scroll box. The items should be places in a other scroll box (box to be mailed nr. 3).

and than send the boxes to be mailed to a email address.

But I really can't figure it out. Would you mind if I mailed the form over? You'd really save my ass!

Thanks in advance and stuff! [sig][/sig]