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!

  • Congratulations strongm 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: trudye10
  • Order by date
  1. trudye10

    Can't pull Month from date

    That makes PERFECT sense, it is clear as mud (Smile). It seems so easy when someone breaks it down. I and I'm sure others will apprciate your explanation. Thanx so very much, Trudye
  2. trudye10

    Can't pull Month from date

    George, thank you so very much for your patience, professionalism and your understanding of what it is like to be a newbie to SQL Server. Also please accept my gratitude for taking your valuable time to explain the posted formula. I am sure I am not the only one who does not understand it. We...
  3. trudye10

    Can't pull Month from date

    Hi Guys thanx for responding so quickly. I make it a practice never to code anything I cannot support. I am new to SQL Server and I have no idea what you just coded. Although I appreciate the fun you guys had creating this complex formula, there has got to be an easier way to pull the month...
  4. trudye10

    Can't pull Month from date

    Thanks Guys so much for repsonding however, I'm don't understanding how the proposed options will get me the value I want from field ddbldt. I am trying to compare month values in an effort to get a specific year and month. Trudye
  5. trudye10

    Can't pull Month from date

    I have a date that is stored as numeric in format yyyymmdd. I am trying to extrapolate the month from it and compare it to the current date. Is there a way to do a substring on a numeric field? Here is my code: SELECT DDLOAN, DDprod, DDOFFR, DDBLDT, DDMFEE FROM...
  6. trudye10

    Error Converting Julian date using DateSerial

    Thank you so much for responding Skip but, I'm sorry I didn't get that. Trudye
  7. trudye10

    Error Converting Julian date using DateSerial

    Hi Guys, I found this function to convert julian date online but I'm having trouble getting it to work properly. S_Date = DateSerial(1900 + (rs1!PDATE \ 1000), 1, rs1!PDATE Mod 1000) after processing 2007184 S_Date is equal to 7/3/3907. which is bascially correct it s/b 7/3/07? What am I doing...
  8. trudye10

    Mail Merge horrors

    Thank you so much I will look into that. Trudye
  9. trudye10

    TimerInterval Problems

    Basically sends msgs to users. Here is the code: Function Time_To_Compress() Dim db1 As Database Dim rs1 As Recordset Set db1 = DBEngine(0)(0) Set rs1 = db1.OpenRecordset("Log_Em_Off", dbOpenDynaset) rs1.Edit rs1!Msg_Count = rs1!Msg_Count + 1 rs1.Update If rs1!Msg_Count = 2 Then...
  10. trudye10

    TimerInterval Problems

    Remou, thank you so much for responding so quickly. I have question, why does cnt jump from 0 to 3 on the very first pass thru the code? After this code is exec cnt is eq to 3(cnt = Val(Me![lblCountWarnings].Caption). I know I'm missing something just not sure what. Thanx, Trudye
  11. trudye10

    TimerInterval Problems

    Hi Guys, I am trying to execute a function every minute. It works the first time, the intervalTimer waits a minute before it exec the code the first time, after that it exec it every second. How can I get it exec every 60 seconds? Private Sub Form_Timer() Me![lblclockview].Caption = Time Do...
  12. trudye10

    Mail Merge horrors

    2003. Thanx so much BlueHorizon for responding but I figured it out. The fields were padded, I just needed to do a TRIM function. I still haven't figured out Current date, other than hard coding it in the letter. Trudye
  13. trudye10

    Assigning File Types

    Thanx Guys
  14. trudye10

    Assigning File Types

    Thanx for repsonding. That's not exactly what I was asking, let me try again. I want to assign "file types" not a single file. So in the future any time I open that "file type" the desired software is used.
  15. trudye10

    Assigning File Types

    Hey Guys, how do I assign a file type to a specific software? Thanx much, Trudye
  16. trudye10

    Mail Merge horrors

    It seems that they MS has managed to take a task that has always worked and screw it up. Leave it to MS. You used to be able to place fields in Mail Merge where ever you wanted and that's Exactly where they would print. Now it seems MS supersedes your placement with their own. Here is how my...
  17. trudye10

    Update/Join - Zero Recs Returned

    Thank you so much George for responding, but I jumped the gun on this one. It did the Update! HURRAY!! I had run it so many times (tweaking this and that) and it didn't work. It looked as it if was not working this time either. Thanx again for taking the time to respond, Be well, Trudye
  18. trudye10

    Update/Join - Zero Recs Returned

    HI Guys, I checked the Advance Search and fashioned my Update/Join after them. But for some reason it is not working. I created a SELECT query to insure my basic syntax was correct and it ran just fine. I ran a query in Access/SQL to insure my criteria was correct and I got back 2 records just...
  19. trudye10

    Concatenate/Update a record

    I figured it out FINALLY. It woke me up last night, I need to add the TRIM function. I confirmed it this morning, in some of the records the first byte is a space. Thanx guys for all your help, Trudye
  20. trudye10

    Concatenate/Update a record

    My mistake I forgot to mention the Acct_Number can be 10 or 11 depending on the Division. If the Division = 30 then Acct_Number is 10 bytes, if not it is 11 bytes. That's why the 8 zeros on if = 30. I put the DUH answer because I thought I had put the 8 Zeros on the Else. I gave the Stars and...

Part and Inventory Search

Back
Top