Search results

On the same lines as above, if you have 32-bit Office in 64-bit Windows, the paths to Word & Excel need to be modified e.g. for Word to C:\Program Files (x86)\Microsoft Office\root\Office16\MSWORD.OLB For Excel, it should be: C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE (not...

Although not the standard method, you can run a progress meter on a timer. See my example app: Progress Bar (isladogs.co.uk) I really wouldn't recommend you try to do so for this purpose. Instead show a message to indicate something is happening e.g. Loading Report . . . Do bear in mind that...

If it works for you, that's fine. I find neither works reliably.

I disagree with part of this statement. Not sure what 'pure' means in this context. 1. I can safely drag & drop almost (*) any object: which isn't open. Other unrelated objects can be open without problems 2. The object being dragged must first be saved if any changes have been made. 3. The two...

My response was for anyone reading this thread. I do suggest you try creating database object shortcuts on the desktop with only one database open. At the very least, that's one thing to eliminate

I agree with Tom. Error 3734 can occur when a database is already open as a background process Using Access 365 & Windows 10, the functionality has not changed. I have just re-tested to confirm this In fact I created a video on this topic a couple of years ago I don't have Windows 11 but have...

I have several articles on filtering and sorting continuous forms. You could start by looking at this summary article with multiple links to other articles and videos https://www.isladogs.co.uk/add-features-forms/index.html

No problem. I thought comments with replies could only be deleted by the video owner. Clearly I was wrong about that which is useful to know

@Gasman You commented about the download link below the video on YouTube. There were links on that page but I've since changed it to the specific page: http://dev-soln.com/access-shortcut-right-click-tool/ However both your comment & my reply have disappeared. Did you delete your comment? I...

As already mentioned, I'm pleased you've upgraded. I was just explaining how some versions of Office can be purchased so cheaply. I've done it myself in the past & so I know some of the potential issues.

The video of Dale Fye's very interesting and highly informative presentation to Access Europe on Wed 3 April is now available on YouTube. A PDF of the presentation together with links to all downloads is also available from https://www.isladogs.co.uk/aeu-26

2019 is only available as C2R Most 'cheap' Office licenses are where a volume license has been obtained by the reseller who then sells on a number of licenses with the same license key. You may find that you cannot obtain monthly updates for the software.

If you upload a database, it is a bad idea to lock it down. That may be why 15 people before me had downloaded this & not responded It looks to me that you don't understand the APIs that you have used in several modules. If you had, I doubt you would be asking this question You cannot move your...

I have an example app that you can adapt for this purpose: https://www.isladogs.co.uk/limit-records/index.html Related video:

Hooray. You finally updated. Why 2019 though rather than 2021 or 365? On my machine, ACCDT files are associated with Access However for info, ACCDT files are not actually Access databases. They are a collection of objects zipped together in a bundle which when extracted create all the...

You can indeed show/hide columns using the datasheet context menu. However, this provides an alternative method that may be more convenient if you have a lots of columns. I'm also wondering whether the approach may be of use to someone at Utter Access forum who wants to select a datasheet...

Not possible. At the moment New Outlook is only loaded if the toggle switch is implemented. In any case, I believe you use older versions of Office so won't be affected.

Yes but I’m not sure which details are publicly available info and how much is still subject to NDA. I can confirm that New Outlook is definitely going ahead and will not support VBA or automation. However the current Outlook will be part of Office 2024 and will be supported at least until 2029...

REMINDER Do join us for the next Access Europe User Group meeting tomorrow (WED 3 April) at 18:00 (6 PM ) UK time when Dale Fye will be leading a session on Command Bars , his Access Shortcut Tool and a simple Audit Log. For full details and connection info, see post #1

I particularly liked this post from Juan Soto: Breaking News: Access and Excel to Merge in 2024, Introducing “AccXel”! - Access developer (accessexperts.com)