开发者

Access Input textbox on Data Access page with only select enabled to allow filter by searchs

开发者 https://www.devze.com 2023-02-04 00:42 出处:网络
I have a data access page which gets all it\'s data from a query of another table, problem is all the textboxs I make开发者_Python百科 on the page and bind the Control source to the matching column th

I have a data access page which gets all it's data from a query of another table, problem is all the textboxs I make开发者_Python百科 on the page and bind the Control source to the matching column then don't allow me to input any text in to use the filter option to search all the results.

I don't want to be able to record any information but if I change page properties to from DataEntry = false too true then it no longer displays the whole section of textboxs.

Anybody know of a way round this or suggestions of other simple solutions to display certain data from the table or all the data from the query in the same/similar way as this?

Edit- Original issue which now requires me to find new solution.


I've used DAP quite a bit -- I even built DAP solutions at Microsoft, and they were wildly popular. I always preferred to use the SQL Server flavor of DAP.. and that allows you to use TWO different types of filters, the standard filter property, in addition to the serverFilter property. The serverFilter property is extremely powerful, and it's incredibly nice to be able to filter things in TWO different ways.

Hope that helps

-Aaron MCITP DBA


The original issue has now been resolved but I had also found these 1, 2 links which guide one through a search feature on DAP's.

0

精彩评论

暂无评论...
验证码 换一张
取 消