Search results

That was the point I was making in post #10 Using Phone Link, the tablet can use the phone's Internet connection where it isn't connected directly using Wifi. Correct?

Why can't you use linked tables?

Using Windows Phone Link, isn't a non-cellular tablet broadly equivalent to a cellular tablet?

This article may be of interest https://www.accessforever.org/post/what-access-versions-are-developers-using-in-2025

The next Access Europe User Group meeting will be on Wednesday 3 Dec 2025 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM). Please note that the UK has now reverted to winter time. For local times, please check World Time Buddy In this session, we are very pleased to welcome...

I'd have thought if you did that too often, it would be your wife who was reliably gone . . . 🙄

And of course I only know to do this from the multiple times I’ve forgotten, run my updated code and lost all my changes.

NEVER run code unless you have saved it first. If it crashes or you close the database, all those code changes will be lost

I wrote the article partly to provide evidence that using a subquery isn't always the optimal solution to every problem. Sometimes the simplest solution is the best. Subqueries can be very useful and are often the only way to solve particular problems. However, using subqueries as the first...

In my limited tests, the fastest approach was the simple unmatched query, significantly so for non indexed fields and marginally so for indexed fields It would need more tests to make a definitive statement about the efficiency of NOT EXISTS vs an unmatched query. However NOT EXISTS is...

Some time ago I did some tests comparing the efficiency (speed) using 3 different methods of finding unmatched records: NOT IN / NOT EXISTS and an unmatched query using IS NULL. By far the slowest method is NOT IN as it cannot make use of any indexing. I would strongly advise using one of the...

For steps 1 & 2, I would create a new blank database and link to the existing tables but not import them Make a local copy of each table. Table structure only without copying the data. Now modify each table as necessary fixing field names, adding validation rules etc. Then create append...

As this is an Access forum, perhaps a (Y)ule of mods - as in module . . . 🤣 Or a rater of mods . . .OK sorry I'll stop now As for the mod of mods, I think the ideal characteristic would be to do the job so well, they would make themself redundant. In this particular case, I think that has...

I'll just add one final comment before I ignore all future threads from you. Feel free to ignore me as well. Back in post #2, I gave you outline instructions on how to remove / add line numbers. You made no mention of that in your later responses. I deliberately didn't give you the code as I...

Despite the numerous questions of this type that you post, and the often lengthy and detailed responses from many experienced developers on this forum, I have never yet seen you provide a working example that you have then gone on to code yourself. If I'm wrong and you have created useful code...

This looks like yet another of your many purely speculative questions that you have no intention of doing. As you stated, VBE add-ins such as MZTools & VBE_Extras do the job perfectly well so its probably a purely academic exercise. However, you could in theory do this with VBE Extensibility...

Yes I did! Its now working perfectly again for me. I changed the order of your code and added an extra line .UserControl=True It now also works with .Visible = False though that makes no difference as Access is still displayed As @arnelgp suggests, the Access interface (not the form) could be...

Tested in 365 Current Channel version 2510 build 19328.20244 64-bit It works reliably and consistently for me with .visible = true. Double click anywhere in Excel. Access opens specified database & opens the form normally. I had moved it to a different folder and set the location as trusted...

Can you upload a simple repro database and example Excel file that demonstrates the issue

The issue isn't specifically about cross posting itself but not stating you have done so. Please read this article about the etiquette related to cross posting. https://excelguru.ca/a-message-to-forum-cross-posters/ Then please go to the other forum and add a link back to this thread