Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   hello ·¢¼þÈË: "orjan hagstrom" <orjan.hagstrom@spray.se> Ö÷Ìâ: Access Runtime and Novell/NT ÈÕÆÚ: 2005Äê10ÔÂ19ÈÕ 1:23 Hi, One of my users has installed my application (developed in Access2000) on the server (Novell network and Windows NT) and has installed Access RunTime 2000 on a client with Windows NT and receives a message "the expression you entered has a function name that... 2 14.12.2005 04:12:17 Pivot Charts as DAPs?? Hey Gang, Trying to use the Data Access Pages feature of Access (2003) to post Pivot Charts on our Intranet. The queries used to create the nice column-bar charts end up looking like form records when DAPs are created. Am I missing the obvious? By the way, my specialty is NOT Access, but I'm getting better! HA! TIA! -- Bill Foley www.pttinc.com Microsoft PowerPoint MVP Micros... 2 09.12.2005 17:44:52 Access > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3216980212_655137 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Hello, How can I run Access on my Mac, i will be glad to know it. Regards Nicolas --B_3216980212_655137 Content-type: text/html; ... 3 09.12.2005 16:29:01 data access page search I am using the below script to search a field by a string but it only works on a complete match. Is there any way to search based on a partial match? Any help is appreciated. Chris <SCRIPT language=vbscript event=onclick for=Command0> <!-- ' Clone the recordset. Dim rs Set rs = MSODSC.DataPages(0).Recordset.Clone On error resume next ' This line assumes that the value you... 2 08.12.2005 19:00:53 Finding a record in data access page I implemented a data access application in September "05 that already has over 2000 records. Using the navigation buttons to find a specific record number is becoming time consuming and my clients are complaining about the finding process. Can I create a find button in the navigation tool or is there any other way to enter the record number and get there with one click? I made a qu... 6 08.12.2005 16:54:03 ÎÒ°®ÎÒ¼Ò µ±Äã×ßÔÚÀëÏçµÄС·ÉÏ ÓÐÒ»ÖÖÇ黳½Ð×öÓÇÉË ÄÇÊÇÄãÀë±ðµÄ¸Ð̾ ÊÇÄãÄÚÐĽÇÂäµÄÒþ²Ø ... 1 08.12.2005 02:26:42 Connection cannot be used I get this error message when trying to open my connection string: Connection cannot be used, either closed or invalid, any ideas? thanks....... if cboTeacher.value = "Total" then Dim cnn, rst Dim sConnString Set cnn = CreateObject("ADODB.Connection") Set rst = CreateObject("ADODB.Recordset") sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=E:\eieio.mdb" rst.Open sCon... 9 05.12.2005 01:12:20 tiq t qtq t tqwit qt sru sit gq ti qti qwtp ... 1 03.12.2005 07:42:06 code for DAP not working The recordset does not open. Any ideas? At one time there was an error that server needed an object. Now there is no error. The code runs but the recordset isn't showing in my DAP form. I can't seem to find any clear examples of programmatically opening another recordset from the same db using vbscript. if cbo.value = "iteminList" then set conn=Server.CreateObject("ADODB.Connection") ... 4 25.11.2005 16:31:21 have a complex report I want to convert to a DAP. I have a feeling this might not be possible, but thought I would ask. Wish I could attach a screen shot of the report, would make this easier. but here goes. I have a report that is looks something like this Team Name Location Month: Code: #of hits savings savings 2 1/05 0001 4 0.00 5.00 2/05 ... 2 22.11.2005 21:09:20 Pivot table results wrong in data access pages Pivot tables when saved as Data Access Pages give wrong results. The pivot table when displayed normally gives the correct answers, just the DAP seems to be incorrect. I have tried to isolate the problem by simplifying things down to just one local table, but still get incorrect results in the pivot table DAP. I ran the "detect and repair" as well, but still have the same errors in th... 1 21.11.2005 15:44:03 slow client/server application While running my Access application in a client/server environment, my users regard the application as being very slow -sometimes it takes 30-40 seconds to move from one registration form to another. The two databases (one with code, forms etc and another with the users own recorded data with some 10.000 items) are stored on a server and MSAccessRuntime is run from 5 different clients. ... 4 20.11.2005 15:58:13 form with chart I have a data access page with a chart that I inserted from the toolbox in design view. The recordset(233 records) moves accordingly with navigational buttons. One of the three columns on the chart references a field value on the form. When the value of the field goes up so does the column, at least it should, but it is not. I cannot for the life of me figure out what I need to enable so... 1 18.11.2005 16:57:08 code logic problem I don't get any errors, so I'm thinking the logic is wrong. I'm trying to loop through the recordset when the cbo value is selected. Thanks for any pointers.... <SCRIPT language=vbscript event=onchange for=cboTotal> <!-- if cboTotal.value = "Total" then Dim cnn, rst Dim sConnString Set cnn = CreateObject("ADODB.Connection") Set rst = CreateObject("ADODB.Recordset") ... 5 16.11.2005 01:35:32 AfterUpdate Event in a DAP Combo Box I'm very new to DAP's. Is it possible to have a combo box in a DAP behave like it does in a form? For example, I have a form combo box with an AfterUpdate Event: Private Sub cbProfileID_AfterUpdate() Dim strNewProfile As String With Me.cbProfileID ' Capture the profile ID the user has selected or entered. strNewProfile = .Value & vbNullString If Len(st... 1 14.11.2005 19:18:04 vbscript error in DAP I keep getting the error: "expected end of statement" for my dim statement. If I change it I will get another error to declare or define it. <SCRIPT language=vbscript event=onchange for=cboTotal> <!-- if cboTotal.value = "Total" then Dim rst as ADODB.Recordset Set rst = New ADODB.Recordset With rst ..ActiveConnection = cnn ..CursorType = adOpenKeyset ..Open Source = "total... 3 13.11.2005 22:45:01 solution to moving controls on Data Access Pages Hello, and thanks for reading my question. I'm creating my first Access page for my database. I've imported a background image that I want to use. Now, I've been dragging fields from my Field list onto the page. It looks great, until I hit "Page View." Now, all of a suddent, my controls have moved about 40 pixels up the screen. They're no longer matching the place I need them to be ov... 3 07.11.2005 18:16:03 Passing Parameters from one DAP to another. (Has anyone ever got it to actually work?) Hi, I've seen this URL posted many times throughout the forum http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_PassParam.asp I'm just wondering, has anyone ever been able to get it to work? I've tried so many times, and no matter what I do it just gives me errors, or does nothing at all. So I thought I would ask, if anyone here has ever actually gott... 5 05.11.2005 00:45:29 Filter a sublist I have a 2 tier DAP that is organized as a tree: Projects and Drawings. After I filter down to a list of Projects, I expand one to view the Drawings inside. Within this new expanded area I have 3 radio buttons that I want to filter the Drawings within that single Project. Any idea on possible code for this last filter? I don't want the whole Project list to refresh if possible, I want to... 1 04.11.2005 22:17:02 dropdown popup filter? Hi, Working on a page that currently displays all the data for 5 different teams. Looks currently like this Month: December 05 Date: xx/xx/05 Team: xx Employee Name: Fred Team: XYZ Employee Name: Susie Date: xx/xx/05 This gets to be a fairly large page, and would like to have it broken down more based on user input.... 2 03.11.2005 06:57:42 Recordsource DAP I can't seem to get the right code in vbscript to change my recordsource using onchange event in a drop down list. Any ideas? example: if cboField.value = "selectedItem" then recordsource = end if Thanks,... 3 01.11.2005 10:58:03 Sort I was wondering if it is possible to sort my table with something other than the primary key (keeping in mind the table is already created without using the wizard), and then use my primary key as my secondary sort field?... 2 26.10.2005 21:25:15 Send Mail From DAP I would like to automate the sending of email from my DAP. The code that I am trying to use is: <SCRIPT language=vbscript> Sub SendMAPIMessage() Dim MapiSession Dim MapiMessage Dim MapiRecipient Dim MapiAttachment Dim Recpt Set MapiSession = CreateObject("Mapi.Session") MapiSession.Logon Set MapiMessage = MapiSession.Out... 2 25.10.2005 17:13:48 multiple columns ala reports Is it possible to create multiple columns of data with DAP? I've searched all over. Nowhere does it say you can or can't. Many of my old reports, that I am converting to DAP, are very skinny, so to save paper while printing, I used multiple columns. I'd like the same functionality in DAP if I can. ... 1 25.10.2005 04:45:13 Copying dap pivot table and pivot charts into Excel Good morning, While it is relatively easy to copy the content of a dap Pivot Table into Excel by using the standard CTRL+C & CTRL+V, it seems impossible to copy and paste a pivot Chart generated with a dap page. Is there a trick? Thanks,/Merci/Gracias Gilles -- Gilles A Belanger... 1 24.10.2005 15:45:13 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13