a contiues form question

  • Thread starter Thread starter joyo
  • Start date Start date
J

joyo

I am working on a document searching program. I am using
the continues form to display my returned results. I have
two questions about this issue.

1. What is the record limit of one continues form. If I
have many results returned, whether the recors will be
over one page. How to limit the number of displayed
records in a form. For example, I would like to display
20 records in a form, then user click a NEXT button, go
to next 20 records... I know I can use a list or
datasheet form, but I am pefer to use a columnar form to
display these records.

2. I am using Front/Back end structure in my program. How
do I transfer the searched result to the front end.


Thank you for your help.

joyo
 
1. What is the record limit of one continues form.
Click to expand...

I don't think there is a particular limit.
If I
have many results returned, whether the recors will be
over one page. How to limit the number of displayed
records in a form. For example, I would like to display
20 records in a form, then user click a NEXT button, go
to next 20 records... I know I can use a list or
datasheet form, but I am pefer to use a columnar form to
display these records.
Click to expand...

If you are using JET as your database engine, then it
is smart, and it will not fill the form with more data then it needs

2. I am using Front/Back end structure in my program. How
do I transfer the searched result to the front end.
Click to expand...

You don't have do anything specify. If you shove the sql
into sub-form, then the records are transferred for you.

dim strSql as string

strSql = "select * from tblCustomers where city = 'Edmonton'"

me.MySubForm.Form.RecordSource = strSql

The above would thus display all records with a city of Edmonton.

It is not clear if you have a need to save a local "copy"
of the results, or are you just asking how a split
database works? In a split database, records are
read from the data file and displayed in a form, or
a continues for in your case. No special programming
or changes need be done to your code in this case.
 
Back
Top