Search Result

My main form contains as tab control. The first tab contains nothing but a suform whose ControlSource is a select query. When the form is opened the results of the query are displayed in the subform. It is a thing of beauty.

Here is my question: The subform has only two events (Enter and Exit). How do I tell when the record selection changes. Or which record is actually selected. There are no controls, as such, on the subform....

Hi,

I would like to prevent movement of the category, axis, data and filter fields of a Pivot Chart in a subform. I do not want the user to tinker and begin moving data fields (e.g. SumofTotal).

The idea is for the user to view the displayed bar charts in this subform.

While the subform is based on a query, I do not see any property in design view that would stop a user from manipulating these fields....

Hi again!

I have a form (parent) that has a subform (child). I know how to make it so the parent form's feilds opens up null, but I need the subform (child) to open up null, too, when this form opens up.

From the parent form the subform populates symbols based on the parent form which has some combo boxes to choose from and one text box to enter a number into. When the end user enters or choses the data in the parent...

Hello. I have reversed a notes field in a subform so that the latest notes appear at the top. I wish to have the 'new field' available at the top, rather than at the foot of the list which is defaul. Can anyone suggest a way of achieving this. Many thanks. Sue

Hi,

I've made a multi user (4 end users) database in Access 2000. I've made data tables, reference tables etc which sits on a shared drive and I've made individual front ends for the end users which gives them specific views of the data.
I'd like to track all the changes made to a record which works find with the following code :
basAuditTrail:
...

I have created a program for our company in Access 2003 that allows users to track inventory, pricing and create purchase orders. I have also created a similar table for tickets. My purchase order table has a primary key assigned that we use for a Purchase order#. The Customer info is contained in this form. The actual product info is contained in a subform which is tied to the form by the Purchase order #. I have structured the Tickets similar....

I have a form (Form1) which contains basic Project data and a subform listing the personnel assigned to the Project as a continuous form. Selecting a person on that project and clicking on a command button will open a new form (Form2).

Form2 has two subforms. Both are embedded in the main form. (Subform2 is NOT embedded in subform1.) Subform1 displays records as a continuous form based on the Primary ID of the main form and lists...