By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,285 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,285 IT Pros & Developers. It's quick & easy.

Select multiple records for printing

P: 13
I am working on small database, which has a number of thousand records in one table. I need to print those (a hundred records or less) a time. I think that i should have one form for input the data, another form for selecting record for printing. In the second form i woulk like to type each UserID and the UserID should store in a list box or any object that i can verify before printing its (in report). How can i do ? please advice me step by step.

Your respond are highly appreciated.
Dec 18 '08 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Do you mean type in 100 userID's at a time? This does not seem very user friendly. Have you no other criteria by which to choose which records you want to print?
Dec 18 '08 #2

P: 13
Yes, it seems that user type each ID at a time in text box. After they click on return key, that ID should store in one object (ie. list box in order to verify) and the text box is blank, then they start type another ID until they get all they wanted. I think that this way is not user friendly, but it will make confusion or mess up when user browses around 5000 records and select 100 records or less . Thank you again.
Dec 20 '08 #3

P: 13
Or any possible way, please.
Dec 20 '08 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
@Nhoung Ar
The basics of what you want to do are this.

Assuming controls ... command1 (button), List1 (Listbox) and Text1 (Textbox) the code on the button would be as follows:

Expand|Select|Wrap|Line Numbers
  1. Private sub command1_Click()
  2. Dim strList as String
  3.  
  4.     strList = Me!List0.RowSource
  5.     Me!List0.RowSource = strList & ";" & Me!Text1.Value
  6.     Me!List0.Requery
  7.  
  8. End Sub
  9.  
Dec 20 '08 #5

P: 13
Thank you very much for your respond. I will try it.
Dec 20 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.