How to make muti records showed in one Data Access Pages

[leucine]

Hi,

I am making the reports using the Data Access Pages Wizard. It only shows one record in one page then goes to the next record by using navigation arrow. Does anyone know how I can change it to show a few records in one page? What property should be modified?

I appreciate if anyone can help me.

[MMcCarthy]

Hi,

I am making the reports using the Data Access Pages Wizard. It only shows one record in one page then goes to the next record by using navigation arrow. Does anyone know how I can change it to show a few records in one page? What property should be modified?

I appreciate if anyone can help me.

Open the page in design view and then open the sorting/grouping wizard.

Change the Data Page Size from 1 to however many records you want to show on a page.

Mary

[leucine]

Open the page in design view and then open the sorting/grouping wizard.

Change the Data Page Size from 1 to however many records you want to show on a page.

Mary

In my query, I have a function call to get the current fiscal year (getFisYear()). It works in access report. If I publish this date access page on test server it have two errors when I open it.

"Data provider failed while executing a provider command."
"Undefined function 'getFisYear()' in expression".

Do you know how I can define this function in data access page?

Thanks.

[MMcCarthy]

In my query, I have a function call to get the current fiscal year (getFisYear()). It works in access report. If I publish this date access page on test server it have two errors when I open it.

"Data provider failed while executing a provider command."
"Undefined function 'getFisYear()' in expression".

Do you know how I can define this function in data access page?

Thanks.

I don't think you can. However, I'm not an expert in Data Access Pages. I will see if I can find someone with more knowledge.

Mary

[Killer42]

I know even less about data access pages (almost nothing, in fact). But while these couple of links might not provide the answer, perhaps they may help to stimulate some ideas...

• ACC2000: How to Simulate a Subform or Subreport on a Data Access Page
• ACC2000: How to use VBScript to Synchronize Two Data Access Pages

[pks00]

Im not sure how u can do it as a DAP is really a web page connecting to the database, using jetole.

U may find u could perhaps add some vbscripting, use ADO to connect to your db (the same connection string as u have already) and read data if thats what your function does