Replies

I would like it to be without user intervention using a generic email with the name of the contract and the expiration date in the body.

This didn’t work. What did I do wrong? I have attached a part of my spreadsheet.

Thanks for the info. So, do I just make a calendar folder in the public folder? Can I limit who has access to it if it is in a public folder?

Thanks for the help! It works great!

Thanks for the help! It works great!

Thanks for the help. This worked, however, it showed the comments in all cells at once. I want to show only the comment for the selected cell. Can I do that?

Thanks for the help. This worked, however, it showed the comments in all cells at once. I want to show only the comment for the selected cell. Can I do that?

Thanks for your help. I’m not sure what the code would be. Can you help?

Thanks for your reply. I tried this and it doesn’t seem to work. My command line is:C:Program FilesMicrosoft OfficeOfficemsaccess.exe J:[Audit Reports.mdb]; Forms![frmSelectBndAudit#]. If I rename the database to “AuditReports.mdb” it works fine, but this is on a network and being used by others. Am I doing something wrong?

Thanks for the help. That is working fine, however I would like to make the subform not visible if there is no data for it instead of showing an empty form.

Charlotte,

Thanks for the help. I can see where I need to follow up my Access class with a Visual Basic class.

Jim

My brain has gone to lunch! How do I set up the comparison for this?

I need some more info on how to do this. I am a new user and “just learning the ropes.” Any more specific info would be greatly appreciated. Thanks.

Denny,
Thanks for the help. I finally got it to work!!

Denny,
Thanks for the response. I tried working with the “firstdayofweek” parameter, with no luck. I think the problem was with my syntax. Any help on what the syntax would be?