Recent content by prlsol

Dave, Do you actually read the posts or the answers? Your answers either repeat something already said or answer a situation not described in the question.

I just realized you are missing a vital piece if you actually try to execute this sql - It should be 'Select * From TblPcrMain Where .......". This would return all fields in the table. If you didn't want all the fields you would list them as in 'Select Name, Address, Zip from TblPcrMain Where...

That line compiles fine for me. Do you get the error when you try to execute the sql or just when the variable is assigned?

You also should come up with some naming syntax convention to make identifying your variables easier. One common scheme is to prefix module level variables with 'm' and global variables with 'g'. This would be the three different versions: Dim sMyString as String 'Procedure level...

I have had forms with the VBA module corrupted before but I could create a new db and import all the objects into it and be good to go. It sounds like you have entered another level of hell. I can give you a few suggestions you may or may not have already tried. First, I would uninstall Access...