Recent content by fredgmain

Mark & Mike, Thanks for you suggestions. I will first try to index the last 8 characters and check the performance. If that is still slow, I have to split the field or create additional fields for performance. Thanks and Regards, Fred

Hi all, I have a "2 - Top level" form (form1) with a menu. I want to disable the main form (form1) when I call another form (form2) from the menu and enable the (form1) again after the user closed the second form (form2). Thanks in advance. Fred

Hi all, I have the following partial criteria for the SELECT statement. It involves the following fields ("senderemailaddress","cc","to"). The query definitely not very effective because it is very slow when I created 100,000 test records. But I must use AT() or $ to match the string within...

Dear all, Many thanks for all the inputs. I have tried the GIUD and it works for my application. Have a good day! Regards, Fred

Dear Cetin Basoz Thank you for your help. It solved my forms' problem. Regards, Fred

Dear Mike, Actually, removing the parenthesis did not solve the problems. I believe is my mistakes...but still cannot solve this easy problem. I have a simple "2 - Top Level" form, but when the form displayed, I don't know why the cursor is not stopping at the first input field. (I already...

Hi all, I create a simple form (2- Top level) but the form is not in focus until I click on the form (any area or title). I believed the settings in the form properties is wrong but I cannot figure out why. Or any command that I can put in the form "Init" or "Activate" section so that the...

Dear Mike, As always, Thanks for your help. Regards, Fred

Hi all, Is SYS(2015) is the only VFP fuction that returns unique number? I try use it as a "login session id" for the app. This "id" will be used to track/link all the activities withn the system access, like runnung reprots, add/edit/dele information and etc. Is this a good way? Thanks in...

Hi all, I have a "RETURN (THISFORM.loginid)" command in the VALID, but the cursor did not stop at the THISFORM.loginid field. I know I have done something wrong but cannot figure out the reason... BTW, the "THISFORM.loginid.setfocus" command would not work either. I want the cursor to go back...

Dear Mike, Many THANKS for your help as always. Have a nice day! Regards, Fred

Dear Griff, Thanks for your quick response. Regards, Fred

Hi all, I have seen the solution in this forum before but I cannot find it. Thanks Fred

Hi all, I have a app that has only one "2- Top level form" (form1) with a menu inside the form. Now, I like to call a login screen before the "form1" is called. I try to use the following code but is not working because the program execute till the READ EVENTS. Should I call the "DO FORM...

Dear JRB-Bldr, My "freddiekg" account is lo longer working for unknown reason, so I setup a new one. Back to the Outlook questions again, let me explain what I try to accomplish and please help. BTW, I really appreciate all the helps you gave. (1) I have 10 uears that login to a remote...