Recent content by mboe

I have a report with a subreport for detail. The report has a couple customers who end up having what looks like identical subreports showing up in the detail when I run the report. I have found one case where the subreport is returning slightly different data. I only have one subreport in...

Thanks Brent, I think putting the vbTextCompare did it for me. Thanks a ton... Thanks for the cleaner code on the space replacement as well. I was meaning to get around to that after I fixed the first problem.

George, Could you give me a practical example in VBA?

Sorry if I didn't make it clear. It does not always find and replace strings like the following: strfield = Replace(strfield, " ST ", " ") strfield = Replace(strfield, " DR ", " ") strfield = Replace(strfield, " RD ", " ") strfield = Replace(strfield, " Ave ", " ") So it will get rid of 95%...

Sorry about that I think I posted the wrong query. The field I am scrubbing is teststreet. INSERT INTO 02_Address_List_Single_CIF ( CIF_NO, ADDRESS_NO, Address, City, State, Zip, Test_Full, POBox, Street, TestPOBox, TestStreet, ScrubAddress ) SELECT [01_Address_list_Full].CIF_NO...

Here is the query I was using it in. SELECT [03_Address_List_Household].testpobox, [03_Address_List_Household].AddressID, [03_Address_List_Household].Address, [03_Address_List_Household].City, [03_Address_List_Household].State, [03_Address_List_Household].Zip...

I am using 2003 but I can't post the database because of privacy issues

I have a function that is run as part of a query for scrubbing addresses in order to eliminate duplicates. To help find dups I get rid of things like ST and RD because they are not always included in the address. I thought it was working but noticed that in some cases, and I can't figure out...

I need to standardize some address fields. I am having a problem with splitting number and letters in a address field. For example: 2400N Main Street trying to switch to 2400 N Main Street I can't figure out how to update this in VBA. I tried a update query and can get the criteria to...

Apparently I am not getting enough sleep. Thanks.

I have two identical tables with one being created by coping the structure of the other. Table A is my primary table. Table B is my new data imported table. I created a Update query with a dlookup to update Table A's address field from Table B. All records fail to append due to type...

Did you ever fix the problem with only one line of data showing? I need to build a similar report. Mike

ppoindexter Do txtStart and txtEnd contain a formula or are they pulling from the underlying query? If they contain a formula you may have to use that in you sum formula instead of the "txtStart" reference. If their source is a field in an underlying table/query then I believe you should...

Can you duplicate the logic from your onformat code. Something like: count(iif(Me.ReportDate.Value > Me!txtStart.Value And Me.ReportDate.Value < Me!txtEnd.Value ,0,1)) It will check the value and assign a 0 if it's in the parameters a 1 if out and then count all the ones. I just typed this...

I got it working. I think I just needed to error trap some field values.