Recent content by RHubbard

I have a form called [frmConfiguration] which is parent to the subfom [Formation Setup Date Section] in which are recorded the dates of revisions to information in [frmConfiguration]. In the footer of the subform [frmRevisionDates] I have a text box [txtCountDates] that counts the number of...

I have a database query that returns the following result from a 3 column table: The first column is “Sentence_ID” The Second Column is “Word_ID” (the PKF Field and sort field) The third column is “Word_Used” A 1 The A 2 Quick A 3 Brown A 4 fox A 5 jumped A 6 over A 7 the A 8 gate B 9...

Thanks for the help Paul. Sorry I coudn't explain what I was trying to achieve a little more clear, but nevertheless, you NAILED the solution for me.:) Rick

Ah yes, good point! The conditionas are straightforward. When a field field is populated with text, it needs to be colored. That is simple enough, however the colors need to vary. If, for example, fields for Name1, Name2 and Name3 are all populated, the color of all three shouldbe the same...

I have a simple database but with roughly 30,000 name records in it. Each name record consists of three elements Name1; Name2; Name3 (similar to first, middle and last). Not all three elements are present in every record. The possible combinations for any given record are as follows: [Hussein]...

The ability to apply rich text formatting to memo fields (in Access 2007/2010) is quite helpful for me, however I wonder if there is a way to apply the same RTF formatting to multiple memo records (all at the same time)? As it is now, I need to go to each individual record and change the...

A report that I use fairly frequently has suddenly started "hiding" the Page Header and Footer on the FIRST PAGE of the report. It displays properly on all subsequent pages. I noticed too, that the first time I tried to run the report today that the Page Margin settings had all reverted to 0"...

I am using Access to double check some statistical analyses done “pre-computer” and published in book form some 70 years ago. So far I have been able to duplicate the analyses quite successfully, so that part of the project is not a problem. There is one feature of the printed document from...

I am having problems with the following code that is in the On Format event in the detail section of a report. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) ‘*************************** ‘ Change font color when translator name is “L” for Lamdin ‘ ”PM” for Patterson-Meyer...

Here is another off-beat problem that I need help with. I am working with a large Access database of foreign language (Greek) words that is being used to create a dictionary. The Greek alphabet is represented by translated western (“English”) letters. A True Type font makes the letters display...

I have a report with multiple columns. The REPEAT SECTION property of the Group Header is set to "Yes" (so it repeats when there are more detail records than there is space in the column). This is a nice feature but I am constantly replying to complaints from report users who claim data is...

I have a large report (+/-300 pp) where the field for each item in the Group Header is shaded grey. When the report is generated, I would like to be able to programmatically change the Group Header data item shading to other colors based on the text value of another field associated with the...

Ooops- Never mind, I found it! Thanks again! Rick

Hi Ken- Thanks for the hint. I looked at the sample DB and I might be able to make this work (in a convoluted sort of way). The only problem is, I can't seem to find where the code is that makes this work. What am I missing? Rick

I am trying to devise a way to display query results in a row instead of a column. The table on which the query is built has this structure: Column1: Index (pkf) Column2: Group (int) Column3: Position (int) Column3: ItemCode (txt) When I do a select query, the data comes back like this: Group...