Search results

  1. B

    Word Mail Merge

    I wonder if there is a way to link two tables or queries to a word doc for mail merge. I have an investigative memo and many findings associated with it. They all in Access for record keeping. Now I want to merge the main memo with all findings into a word document. The trick part is that the...
  2. B

    Editable Form

    Main form and subform I have found that if you use main form and subform and you make mainform uneditable, then you cannot edit subform either.
  3. B

    How to make zero invisible in form with dataview

    Thanks a lot All great ideas, thank you very much.
  4. B

    How to make zero invisible in form with dataview

    I have a form display project hours and also caculation of total for each project. A user can spend time on multiple projects each day, I would like all zero invisiable. I had tried to set all default values to null (nothing) instead of zero. It causes problem in caculation of total. I...
  5. B

    change one form causing change other

    Changes I have two or three forms which are linked to the same table. I used them for different purposes, one for view, one for add/edit. Forms look the similar with different names, I used save.as to make copy of them. Now if I change one of form, such as adding/deleting/moving around fields...
  6. B

    change one form causing change other

    I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003? Thank you very...
  7. B

    Importing a word document

    No solution so far I am doing research how to import Word doc into access. These are what I have found so far and seem not encourage. 1. If you have a table in Word, you can paste in into Exce; and have it link to access. But if any field in the Word table have more than 255 characteres...
  8. B

    How to make mainform view only while allowing to edit on subform

    May be this is easy for your guys. I want to freeze or lock the mainform data fields while allowing users to input, edit, delete data on a subform. I tried to change mainform properties so it can not edit, add or delete data on mainform. By doing so, I cannot do anything with subform, it seem...
Top Bottom