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...

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...

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"...

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.

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...

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?

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...

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...

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"...

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...