Recent content by Takashi

Exactly what I needed. Thank you very much.

I already have a crude search setup in my DB using the Access Wizard. It produced the following code: DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 This canned 'find and replace' dialog defaults to match 'Whole Field'. Is there a way to tweak it so the value defaults to 'Any part...

Sorry for taking so long in replying. As for your method, #1 works perfectly is you replace the COUNT with SUM in the SQL statement. Thanks

I want to generate monthly reports containing a count of the number of different types of invoices processed during the month. I want the count of invoices of type "A" to end up in a field called "A", the count of type "B" in a field called "B", etc. I tried using a union query, but the counts...

I need to write a routine that can tell if a query with a specified name already exists. I've already created something that's functional, albiet very crude. Can anyone show me the better way to do this? (I know there must be one) Here's what I'm using now: Query_Name = "XAQ_" &...

Nevermind I fixed the problem with a short VB routine.

OK, splitting each entry and using the 'can shrink' value closes the unsightly gaps. I have one more question though. I have all 60 error messages already in a table [Messages]. Is there a way to lookup the value in the table from the report expression? Something like...

Thanks for the reply. Somehow I figured it would come to that... I'm dreading a scratchbuild simply because the DB is not only large, but *live*. (Only partially funcitonal, but live nonetheless)

I'm trying to draw a report of a table that has many checkboxes (yes/no). Each checkbox corresponds to text statement (stored in another table). I want to design a report that only prints the text statements corresponding to checkboxes with a value of 'yes'. I've tried using...