Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Pages from existing HTML forms? Greetings, I'm new to data access pages but not to Access. (I'm working in Acc2000.) I'd like to create some data access pages that look exactly like the HTML forms I'm using to solicit data (for importing via e-mailed attachments). This way the user can print out a document that looks just like the completed form on the web. Is there some non-tedious method of assigning fields to... 2 12.01.2006 19:26:05 Merge rows The following query does take too long time. Is there anything wrong og is maybe my query to big? SELECT QKontoplan.Konto, Concatenate("SELECT [QKontoplan]. FROM [QKontoplan] WHERE [QKontoplan].[Konto] ='" & QKontoplan.Konto & "'") AS AllCustReps FROM QKontoplan GROUP BY QKontoplan.Konto, Concatenate("SELECT [QKontoplan]. FROM [QKontoplan] WHERE [QKontoplan].[Konto] =... 2 09.01.2006 22:16:06 Prueba Envio esta prueba de mensaje. ... 1 09.01.2006 04:13:46 Data Entry drop down fields? When I create my data acess page, some of the fields from the table had drop down menu choices. In the acess page, they are no longer drop down fields. If I put in a Dropdown list as an object, the data does not go into my field. Is there a way to have the original field (created with wizard or autopage) to retain its dropdown choices? (helps to eliminate user entry error). Thanks... 6 04.01.2006 20:36:06 Users without Access I have database that I would like users to do entry onto from a central web page. All have Microsoft Office, but not all have Access. Will everyone be able to enter data on my Data Access Page form, or only those who have Access on their home computers. Help files have not been sufficient for this question. Thanks... 3 04.01.2006 14:04:03 Sequential number on report not working after changing to DAP I have a report with a sequential number by using the running sum on a control source of =1. After saving this report a DAP, the sequential number does not work anymore. How do I put sequential number on DAP at a group level? GMem ... 1 04.01.2006 05:33:36 Access 2000 Help!? I use Access 2000. I also use a (Quickbooks add on program). Using ODBC, I can get access to talk to fishbowl and download tables to my database. No problem. EXCEPT... certain tables won't download, I get an error message that states "The decimal field's precision is too small to accept the numeric you attempted to add". I then went to the MS website and found that this is ... 2 04.01.2006 04:25:54 Need Help on Droplist boxes in Access Pages Hi, Is it possible to have Cascaded Drop list boxes whose Data row source changes with respect to the Selection made in Droplist box A. E.g Droplist A has Row source having all the column names in Table. Depending on the Column name selected in Droplist A, The Rowsource for Droplist B should change and display the equivalent Column data from the Table. Please let me know how can I achi... 2 30.12.2005 21:59:57 Format Problem How do you format a phone field in a data access page to display a phone number like (123) 456-7890 instead of 1234567890? My underlying table and all my queries, forms and reports show the phone numbers correctly. But, it doesn't display correctly in the data access page. I've tried to change the (element) properties of the phone field to (000) 000-0000 and even tried making the prope... 5 30.12.2005 19:09:01 How to display all records on the same page? I would like to display records on a HTML page generated from query in Access database, with heading on top and query results in the form of a table. For example - Order No.: xxx Description: xxx Item No. Item Description Qty Rate Value ---------------------------------------------------------- Item1 Desc1 200 10 2000 Item2 desc2... 2 30.12.2005 01:00:25 Format a Phone Field How do you format a phone field to display a phone number like (123) 456-7890 instead of 1234567890? My underlying table and all my queries, forms and reports show the phone numbers correctly. But, it doesn't display correctly in the data access page. Thanks! -- John... 1 29.12.2005 13:09:02 Date Sorting in Queries I have Access 2003. I am trying to sort a column that has dates (01.01.06 as an example) by the year in query design. Can this be done? I appreciate any help. Thank you, grace... 2 26.12.2005 21:39:02 Earn money Online - without risk! Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to determine, when, how much and like often you salary? Then you should take yourself a couple minutes time. You happily will be that you ... 1 25.12.2005 01:35:40 THE > SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE < This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program. Prohibited utilization leads to the notice! THE > SUPER-MONEY-SOURCE < In this program, there is really money. 1200.- Euro / dollar and MORE are in only 3 weeks possible with only 5 participants!! Example, you get Euro o... 1 22.12.2005 17:13:38 THE > SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE < This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program. Prohibited utilization leads to the notice! THE > SUPER-MONEY-SOURCE < In this program, there is really money. 1200.- Euro / dollar and MORE are in only 3 weeks possible with only 5 participants!! Example, you get Euro o... 1 22.12.2005 17:13:36 Refrencing a text box in a table Hi, I would appreciate any information on how to reference a specific test box in DAP displayed in a table format. Thanks ... 3 22.12.2005 16:05:13 Grouped data on a DAP I have a database for invoicing customers that is being used internally with a form/subform format where the invoice is the main form and the subform has the invoice detail information. I would like to convert this to a DAP so that we can generate invoices/sub invoice detail sets across the web. I have successfully created a DAP for the details of the "subform", but I can't figure out ho... 5 21.12.2005 23:51:46 fddfsd dsfsd ... 1 20.12.2005 11:46:48 Using the Activex Calender to enter a date in a field I am trying to pull the activex control Calender , then select a date and enter it into an adjacent field. How can I create a button with a small calender image to open the Activex control Calender? I think I know hot to send the selected date into the adjacent field by selecting the appropriate ControlSource in the Activex Control properties. Thanks -- GillesABelanger... 2 19.12.2005 17:20:28 Access crashes when creating DAP I have an MDB FE and a SQL Server BE. I need to create a small web FE to part of the database, so I thought maybe DAP would be a quick way to go. But every time I try to create a DAP, I get the ubiquitous "Access has encountered a problem and needs to close". What could be causing this? I saw one exchange in this forum about a limitation of 360 queries. Is this still tru and are the... 4 19.12.2005 11:01:10 Links to VBscript tutorial Good morning, What happened to this link- it is nowhere to be found anymore? Thanks -- GillesABelanger... 4 19.12.2005 00:33:07 Passing parameter to DAP Is there an easy way to pass a parameter to a page with a hyperlink? Using the Northwind database, if I wanted to select an employee by there employee number with a hyperlink how could I do this? What I am trying to do is link a Visio Office Floor Plan that shows were employees are seated to a DAP that pulls the specific employee info. I would like to put a static hyperlink on an obje... 2 18.12.2005 18:34:05 ÎÊÊÕ·Ñ ÓеÄÊÕ·ÑÁÄÌìÍøÕ¾×¢²áʱҪÇóÊäÈëÊÖ»ú»òСÁéͨºÅ.ÁÄÌìʱ³ýÁËÉÏÍø·Ñ»¹ÊÕÊÖ»ú»òСÁé ͨͨ»°·ÑÂð?Ò»°ãÈçºÎÊÕÁÄÌì·Ñ? ... 1 16.12.2005 01:17:18 DAP with non-Microsoft Server If my server does not run IIS, will data access pages work? We are running an Intranet with Novell. As I look at the instructions for installing data access pages on the internet, I am beginning to wonder if this is why everything connected with data access pages that I am doing either works incredibly slowly, or crashes. Or maybe there's another problem. Thoughts, anyone? Thank... 5 15.12.2005 20:26:02 Password on database itself, but would like DAP's to not prompt each time Hi, On the database I'm working on, I would like to have a simple password on the DB since it's on one of our network drives. Just to stop anyone from changing the data, but when I add a database password, if you try and open any DAP it prompts for the password. I don't want my end users to have to remember a password. Is there a way to have a db password (to stop data from being changed... 2 15.12.2005 18:29:06 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13