I am trying to do a merge from Access to Word .. the information is all there ... unfortunately my records are listed one per page (I only have 2 fields per...

I'm following instructions from a thread I found here, which I've posted below. I'm having trouble with one step: As criteria in the query date field...

Hi all The round( 1/4, 1) will display 0.2, round( 2/3,1) will display 0.7 , the first one is not rounded up , but the second is. Could you tell me which...

I have a Summary report that has several subreports. Most of these are based on a data span such as the first to the current day of the month. Now I have coded...

Hi, I have an existing memo field in a table that contain paragraphs of text. When I convert this field to an OLE field, the field shows "Long binary data" in...

I have the following formula, which works correctly, in a report I have created. I use the same formula layout for a number of fields. What this formula...

I have a form letter where when printed will display the OpenArgs statement. Like this: Joe was {OpenArgs} today. Now the problem is that OpenAgs is a...

Folks, I have four subreports in a report in the detail section. I suppose I could move them to the footer of the report. Anyway, if any of them have data,...

Hi, I can successfully turn resizing off and on in the RTF2 sample database by removing and reinserting the resizing code: Private Sub Detail1_Format(Cancel...

I am wondering if it is possible to accurately create sums in this report: I have 2 tables. Orders and Order Details Among other data, Orders contains a...

Hi, I have a report that is based on a query, but I want to use VBA code to force something to display in the textbox, according to what is store in the...

What I have is a report that is listed by Tenant's names. They may have more than one space so the report looks something like below: John Smith 891 ...

Please forgive me if I am double posting, I do not mean to. I need help and did not get a response to "Puzzling Problems" and it does not come up when I...

I'm a little new to using Access, but I have created about five databases for my work. However, I'm unable to format an Access text box with the same format...

Is there a method for sorting a report in the design view by a specific order, not just sort in ascending or descending order?

Hi I posted my question in Forms. However, my question has a form event and a report control box question. I have been searching for some simple way to...

Duane; You answered a post I wrote earlier in the month, and I have been playing around with your suggestions off and on for the last few weeks, and I am...

I copied the following code that was posted last year. This is a difficult situation. I can only come up with one way to get that effect and it requires...

I have used your A2KAutosizeOLEVer6 to create a database that generates reports with pictures and the pictures are autosized. I was wondering if it is possible...

I am trying to use your AutosizeOLE and RTF2 together in one report. this would mean that there would be a rich text field and a OLE field and they both can...