Search results for query: *

Hi All, My email system has an activex button that does the work of sending emails when needed. I need to send an image with certain emails. I've been successful in adding the image as an attachment, but I'm not sure how to EMBED the image so it's in the actual body of the email. Here's how the...

Hi Mike, VERY HELPFUL! I haven't messed with detail bands much in the past, just copied old reports to make new ones. I was able to get the department deductions to use a detail band dynamically, so there could be 100 different deduction types in a Department and it will work. Now I just need...

Hi All, I have an old report that I was handed to revise which has : Page 1 with Employee and Employer total pay by PayType, Deductions, and Witholdings Page 2 with Summary of Departments totals for PayType and Withholdings (which I'm supposed to add Deductions to dynamically) Page 3 is the...

Hi All, atlopes and Olaf - Thanks, can't wait to try it. MikeLewis and Stefan - Thanks for the lesson and for expounding on the topic! also atlopes - I have validation for my colorpicker button to ensure -1 doesn't get into the field. It's either blank or has a color, so as long as it's...

Hi All, I'm currently storing colors to a field that is numeric using GETCOLOR(). All references to DynamicBackColor talk about using RGB() function. I can't seem to get the actual colorCode to work in the same manner. Does anyone know if this is possible. Here's what I'm trying to no avail...

Hi Olaf, I've just added (successfully) to the KeyFieldsList a new field I made called COMUNIQ C(10), wherein I put Sys(2015) whenever appending. I did a REPL COMUNIQ WITH SYS(2015) ALL for the current records and now even if all three records match exactly on the grid and I change one or...

Hi Tamar and Olaf, I'm having serious trouble with records becoming duplicated (or rather copying over the next record) in my CursorAdapter. I can start a new topic, but its very similar in that it's regarding my CursorAdapter. I tried adding more to my KeyFieldList, so that now it's the...

Olaf! Friggin Brilliant!!!! I just stumbled onto some legacy code that looks similar, but I like your direct approach. Here's what they used: WITH ThisForm RETURN GETFLDSTATE(-1, .r_cMasterAlias) <> ; REPLICATE("1", LEN(GETFLDSTATE(-1, .r_cMasterAlias))) ENDWITH Thanks. Dan

Hi All, Is there a function to know whether the cursor (that the CursorAdapter uses to update the table) has been changed? If changes are made to my grid and somebody tries to exit out without clicking Save, I'd like a message to ask if they'd like to Save (meaning do a TableUpdate(.T.) ) or...

Thank you, Olaf. Very informative!! Starred. Dan

***UPDATE**** 1. To add to the fun, I just discovered that even if I close my EXE, do something to code, recompile and run it, the procedure Still Works as long as Thunderbird was initialized via my EXE. If I close Thunderbird and open it manually instead of from my VFP EXE, then it fails again...

Hi All, I tried to be as expressive in the title as can be, but essentially, I'm trying to send emails with MAPI session using Thunderbird. Some considerations: 1. Thunderbird IS default mail application. 2. This procedure works when I'm debugging the code, just not when I compile the EXE and...

Thanks, Olaf. Yes, I was putting SCAN inside the TEXT function, because I'm apparently very simple. . . You make everything look easy, buddy. Thank you!! JRB, I probably would have done something like that initially, but I think I was afraid the variable would be maxed out at 255 characters and...

Hi All, Looking for recommendations for the best method to send out daily summary emails to several salespeople. I have a cursor with their emails and details for each record. I'd like to just be able to transform this cursor as text or table in an email and send. Not sure how to do that. I...

Hi Olaf, Yes supplmt is the CA cursor alias. Fields in the grid are like ControlSource = 'supplmt.ctype' (and the like). The real table is called prcomm.dbf. I didn't have a "Save" button currently as I thought I was experiencing automatic saves once I leave a record and once the...

Hi Olaf, I got it working by using the second cursor like so: PUBLIC nSecs nSecs = SECONDS() ** determine which optionbutton is pressed DO CASE CASE thisform.optiongroup1.Value = 1 && This contact only m.obResult = thisform.r_filter CASE thisform.optiongroup1.Value = 2 && This contact only...

Hi danfreeman, I'm working with a team and I don't want to add anything or take away from the base class, just want a new form I can mess with. Thanks! Dan

Hi All, Is there any way to make this beautiful vcx form into an SCX. I'd like to tweak it and use as stand alone SCX. Thoughts? Thanks Dan

Just a quick update: When I tried doing *fill cursor based on updated settings loPrcomm.CursorFill() it closed out the cursor 'supplmt' and the grid now is blank, no gridlines and no visible data. Does that mean I have to do a cursor at the beginning with the whole table and do BROWSE FOR ...

Thank you, Olaf for that descriptive answer. I appreciate it! A follow up question, since I've invested several hours in the CursorAdapter class and integrating it with my grid: Which would be faster: 1. A vague cursor and just filtering it by using BROWSE FOR ... AND BLAHBLAH Or 2. Is it...