By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,655 Members | 1,860 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,655 IT Pros & Developers. It's quick & easy.

How to make muti records showed in one Data Access Pages

P: 6
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.
Dec 28 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 1 '07 #2

P: 6
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.
Jan 1 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 1 '07 #4

Expert 5K+
P: 8,434
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...
Jan 2 '07 #5

pks00
Expert 100+
P: 280
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
Jan 2 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.