Search results

Until recently I thought that we couldn't call APIs that return a LongLong values using 32bit MSACCESS. That's not true! There is a workaround. I came across that we can use these APIs if the return value in 32 bitness is the same size as LongLong type (8 bytes), for example; Currency or UDT...

This is a new version of the PictureBox converted to x64. In the first version there were two buttons that didn't work because they depend on a call (VarPtrArray) used in VB5 (msvbvm50.dll), now I've changed that reference for another one than comes with VBA7. (VBE7.dll) Now, I think the sample...

Ok, perhaps I'll try to convert it, but as you know it's not a piece of cake! ;-)

Hi @theDBguy, No unfortunately I don't have a 64-bit version of Leban's API calendar.

Here it's the vba7/64 bit version of the PictureBox database by Lebans. I hope it would be useful/helpful.

A simple way to do it would be: Create a table with all the Id possibles (for example in Excel and attach that table) Create a query with not matching records as @ebs17 has posted.

After some tests, I see no difference: Both accept parameters and both can return a value.

Surprising and very interesting! Thanks for sharing.

I think the problem is that you are moving the mails in the For Each you are looping. First of all, I'd try to execute the code without moving the mail: (oldMail.Move objDestFolder). If it works properly then I suggest you to copy the mails into a new Collection and loop through it instead of...

Yes, you can store instances of classes with several attributes.

Thanks Andre, That's what I do, reinstall it every now an then.

You have to download Office 365 runtime. It detects wich version of Office you have and installs the right version acorfing it (365, 2021 or 2019)

Open ms access with the /decompile parameter: MSACCESS.EXE /DECOMPILE And recompile the code again

lhooker Do you use the old Outlook or the new one? The code works properly on my computer using the "old version" of Outlook 365, using the new version of Outlook that code won't work never ever!

I think the problem is that in your For Each tdf In dbs.Tabledef loop, you delete the tabledef (dbs.TableDefs.Delete) before you create the new link ,and when you delete an item all tabledef elements in dbs are renumbered. Because of this, it seems there are missing and duplicated tables. You...

Do you assign or reassign Set db=CurrentDb() after reconnecting SQL server tables?

Hello. I've been using V-Tools for MSAccess by Skrol 29 for many years. For my developing tasks, it's a "must" tool in MSAccess. Thanks Scrol 29. Recently, I upgraded to Office 365, and installed V-Tools with no issues and it worked properly for some days, but every now and then it dissapears...

Hi, Notiophilus My approach is that for testing if the comment is null or not would be easier if you change the Recordsource of the form joining the two tables and then inserting the comment Textbox invisible. I uploaded my approach.

Hi @CJ_London, This is my approach to the topic and my first post. After many years looking for a solution, I think I found and easy way to do it! I've attached a database with an example using an On/Off image and a tri-state image in a continuous form and a transparent button over them. The...

I'm 57 and I've been working with Access since Access 2 and I still love it. I live in Girona(Spain) .