Search results for query: *

Hello, I am having an issue with adding file names to the body of an email, when I add the file names which are passed to the body via a variable the email will not send (no error appears), however if I pass some text to the body the email sends. Does anyone has any thoughts? 'on error resume...

Hey Everyone, This one has me quite confused. I have 2 snippets of code which I would expect to return the same results but they are not. Snippet 1 returns the full range of transaction dates but snippet 2 returns nothing, not a single result. --Snippet 1 SELECT TransactionDate...

Hey, I am pulling a date from the database which has a data type of varchar(50) and with the use of flat connection file manager I am exporting the data into a .csv. the data in the varchar(50) is a date presented as dd/mm/yyyy but the date is converting to yyyy-mm-dd 00:00:000 when exported. I...

Hi, the follwing code is trying to insert into table1 the deleted data and some static data following an update of table2. I am trying to get the field AccountID from table1 to update into table2 but i keep receiving the following... The multi-part identifier "table1.AccountID" could not be...

I have 4 tables: 1. Account 2. Customer 3. Sundry 4. Transactions Account to Customer = Inner join Account to Sundry = Inner Join Account to Transactions = Left Outer I am trying to return data from the Account table whether the {Transactions.tran-code} = 'SC3000' or not. I think I have found...

Hi all, I have 2 SSRS reports what I want to display one after the other in a reportviewer. To explain in more detail, I want reportviewer1 to load a report while in the background reportviewer2 is loading the second report (while hidden) and then after 30 seconds show the updated report and...

Hey everyone, I have a report which can be viewed via report manager, which is great but the header/toolbar is showing and I want to hide it, i.e. I only want to see the returned data and not show the user export options or anything above. I keep reading that "&rc:Toolbar = Flase" at the end...

Hi guys/Girls, I am trying to load a list of pages into and Iframe one after the other, without any user interaction. What I want to happen is: page1 loads into the Iframe then after X seconds page2 will load into the Iframe, then page3 and finally back to page1. So far I have been working...

Having read several posts on several forums I am becoming increasingly worried that there is no resolve for my problem. I am trying to sum a sum in Crystal 9. *Firstly I tried to sum a running total which failed. *Secondly I tried to sum a sum which also failed. *Thirdly I tried to put a...

Hi all, I created a function that was to re-set the values in a text box i.e. textbox1 = 1 and when the function is run the textbox is to return to 0 Call the function: Reset_Values ("txtScore") 'txtscore is the name of the textbox The function: Private Function Reset_Values(Field1 As String)...

Hi All, I have a form with a combo box which contains a list of users, also the form contains 2 buttons "Exit" & "Begin". When I click arrow key "up" focus moves to Exit and the code is executed (this also happens when I press shift tab). The same happens when I press arrow key "down" only...

I have a table of addresses which are presented like: address1, address2, address3, address4 address1, NULL, address3, address4 address1, address2, NULL, address4 address1, NULL, NULL, address4 etc, etc! I want the data to be extracted like so: address1, NULL, address3, address4 BECOMES...

Hi ppl, This is a little backwards as I know how to do this but I could really do with an easier way. I have the situation where I have addresses (postal) that I need to extract from SQL. Unfortunately the address do differ from field to field e.g. address1, blank, address3, address4...

I have the situation where i require totals before the matrix data and after. Example: Header Total Total Data Data Total Total Data 1 100 10 25 35 65 Data 2 120 10 10 20 100 Sub total 3 220 20 35 55 165 I have been able to add multiple totals on the left,however I am unable to add multiple...

I create a report in SSRS 2005 and export the data into Excel. The issue I am having is: Excel automaticlly creates page breaks. So when printing the report gets chopped into several A4 pages! Can you edit the SSRS report to handle the page breaks in Excel? /Nice

Basically I am trying to convert a date (which is stored as a VARCHAR(8)) in the format DDMMCCYY into DD/MM/CCYY. What I have tried: 1. CONVERT(VARCHAR,Create_Date,103) - returns: DDMMCCYY 2. CONVERT(VARCHAR,CAST(Create_Date as datetime),103) - returns: The conversion of a char data type to a...

Hi All, The following code is doing my "Nut!" what is wrong with it? When I run the module I get an error advising that the SQL statement is incorrect. SqlInst = "INSERT INTO Result (Date) VALUES '01/01/1900'" Debug.Print SqlInst DB.Execute SqlInst /Nice

The issue I am having is that when I export a 16 digit number in to Excel, Excel is displaying the number as 8.92752E+14. Now I understand why this is happening however I do not know how to correct it. I have tried prefixing a "'" to the number so that the digits will be recognised as text but...

I am trying to place a several SELECT CASE statements into a variable and I am not having much luck. Example follows: SELECT CASE WHEN LEN(Field1) <21 THEN field1 + SPACE(20 - LEN(field1 )) END, CASE WHEN Field2 = 'X' THEN 'Y' FROM Table1 Note: this query returns several records. How do I...

Hi everyone, an issue with union: if i put two select statements together I do get both the answers I require, however when I execute the code I get a single row for each select statement (I suppose this sould be expected). As there is a good chance I have not explained myself very well...