Recent content by pbisaillon

Hi, I am trying to group a date field that will display records that fall within a 3 year date period. I noticed in Crystal 8.5 that when you group a date field you have the option of selecting how the section will be printed (ie: for each year, each quarter, etc..) I would like to be able to...

Hi, I am trying to attach the values to an email that I exported out of Access by using the "DoCmd.TransferText acExportDelim" function. I currently have this exporting to a network drive, but it would be nice if it can generate an email. I would like to have this either populate...

Hi, is it possible to export out of Access and have the .TXT file automatically attached to an Outlook email message? Below is the code that I have for the command button to have it export to a directory, but I would like to have it launch Outlook, and attach itself to an email. Any tips would...

That works like a charm! Thanks a lot for your help, Patrick

Thanks.. Is there a code or certain expression that I put in the Default Value field? Thanks a lot, Patrick

Hi, I currently have one form linked to a subform by a BoxID field that is being concatenated to get it's value. I have some fields on the main form that retrieves it's value from the Subform. I added a "clear form" button that clears all of the field values but that is no good! I...

I am trying to change the color of a certain field when the condition of another field has been met. I am not sure of the code needed to do this. Example: I am performing calculations based on dates. I want a certain field to change colours based on the MAXIMUM or latest date value of the...