Search results for query: *

That is is for the following. ' Do not prompt when exporting Yes there should not be any problems writing to disk, it has been checked.

Hi, I have a web application that has been moved to a new server. The only difference is that is now running on a win 2003 server. I have ms sql 2000 and I am running crystal rep. dev. 8.5. I am generating a pdf file that I am saving on disk but I am also pulling it up to view from the web...

Thanks I will try to do that /Linkan

But they need to be able to come back later in the same session to submit again. /linkan

Hi, How can i prevent my form from beeing submited more then once? I have a DB app and i would like to be able to prevent more then one submit. Thanks, Linkan

Hi Terry, I will use that ABS function that is a great idea, thanks for your input. Much cleaner. /Linkan

Thanks guys, great work, it works just fine now. The second option is more simple and I had some problems with the group function when I had the temp table. Thanks again! /Linkan

I see what you are saying, don't know how I can do it then. I need to sort all my accounts and sum the ammount but when the account type is 2 I need to convert - to + and sum it as well. Thanks for all your help. /Linkan

That did not help much. This is the message i get. Server: Msg 512, Level 16, State 1, Line 2 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. /Linkan

Thanks for your input but it did not help. /Linkan

Hi, I am trying to set up a query that makes a value positive i is is a certain transaction. Trying to set it up in a sproc but I just don't seem to make it work. What am I doing wrong here? Thanks, Linkan DECLARE @lngType int SELECT @lngType = (SELECT lngType FROM vLinkanTestView) IF @lngType...

Thanks Rudy! Great job, it works perfect :) Regards, Linkan

Hi i am trying to make a nestled query to get the total sum of my accounts. My question is how to make a query to handle this? I have two tables. tbAccount lngAccountID strName 1 A1 2 A2 3 A3 4 A4 Now I want to SUM...

Thanks for you help, it got me going :) Good work! Jonas

Hi! The last section where I have data is the Report footer but under this I have a page footer. Thanks. Jonas

Thanks for your fast replay. It seem to work to get a new page but I am not sure how I can make a design that will look nice for the second page. Its only to be text and when I followed your advice I got the bottom part of the report on the second page. I am sure I am missing somthing? Thanks...

Hi, I have a report that prints out perfectly. I would like to have a new page with only information regarding the printed report. I want this to come as the last page. Can this be done? Thanks! Jonas

Hello, How can I print out a email message without the memostyle heading. From: Dent: To: Subject: I only want the message it self, anyone have any ideas? Thanks, Linkan

*** Very good, thanks for your promt answer. Works like a charm. //Linkan

Hello, I have two dropdowns, they are not dependent but they both pull data from a DB. The first one is -CARS- and the second is -COLOR-. I want to make sure that if no -CARS- is selected -COLOR- should jump back to -COLOR-. Value for both -CARS- and -COLOR- is &quot;-&quot;. This means I dont...