Recent content by dantheinfoman

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