Search results

You are welcome! It has been an interesting challenge to convert it and I'm happy to have solved your problem. I don't think we see it! ;-)

This database shows how concurrency can be used in MS Access using Doevents. It also shows that if a process is not dessigned to be used concurrently and uses Doevents function in it , you have to prevent it from users to execute multiple times. Concurrency is when two or more tasks can start...

My point is, if the procedure fits on one screen on the top, if not, then before the first use.

No, Richard never uses spaces or puctuation/special characters at all.

Not related with the error but the PtrSafe in the #Else should be deleted.

This is a compilation of different techniques I have found and adapted using images, buttons, labels, etc,

Cascading combo boxes in a continuous can be difficult to do. See this discussion https://www.access-programmers.co.u...boxes-in-datasheet-or-continuous-form.275155/ Semi Unique Combox Record Source on Continuous Form

This screenshot shows the GetTickCount64() behavior of this API after 39 days on a computer turned on (32 bit Access). As you can see the equivalent declarations: Private Declare PtrSafe Function GetTickCount64 Lib "kernel32" Alias "GetTickCount64" () As LongPtr Private Declare PtrSafe Function...

This database has been tested with 32 bit MS ACCESS 2010 and works properly. LongLong type is not allowed in any 32 bit MS ACCESS version

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.