Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    498

    Is anyone familiar with a way to automatically...

    Is anyone familiar with a way to automatically close a database if not used for x amount of time? I can obviously code it, but why reinvent the wheel
  2. Replies
    3
    Views
    474

    Thanks that is more or less what I ended up doing...

    Thanks that is more or less what I ended up doing also. Just wondering if there was anything else.
  3. Replies
    3
    Views
    474

    I have seen different variations on code for...

    I have seen different variations on code for this. Anyone have any favorites?
    Thanks
  4. Replies
    16
    Views
    1,027

    here is some code from Dev Avish, that I modified...

    here is some code from Dev Avish, that I modified to use a registry setting. I always appreciate his code and am very grateful
  5. Is there an add in or code to do this? If so is...

    Is there an add in or code to do this? If so is there a way to code it to remove the recurring appointmnets but only for those days?
    Thanks
  6. Replies
    14
    Views
    958

    This is not the place to discuss Office 2010...

    This is not the place to discuss Office 2010 Beta. Moreover, this topic is about starting Excel from Access, please don't hijack it.
    Sorry you are correct
  7. Replies
    14
    Views
    958

    Is Office 2010 on its' way? I ave been using the...

    Is Office 2010 on its' way?
    I ave been using the technical preview (beta). Not any major changes in the front end of Access, did not yet get a chance to sue the new macro editor which look...
  8. Replies
    14
    Views
    958

    The code itself is correct, so there appears to...

    The code itself is correct, so there appears to be a problem with the Excel object. Does the problem persist after restarting your PC?
    due to some other issues also I uninstalled 2010 and 2007 then...
  9. Replies
    14
    Views
    958

    The code itself is correct, so there appears to...

    The code itself is correct, so there appears to be a problem with the Excel object. Does the problem persist after restarting your PC?
    yes. I think it might be because I have both 2007 and the beta...
  10. Replies
    14
    Views
    958

    Is there other code between the line Set...

    Is there other code between the line

    Set appExcel = CreateObject("Excel.Application")

    and

    Set wkb = appExcel.Workbooks.Add()

    that you haven't posted?
    no- just the rest of strsql that is...
  11. Replies
    14
    Views
    958

    Does it make a difference if you omit the...

    Does it make a difference if you omit the brackets?

    Set wkb = appExcel.Workbooks.Add
    No, I had tried that first.
    Thanks
  12. Replies
    14
    Views
    958

    I have the following simple code and have no idea...

    I have the following simple code and have no idea why it is throwing an error:

    Dim appExcel As Excel.Application
    Dim wkb As Excel.Workbook
    Dim wst As Excel.Worksheet
    Dim intCount As Integer...
  13. Replies
    3
    Views
    410

    Open the database on a PC with Office 2003....

    Open the database on a PC with Office 2003.
    Delete the reference to the Microsoft Word 12.0 Object Library, then set a reference to the Microsoft 11.0 Object Library.
    Check for other missing...
  14. Replies
    2
    Views
    1,006

    Brilliant. A lot easier than reacordset clone....

    Brilliant. A lot easier than reacordset clone.
    Thanks as usual
  15. Replies
    2
    Views
    1,006

    If I use the filtering options on a continous...

    If I use the filtering options on a continous form, can I then use the recordsetclone to get only those records and then save them as a table or send them to word or excel, as the basis for a...
  16. Replies
    1
    Views
    522

    I just installed it. A 15 page report that I...

    I just installed it. A 15 page report that I wanted to export to a RTF file, yesterday after 20 minutes of working, gave back an overflow error. Today it ran instantaneously. To me this is...
  17. Replies
    4
    Views
    556

    You can use the built in database documentor in...

    You can use the built in database documentor in database utilities
  18. Replies
    3
    Views
    394

    It still jumps back to the first record on the...

    It still jumps back to the first record on the subfom.Istere any way to stay or retrn to the record I was editing


    Try

    Me.Parent.Recalc
  19. Replies
    3
    Views
    394

    When I change a record on the subform I want to...

    When I change a record on the subform I want to refresh a textbox on the main form that is based on a DCount of the specific records on the subform. How could I do that but still return record I was...
  20. Replies
    3
    Views
    451

    Re: Forward references in Access 2007 (pro)

    Another option that is much more expensive is FMS Total Access Analyze ,but it does what you need and a lot more. I have used it http://www.fmsinc.com/MicrosoftAccess/BestPractices.html
  21. Replies
    3
    Views
    715

    Re: Call Mail merge Wizard (2007)

    In other words there is no docmd.... that calls the mail merge wizard?
  22. Replies
    3
    Views
    715

    Call Mail merge Wizard (2007)

    How would I call either in VBA or Macro the mail merge wizard to be already pointed at a particular table or query?
    Thanks
  23. Replies
    3
    Views
    733

    Re: Acess and LiveMesh (2007)

    I am going to try it in stages, but first I need to get my main computer repaired so it will take a some time. Thanks for the encouragement.
    If I am using accdb and there is no replication support,...
  24. Replies
    3
    Views
    733

    Acess and LiveMesh (2007)

    Anyone have any experience using Live Mesh or something similar to synchronize a Back End in different sites. I am aware of the issue of making sure that you do not have simultaneous changes, but are...
  25. 'Cannot Create Databse Window' Error Message (2000)

    I created a database in 2003. I then used 2007 to downgrade it to 2000 for someone, When I installed it on their computer, it refused to open and gave me a message "Cannot Create Database Window,...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4