Search results

Your problem is, as I understand it with this line Set objRecip = objNS.CreateRecipient(strName) OR Set objRecip = objNS.CreateRecipient("myemailaddress@email.com") You need to try a proper email address of someone, try you own. Further test if objRecip is an object of if it is Nothing...

So in sudo code in your loop you will create an if - if userID = bekesikr then ........ The last 2 rows of a recordset probably would need you to keep a count of the number records in the record set and your current position. Then when you loop gets to "total recordset count - 2" you would...

what does this do If Not objRecip.Resolve Then MsgBox "We have a problem" End If

I cannot give you an opinion on your first question but I have one on the second. Visual Basic is pretty similar to VBA. To be more specifc VB.NET. If I were to explain what MSAccess is I would say it is a Programming Editor (with a nice tool box of controls and nice set of addons like Active...

Ok your first problem is you need a recipient. You need this because it is from HIS folder that you are going to make an appointment. Thus to get him you need his email address. strName = "donanl.duck@disney.com" or strName = Me.emailField.Value. This may solve your second problem. If it...

I agree with the other guys. Use Outlook for outlook things and use Access for database things. Here you have a conflict or gray area and are having problems visualising how to do it. I imagine you have a MsAccess database which tracks projects/things/topics - and at some stage during this...

No problem. So if you understood my last post take out the things I have talked about above. Then (even if you did not understand) put in a breakpoint right at the beginning of this code and step through it with F8. Before each step put your mouse over variables and objects like objAppt and...

That is a good idea, and maybe try it with an email instead. It is identical just you will not have the folder part and you will create an email.

I understood you. I am guessing you are not making it correctly. Please go through my list of checks to narrow down the problem.

I see the copy and paste monster has bitten you. It is Friday, go out tonight and have a few beers, then get a big knife and cut off the fingers that you use to copy and paste, then drink until the words "copy" and "past" drown in beer and die. Or find the men in black. why do you set...

welcome to the forum. Yes show you full OUTLOOK code.

The links given are great. But bellemmar WHY? Outlook is a database of emails, appointments, contacts etc that has a great timer and email client attached to it. Instead of reinventing a contacts database try to work with it. Your database need only have some unique identifer to the Outlook...

spikepl i should have taken your advice and saved some time. I have now choosen to link the tables - do what i want and then dropping the links. Thank you for your help.

Hi Dave, I gave up on trying to execute this in one sql. Instead I regressed to opening 2 record sets (source and target) and then added records this way by looping through. This probably takes longer but I can control things better, can show progress and Access does not lock up so badly.

Hi 1. When creating your appointment check with msgbox Me!RoomRequestID.Value .Mileage = Me!RoomRequestID.Value .Save msgbox .Mileage .Close (olSave)if you have an id in your control. Also that mileage actually has something in it. 2. I have a feeling...

From the SELECT I get about 78,000 records. I am trying to INSERT the whole 78,000 into the table.

I am currently testng the following - This select works fine. (This is from the query objects of Access) SELECT patent_akz AS q_akz, em.status AS q_status, em.decision_number AS q_decision_number, CVDATE(em.decision_date) AS q_decision_date, em.work_around_ability AS q_work_around_ability...

please read my post #25

What is "qry_emailing" Then what you are going to need to do is group your Recordset by UserID and then keep adding records to your email object until the UserID changes. If you do this then do not forget that you cannot have this in the loop UNTIL you have a new UserID Set olitem = Nothing...

what he means is something like this. Dim olapp As Object Dim olns As Object Dim olfolder As Object Dim olitem As Object Dim olattach As Object Set olapp = CreateObject("Outlook.Application") Set olns = olapp.GetNamespace("MAPI") Set olfolder = olns.getdefaultfolder(6) Do While Not...