Recent content by mark4man

Thanks very much !!! [Actually, they both work.] Thanks again, mark4man

Hello Again... In my company's database...which keeps architectural info & conditions for a homeowners' association...I need to run queries from time to time...that do not have a strict criteria definition. My inspector in the field, for example, enters info on 'Satellite Dishes'...but...

funny you should mention that... ...'cause I can't seem to get back into the Query, itself. When I try...I get the big message that reads: I hit Yes, another message pops up that tells me I am ...but I hit Yes...the Query runs...& that's it. It doesn't open. So...without sounding more...

OK... I'm not using the code entries...I'm using a simple Update Query. But...I just tried it again; & it worked...!!! In my Update To record I entered: [FR STM DR COMM] & "~"...& it worked perfectly...it retained all previously entered data to that column & added an ~ to the end of the line...

Well... That's the answer...the table is entitled: TH Inspection File. But...I've already established what the Table is...when I first create the Query...I don't get it. I should just be required to give that column the update criteria. (???) I.e., if you look at the Query form, the 2nd...

no...that doesn't work...it now asks me for Parameter Values for [tblInfo]. Please...this should be simple...why isn't it working?

odin1701... Let's back up a bit: For my test...the conformity column is titled: FR STM DR I A W. The comments column is entitled: FR STM DR COMM. So I revised your code to: UPDATE tblInfo SET tblInfo.FR STM DR I A W = "Y", tblInfo.FR STM DR COMM = tblInfo.FR STM DR COMM & "~" WHERE...

OK... The Update Query worked like a charm...except for one little thing...in the column that got the "~"...everything else that exists in that column was deleted. I., e., those columns where the "~" will reside (after the update query) is a column labeled Comments. Every database attribute...

Thanks...will give it a whirl when I get back to work on Monday...it's a work thing anyway; & I don't have Access at home. MF BTW - What the h_ll is an SQL, anyway ???

Hello... [I need to know if there is a function...perhaps a Macro or Query...or a more complex 'Find & Replace'...that can accomplish the following...'cause my database is huge; & I'm hoping not to do this manually]: I keep an Access database for my homeowners' association on the condition &...