Browse by Tags

  • ACCESS 2003 - HOW TO REFRESH/REQUERY THE QUERY IN SUBFORM AFTER RECORDS ARE DELETED

    USING VBA TO DELETE A RECORD ON A TABLE/QUERY BEING VIEWED IN A FORM, HOW CAN I REFRESH (NAMES IN PARENTHESES) THE TABLE/QUERY WHILE THE USER IS STILL VIEWING IT IN THE FORMS' SUBFORM ..... HERE'S THE HIERARCHY OF CONTROLS, ETC. A QUERY (QRY_ASSIGNED) ...ON A SUBFORM (QRY_ASSIGNED_SUBFORM) ....
    Posted to Access Forms (Forum) by microsoft on 04-15-2010
  • Access 2003 Print Form Command Button

    Hello, I have a form in Access 2003 that I placed a print form button on. I used the command button wizard for the button. When I press the button it pulls up the print interface but will only let me print to a .xps document format. It won't let me select any of my local or network printers. Is there...
    Posted to Access Forms (Forum) by microsoft on 04-10-2010
  • Form Dirty Values Lost on Forms 2.0 Scrollbar Methods :(

    I have an unbound form that is using a VBA timer event to periodically update the position of an unbound scrollbar. There's just one annoying problem with this. Every time the timer fires, it deletes any dirty value being edited in a text box field at the time. For example: In an empty text box I...
    Posted to Access (Forum) by microsoft on 01-02-2010
  • How to filter a report from a form?

    How to pull a report filter from a form? I have the following but when I run a bubble pops up asking me for the information in the form. I am close but not close enough. Thank you !!! Code Snippet: 1: DoCmd.OpenReport stDocName, acPreview, , "[Customer #] = [frmCustomerSearch]![Customer #]"...
    Posted to Visual Interdev (Forum) by microsoft on 11-14-2009
  • Access 2003, Refresh Form Data

    I have an append query that inserts data into a table. This table is being viewed through a form. However, I can not see the newly imported data in the form until I close the form and re-open. I have added a "refresh" button below to refresh the data. However, it is not working? Table: Dispute...
    Posted to Access Forms (Forum) by microsoft on 06-29-2009
Page 1 of 1 (5 items)