Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   parent and child table on DAP I would like to know that is it possible to have parent chile table on the DAP. For example, I have customer and order table. I need to show cusotmer and detail order for customer number 1. I tried to connect my table, but one parent or child table can on the form. Any suggestions are great appreciated,... 3 30.03.2008 03:32:52 nur nu ma pot conecta ... 1 31.05.2007 15:26:57 this is test hi all I have an edit box control on page , which transllated to span object in html. How i can hide ... 1 12.04.2007 06:55:25 DAP Button to execute sql script I need to put a button or link on a DAP that will execute a sql script on the database on SQL Server. Is that possible and how should I proceed. Thanks, Bill ... 1 29.09.2006 19:42:57 Passing value from querystring to DAP field Hi all, I have a DAP with a button that redirects the user to another DAP passing an Id within the URL. What i need to do is to get that Id and associate it with an field that exists on the second DAP. I tried to use Request.Querystring("Id") but it returns an error: "Object required: Request". Is there other way for me to do that? Thanks in advance... 2 29.09.2006 18:17:50 Report export to DAP: mistake 2 Hello again! :) I have a report with columns which get data from another tables than main one for the report. These tables are linked with main table not directly but through third tables. Relations between tables are determined properly. So I have no problem with representation of data in these columns. But when exporting the report to DAP, data in these columns is not shown. I see '#NAME... 1 29.09.2006 11:18:00 Report export to DAP: mistake 1 Hello! I have a report using VBA script with a function as a data source for one of columns. After exporting the report to DAP, during opening it I get a mistake (free translation to English): Column (<function name>) was used in CALC but wasn't determined in string set. What is this? And how can I avoid this mistake? WBR Alex. ... 1 29.09.2006 11:06:32 Converting existing Form and Report into DAP Hi: Is there a way in latest Access 2003 to do conversion from Form/Reports to DAP(of course with some manual untervention in HTML file) or may be some third party wizards or use only Visual Studio? I have to move existing Access 2000 Applications into Web and would appreciate your help to cut vaisting time. Thanks in advance. -- Ilya... 1 29.09.2006 02:56:01 Button for calculations I have a data access page that I am wanting to add to my website. On this page I want to put a button that when pushed will do some small calculations (addition and subtraction) and then post these calculations into a series of text boxes. I setup a test html document so that I can try to figure out how to do this (because I know nothing about html or java) and I can't get it to put a... 1 28.09.2006 16:47:07 Multiple table rows in DAP Hi all, I have a DAP with a few fields (like Id, Name, Phone) from a table Person that has more fields. At the end of each row i have a button. When the user clicks the button its supposed to open another DAP with all the fields from table Person with Id = first DAP Id. In the first DAP i have set DataPageSize to All but everytime i click on the button the passed Id is always the same, ... 5 28.09.2006 08:53:01 DAP in Tomcat? I've created some Data Access Pages and now I'd like to publish them in my tomcat server to link them to my web app. I've read and tried the solution in the article 291783 of the knowledge base, but it is written fot the IIS (I guess) and it didn't work for me. Is there any way to publish this kind of pages in a tomcat server? Anyone knows if it is possible. Thanks in advance!... 1 27.09.2006 10:37:01 Autonum field does not work in DAP I created a DAP form linked to SQL view. My primary key is an autonum field. I moved from access to SQL and the autonum field does not work anymore. Any suggestions on how to create the autonum field in the default value of the field in the DAP? thanks! Mark ... 1 26.09.2006 13:11:46 increase in number of records per page I have created a DAP Report page linked to a SQL view. It only displays 10 records per page. I have the max number of records set at 10000. Should I be looking elsewhere to set the number of records displayed per page in my report. thanks! Mark ... 1 26.09.2006 13:08:52 ¹ØÓÚÍøÁµ ¸÷λ,¶ÔÍøÁµÓÐʲô¿´·¨°¡? ... 8 26.09.2006 02:26:43 DAP on the web Hi. I have a Access 2003 database that I maintain and I'd like to create DAPs for others to access via the web. Everytime I create the page and try to access it through another computer I get a message stating that it can not open a "temp" folder/file. When I try to create a connection to the database which I have on a server it defaults back to a temp directory on the PC I used to cr... 1 21.09.2006 20:35:02 Problem with html pages Hi, I just upgraded to Access 2003 & want to use a feature that creates html pages so multiple users can enter data into the database without having a 2nd copy of access 2003. I created the page but when I open the html document I get the following 2 error messages. "This website is using your identity to access a data source. If you trust this website, click OK to continue, otherwise ... 6 21.09.2006 16:02:22 DAP Server side filter I have a database with employees. How can I display just one specific eploee record on DAP? ... 2 19.09.2006 22:29:09 ATTENTION EVERYONE! I FARTED ... 1 19.09.2006 00:38:13 transferdatabase I link table from an other access database by : docmd.transferdatabase aclink, ... in access 2003 it is very long, when i use on the same computer 2000 it is very fast why ? The both base are in access 2003 the Subdatasheet Name property are set to none The disk format is NTFS short name are used for both database thanks for help ... 1 18.09.2006 07:32:36 Restrict data depending on user? Something has come up here, where it might be needed to have one of my DAP's only display info depending on the user. What we have is a DAP that lets you look up time off for each employee. Right now, any user can look up any other users time off. Some are not liking this, and would like only themselves be able to search for their own time off ect. Is there a way to accomplish this? ... 3 18.09.2006 06:46:20 Data access page problem i have created a data access page and have made the file go live onto everyone in the companies favourites. it seems to work fine on most of the machines but i have found that on some it pops up saying 'data provider cannot be initialised' and then something about Microsoft Jet Database Engine cannot open the file- it is already opened exclusively by another user, or you need permission... 2 15.09.2006 08:30:18 transferdatabase slow in 2003 I have 47 tables linked in access 2003, i use docmd.transfertdatabse aclink, .... but it's very slow when i use access 200 on the same computer it's more faster ? if you how to speed this , thanks to replie ... 1 13.09.2006 11:42:32 Not able to create a DAP from unbound form. Hello All, I am new to Access although a fairly experienced VBA developer. I have recently had Access Loaded onto my set. I am in the process of developing a small application that has three main forms. 1) Sign in Form 2) A form that asks user for input and process a few tables 3) The main form, this form leads to various processing of tables. The text boxes in all the forms are ... 8 13.09.2006 01:42:09 Restricted Retrieval Is there a way that I can prevent a data access page from retrieving data until I have made a selection? I want to simply retrieve the row that Im interested in and nothing else. The query that Im basing my DAP brings back lots of data which, ultimately will be slow, so Id rather do it right the first time. Thanks in advance Rod ... 4 10.09.2006 18:58:01 Non Active X Calendars? Hi, I have a couple pages, that have a Active X Calendar, that allows my users to select a date. It then open the DAPs filtered to the selected Date. But what is happening is, on some users machines. Even tho we modify their trusted sites, and set it to enable Active X components, it reverts back to disabled after they reboot. So when the page with the calendar opens, instead of disp... 5 08.09.2006 20:26:28 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13