Search results

Thanks for the input. It works well. I see that the result does not show if the difference is positive or negative. I tried creating a second column giving a code indicating whether time-1 was less than time-2 or vise versa. This will have an impact if I do another query to categorize the...

I am wanting to subtract two time values: Time-1 minus Time-2. In some instances Time-1 will be less than Time-2, other times it will be greater than Time-2 and at other times both will be the same. I want to create categories of the differences (less than 15 minutes, between 15 and 30...

Thanks for responses-- Thanks for both of your responses. I ended up creating the new db and importing the objects. It works. Just one of those things, I guess. Paul

Thanks for your reply-- It is a bound control. The strange thing is that sometimes the data is there and other times I just get the name of the control. I haven't been able to determine the predesposing factors for this. Paul

Hi, all-- I recently downloaded the Lebans RTF control (recommended by a user on this forum). I want to use it to allow formatting within a memo field. Although I havRTF2 Control Design View Windowe it basically set up, it seems that I keep losing the use of the "RTF2 Control Design View...

A simple question: Does each user have to do their own page setup for a report? Is there a way of configuring the page margins so it is universal? thanks.

Hi, all-- I don't recall having this problem before and it's very irritating! I keep losing the margin settings that I have saved in multiple reports in a new database that I just developed. I save them using page-setup in the report design mode. The margins only last a little while, then it...

Hi, all-- I want to use an RTF2 control in a report for a memo field due to varying formatting within the data in the field. However, each record's content is of quite varying length--some records will require more than one page in a report. Is there any way to "grow" the control so the...

Hi, All-- Everything was going fine in my new database when suddenly I started getting "Module Not Found" messages when using command buttons on my forms. It is happening on all forms. I tried compacting and repairing and compiling the code (get the error then, too). Any ideas? I'm using...

Thanks-- Interesting--I'll give it a try. Thanks.

Is there a way, either in a form or report, to modify the format of a text string within a field? Basically, we are gathering text data using a memo field (due to the amount of data) and would like to highlight sections of the text by making it bold. It does appear that in Access a field is...

Thanks to all who replied!

Thanks-- Thanks-- I'll check it out.

Hi, all-- I am trying to create a continuous form (in lieu of a report) that will allow variations in the size of the primary text box that will hold different quanties of text. I thought this would be simple--just set the CanGrow property of the text box to "Yes". It's not happening. Is...

Thanks for replying. I don't see the reversal-- The destination is a recordset called "rstReport". The source is rst3. I had similar (but not identical) loops for rst1 and rst2 and didn't have a problem. Thanks. Paul

Greatings, all-- I am getting an 3021 error message (no current record) for the following code. I am relatively new at coding and this is the most complex I have ever gotten. Although the loop is supposed to end at the end of rst3 recordset, it seems to keep going. The error occurs on the...

Hi, all-- I want to use my database for a mailing. The envelope for the mailing is an unusual size, 5 1/4" x 5 1/4". Its a greeting card. In the page setup window for the report, I don't seem to have that option or a custome option. Is there a way to do this, so I don't have to do labels...

Thanks for your response-- I'm not finding where to do the setup you suggested for page 1 trayx and page 2 trayy. I checked the report properties and the page set-up properties. thanks. Paul

Hi, all-- I am doing a report to use for a mail/merge mailing. The mailing will end up being two pages. When I print, I want the first page to be letterhead and the second plain (but colored) paper. Since Access see this just as report of over 200 pages and not a paired document, is there a...

Thanks--much appreciated.