Recent content by TiggerNYC

Thank you for all of your help. I will be working on the VBA version of my QBF... but I figured out my quick fix... I eliminated the (main.open1)= from the code and it worked perfectly... ((Main.OPEN1) Like "*" & IIf([Forms]![frmRpt]![frmsubkeyword].[Form]![F1] Is...

Thanks for the reply...I originally tried it...but gave up (I am newer to utilizing a lot of VBA) because the QBF has 11 subforms and a lot of fields...this seemed to work for everything but searching the memo field... If you have any suggestions which would utilize my current approach, I would...

Here's a weird one...I am using a QBF and it is functioning well...except for searching a memo field. I have 15 boxes that a user and input different keywords to search. Heres the problem...say these are the 3 search keywords: empl lead man It returns all records that match "empl" (11...

The DoEvents seems to be doing the trick...thanks.

Thanks for the advice...I will give it a try on Monday...if I have a problem, I will post the code...either way, I will let you know. I did replace the docmd.runsql with currentdb.execute and it runs faster...and it did help with the hangs...but they still happen...but like I said...not all the...

maybe you should set the format for those fields to m/yyyy or date...that could help...or use the full date in the fields...i.e. 1/1/03...

I am having difficulty with Access hanging using vba for report generation. The module is not complex...opening a QBF, running queries and then the report. (Windows XP, Access XP) - Bkend on Server, Ftend on local machine... Once the report displays...it is not "enabled"...nor is any of...

I successfully nested 15 replace functions...no noticible slow down in generating the report. Thanks.

I was having a brain fart with the nesting of the replace function...I will give it a try... The user may have up to 15 search words...will it be over complicated to nest 15 replace functions?

Sorry that I was unclear...the user will specify any number of search terms...i.e. "process", "technology","career" I need a function that will search the memo field for any/all of those terms and change them to upper case (or other format) to stand out on the report. I don't want to update...

Don't know if this will help, but I had a similar situation...I had to generate a query, but I also needed to see the number of unique user ids in that query in order to know which report to run... Dim rptcount As Long DoCmd.OpenForm "frmrpt2" DoCmd.OpenQuery "qryrpt2" rptcount...

Thanks for the reply. And I can use the function in the report...but how do I handle multiple replaces of the same field? Thanks for the UCase tip...

Hey...I am an access developer...but not with a lot of experience with vba. My database contains a tblMain which has a Comment field. This field is a memo type. I need to be able to replace various strings within the memo field for reporting. i.e. someone requests the search in the comment...