We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of work. Thanks
I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in the query and could not. IF I...
A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...