choosing multiple entries in access at same time to export?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built an access database using the wizard feature. I want to choose
multiple entries (at the same time) to export to send via e-mail to another
user. When i use the control key to choose the entries it doesn't allow me
to choose more than one. Is this normal? The control key in other programs
(i.e Excel) allows you to choose mulitple entries. Is this normal in
"Access". Do i have to use the clipboard to obtain the results i am looking
for?
 
A list box control includes a property the controls whether or not you can
use multiselect capability. The choices include "None", "Simple" and
"Extended". If you open your form in design view, and bring up the Properties
dialog (F4 or View > Properties), you should be able to see the properties
for the list box by selecting it. You should see the name of this control in
the blue title bar of the Properties dialog. On the Other tab, you will find
the Multi Select settings.

However, it is not quite so simple as just setting the Multi Select property
to either Simple or Extended. You must have VBA code that iterates the
..ItemsSelected property.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Add a checkbox to your table and display the checkbox on the form. Uor
export query will look for a records with the checkbox set to yes. Don't
forget to create an update query that removes the checkmark.
 
Back
Top