Recent content by Magster

I stumbled upon the answer today and I wanted to share it. There is a PlainText function which can be used in a query which returns a string formatted as plain text! This will remove my red color. Thanks again to PJPoorman!

Hello again! Now that I have my search text highlighted red in my rich text field - and it prints out red in my report which is what I wanted - I now have to change the text back to black after the user is done with that particular search. There may be several rows that match the search...

It's working now! I put the code into the form that I was using for my search and I made the color change there and when the report runs, the search text is red! Since this search value changes and I can't keep the red text, I'll just make sure to set the field color back to black when...

Thank you for your reply... and I think I'm almost there but, I can't quite get this to work. I put your code in detail format event of my report. The code runs until the last line of code: me.Text0 = strTemp ( I used my field name which is me.TxtContactHistory), I can see that red tags have...

The first thing you have to do is decide what combination of fields will make your record unique. The easiest way to think about this is if you are building a table of cities within a country - an example would be San Jose within Calif within the US. So your unique index would be a combination...

You could create a unique index on the table that would prevent duplicates from being added into the table.

Hello all, I'm using Access 2010. I'm passing a string into the OpenArgs of my report - works fine. In the report there are 3 rich text fields which may contain the text I passed in, and if so I want to change the color of that text to red so it stands out. The value passed to the report...

I had the same problem, but I found this code in some of the chat about this routine. Apparently for some wierd reason, only the lower case "i" doesn't work. Put this code in the onKeyPress event on the SearchFor field, it works fine: Private Sub Text1_Keypress(KeyAscii as Integer) KeyAscii =...

Thanks Paul - I totally forgot about the nz() function. I was too focused on what I was sending into the function rather than what was returning to me. Again - I truly appreciate the help - and so quickly!

Good morning! I am struggling with this - so I hope someone can help! Mycode works great when I use the DCount function, but fails when I change it to DSum which errors with: Error 94 - invalid use of null. dblCntr = DSum("[intEventCount]", "tblResourceEvents", "[ResourceEventTypeID] = " &...

Thank you again - I'll have to give that a try.

Thank you - I did have an error in setting up the combo box. I was using a union query that I added another field to and that became the bound column by mistake. I guess I got "wound up" about the syntax because I couldn't specifiy column(0) or column(1) as I thought I should be able to. That...

I have a combo box on a form where I allow the user to pick an office. The primary key is the bound column which I then want to use in a stored query to limit the query results to the specific office selected. I can easily do this with the docmd.runSQL in the module, but I'd like to use a stored...

Perfect! Thanks so much - you've helped me again! :)

Hello all, I have report header and footer pages in my report that I don't want to include in my page count. How do I exclude these pages? Thanks! Magster:confused: