Search results for query: *

Hi, my problem was nearly solves with this Thread:thread703-538743 Now I know that I can set the maximumsclae of the Y-Aches of an Diagram by using: Me.Ranking_VOFI.axes(2).maximumscale = 10 So what i now need to know is. How to reference a second Y-Axes. The Diagram in my report owns...

Hi, i'm trying to open an access workbook and want to jump to an special sheet inside that workbook. rs is a DAO.recordset and delivers the relative path of the xls file. lst_Auswahl is a list box where an id is selecte. This ID is similar to the name of the sheet which shall be opened. I try...

Hi, concerning Lotus Notes 5. What is working so far: We can create emails out of MS Access and send them using Lotus Notes, attach attachments and so on. What is not working : We would like to change the email address of the sender. So we want to create an extra email postbox for maybe 5...

Hi, are there any known issues concerning IE6 and popupwindows? The thing is that my onclick event will be processed in a non popup window but won't be processed in a popup window.. The code example: 1) the click event <form action=""> <input name="Update" type="button" id="Update"...

Hi, I asume that this will be a mistake quite easy to solve for some of you. My piece of code looks like this: strconn ="Driver={Microsoft Access Driver (*.mdb)};Dbq=\\Otdesbwelhttp\clc-mod\cop\cop-test\user.mdb;Uid=Admin;Pwd=;" set conn = server.createobject("adodb.connection") conn.open...

Hi, i have to do a manual cross table. I understood the logic behind it. My question now is belonging to the design. I do have several groups. The details are switched off and the only thing you see are the summary fields of the group. Thats how I get my numbers. The thing is that sometimes 2...

Hi, after starting my computer again - Crystal Reports 8.5 is missing the &quot;implode.dll&quot; and can't open the view which is needed for the report. Do I have to install CR again? Martin

Hi, so far I did a manual cross table based on groups and it looks like this Januar Februar March ...... row1 val1.1. val1.2 val1.3 row2 val2.1 val2.2 val2.3 row3 and so on............... The values are of course group sum fields als all detail fields are invisible...

hi, I'm doing a report based on an Access97 DB. I'm using the access file as datasource. After creating a rough preview of the report I had to import some new data into the database. the report cointained 15 groups. After the new data was put in there are 16 groups. Unfortunately the new group...

hi I want to export some values into an Access 97 mdb via ODBC. I installed the ODBC driver (Windows NT) and it seems to work fine. But the table created does not contain any values - it's totally empty. Does anyone have experiences with the data transfer from CR 8.5 to Access 97? ODBC would...

Hi, I do have 3 groups. first one ist the geographical region secons one is the year third one is the 5 different values which are from interest my question is how can I find the smallest/highest value for each of those 5 data for all groups? so that I can finally say. Allright data1 is...

Hi, my primary data source is a crystal dictionary consisting of 2 tables. all data (except one) is included in this dictionary. So now I also have to include the last missing data which is coming from an Access .mdb file. Could you please give me a short description of how many different ways...

Hi, I finally managed to do a manual cross table allowing me to do conditional formating of the cells of this cross table. My problem now is that I am advised to do more than one cross table in this report. Just to get an idea: There are maybe 15 different values which I do report in...

Alright, my main report consists of a cross table. The structure of the cross table looks looks this... area 1 area 2 area 3 region1|region2 region3|region4 and so on |---------------------------------------------------- id nr...

Hi, I do have several problems but I think it's not possible to solve these in an automatic cross-tab. 1) I would like to show some values in a cross tab with two digits after the colon (i mean &quot;123,99&quot; for example) and some without digits after the colon. All changes of format are...

Hi, what I did until now was a cross-tab. The data for this tab are coming from a BaaN Databas system. My Problem now is that I shall include another data. This single data is only available in an excel sheet. Now, I don't have a clue how to manage the import of this data. I hope you can...

Hi, what I did until now was a cross-tab. the data for this tab are coming from a BAAN database. My Problem now is that I shall include another data. This single data is only available in an excel sheet. Now, I don't have a clue how to manage the import of this data. I hope you can give me...

Hi, I do have a cross tab. There are 3 different values in each row of this tab. There are the Plan value, the actual value and the actual value of the year before in this field. If I do a formular like this on the actual value: if currentFieldValue > {value of the year before} then crGreen...

Hi, I do have a cross tab. There are 3 different values in each row of this tab. There are the Plan value, the actual value and the actual value of the year before in this field. If I do a formular like this on the actual value: if currentFieldValue > {value of the year before} then crGreen...

Hi, I try to format the detail fields of a cross tab via formula. I try to say that - if the value of each field is below avalue it should turn red - if it is above a certain value the field shall turn green. To test is I used the following furmula: if {ZMR.val1 - Ist-Wert pro Monat} > 15 then...