Search results

It's a nonbreaking space. If it's just an import problem and they aren't used in the body of descriptions instead of regular chr(32) spaces, you could just use the replace function, but it might be easier and safer to replace just that character. I'd probably do this if it were me: update...

Thanks, Gina. This is already a SQL back end, though--using Access 2010 as a front end only. I think I would have found the problem sooner if I hadn't been sick for practically a solid two months! Brain function began to return at the same time normal human color did :) I'm in beta testing...

I finally figured out the problem; it was an issue with required fields and unique keys, but there didn't seem to be an error to trap on the front end. Anyway, all is well now, and I was able to remove a lot of code and also the timestamp fields. Thanks for your thoughts!

Thanks, Dave. Yes, all the subform tables have an autoincrementing identity field that is the primary key on the SQL side. It assigns the ID fine after inserting (visible in the back end), and I can see the id back on the Access side after the form is refreshed. In design view in Access, the...

I feel ridiculous having to ask this question but I've been struggling with it for too long now and have tried/changed so many things I feel like I'm lost in the woods. I am working with SQL2014 for the first time. Our shop is on Access 2010. The back end databases have been set up, all boolean...

I've ended up here numerous times when searching for solutions, and probably like most am joining today because I've got a problem I'm hoping to resolve--but that's for another board! I live in Virginia, USA but will try not to make a yank arse of myself. (too late? well, I promise not to do...