Search results

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:

Sorry, I don't have an answer for you, but I did some programming with Lotus Notes and Access and I encountered issues with the old version of Lotus Notes. I was restricted because we didn't keep up with LN releases because of going to Outlook - which we're doing right now. So, bottom line...

Hello all, I have a form with several list boxes. After the users makes their selections, I want to pass each listbox to a subroutine to extract the user's selections. All of this work is being done in one form. This is the subroutine: Sub AllListBoxes(lstTemp As ListBox) This is the calling...

Hi - you have to click on the group header not the detail to make it work - but the idea is the same. Open your report in design view, then click on the group header and open the property sheet and then click on the format event for that header (don't forget you may have more than one header...

Hello all, Finally moved to 2010 from 2007 and I have one big problem - how can I turn off all security for my simple, quick-and-dirty application that is used strictly in house. The front-end on the PC, back-end on server. When users open the database, they get two security warnings. 1)...

Hi Lagbolt, I found those articles too, but they didn't help me much because I really need to see real-life examples with code. I found some great help on this site: http://www.accessribbon.de/en/?Downloads The site has great database examples and I found one there that uses not only combo...