All Tags » form (RSS)

Browse by Tags

  • How to set focus to Word after data export to Word form?

    I have the code below which works to export the information on my Access form into a Word form with the matching fields. 1. This only seems to run if I open Word FIRST; is there a way to get this code to open Word by it self so the user doesn't have to open a blank Word document? 2. In Access VBA...
    Posted to Access Coding/Macros (Forum) by microsoft on 03-10-2010
  • How to get a table count value onto a form

    I have a Form that I would like to place a value/number from a table.(a count) I have a table named students and a field called status. I would like to place the count value of the students who have “enrolled” as their status. What value can I put into a text box on my form that would get this count...
    Posted to Access Forms (Forum) by microsoft on 03-06-2010
  • Include subdatasheet in access form

    I have an access form based on a table with a subdatasheet. I've set the form default view to datasheet. The problem is the subdatasheet doesn't show in the form. I've gone into the properties of the form and set "subdatasheet expanded" to yes and "subdatasheet height"...
    Posted to Access (Forum) by microsoft on 03-06-2010
  • Access VBA - Call Sub Routine In Sub-Form from Master Form

    I've been looking for this for some time and it must be my question language that's the problem. How do I call a sub routine on a sub form from a master form? I'd have thought that it'd be something like Me!SubForm.SubForm_Code. Thanks.
    Posted to Access (Forum) by microsoft on 03-05-2010
  • Unbounded Checkbox in Continuous Form

    I want to add a checkbox to a continuous form for temporarily marking selected records in a muti-user shared environment. I have been asked to do this without adding any new tables or fields to existing tables. I have reviewed as many of the previous ee Q&A as I can find on this topic and have only...
    Posted to Access (Forum) by microsoft on 02-28-2010
  • How to Sum a Calculated Field in a Form Footer   Access 2007

    I have a Form (Datasheet is the default view) that contains a caluated field. (RevisedBill). I want to total all the rows , I created a Text Box in the footer of the form using: =sum(RevisedBill) I get nothing in the box no, error or anything just a blank field. Any help?
    Posted to Access (Forum) by microsoft on 02-25-2010
  • How Do I Dynamically Filter the ADP Combo Box Rowsource?

    Hi, I have a combo box that works great in my MDB using linked tables, and I am trying to migrate it to an ADP. The rowsource property in the MDB is as follows: SELECT SubPeriods.SubStart, SubPeriods.ID_Subperiod, SubPeriods.ID_Plan FROM SubPeriods WHERE ((SubPeriods.ID_Plan)=Forms!AllocationPlanForm...
    Posted to Access (Forum) by microsoft on 02-22-2010
  • Open report based on value in form Access 2003

    HI, I have a form based on a query with a listbox. I would like to have a user select a item in the list box click a button and a report open only showing the related record details for the item selected in the listbox. The listbox returns the primary key value but displays text. I created a blank form...
    Posted to Access (Forum) by microsoft on 02-22-2010
  • Need automatic calculations to be done on an input form.

    We need some automatic calculations to be performed on an input form in Access. For each record, we enter the production cost in field "A"; Printing Costs in field "B" and Misc. Costs in Field "C". We would like a running total to be automaically input in field "D"...
    Posted to Access (Forum) by microsoft on 02-20-2010
  • Brainstorm: PDF Hyperlink into Access Form with Variable

    This is a brainstorm session on methods and hyperlinking INTO an Access Database in Access 2007. Basically, I want to put a link into a PDF file. (The link will be generated by Access in a report, but that is beside the point, and the methods for this are known.) The link needs to 1. Open an Access Database...
    Posted to Access Forms (Forum) by microsoft on 02-18-2010
Page 1 of 66 (652 items) 1 2 3 4 5 Next > ... Last »