-
1. In Finding record I previously asked to find records by typing few letters. That worked. But fetching more than one record, it didn’t work. So anybody tell me how to view records which fetches more than 1 record. I want to view that in the form itself.
That is I have a form where there is 3 textbox for three fields. I will enter the record in the textbox and save it. When I click find command button it will clear the content and I will place my cursor in one text box and type the related text and click Fetch command button so it will fetch the related record and show it in the text box.
What I want is if it returns more than one record then it should display the message that has fetched more than 1 and I want to view all the records by pressing next button or what so ever in the same text box.
2. How to find records of Date type.
So please somebody tell me with some examples, how to do the above things.
-
I it is very long to explain
for finding all the records
use another data control
when you want find something
change data control
recordsource property
and refresh it.
example:
--------
Data1.recordsource="Select * from employees where employeename='xxxxxxx'"
to find date data type
---------------------
you should use #1/1/99#
eg:
data1.findfirst "hiredate=#1/1/99#"
instead of '1/1/99'
-
I it is very long to explain
for finding all the records
use another data control
when you want find something
change data control
recordsource property
and refresh it.
example:
--------
Data1.recordsource="Select * from employees where employeename='xxxxxxx'"
to find date data type
---------------------
you should use #1/1/99#
eg:
data1.findfirst "hiredate=#1/1/99#"
instead of '1/1/99'
Let me know if you have any questions
email [email protected]
