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 SkipVought 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: NEveritt
  • Order by date
  1. NEveritt

    VBA & Dates

    Skip it doesnt, if you enter into excel it works fine, its when I am importing into excel from sql. But as I said, in the vba code, in the point before if puts it into the spreadsheet, it is in the correct format, the second it enters it, its in the wrong format.
  2. NEveritt

    VBA & Dates

    Thanks for that PHV, if this was a new project I would consider that, however everything that is linked to the database would have to be re-written, and thats a lot of things. There has to be a system setting infuencing this, and I need to find that, if it works for me, worked on the my old PC...
  3. NEveritt

    VBA & Dates

    i have to make this clear to all that read this post to clear this up: the serial date of the cell is showing as the serial date for 6th May 2007 (i.e. change the format to general and it shows the serial date), when the data imported was clearly for 5th June 2007 It is not a formatting issue...
  4. NEveritt

    VBA & Dates

    Skip, I am afraid it has changed the value, the serial date of the value has now changed (for example the date we are working with is 05/06/2007 and it is displayed as 06/05/2007) so the serial date is for the 6th May 2007
  5. NEveritt

    VBA & Dates

    Got a strange one here. the person next to me is having problems with dates on his PC. It is manifesting itself in a few ways, I will list them here. The same problems do not appear for me when i run the same code. Just to confirm, his regional settings are set as English UK. 1) In excel...
  6. NEveritt

    Form Javascript needed

    thanks for that, I will have a look at it, but I will need to do this with JS as I do not want to refresh the page. so can anyone help? N
  7. NEveritt

    Form Javascript needed

    I would love to work out how to do this unaided, but I need to get this sorted quick, so would appreciate some help here: I have been told I need a function to do this, so if someone could help me out. I have a DB table with the following 3 fields: ItemID, ItemName, ItemValue The form is a...
  8. NEveritt

    Drop down to populate text box

    that works, but i will need the ID to send back to the database, so how do i get around that?
  9. NEveritt

    Drop down to populate text box

    so how do i then get the value into the text box? this is all bearing in mind that I need to then at the end, when the form has been completed insert values into a table, the only value one of the 3 values i listed that needs to go back into the databse is the IDColumn
  10. NEveritt

    Drop down to populate text box

    Using ASP & SQL: I have a table with: IDColumn, CostType , CostValue I have a populated drop down list that contains just the costtype. When someone selects one of the items it needs to put the costs into the text field. Im expecting its using the Onchange on the drop down list. What I...
  11. NEveritt

    IFRAMES

    i have been told that its very easy to put Iframes on an asp page, but... Everything on the website comes from a user selected ID which is request("campaignid"). so when the main page loads up, all the variables pulled from the database are displayed on the main page. I then want to have an...
  12. NEveritt

    Request.form problem

    hmm, again unless Im going mad its all ok, so I have posted the code here: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 4</title> </head> <body> <form method="get" action="updatereceive.asp"> <p><select size="1"...
  13. NEveritt

    Request.form problem

    I think I am going mad here, so if someone can help me out: Im new to .ASP and I am adding an IF statement to the submit button to Insert a new record if it is clicked. I have tried this both submitting to the same page and to another page, and I have tried Get & Post so I have the button...
  14. NEveritt

    Case statement in a Group By???

    Thanks to Vongrunt, it was that simple! For GShen - the query was a little more complicated as I make a year-week code out of the case statement, i.e. week 12 in 2004 is 2204-12. I use ISO week (ISO standard) as thats what our company use, this is the ISO standard for week numbering. If you...
  15. NEveritt

    Case statement in a Group By???

    Is it possible to put a case statement in a the group by part of a query? Below is an example of a query using the normal Datepart function for the week number, and then the ISO week function to get the correct week number. However in using the ISO function, you have to use a Case Statment...
  16. NEveritt

    Removing email address from Text

    all sorted now, i edited the query given by JayKusch to remove the full email address, plus I had to cope with text that did not have an email address: CREATE FUNCTION fnc_ReplaceEmailAddress ( @OldEmailText VarChar(1000) ) RETURNS varchar(1000) AS BEGIN BEGIN DECLARE @AtSignPos...
  17. NEveritt

    Removing email address from Text

    I am looking to remove email address from text strings and replace it with the text (email removed). The email address' will not be in every string and the the domains will vary. e.g. fields named 'Comments' and an example of a field is: "what a sunny day said email@email.com yesterday" i...
  18. NEveritt

    Date range lookup

    I am looking for the best way to do the following: Each case in my database has a timestamp. Each date is part of an accounting month. This month does not correspond to the normal months. Therefore during the select statement I am looking to bring out the relevant book month for that date...
  19. NEveritt

    DTS Truncates Characters to 255

    I use SQL 2000 version pack 3. When exporting to a text file from a varchar field (set to 2000 characters) it is being truncated to 255 characters. I have found the article http://support.microsoft.com/default.aspx?scid=kb;en-us;247527 which refers to this know problem. However they say it...
  20. NEveritt

    FTP batch process

    Oh sorry I am using a DTS from Enterprise Manager.

Part and Inventory Search

Back
Top