Search:

Type: Posts; User: orangehat; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    103

    here is a great example I used to send all the...

    here is a great example I used to send all the sheets of an excel to in the body of an email
    It needed a little work but I can send all sheets in an xls in the body of an email after a little...
  2. Replies
    7
    Views
    880

    As WendllB said: UNION is the correct answer. Too...

    As WendllB said: UNION is the correct answer. Too tell which table it came from add another field. i.e.
    select name,address,city, "a" as which
    from table1
    UNION
    select name,address,city, "i" as...
  3. Take a look at...

    Take a look at http://stackoverflow.com/questions/13713327/sending-emails-from-access-db-containing-attachment-with-dynamic-name
  4. You mean something like this? stDocname is name...

    You mean something like this?
    stDocname is name of report.
    DoCmd.SendObject _
    acSendReport, _
    stDocname, _
    acFormatPDF, _
    , _
    , _
    , _
    stDocname, _
  5. Replies
    8
    Views
    616

    Something like this? Not the cleanest but it...

    Something like this? Not the cleanest but it works.


    Option Explicit 'force all variables to be declared
    dim objFSO,objFolder2,objFile2,Directory,fsodir, sf, fullpath, Filename
    Set objFSO =...
  6. Replies
    1
    Views
    178

    What kind of file?

    What kind of file?
  7. Replies
    2
    Views
    365

    [SOLVED] Does this help?...

    Does this help?
    http://technet.microsoft.com/en-us/library/ee198684.aspx
  8. Maybe I didn't explain it correctly. How can I...

    Maybe I didn't explain it correctly.
    How can I prevent a form form being saved if they have NOT entered a required field?
  9. Javascript prevents closing of PDF if some fields not filled in

    I have a form fill-able pdf, on document close if a certain field is not populated I pop up a message telling them to reopen and fill in that field.
    Anyway I can abort the close in javascript it if...
  10. In 64 bit Windows I had to do the above in...

    In 64 bit Windows I had to do the above in c:\windows\syswow64 directory.
  11. Assuming the broadband router has an rj45...

    Assuming the broadband router has an rj45 connection put another (backend) router behind it and connect so it using the 1 connection. Connect your systems to the backend router.
  12. I ask the obvious: Did you run a scanpst on it?

    I ask the obvious: Did you run a scanpst on it?
  13. I may have posted this in the wrong group. Please...

    I may have posted this in the wrong group. Please advise.
  14. Outlook 2010 Public Folder path missing domain name

    Using Outlook forms and vbscript I'm searching though the public folders on Exchange 2007 using Outlook 2010
    I have one user who's public folder path does not have the domain appended
    The primary...
  15. It was already checked. Still doesn't work.

    It was already checked. Still doesn't work.
  16. I'll give it shot when I return from holiday...

    I'll give it shot when I return from holiday vacation.
  17. Thread: Access 2007

    by orangehat
    Replies
    3
    Views
    495

    I threw this together, give it a shot. I put the...

    I threw this together, give it a shot. I put the data in an array not knowing what you want to do with it.
    Module1:


    Option Compare Database
    Option Explicit
    Public myarray(200) As String...
  18. outlook 2010 not running vbscript inside outlook form

    I have an Outlook form for vacation approval using vbscript. It works on 200+ machines at work running everything from Office 2003 to Office 2013, except one user who is running Office Pro 2010...
  19. Thread: gadgets

    by orangehat
    Replies
    10
    Views
    1,008

    Take a look at...

    Take a look at http://social.technet.microsoft.com/Forums/windows/en-US/c182390e-f4bb-4d7a-93ea-1f411525c7f6/desktop-gadgets-are-managed-by-your-system-administrator?forum=w7itproui
  20. Replies
    9
    Views
    1,577

    What's wrong with setting a flag the report...

    What's wrong with setting a flag the report checks at 'on open' do a cancel=true
  21. Replies
    3
    Views
    785

    How about: Combo2.Value = ""

    How about: Combo2.Value = ""
  22. I tried a macro using runapplication with: ...

    I tried a macro using runapplication with:
    "C:\Program Files (x86)\Microsoft Office\Office14\excel.exe" "C:\Users\fred\Documents\a folder with spaces\test.xlsx"
    and it worked using Office 2010. I...
  23. Replies
    3
    Views
    926

    Any error message(s)? I use the above in...

    Any error message(s)?

    I use the above in access 2007 with no issues.
    I also put a
    DoCmd.RunCommand acCmdSaveRecord
    to save any changes before I do the select.
  24. Replies
    9
    Views
    1,853

    The only way I've been able to read a users...

    The only way I've been able to read a users contact list is by opening Outlook using a profile with that user's information. I'm sure there is another way, I just do not know it.
    i.e....
  25. Take a look at...

    Take a look at http://windowssecrets.com/forums/showthread.php/111149-Word-97-2007-Mailmerge-Tutorial-Create-Sorted-Listings-%28v1.52%29
    He also has a youtube video...
Results 1 to 25 of 40
Page 1 of 2 1 2