Search results

Sorry it took a minute to get back. Had to run some arrands, anyway, one of the best free ones I had used was http://www.icsharpcode.net/OpenSource/SD/Download/ It allows for development of not just vb.net but quite a few others as well. It has some decent tools to go along with it. Lastly it's...

One last question then I can answer the real question. Are you going to want to do any C#.net programming as well as vb.net as well? And are you familier with C#?

Yes we can help you. I was hopeing to find something already created online that would be a good reference and will continue to search for a bit. And I'll post a short sample of something here that's cleaned up to try and get you started. Hope this helps I'll be posting in a little while.

Are you going to be doing all of the development or are you talking about having some side developers as well? Sounds like a silly question but it does matter.

Looks like CJ beat me to it awwww :D

I had some time and wrote an example database that sortof does what your talking about. Download it below and break it appart you'll see what I did. Also here is a preview of the code and it seems to work just fine. Function CheckSchedule(lngID As Long, sDate As Date, EDate As Date)...

I understand as I am on DoD as well. I cannot automatically send but it should produce the email so you can see it at least and with the template with the replaced words from the code.

Have you tried it on another computer yet? It would be ideal at this point instead of beating it to death. Also that is correct because it's pretty much saying that it cannot create the email with the oft template and therfore cannot send or do anything with it either. I am really thinking that...

I dont know what to tell you at this point. Maybe try running it on a different computer and see if maybe this whole problem was because of a office file problem on that machine... Gotta think a little while on this very weird

hrmmm Yes that is correct. That's really weird because it works just fine on my system here. I just call the function from the debug window and then it asks which account I want to use. Finally it prompts me asking if I want to give my program access to outlook and I specify a time limit. Then...

Also I just have it opening the oft file in a folder directly off of the c drive under folder 1. So C:\1\test.oft So just make sure the file is located there and you should be good to go.

It sounds like the reference got broken. Go into your visual basic editor and look at the module and at the top select tools--->References and look at the outlook reference. Try deselecting and then reselecting it in your references.

What version of office do you have loaded and is this a windows machine or a mac?

No worries and good luck :D

Ok I got it to work. See the attached database. I removed a lot of your custom code but using it this way worked like a champ. You can add all your items you want to after. The code looks like this: Function workwithoft() Dim intUSL As Integer Dim olApp As Outlook.Application Dim objMail...

Why do you need the text files linked? Is their a specific need or are you just needing to read the file everytime someone opens it? Also are you wanting to update the text file from within access or is that done manually by something else? Please provide additional info.

Why do you need the size each field in an access table? Are you doing something really advanced or are you just simply wanting to get access data on a sheet or in memory so you can work with it in excel?

Look at the contents of an OFT file below: Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=SHA1; boundary="----=_NextPart_000_001A_01CE13D9.ED9885F0" This is a multi-part message in MIME format. ------=_NextPart_000_001A_01CE13D9.ED9885F0 Content-Type...

ROFL man I must have been stupid tired yesterday. CJ London thanks for pointing that out. boaterjohn I totally did not notice that. While the code is still close that I wrote earlier it's not going to give you it per car. I'll shoot you the code that will do this later today. Good luck

Umm now that I am looking at it quite a bit closer their is a huge problem with your do while loop. The reason is your loop is counting on rs.eof as part of it's criteria but inside of your loop you close the recordset and open it to other criteria then you tell it to move next in that recordset...