Search results

Well good news...I converted it all over to use AccountID and we are all good. Also just as a side note...the AccountNames were all unique..I spent hours doing that on the spreadsheet before I brought it in to the DB ;)

Sorry folks..Ive been out of pocket for a few days and Im just now seeing the responses.... Anyway...yes I agree..I should be using AccountID instead...and I will try to make it work... I realize I have to use the argument for number instead of a string...which I will change and test. And to...

It worked! I took your advice and changed it to single quotes and it is now working. Thank you for everything!

Ahhhhh gotcha...well I am using the AccountName in my query and on the frm_AccountSalesTouches form. I do have the AccountID on my form as well. Regardless I think you are on to it...with the single quotes idea... Also...here is a shot of the tbl_Accounts table....

I took your advice and I certainly see the logic and that this should work...however, I am getting the following error message as in the attached screenshot...any advice? Note - I commented out my first attempt...as you can see.

I am betting this is n easy one for the experts...but again...not so easy for me.... Is there a way to click a specific record in a datasheet (a query placed on a form in datasheet view) to pull up the form with that record in edit mode? I have a query that tracks "sales touches" against each...

This will be setup for a single user running locally on their machine along with Outlook. I really like the way this is put together and I especially like your mods...I think it greatly improves the functionality. The only thing I see that could use some improvement is the ability to schedule...

I am sure this has been an issue with Web Browser Control and Chrome for a long time...good ole MS...just now trying to fix ....go figure... ;)

Interesting. Use that on the forms "On Load" event I am assuming?

Is there anyway to force the Access Web Object Control to use Chrome instead of IE? I am trying to use a website within Access that my company uses for it's daily routines....and that site does not like IE at all. Every time the site loads you have to click through about 25 different "script...

Thank you MajP. This was exactly what I was looking for. Thanks again! -mgm

Yep DBGuy I have check the templates for it...but not really finding anything. Pat, I would like to use Outlook if I could drop it in on my form...Im trying to keep all my tools in one place... even with that said, Outlook doesn't have a way for me to track my activities on specific client...

Can someone point in the right direction of getting information about building a daily planner? All I want to do is build one Form called MyDay and be displayed in 3 different sections (with 3 different sub-forms if needed) 1. A calendar view section ( or sub-form) that shows the days of the...

Thank you Arne! Thank you Vlad...I really appreciate all the guidance you gave me.

Oh myyyyyyyyyy ...YES! That was it..... wow....just a dumb mistake......sorry....and thank you!!! It works perfectly.

*****UPDATE***** Vlad, I implemented your arlRefreshCheckBoxes() code and made the changes you instructed and it is now working perfectly. Arne, I also implemented your updated code to Vlad's function ( Call vcSendEmail_Outlook_With_Attachment ) and it works. I can now attach the PDF from the...

Sorry Arne and Vlad...I have been SWAMPED today! My phone started ringing at 6am...woke me up out of bed, and I have literally been on the phone dealing with clients all day....just wrapped up and it is almost 730pm here...plus it is end of month for us sales flunkies...so its crunch time trying...

Vlad, you said earlier for me to put your Outlook Automaton Function in a module and then just replace my Docmd.sendobject with a call to your function...I put the following code in my email button and it is returning a compile error "Argument Not Optional" Private Sub bt_SendEmail_Click() Dim...

I made a new module call Private_Module and put it in there and I still get the sub/function not defined error. And...I was wrong earlier...it is NOT updating the the form like I thought originally. I have attached screenshots....I am working on creating a sandbox database and I will upload it. ;)

ahhhh yes I do....stand by.....