Recent content by shanegroff

This issue will be fixed in Version 2312, which will be released to Current Channel soon.

This issue was fixed in version 2305, Access Releases 14 Issue Fixes in Version 2305 (Released June 1st, 2023) (microsoft.com)

I can't reproduce the error using a table with the specified structure, and the query (I also created a t_OTD_Date table with a DueDate Column of type Date/Time to make the query work). Is there any chance you could provide me with a database that shows the problem? Perhaps the problem only...

By saying you were 'able to find a work-around', do you mean you think there is a bug? Or was there really a 'data mis-match'? Can you provide an example of what wasn't working that you thought should have worked? Or are you just saying that the error message wasn't helpful? Shane

Can you share a simple reproducible case of this? (I mean attach a database that behaves differently in V2304 vs V2305). It has never been allowed to assign Null to a strong variable in VBA. Dim x as String x = Null will fail in any build, v2304, v2305, v2306 or any older build, this is the...

I'm a bit confused here. You say the error occurs on these lines: holder = Me![Dam] & "" or holder = nz(me! Dam,"") but neither of those lines appears in the code sample you provided. If I have this code: Dim holder as String holder = Me![Dam] Which does appear in the code you provided...

Try not to be so pessimistic, Pat. The Access team does review feedback, although there is a lot, so it may take time if only a small number of users are encountering an issue. Matt, it does sound like a problem we should address if it only happens on Windows 11. The easiest way for us to...

Attachment fields will also represent File/Image columns in Dataverse. In any case, though, you should certainly be able to import a table from one Access database into another, regardless of what field types you have. This is a bug (but should be fixed now)

Can you try restarting Access, then try this again?

I'm new to this forum, so I may be missing something, but it doesn't look I can answer individual replies (short of writing a bunch of replies with quoting), so I'll just reply to everyone in one message. Thanks for the welcome. Unfortunately, it's unlikely I'll have much time to pass on hints...

My name is Shane Groff. I'm an engineer on the Access Product Team, and have been for a long time. Indeed, I've worked on every version of Access, even the one that never shipped. There are people who know more about how to build great applications with Access, but few who know more about the...

You don't have to use variables. Your code in cmdClose_Click in the Form_Incidents module says: Call LogError(Err.Number, Err.descripton, "Incidents - check_values") If you change that to Call LogError(Err.Number, Err.Description, "Incidents - check_values") Then it will work. The...