Search results

  1. N

    Listbox filter VBA

    I understand that and have filled in both to the correct names as below, however it filters nothing. Am I missing something ?
  2. N

    Listbox filter VBA

    Hi arnelgp Thanks for the post, however this method isn't working are you suggesting the code to be like this? And if so it fillters nothing. (-:
  3. N

    Listbox filter VBA

    Hi Guys I have a listbox with shows Name, login, logout ect. I have a textbox which filters the name using the below method. Which is fine however I then need to filter (AND) the login, logout ......so kind of like a cascading filert. or could I have a command button with the same effect that...
  4. N

    Multi Select File Dialog VB

    Nice one James thanks! works a treat.
  5. N

    Multi Select File Dialog VB

    Hi Guys I have code below that open the file dialog to select files, when I select multipal files it only enters 1 file in my list box and not the rest. Can anyone help me please. :D
  6. N

    Counting a Filtered Recordset VBA

    Hi thanks, However I was hoping to add to the existing code as that code shows record of record.
  7. N

    Counting a Filtered Recordset VBA

    Hi Guys I have this code below and works ok with a lable box, however is won't show filtered recordset. I know its something to do with Me.lblRecoredCount.Value = DCount("StaffID", "tblStaff", strFilter) but I just can't seem to get the correct end resault. Thanks for any help :D
  8. N

    On Error VBA Outlook

    Thanks for the post zpy2, not sure what your post is suggesting??
  9. N

    Problem with Pathfile opening on any desktop/user using VBA

    I'll have a look, howevr I've put an error handler on the message box so that now it promps the user just to open Outllook, if they click OK - before it went to an error message for debugging. Now it just runs the error handler and all is good! just making it user friendly as users will...
  10. N

    Problem with Pathfile opening on any desktop/user using VBA

    Nice one Minty! Is there anyway of forcing it open without the message box??? Other than that solves most of the issue. Thank very very much. (-:
  11. N

    Problem with Pathfile opening on any desktop/user using VBA

    Thanks Minty, sorry do I put that in a module and call it? Also it would be good to just force it it open. (-:
  12. N

    Problem with Pathfile opening on any desktop/user using VBA

    Hi Guy's I'm really struggling with this one, My Outllook Template is saved into 'Documents folder' when Outlook is running everything is fine when I click the commoand button to open the email 'Template' on my form in Access. Now if Outlook is closed and I click the button I get an error...
  13. N

    On Error VBA Outlook

    Thanks for all your help anyway. (-:
  14. N

    On Error VBA Outlook

    Like I said when Outlook is running it finds the path no problem. so I can't work it out.
  15. N

    On Error VBA Outlook

    Ive tried that link before and it open and mininsese out striaght away and the gives me the same error message as metioned before about it being open already.
  16. N

    On Error VBA Outlook

    Now i get compile error 'sub or function not defind' on this line. shellexecute bit
  17. N

    On Error VBA Outlook

    I'm pretty sure I've the correct path, the code you gave ealier dosen't work for some reason, i'll wait for your reply. Thanks very much.
  18. N

    On Error VBA Outlook

    If Outlook is ruuning then it will open the template, if acces isn't running it get run time error '-2147287030(80030002)': 'We can't opent the 'Template.msg'. It'spossible the file is already open, or you don't have permission to open it. To check your permissions, right-click the file...
  19. N

    On Error VBA Outlook

    It's because of this line of code -
  20. N

    On Error VBA Outlook

    Thanks Gemma-the-husky, I have tried that but just comes up with a 'Run time error' Temple.msg might already be open, this is even when Outlook isn't running?
Back
Top Bottom