Recent content by JGG

It didn't work, could that be because it was created in Access 2002-03, and I'm now using 2007? Some of the other functions (auto checking one box should check a number of others depending on which is checked, worked while I was still running 2002, but now in 2007, it doesn't seem to be...

:/ I know it's redundant (it was requested by someone who wanted a lot of extras (and who doesn't understand the word "no"), a completed check box as well as date completed being two of them). Sometimes, it can be checked (the check box) without the date field being filled out, however, if...

I'm looking to have a yes/no check box automatically checked if I add a date to another field (If Me.Date_Completed_ = whatever date it is Then Me.Completed = Yes) ...something like this is what it should look like (I think). What is the proper code to write to have what I need done? Please advise.

INSERT INTO [Formatted Host Meter] ( [Host Meter], [Formatted Host Meter] ) SELECT [Copy of ASN as of 08312010].Host_Meter, Replace([Host_Meter],"-","") AS Expr1 FROM [Copy of ASN as of 08312010]; ***I'm trying to append it to a different table, and it's not doing it, I keep getting this...

I need to remove a hyphen from a string, how would I write that in an Append Query? Replace([FieldName],"-"," ") is what I used and it didn't work, please advise!!!