Search results

  1. D

    Find and Move picture files via Access VBA

    Set fs = CreateObject("Scripting.FileSystemObject") Set SelectedFolderTemp = fs.GetFolder("pathToYourFolder") 'Loop through the files in the selected folder For Each MyFile In SelectedFolderTemp.Files If InStr(MyFile.name, "tool123-") > 0 Then 'DO WHAT YOU WANT as you have...
  2. D

    Multi-language Access

    PS. If you really want to be good if the key is not found in the foreign language you can make a fall back to your English file as Generally it is fully filled out.
  3. D

    Multi-language Access

    Hi JohnPapa From what I see with languages like Objective C / VB.NET and /C# the method of making software multi language is normally that you have a text file with keys. When your software starts it chooses the text file with the language of choice and then reads the language in. The...
  4. D

    Help

    I will help you if you show me some code as to how far you have got so far. If you are just starting, then my I suggest (you dont have to use it but) you use Dim fs As Scripting.FileSystemObject as the start. Then look at this link for examples. http://support.microsoft.com/kb/186118
  5. D

    Help emailing copy of forms

    The thing you need to change is the .To property of the email you are sending. What you could try is to use a Method like this.. Private sub sendEmailWithAddress(String theEmail as string) 'put your code in here end sub Then you can change this .To = "name@company.com"to this .To = theEmail
  6. D

    Add Outlook Referances in VBA

    Office Version hell is a real problem. You should look at late binding then you do not have to worry about this. You do however have to test your code on each version to make sure you dont try a method or use a propoerty that that version did not have.
  7. D

    Open Existing Outlook Contact

    if you are still having a problem. Can you post some code. How do you "have" a contact? Do you have their email address?
  8. D

    Help. db works on one computer and not another

    I have no idea why you have a problem, nor do I think my suggestion below will solve it but are you getting an Outlook object? Can try this replace this Set objOutlook = New Outlook.Application with this Dim oNS As Outlook.Namespace On Error Resume Next Set objOutlook = GetObject(...
  9. D

    How can I know sent successfull or not using Outlook Application in VBA

    At the top of your form code you need to put this Private WithEvents olMailItem As Outlook.MailItem when you set your email object you need to use the above. Set olMailItem = objOutLook.CreateItem(0) Now I would suggest you use two events. If you show the email and let them send it then you...
  10. D

    Trying to click Javascript menu tree in IE

    Hi neveu, Please post the code you have so far that opens IE and at least goes to the page you want. Please supply a link to the web page. Please identify each element you have explained in words in your text with the elements in the HTML, this means going to the HTML for the page / frame and...
  11. D

    Creating an appointment in outlook shared calendar using an access form

    I was interested to learn what all those 111 and 000 were in the free busy method. Have a look here.
  12. D

    Creating an appointment in outlook shared calendar using an access form

    I see the free busy method is a little different. Write some code. Show me what you get and I will help you. Remember, just because you are coding it does not mean you will get to see any more details about other peoples calendars than what you can see from your own outlook client. unless of...
  13. D

    Creating an appointment in outlook shared calendar using an access form

    Your Welcome. i have never done what you are talking about as I always send the appointment item and then let the person decide whether to accept or not. But I had a look at the Appointment object. http://msdn.microsoft.com/en-gb/library/aa210899%28office.11%29.aspx I like the...
  14. D

    VBA to choose Outlook Profile

    I know this is an old thread, but I just wanted to clean it up and answer it for next time. The answer is to us the LOGON method of the MAPI object in Outlook. Here is a link to the full explanation. http://msdn.microsoft.com/en-us/library/office/ff861594.aspx Below is an example of logging on...
  15. D

    Question Where to added/install a database file in Windows 7

    That sounds interesting, so what happens if they choose the Programs Folder, then do you tell them not there or do you check to see if you have the UAC rights to copy the files to the selected folder? Also do they use multi-user machines? If they put it in their own folder then it would not be...
  16. D

    Question Where to added/install a database file in Windows 7

    thanks for answering. So just so we are on the same page you mean for example C:\Users\(user-name)\.....
  17. D

    Question Where to added/install a database file in Windows 7

    I have an A2007 file with a lot of helper files such as Office templates, and icons and other files used by Access to do its job e.g.. an ini file for settings and multi language things. Due to my lack of knowledge at the time and because it was easy, in XP my installer program I made myself...
  18. D

    Trying to read an Appointment from Outlook

    Hey Richard if you need help then ask. But you'll need to give lots more details. What you have said so far does not make sense as I think you realize.
  19. D

    amend or delete appointment from outlook using access

    Have a look at the first post http://www.access-programmers.co.uk/forums/showpost.php?p=935336&postcount=1 you can see in there an example of this (he talks about a concept of early and late binding). It is also a good idea to do a little bit of looking around, non of this thread is suitable...
  20. D

    amend or delete appointment from outlook using access

    I am not sure that is a language problem. Other people also my not understand it. What I mean is that you need to set objApp to be your main Outlook.Application object.
Back
Top Bottom