Recent content by JohnnyB

Hey Sneuberg, thanks for the ideas. It's failing very quietly. I stepped through the code and there were no errors. I had turned SetWarnings from False to True. I can link to the source database. I did that for the user for a temporary fix, even though it's a violation of the intent of the...

Hi. This one's a jaw scratcher. :banghead: I support a database with about 20 users. It works fine for everyone except one person who was just given access to a new process that works fine for the other three special people who were granted the same access. For reasons beyond my control...

Trevor, THAT WORKED!! Thanks a lot! I had one minor cultural glitch. We Yanks use a date format of "mmddyyyy" and I was using that for my password. Then I looked at your code and saw that you had "ddmmyyyy". I entered the password that way and my spreadsheet opened just fine. I'll have...

Hello All, I have to create a process that breaks down a dataset by email addresses and puts all of the info for each address into a separate Excel workbook. I've got that taken care of. My process creates around 50 separate .xls files that will be emailed out to the 50 individuals. My users...

I fixed it by doing a User DSN instead of System DSN. I'm not sure why that worked, but it did.

I have some users who just got reimaged. Their linked Access databases stopped working and they were got error messages when they tried to use tables connected to a SQL Server database through ODBC. I saw that the ODBC DSN's were gone so I tried to re-establish them. I used odbcad32.exe from the...

Hello everyone, I've been working with Access since the late 90's but there's still so much I don't know, I consider myself a newbie. I'm a member of a few other forums and see a few familiar names here. Looking forward to participating, helping and getting help! John