Search results

You can send me a small sample and I will take a look at it.

I really don't think that you can do this. I have made dozens of charts for reports and each chart still requires an underlying source to base its information on. Just a thought, but you might be able to have a form with an underlying table with fields such as Value1, Value2, Value3, etc...

I think what you are referring to is RTF (Rich Text Formatting) and Access does not allow for that. The format that you choose will cover the complete data for the field. There are some Add-Ins that have this feature that can be incorporated into Access to achieve this feature. Maybe...

Go into your main tools and click Options. Then go into Edit/Find and unclick all options in the Confirm Box.

Create a query that contains all the fields that you want on the report and then use this query as the recordsource for the report. - Or If all of the fields are contained within 1 table, then just set the table as the recordsource.

Continue with the idea of using a Crosstab Query for this report with your Status Field being your Row Heading and your Sex Field being your Column Heading and your counts being your Value. On your report, create the additional calculation fields to hold the sub-totals, totals and percentages.

It still seems to me as though your set-up is not correct. If you can, send me an small example of the problem.

Check the references on the computer where it does not work and make sure that the same references have been checked. Look for your Microsoft Word Object Libary.

If I understand your question, you are trying to print a report, using criteria from 2 different fields. Try using the following. Private Sub Print_Click(Cancel As Integer) On Error GoTo Err_Print_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

Could you not use subreports within a main report in Access and then bring together using the Master/Child linking. By the way - how many fields are you using.

I would first open up a form in design view and then go into the coding and check to see if all required references have been checked. Next step is to make sure that the program is complied. Report back if you are still having problems.

There is no way. But if you want to achieve a colour effect, create a small bitmap and use this.

1 - In your table, create a Yes/No field and call it Printed 2 - In your form, on the Print Button, put the following code as an Event Procedure in the On Enter: Private Sub Print_Enter() On Error GoTo Print_Enter_Err Forms!MyFormName!Printed = True Print_Enter_Exit: Exit Sub...

What happens if the record is lost or destroyed or requires an additional copy. I would set up an additional field in my form to hold a checkbox, that when the report is printed would update the checkbox to true to show that it has been printed.

Check your margin settings in both the actual label and the total page. Make sure that it is not creating a run-off.

You dont have to change it, you just have to use the insert tab page and for each page, just use the fields that you would like displayed on them. The forms underlying recordsource does not need to be changed. If you already have your form made up, then just insert the tab control underneath...

David: Check your e-mail. Carol [This message has been edited by Carol (edited 07-12-2001).]

There are various ways to accomplish this, but the easiest way for you to see how this is performed is by the following: In your underlying query for your report, create additional fields to handle the value portion of 1 for entry and 0 for null following the example below...

First make a query that holds all the fields that you want displayed within the report. Make sure that one of the fields contains a common ID such as CustomerID. Next make a command button on the form and set the event procedure for On Click, that would be the following: Private Sub...

As with any program, the printer set-up is defaulted to any printer set up within the actual computer. Your problem seems to be from an internal set-up. Try going into the page set-up and see if another printer has been set as the Default printer for this form/report only through the Page Tab.