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

Viewing more than 10 records in a dropdown box on a DAP

P: n/a
I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.

axsprog
ax*****@yahoo.com

Jul 16 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
* axsprog:
I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.
VBQ, ADo and DAP. Some interesting TLA's.

Jul 16 '06 #2

P: n/a
The limitations of DAP are such that most find them useful only in an
organization's intranet, not on the Internet. And, in fact, the development
team has blogged that DAPs are to be "deprecated" in the next version,
Access 2007 -- the ones you have will still run, but to create new ones or
maintain existing ones, you'll have to keep Access 2003 or earlier around.

Generally, for web-enabled database applications using Microsoft tools, the
recommendation is for classic .asp (Active Server Pages) with ADO or the
newer ASP.NET with ADO.NET. There are newsgroups specifically on those
technologies available from news.microsoft.com or via the online interface
to which you can link from http://office.microsoft.com. There is also free
"express" website creation software for Microsoft Visual Studio 2005, but I
don't have the link.

Larry Linson
Microsoft Access MVP

"axsprog" <ax*****@yahoo.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
>I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.

axsprog
ax*****@yahoo.com

Jul 16 '06 #3

P: n/a

axsprog wrote:
I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.

axsprog
ax*****@yahoo.com
Jul 16 '06 #4

P: n/a

axsprog wrote:
I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.
I played around with this but like you I could find nothing that
helped. I wrote directly to the DAP's html inserting onfocus and onblur
commands, which I know work in other circumstances ... this simply made
the dropdown into a narrow line.
It's probably not very helpful to suggest that you try HTAs or simple
HTMs running in IE; these are a bit like DAPs but much more responsive
to one's needs. On the other hand they take very much longer to create.

Jul 17 '06 #5

P: n/a
In the morning and with coffee I was able to effect modifying the
number of rows shown in the dropdown by modifying the original SELECT
from:

<SELECT class=Style2 id=ReportsTo
style="Z-INDEX: 34; LEFT: 10.761cm; WIDTH: 3.105cm; POSITION: absolute;
TOP: 1.809cm; HEIGHT: 0.449cm"
tabIndex=16 MsoTextAlign="General"></SELECT>

to

<SELECT id=ReportsTo style="Z-INDEX:34; LEFT:10.761cm; WIDTH:3.105cm;
POSITION:absolute; TOP:1.809cm; HEIGHT:auto" tabIndex=16"
onblur="this.size=1" onfocus="this.size=25" size=1></SELECT>

Jul 17 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.