Select Range of records 
Author Message
 Select Range of records

dear friends,

I'm using Access for my database and user interface ( form ) using Vb.
The problem is how to select a range of records and display the
particular records to the user.
I'm using userId field as a criteria to select records, Meaning if a
particular user  login they can only view their records.

note:- All the different users records are in the same database file.

I'II be appreciate if any one could help me this problem and provide
some sample of code for this problem. thanks in advance.

vijay



Fri, 10 Mar 2000 03:00:00 GMT  
 Select Range of records

You can use a Data control to access the records you want and display
them using a DBGrid.  Set the grid data source to datControlName.

datControlName.recordsouce = "SQL Statement"
datControlName.refresh



Quote:
>dear friends,

>I'm using Access for my database and user interface ( form ) using Vb.
>The problem is how to select a range of records and display the
>particular records to the user.
>I'm using userId field as a criteria to select records, Meaning if a
>particular user  login they can only view their records.

>note:- All the different users records are in the same database file.

>I'II be appreciate if any one could help me this problem and provide
>some sample of code for this problem. thanks in advance.

>vijay




Fri, 10 Mar 2000 03:00:00 GMT  
 Select Range of records



Quote:
>dear friends,

>I'm using Access for my database and user interface ( form ) using Vb.
>The problem is how to select a range of records and display the
>particular records to the user.
>I'm using userId field as a criteria to select records, Meaning if a
>particular user  login they can only view their records.

>note:- All the different users records are in the same database file.

>I'II be appreciate if any one could help me this problem and provide
>some sample of code for this problem. thanks in advance.

>vijay


Use a snaphot and create a SQL statment that uses the ID of the user
to find all the records.


Fri, 10 Mar 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. How to select a range of date record from SQL server

2. PROBLEM - Selecting records based on Date Range

3. Selecting records within date range

4. How to select a range of date record from SQL server

5. Selecting Access records in date range

6. How to select a range of date record from SQL server

7. How do I select a constant time range from a variable time range using VBA

8. Crystal Reports 8.5 date range parameter field - record selection that includes null date range

9. vb Select * from tableA?How to select record from 1000 to 2500

10. Cetting A Report To Select Records Based Upon A Value Selected In A Combo Box

11. vb Select * from tableA?How to select record from 1000 to 2500

12. selecting items in a Data bound list and passing a field content for the selected record

 

 
Powered by phpBB® Forum Software