Recent content by rsACC99

My Office 2019 spreadsheets get tables & queries from Access. Sometimes, when i want to refresh connections the error "ODBC Microsoft Access Driver 'C:\...' is not a valid Path. Make sure the path name is spelled correctly..." occurs. The path the error references was the correct path on my...

Thanks for this clear info. I think I've got this working now.

I have never been able to declare a Public Variable that is available to another module. The instructions seem simple: use the word 'Public' and and put the declaration in the Declaration section, but I always get the 'Variable Not Defined' error Questions: Is the Declaration section the...

Been a member some time now, so maybe should get rid of access-programmers login message suggesting I say 'hello'. Started out with dBase doing microbiology research back in the DOS days. Needed to replace a paper notebook of bacterial isolates with a searchable database. Duh! Eventually...