Recent content by goldfische

All of the replies have been most helpful, I have everything reading in and out including Apostophes, I ended up using Global constaints as John suggested. I will try chr(180) for inputs on text boxes too. Thank you all again.

Hello again, I didn't think to add this information at the time of my question (I'm sorry) but I am choosing the clients names that are concatenated in a combo box, and then fill the appropriate text boxes on the form. Here is the code I am using to compare the users chosen client to fill...

Hello, I have a question about retrieving last names from an access 2000 database that contain an apostrophe ', like O’Connor. Is there a simple way to have VB bypass all the apostrophes in the database so VB does not think it is a typo in the sql? Thank you for any help given.

Thank you Cajun for the input but I have all the attributes the same and it still compiles that error at run time. What I noticed though when I mouse over DTPDateTwo.Value = Temp!DateTwo, The quotes are separated " " unlike the other two dates variables which contain no white space...

Hello, I have a strange problem with a Date picker, I have a couple on a form that are all the same except for the names. The checkbox is enabled on all of them and the coding is all the same except for their names. One of the DTPickers keeps giving me an error after I add a new...