Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   record selector problem in data access pages Hi, I created a data access page in Microsoft Access 2003 (part of office 2003 pro). My problems is that I am not able to use the record selector by typing record ###, instead been having to use the 'next' to go threw 1000 records. How do I enable it so I can just enter in the record number I want to go to and not have to click a few hundred times on the next button on the navigat... 1 16.03.2006 12:42:27 query to show only one field with no duplication Hi, I have created a query to show 6 fields, key word 1 key word 2 and so on up to key word6. Now I want to show on the same query, all the fiedes selected on field (like Keyword1 + keyword 2 and so on till kewyword 6) but also I want to make sure it does not show any duplicates. ... 1 14.03.2006 17:13:46 Access PAGE can't use in website ?? Hereunder is what I was discussing with the persons in "microsoft.public.access". I want to know excactly, Access Page and its .htm file really can't put into use in my website?? Is there any solution? Thanks! Martin. --------------------------------------------------------------------------- Oh, my God! It's really a bad news. The Access Page and .htm can't run in internet s... 3 15.03.2006 14:51:23 DAP so simple as that ? Hi group, I'm totally new on this newsgroup. The question is very general. I normally distribute my application by Access Runtime, where there is no Office licence. A new user asked to me to provide the next databases applications without any Office licence nor any runtime version. He just wants to access the forms and the reports with IE 5 or grater. I tried and succeeded to save my f... 7 13.03.2006 21:00:27 Does DAP w/ MSA backend work from internet or just intranet? I used MSA 2003 to convert a table to HTML. I saved it on the 2003/IIS webserver and read Article:291783. The *.html and the *.mdb are in the same directory. I thought I could use "Data Source=mydata.mdb", but I had to use "Data Source=\\Server\c$\inetpub\wwwroot\webfolder\datafolder\mypage.html" This works great for all the machines that can see \\server\c$, but all my friends on the... 8 13.03.2006 10:10:06 Saving dap data in more then one table I am trying to save data captured with a dap page in more then one table. Actually the tables have a many to many relationship through a junction table. However, it seems that I cannot save data in more than one table from a dap. Is that true for all situations? I have been recommended (by Sylvain Lafontaine- who provides answers on this site quite often) to use ASP instead of dap. ... 4 12.03.2006 21:59:58 DAP Help Needed All, I'm quite familiar with Access (and DAP) out of the box; however, I am not very experienced with customization. Here's the scenario: I am linking access with Oracle tables, writing the queries in Access, and using the parameter queries to feed a DAP. The end-user would like the option to select records, via checkbox, and then select a "print" command button that will allow for the r... 2 12.03.2006 03:06:44 Data provider could not be initialised This one is driving me mad! Got an Access database with a data entry page - both held in same place on network. *Some* users are getting the message "data provider could not be initialised" when they open the data entry page, followed by "Could not use "; file already in use" What does this mean??? Why is the database read only for them? And surely more than one person can put data in at... 3 12.03.2006 03:05:43 I need help every time I send and receive this error message comes up. It says incorrect password or account nameCheck the username/password or security settings. And it doesn't let me get my mail. can somebody help? my address is eli.barr@providenceday.org ... 17 11.03.2006 15:51:33 BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 09.03.2006 20:43:06 Data Access Pages are DEAD in Access 2007 (Office 12) Hi, Data Access Pages are quiet dead in Office 12 / Access 2007. The Access lead programmer said, they will be runable but not editable in the new Access 2007 version. Better use ASP.NET 2.0 / Visual Express instead. Here's the link: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=86&Number=1057772 Steven... 3 09.03.2006 14:24:53 ÎÒÊÇ ÎÒÊÇ ... 1 09.03.2006 03:18:18 Hi Hi,my name is yangxiao hua , ... 1 09.03.2006 03:03:14 pl advsie urgent before I lose my job have this data access database which I modifed. In the Search form code I need it to modify code so, it look and match more then one field. If the record is not in one field then it should go and look for the second one or third. pl see the code. pl some one hlep me. Thanks. Mike Option Compare Database Option Explicit Private Sub Clear_Click() DoCmd.Close DoCmd.OpenForm... 2 08.03.2006 16:52:30 Gamma Plus news://msnews.msn.com/microsoft.public.msn.inetexplorer.ie6_outlookexpress ... 1 08.03.2006 14:06:35 Data addition error ! I have Access DAP. I get the following error. "The data was aded or updated in the database, but the data won't be displayed because it does not satisfy the criteria in the underlying record source." My record is successfully added though I get this error. What is the cause for this warning message and how can I remove that. thanks in advance begin 666 error.JPG M_]C_X `... 4 07.03.2006 21:38:15 MSODSC.RecordsetDefs("QRY_Name").parametervalues.add.... Is it wor I think I'm going both, crazy and paraniod :(, I'm trying to pass parameter from the DAP page to qry. And I've found some news in the group, and also link in Access 2002 help to KnowledgeBase about this: MSODSC.RecordsetDefs("QUERYNAME").parametervalues.add "[FILEDorPARAMname]", VALUE. But all my hard effords, to get it works are going to nowhere! I created the simple DB with one ta... 10 03.03.2006 15:35:49 Trouble connecting to SQL Server I am trying to create a data access page for a project I'm working on. I'm on a winxp machine with Access 2004 and MS SQL Server Desktop Engine 8 (SP3). When I create the page, it works fine. I can save it to my web server - it works fine and I can access the data from any web browser (usually). As long as I don't leave "design mode" I can continue to modify and save the data access page... 1 02.03.2006 16:22:09 How to set server filters like query with SELECT DISTINCT I got table with mobile phones called 'tMOBILE' with the fields: IMEI - imei number - primary key (text - unique index) Name - name of mobile (text) Colour - the colour of the phone (text) Only IMEI field is unique, name and colour could repeat, because this table reflects the state of stock. How to open a new page with recordset set like result of following query? SELECT DISTINCT tM... 1 02.03.2006 00:24:27 EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P> <P><A href="http://www.vosar.net">www.vosar.net</A></P> <P>Tel: 775-333-11... 1 01.03.2006 07:13:19 repost Data Binding I spent so much time figuring out DAP mechanism to change the binding programatically....I would have written asp.net applicaiton in this time but u know my client doesnt want like that.... I have bounded a recordset in my BeforeInitialBind event ...the record pops up nicely , get data in all controls....now I am programatically adding another record (say blank record) using MSODSC.Defa... 3 28.02.2006 23:40:39 DAP with upgraded db Hi, I've got a data access page that I created using ms access 2000. I've sent it, along with the database to someone who has access 2003. He updated the database connection to fit his environment. The data access page doesn't work though. The title appears but not the form (with text boxes and drop down boxes). Can anyone help with this issue. Thanks. ... 1 28.02.2006 21:04:45 DAP - Copy/Create/Update Hi I am using acess DAP. I have one button whose class is MsoNavSave. I have written my page so that I use the same button for update and create. I now want to use the same button to cpy the current record as it is and then user will change whatever he needs to and save as a create operation.... How can I do this...When I progrmatically rename create/update to Copy the event BeforeUp... 3 27.02.2006 20:00:52 Real Estate - Free post Your ads about property for sale. Real Estate - Free post Your ads about property for sale. You can join for free and post your ads about property for sale or for rent. www.World-Estate.com ... 1 26.02.2006 16:59:52 Weird!!!!! You people are weird I mean all this computer talk I don't think that you are human!!!! From,Somebody ... 1 25.02.2006 19:46:33 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13