Search results for query: *

Hello folks! Since I am really new on this I hope my question is not a dumb one... So I have this problem. I have a list that includes a column for an STATUS, which can be IN PROGRESS or COMPLETED. What I need is that Sharepoint send me an email once an item is changed to status of COMPLETED...

When you run into a lot of times on the same error, you simply don't see the obvious... Worksheet(Resumen), what is wrong with that???... the ""!!! Well, this is the last time I promise this is going to happen. Thanks folks for all your help and patience... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~...

LOL... Yes they are buddy, and don't worry I do really appreciate your time and great ideas... I'll keep checking what I am doing wrong, I am almost sure that somwhere in the code I am making a mistake. Thanks for all! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HudHwk "Here comes the Hawk!!!...

Its is 5,000 the value that should be... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HudHwk "Here comes the Hawk!!!...

For both of them I get a list of objects information and their properties... I am wondering... CodeName and Name can be a problem? I mean, I am using Name and not CodeName, can that be an issue? For Worksheets("Resumen") this is the Name property information: : Name : "Resumen" : String ...

Yes I did as you intructed me. The variable now has the right information that I needed in it, but for some reason is still not retrieving the cell data from the chosen worksheet as I expected. "Subscript out of range" still shows... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HudHwk "Here comes the...

=( Nope... the error "Subscript out of range" remains. Sorry... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HudHwk "Here comes the Hawk!!!...

BIG TYPO ERROR!!! Yes, you are right, the select code should be "G2" instead of "C2" I have the wrong cell assigned. Select Case Worksheets("Resumen").Range("G2") I have added the watch and it is now populated with the rigth info, but still getting the "Subscript out of range" error. The...

Thanks Skip...!!! Still receiving the Subscript out of range error message on the same line folks... Thanks! HudHwk

Sorry for the delay PH... Resumen is a worksheet itself but m_Ejecutivo is a local variable.... Hudhwk...

Hi again PH, Now I am receiving a Run-time error 9. Subscript out of range... This is the original code (sorry for the spanish info) Private Sub CommandButton1_Click() Dim m_Ejecutivo As String Select Case Worksheets("Resumen").Range("G2") Case "Roberto Garza" m_Ejecutivo = "Roberto...

PH, The second option (use of string) is getting me a 0 value of D4. In the first one, the error shows on line: Worksheets("Total").Range("B9").Value = m_Data.Range("D4") HudHwk "Here comes the Hawk!!!

Thanks for replying PH! Now I am getting this error: Run-time error '91': Object variable or With block variable not set Thanks in advance! HudHwk "Here comes the Hawk!!!

Hi folks! This may sound silly, but I need to do something that I know how to do in FoxPro very easly but just can't seem to find the right syntax in VB... I have a Select statement: Select Case Worksheets("Total").Range("G2") Case "Data 1" m_Data = Worksheets("Data 1") Here is the thing...

Alright! I'll keep it in mind. Thanks everyone.

Guys, Exactly. The problem was the the selected area, y changed it to 0 and worked perfectly, the cursor was in the area 2 so when I use the cu_servs it got destroyed. Thanks a lot to every one!!! Have a great day. Sincerely, Daniel Buentello "Here comes the hawk...

the line that is telling me the problem is: APPEND FROM DBF('captura_movs')

Sure, Here it goes. create cursor captura_movs (mcve c(15), mdes c(30), mstat c(13), mresp c(13), mmemo c(13), mswap c(13), mobs m)

Maybe I am making a big mistake. I forgot to tell you, that the source database is a cursor. Do you think is that the reason?

I have VFP 6.0 and change everything that you said, and still doesn't work... Any idea??? Thanks in advance... Sincerely Daniel Buentello. "Here comes the hawk...