Search results

Dear Steve, yes that's exactly what I want. In the form, User will type in the number of records he/she wishes to see in the select query. Based on that input, I wish the select query to display the records. By the method you have explained .... the count of records field in the output of...

1> Create a form with text box for the user to give the input 2> Set those input as criteria in a select query .. the syntax you have written is right 3> Make a sub form in your initial form to display the output of the select query ... 4> In the command button .. either refresh data or...

Could some one help me with some good reference books or material to learn complex VB coding and Access coding ??? Thanks Alvis Lazarus

Dear Steve, yes that's exactly what I want. In the form, User will type in the number of records he/she wishes to see in the select query. Based on that input, I wish the select query to display the records. By the method you have explained .... the count of records field in the output of...

Dear John ... thanks for the reply. If I have to ask the user for the number of records to be displayed through an user form and then I have to use that value to display the number of records in a select query. How to do that ?

Question 1: I'm using MS access to write a small app for my friend. I need to display and print the first 'X' number of rows in a select query based on a number the users enters in a form. Can you help? Question 2: Is there a way to restrict the number of rows that are returned from a select...

Hello to all ...