Search results

We have another report with the same issue here.

I am on A365-32 MEC v2510 and I also get the error with the heterogeneous query. The only way I can make it work is to attach the table from test2.accdb. I realize that would be a massive change to the OP's app, and may not be practical.

I think you're now in the "collect more information" phase. Apparently, it works sometimes on some machines. What do they have in common? Soon this may be seen at customer sites too, so it is an urgent issue. Note that MSFT can turn features on and off remotely, so "no changes were made" does...

I speculate that this is a security issue that was "fixed". You may have to fall back to what most people would do: attach the linked table and create the query that way. No IN clause. Surely that still works?

Is E:\ a trusted location as I requested?

At this point I am not convinced that there is a bug. The OP should simplify the problem, and on the failing machine create two new databases with simple names (without any spaces or other funny characters) and put them in a Trusted Location that also is a simple path, and create 2 simple...

It does not happen on my Monthly Enterprise Version v2510. I'm asking another tester to try it on his more aggressive versions.

What is the current version and bitness of Access you are on? What is the previous version where it worked fine?

> Application.SendKeys "%DA" This assumes you are in the VBA editor main window. Sendkeys is always very fragile, but it may be your only resort since there is no programmatic access to the Watch window.

Yes that is a string. I read this code as: we have a form frmAccounts, with a subform Register. The subform has a control CkDate. We're setting fld to CkDate's name. That seems equivalent to: fld = "CkDate" When you hit Debug > Compile, which line of code is highlighted, and what is the error...

> strRange = GetDateRange("CkDate", cboDate.Value) You're sending cboDate.Value to RangeType As Integer Is that really what you wanted? Note that today's date expressed as a number is 46005, which would overflow the integer data type. (in the immediate window) ?CInt(Date) Overflow ?CLng(Date)...

I share my mother tongue with the OP so I understood right away. Same for the UI elements in Dutch. I should have translated "map" for you.

Then you did not follow the instructions from the OP. See #24. Note that the MDE is compiled for 32-bit.

Too bad, so sad, but we do not have access to local variables from VBA (a comparatively VERY simple language). That's why we have to pass them into our function. Python: name = "Alice" age = 30 print(f"My name is {name} and I am {age} years old.") VBA: Debug.Print StringFormat("My name is {0}...

That is indeed what function modStrings.StringToDictionary is for.

Re OpenArgs, I highly recommend borrowing modStrings from the Northwind 2 Developer template, and using it to parse the several OpenArgs arguments that are passed as name/value pairs. I talk about it in this YouTube video, at 35:34.

One possible solution would be to implement a MRU list like we did in Northwind 2 Developer Edition. That gives user a different way to access the 20-or so most recently edited records again.

That is the biggest rub for me so far. It leads to more clicks and more forms popping up to get things done. For many of my customers high-speed data entry is very important. Plus, the aesthetics of it: no dropdowns, no checkboxes, no radio button groups etc. I know beauty is in the eye of the...

You don't have to delete it every time; you can set the SQL property and use it again. I do this all the time for passthrough queries to SQL Server. I create ptTemporary1 through 10, and round-robin pick one, set the SQL statement (usually a call to a recordset returning stored procedure) and...

@Imb: I entered a few persons and groups, then tried to associate a person to a group. Clicking on New PersonGroup I get this form, with yellow textboxes where I was expecting comboboxes. I read that you mostly use textboxes. Are we supposed to type the names here? I found out that in other...