Search results for query: *

Hi, I would like to auto-edit the content of cells in Excel: 'Tanja Jansen <tanja.jansen@domain.com>' into: 'tanja.jansen@domain.com' Does anybody have a solution for this? Thanks in advance! Cheers, Tanja

Hi Everybody, I would like to know how I can have a cell discplay the row number that belongs to a specific cell in my ecxel sheet. Using Office 2000 Thanks in advance! Tanja

Using: Excel 2002 I have a huge excel worksheet on which I want to apply a filter. The only problem is is that I want the filter to select records where one of the fields equals multiple values. Excel standard only provides the option to select 2 criteria. Record 1 red Record 2 red Record...

Hello all! I'm designing an automated registration form in Excel. For the enlisted people, i want to print out badges with a little picture in the corner. The picture should be inserted in a cell on the registration sheet. That cell then contains the source image for a corner cell on the badge...

Glenn! You're brilliant! Thanx a million! *hugs glenn*

Hi there! Thanks for your replies! It is not entirely, though, what I was looking for. I want (contents of) cells to be transferred to a second cell, being the bottom of a column, the column being defined by a third cell. *:-)* Hmmm, come to think of it, maybe my description of the problem (in...

Hi there! I use Excel 2003 (SP2) (dutch language) and would like to find a solution for the following situation: In a financial administration I want to manually insert as less as possible, for obvious reasons ;-). I only want to insert the information from my bank receipts, like "date"...

Hi! I know how to link from a word document to another word documents bookmark. But how can I do the same from excel to word (bookmark) I get the following error: 'Microsoft Excel could not open this file or could not parse a file of this type'. Thanx in advance! Tanja

Hi! I have used the text-lookup funtion to add some data to the report from an ini-file. I use the following code: if {@R&D} <> "" then if TextLookupLine ("Planned_Stock.ini",{@R&D}) <> "" then Split((TextLookupLine ("Planned_Stock.ini",{@R&D})),"=")[2] The ini-file looks like this...

Hi! Using : ms office 2000 I have a cell with a time format. I want to increase te time with a few minutes from another cell and place the result in a new cell. How do I do this and what formats do I need. Thanx in advance! Tanja

Hi all, Using: CR 9, VB6, Btrieve data, pervasive 2000i I have an VB application with a crystal reports designer. When I make changes in the designer and afterwoods compile or save the program it returns the error: permission denied. I connect to the database with the btrcall api call. The...

Hi all, Using: CR 9, VB6, Btrieve data, pervasive 2000i I have an VB application with a crystal reports designer. When I make changes in the designer and afterwoods compile or save the program it returns the error: permission denied. I connect to the database with the btrcall api call. The...

Thanx for the tips guys! The problem has already been fixed but I couldnt figure out the cause of it. I have used a recovery point on my system before the error. It was only with install and setup files and not with all .exe files. Tanja

nothing at all. It just shows the hourglass for a nanosecond long. Tanja

Hi! Somehow I can't start my install.exe and setup.exe files anymore. Is this a known problem? How can I solve this? Help will be very much appreciated! Tanja

I got it working! I am using CR 9.0 and if I copy the Display field into a new formula field e.g {@TEMP}, then I can use the display value through this {@temp} field in a chart. The only funny thing I noticed is that the first of all charts is empty. It shows the values on the X-axis but it...

Hi! Visual Basic 6.0 Database: Btrieve Using: CR 9 Problem 1: when I open my Report (as Crystal Designer) in VB to edit it and I want to save after this, VB returns the error: " Permission denied" And after trying to save a cecond time it terminates. The report is already included in the...

I don't think this can be done in a more text-efficient way because there is no patern in your case statements. If there is you can create loops with increasing numbers so you can do a 'for i=1 to x do: ' And then increase your variables. In this case the variables dont show a patern so you...

Hi! Using: CR 9 Database: Btrieve Visual Basic 6.0 Problem 1: when I open my Report (as Crystal Designer) in VB to edit it and I want to save after this, VB returns the error: " Permission denied" And after trying to save a cecond time it terminates. The report is already included in the...

Hi! Using: MS Excell 2000 I have a Crystal Report that exports data to an excell sheet. The data looks like this: Prod.Code Amount 12345AB 12 34234AB 09 54521BC 90 82383IK 34 84545IK 34 ... I want to create a chart per Prod.Code that ends with AB / BC / IK etc. I linked the...