Recent content by dalcazar

Well called good sir, this was indeed the issue. Access was replacing the list separator automatically.

Hi all, I had a query that was working but has since broken due to one of the tables being moved, now I can't get the DatePart function to work. I'm trying to get the year from today's date by using the expression Year: DatePart("yyyy",Date()) This was working before, (although for some reason...

Thanks, you found the source of the problem. It is Date/Time Extended causing the issue, except that I didn't ask Access to make this conversion. It just did it as part of the importation steps. I don't have control over the tables housed in MSSQL and have to go thru my DB admin to get those...

Hi all, I've been trying to get a query working that worked fine previously, but now it refuses to work properly. I'm trying to run a SQL query to append a new value to a table, but it's choking on my date submitted value and throwing a type mismatch 13 error, and I don't think that the problem...

This is solved, and it was a permissions error, not a code problem. We weren't able to diagnose the problem until I tried running a ShellExecute command as an alternative to the regular shell call. At that point the 'Suspicious Macro Detected' red flag came up and generated a block that could...

Hi everyone, I have a piece of code that updates an access front end. It used to run just fine, but it has suddenly started causing a Run-time error '5'. I have made no changes, and I'm able to run the UpdateDbFE.cmd file manually. Can you help me pinpoint what the problem might be? My IT...