Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: NiceArms
  • Content: Threads
  • Order by date
  1. NiceArms

    Email Not Sending When Adding File Names to Body of Email

    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...
  2. NiceArms

    2 Date Range Queries 2 Differing Results

    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...
  3. NiceArms

    Strange Date Conversion

    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...
  4. NiceArms

    OUTPUT/UPDATE - log data from the updated table

    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...
  5. NiceArms

    Left Outer Join

    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...
  6. NiceArms

    ReportViewer and Timer

    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...
  7. NiceArms

    Toolbar Will not Hide

    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...
  8. NiceArms

    IFrame - Page Load in Sequence

    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...
  9. NiceArms

    Sum of a Sum

    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...
  10. NiceArms

    Function to set values

    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)...
  11. NiceArms

    Arrow Keys Moving Focus and Executing the Code

    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...
  12. NiceArms

    Address Formatting

    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...
  13. NiceArms

    Address Formatting

    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...
  14. NiceArms

    Matrix Totals Left and Right of Data

    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...
  15. NiceArms

    Page breaks in Excel

    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
  16. NiceArms

    DDMMCCYY to DD/MM/CCYYY

    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...
  17. NiceArms

    Insert issue

    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
  18. NiceArms

    SSIS Exporting a 16 Digit Number into Excel

    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...
  19. NiceArms

    Multiple Selects into a Variable

    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...
  20. NiceArms

    Alternative to UNION

    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...

Part and Inventory Search

Back
Top