Search results for query: *

I have a report that I need to have the text justified both left and right. A richtext box control only left or right justifies but not both. I was thinking there might be a way to use a Word object to accomplish this. The report I am printing out is a Word document with a textbox control on it...

MichaelRed, I don't have a problem doing a two pass process. It won't affect the recordsource. If you could, please elaborate on how I might "Run" the report one time without it actually printing. I was trying to view the report and in code show each page but I couldn't get the...

I have a report that I want to print a table of contents at the beginning of the report. I have found a way to do this but it involves printing the main report and then printing a seperate cover page for the table of contents. The only way I have been able to get this to work is to create a...

John, Thanks, this will work but to do this you print your report and then the table of contents. I want to print the table of contents with the report. I was thinking of having the Table of contents in a report header and then the report. Is it possible to print the report without it actually...

I have a report that I need to put a table of contents in the Report Header. How can I determine the page number that each group starts on? I cannot find a page property that I think would give me all the different pages. I hope you can help! Thanks in advance Rick

I have a form with a combobox that is used to find a certain data member. The form has many textboxes that display the results of the search. The textboxes are bound to the database. I want to be able to make changes to the data on the form and then have the option to save the changes by...

I have a form that has a combobox that I use for a search field. Also on that form there are several text boxes that reflect the different fields of the database. The textboxes are bound to the database so that changes can be made easily.When a person selects a data member in the combobox the...

The Limit to list property is set to yes. When I try to change it, I get the message that one of the column widths are set to 0. When I change the width, I get the Id field in the combo box also. I only want the Emp Id to show in the combo box. This is so easy in VB! Any other ideas? Thanks Rick

I have a form with a combo box with all the Employee id's in it (cmbCDC). And on the form I have text boxes with the data for all the fields in the table ie: Name, ID, SSN, DOB, etc. When I input info in the cmbCDC that is not in the list I want a message box to pop up and ask if you want to add...

I have a form that has a combo box and if the user types in a value that is not in the list I have a message box pop up to ask if the user wants to add the value. If the user wants to add the value, the value is added to the database and then the value is placed into a text box. I can get the...

I have a text box that I want the info in the window to be the data selected. In VB I can use the TopIndex property and Selected properties to achieve this but I can't figure out how to do this in Access. In other words, the list box has the following values: "ON";"Off&quot...

Thanks a million! I knew it could be done, but I was trying to do it like I do in VB and that was with the COUNT function. Well now I know! Thanks a million! Rick

I have a report based on a query. In that report I have a field that has 4 different values ie: Yes, Pending, No, and null. I have a text box in the report footer that I want to display the total number of ocurrences of "Yes" and "Pending". For some reason I cannot get the...