Search results

To get around this problem I have resorted to letting all users know about the ability to choose which profile to open Outlook with. Then just before the event I have added code to shutdown Outlook and then create a new instance of it. This then shows the "choose profile" dialog. Not everyone...

NP Darbid, Thanks for looking around tho. :)

Thanks Steve, Hitechcoach, I think I have finally got it. I am ready to deploy and I will look into the use of sql 2005.

:eek:Wow:eek: Did I really write that last night ^^^^^^^^^^^ So let me get this straight. I split the DB at the .mdb stage then make a .mde file from that. is the .mde file also split into f/e & b/e. Then, whenever I make changes to the (now split) .mdb file I make a new .mde and share the...

I have had a eureka moment. I must find a way of making it available to all 4 positions without compromising each position. (I think). Please forgive me I am a little tipsy lol

I think there-in lies the problem.. although we are all on the same network, there needs to be 4 separate databases working separately from each other.

What's the best way to implement my database? It has to work on a large corporate network which uses a remote infrastructure for updating software. It will be used by a maximum of 2 people at the same time but will be available to about 30 people.

Thanks darbid. I will be utilising this on my machine at work which uses MS exchange software. I have multiple inboxes and some inboxes are "multiuser". When I place my own email in, it shows the "outRecipient" correctly but fails at the line I mentioned. Have a play around, I am in no rush...

Darbid, I am trying to get this working and in it's current form I get the error that an object is missing when I get to the line: outItem = outFolder.Items.Add("IPM.NOTE") any ideas. Public Function SetupOutlookEmail(ByVal sTo As String, ByVal sSubject As String, ByVal sBody As String...

Ghudson: just found this. I know it states Winnt and 2000 but.. well ... I dunno. Quote from: http://www.granite.ab.ca/access/email/outlook.htm If you are using Windows NT or Windows 2000 as an OS then you can use CDONTS. It uses the SMTP Service to send mail directly. However the SMTP...

Ahh ok. I guess I will just have to educate the users about this then. Thanks.

Ghudson: I am using your code for automation however I have a problem. How do you introduce a "from" field, this is needed as the system I will be running my utility on uses microsoft exchange server. It seems that "outItem" does not recognise a "from" attribute. Thanks.

Thanks HiTechCoach. That is exactly what I did, just before I read your reply. :)

Thanks for your support. I searched and searched and finally came upon this http://www.access-programmers.co.uk/forums/showthread.php?t=194749&highlight=%22error+429%22. It seems that your own advice from this thread was exactly what I needed. Thanks again. :cool:

Hi, Sorry for bringing up an old subject. I am trying to use the code posted here on my 2007 desktop at home however, I am developing a utility for use with access 2003 at work. The code in it's current form on my access 2007 pc doesn't send the email if outlook is not running, will it be the...

Hi, I have a function in my database which creates .txt files ready for emailing. It saves the files locally in the form "ddhhmm_MMM_yy.txt" so each one is different. The files only need to be sent to one addressee which is the same every time. How do I automatically attach this to an...

Thanks guys, Works now.

I have a public function which I d/l from the net which removes punctuation from a string. The string is derived from a text box on a form. I know how the function works and how to send the string to the function. My question is: once the function is complete how is the string passed back to...

Wayne, You are an absolute genius. Thanks very much it works a treat. Merry Christmas :)

Here you go Wayne, Have a look at the "flag" field and what I have attempted to do with it, (you'll understand when you see it). Thanks,