Search results

  1. B

    Export Yes/No Value to Word Checkbox

    give me a few minutes.....
  2. B

    Export Yes/No Value to Word Checkbox

    break down your code and post it. I read you other post. POst your code which only applies to the Checkboxes.. We'll take a look at it. Whe replying, use the #Code/#code - its much easier to view.
  3. B

    Access to Word Automation

    maybe this will help. If you want to export yes/no value to a word check box see this post: http://www.access-programmers.co.uk/forums/showthread.php?t=105426
  4. B

    Invalid Use of Null

    TRY if isnull(me.EXPIRYDATE) then me.EXPIRYDATE = " "
  5. B

    Export Yes/No Value to Word Checkbox

    make sure you have Word active in the object library.
  6. B

    Export Yes/No Value to Word Checkbox

    Solution Incase anyone wanted to know..here is the solution: Dim path As String Dim objWord As Object path = CurrentProject.path & "\file.dot" Dim dtnow As String DoCmd.SetWarnings False Set objWord = CreateObject("Word.Application") objWord.Visible = False 'True is visible...
  7. B

    Export Yes/No Value to Word Checkbox

    Hi all, Does anyone know how to Export Yes/No Value to Word Checkbox? This is what I have so far. Dim path As String Dim objWord As Object pathx = CurrentProject.path & "\file.dot" Dim dtnow As String DoCmd.SetWarnings False Set objWord = CreateObject("Word.Application")...
  8. B

    multiple email body problem

    Its telling you that you are refferring to an object that is not there. Check to make sure all your objects are there
  9. B

    Show that a record has been deleted

    I think I will add a MSG box to ask "are you sure you want to delete?" Then save the record to a table called DeleteHistory....then delete the orginal. thx
  10. B

    Show that a record has been deleted

    Hi All, Is there an easy way to show that a record has been deleted (besides "audit trail")? for example: if record_id 2 was deleted, the fields can show "deleted" thx
  11. B

    Calendar Odject for Scheduling Holidays

    There is one here that I use but I cant find it. Keep searching, you'll find it.
  12. B

    Combobox Question

    try this (see attached)
  13. B

    Combobox Question

    yes it is. if you post you DB I'll show you how to do it.... Bones
  14. B

    adding a record problem

    Sounds like the combo box is bound to a field in the the record source. Delete the combo box and used the wizard to create a new one. Dont choose the option that asked you to have it look up record on the form... Hope this helps
  15. B

    Is this possible? Access to Word Again

    try this http://www.access-programmers.co.uk/forums/showthread.php?t=97740
  16. B

    Acces to Word - Checking for Bookmarks

    why dont you open the word document and check there? Bones
  17. B

    Force Entry Based on Criteria

    you can add you code to the Exit event for the form. By doing so they cant exit the form until they fill in the required fields Good Luck
  18. B

    advanced searching through forms

    take a look here: http://www.access-programmers.co.uk/forums/showthread.php?t=100246
  19. B

    Learn VBA

    I started with "VBA for Dummies" then moved on to "Expert One-on-One Microsoft Access Application Development by Helen Feddema May 2004", plus this forum is price less. Good luck
  20. B

    Exit a half populated Form without saving record

    you can also add the undo command on certian conditions. on exit add #DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70# for example: if isnull(me.textbox) then DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 good luck
Back
Top Bottom