Recent content by neilhwilliams

It was a bit naive, but I got away with it once. I like the assumption that I have access to multi versions of accessdb ! It was only a one off so not worth the investment. If my fix doesn't work, I'll just sit in the client's office and do the work. It's only half a mile away and the...

Thanks Ginawhipp. I wonder if I take the encryption off again it will be ok, or is the damage done?

Hmmm. Thanks for that... however... I have made changes to this before in the same manner without the same issue... So not sure that's the problem.....and the save dialog doesn't allow me to save it as anything but 'Microsoft Access database'... it doesn't offer alternatives such as 2.0 or 2007...

HI, My name is Neil and I've been involved with Access on and off (and database design) for 25 years. My biggest successes were in using Access as middleware when converting data from several sources and importing to bespoke databases. I've also used business objects extensively I haven't...

Hi, I brought away a client's access 2007 db and made changes to it. I only have access 2010, so I made the chages within there. When I took the db back to the client, it came up with a message that the file either wasn't a db or it was corrupt. Does this sound like a backward compatibility...

Thanks RODMC, I did realise where I was going wrong. I was trying to populate the box with values from the qry that obviously hadn't yet been executed !! I'm a bit rusty. I've now populated the boxes with the correct values from the root tables and they work fine. Well, they would if the tables...

Hi Chaps, I followed the advice here and can make this work beautifully when I use text boxes (unbound); but I have absolutely no idea how to use this with a combo box as you suggest here. How would I pre populate the combobox drop down with the values in my source qry ?! Regards, Neil