Search results

The following is an extract from the helpfile showing how to reference a subform control. Note the .FORM after the subform name (ctlSubForm) it is the .FORM that takes you to the Sub Form. example showing how to refer to a control named NewData on a subform called ctlSubForm contained in the...

Not sure if I understand the question correctly but you could simply just PRINT the Form containing the chart. You can control which parts of the Form you want to print by setting the forms FORMAT and DISPLAY WHEN properties Hope this helps Trevor from www.accesswatch.co.uk

Addendum to above I have just checked my documentation and it Appears that the Hyperlink SubAddress SHOULD work with Office Documents, Netscape 3.0 or higher and IE 4.0 and higher. Hope this help Trevor from Accesswatch.co.uk

For a Command Button got to Format HYPERLINK ADDRESS and enter the hyperlink address You could also assign the value in code You can also add a Hyperlink Subaddress i.e a 'label' on a HTML form. However a small bug means that the SUBADDRESS does not always work with all browsers notably IE...

You need to REQUERY the subform to pick up the records containing your selection criteria. Look up REQUERY Method in the help file for examples of how to do this Hope this helps Trevor from Accesswatch.co.uk

The following restrictions apply to reports in Access 97 Total width of a Report = 55.87cm (22in) Total Number of nested reports = 3 Number of fields you can SORT or GROUP on = 10 Total number of CONTROLS ans SECTTIONS that may be added to a form over is LIFETIME (note that this is over its...

You can do this by making your report field visible or not visible by referencing the value on the form in code. e.g On your report you have a field called 'txtField01' with a visible property value set to false On your form you have a checkbox with True/False values Yes/No field called...

Just a small rider to David Mack's (100% correct) answer. Don't forget to switch setwarnings back on after you have run your code: DoCmd.SetWarnings True Also add the DoCmd.SetWarnings true into your error handling routines One common 'gotcha' with this type of operation is when one of the...

There are number of ways of doing this. If this is a one off operation then I suggest: 1-Create an intermediate temporary table tblTemp with the same structure as the table you are copying from 2-Copy all your records to the temp table 3-Create a temporay update query to update the number field...

It is possible to code this yourself although it gets very complicated. If you are interested then the 'Access 97 Developer's Handbook'from SYBEX has a whole chapter devoted to this subject. My advice is don't even attempt to do it unless you have a lot of time to spare. A better solution to...

You need to use the DCOUNT (Domain Count) function not the COUNT function. The COUNT function will always work on all records whereas the DCOUNT allows you to set filtering criteria so that you can restrict the number of records counted based on your criteria. DCOUNT can be a little awkward to...

In your Subform: Create a text box called 'txtsfrmTotal' in the footer section of the sub form (Note: Because you are displaying the sub form as a datasheet this new field will not be displayed on screen but you can still refrence it) In the data controlsource of the new textbox 'txtsfrmTotal'...