Nhoung Ar
Last Activity: Feb 6 '09, 07:41 AM
Joined: Aug 22 '07
Location:
-
Thank you very much for your respond. I will try it. -
Or any possible way, please.Leave a comment:
-
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.Leave a comment:
-
Select multiple records for printing
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... -
I have tried your code in module, but in event form_open I am not sure about
me.name and
me.child
what are they stand for ? are they form name and subform name? could you please give me the code using my form name and subform name above....Leave a comment:
-
Thank you very much Jconsulting and Adezii. As I am very busy I did not try your code yet. Anyway, I appreciated for your prompt respond to my question.
Many Thanks....Leave a comment:
-
Please help in coding module
I am using MS Access 2000 to design a small database, which have five forms. Each form has few subform. For security, in the event of form load I protect as follow:
Private Sub Form_Load()
Me.AllowEdits = False
Me.AllowDeletio ns = False
SCTP.Form_FormC ounselingQ.Allo wDeletions = False
SCTP.Form_FormC ounselingQ.Allo wEdits = False
SCTP.Form_FormA ccomodationQ.Al lowDeletions = False
SCTP.Form_FormA ccomodationQ.Al lowEdits... -
I am appreciated for your repond. I will try those websites and get back to the forun if i have more questions....Leave a comment:
-
Embedded image into form/report
Can anyone outhere advise me about a best practice of embedded the image into form or report.
I have several forms and report which embedded images (logo) to the header. I observed that the database size is quickly increase its size (up to 80 MB for only 20 records).
Then, I changed the picture type in all forms/reports to Linked. Now, the database size is reduced to around 10 MB. After the records up to nearly 200,... -
OK, it works like this:
1. After you filled out all your selection/combo box (for example 10 combo) in your form and click the command button. (This form contains only 10 combo boxes and command button).
2. It will then try to open your report, which took the record from the query, which had a criteria and
3. This criteria will match to the value in your combo on your form, then it previews the...Leave a comment:
-
Hi! pouj,
If I understand well what you mean that, after you select the option on your from and click command button your report will show all records which match to your selection.
1. Create the query (queryName) from your table, put the criteria under field status:
Like [Forms]![formName]![comboName]
2. Create report from this query.
3. Your form (formName) contains...Leave a comment:
-
Thank you very much puppydogbuddy. It works well right now.
I appreciated your quick respond....Leave a comment:
-
Apply filter on number field
Can anybody out there help me please on apply filter in MS Access. I have a form that create from the query, which contain field chidid (text field), in the form footer, I add the button to open another form (searchF form), which have an unbound text box (text1). It works fine with this code:
DoCmd.ApplyFilt er , "childid='" & Form_SearchF.Te xt1 & "'"
But if I change the data type of childid...
No activity results to display
Leave a comment: