Recent content by trudye10

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

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

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

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

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

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

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

Thank you so much I will look into that. Trudye

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

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

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

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

Thanx Guys

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.

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