Search results

I don't think there are a real speed difference on most of databases. CurrentlyI install x64 on my clients but there is no real improvement on my applications.

@andymartin3186, have you tested exporting the query to Excel directly? Does it work properly?

When you call .Update on a DAO Recordset, the current record’s buffer is written to the database and may be repositioned or refreshed — depending on the recordset type and underlying query. This means that the record you were editing might no longer be current, or DAO needs to requery to see...

Another one: RS("EmailID")

Hi @dalski, this tutorial is by Doug Steele. No credits for me, but thanks.😉

@Mark has explained what the problem is. A simple way to avoid going to a new record is changing this line on your create Invoice button: Richard Rost would be happy to see this database. ;)

Perhaps these functions are useful for someone. I use them for saving and loading *.MSG Files. I don't remember where I found them: 'For Windows 2000 or later. Requires a reference to: ' Microsoft CDO For Windows Library ' Microsoft ActiveX Data Objects 2.5 Library Function...

Quick answer: Yes! Some information: https://nolongerset.com/outlook-alt/

I don't use DoCmd.SenbObject but CDO works properly in Access365.

This post is 13 years old, so it might be oudated! I've tested (not worked) with 64 bit MSFORMS in MS ACCESS with no issues.

After two years of the OP, I would like to know what happened with the project!:unsure:

And continue with this other one: https://www.devhut.net/adding-speech-recognition-to-your-application/

I remembar that once I solved the same issue by changing the user monitor to a much larger one that also had the same recommended resolution (1920x1080).

After some tests, it seems that the name that appears in the VBA References "dropdown" is the name of the VBA Project, not the database file name:

When you have changed the textbox control to a combobox, the combobox tab order of the control has changed and now is the last control in the section. You have two options to avoind going to a new record: - Reorder the controls on the tab order option on the form section (surely detail section)...

Yes, like 0.20 is ten times greater than 0.2 🤭

Perhps this approach helps you @riktek: https://nolongerset.com/better-global-constants/

I found it when I converted the Lebans PictureBox to 64 bit. ;)

If I'm not mistaken, I've seen it when you copy memory addresses using Windows APIs. As you know, memory addresses length are different depending on the bitness. This is the code I've used sometimes ' *********************************** ' #If Win64 Then Private Const PTR_SIZE As Long...

Sometimes, converting a database is not as easy as it seems. For example: - You have to change len() to lenB() in some UDT. - When there are copy memory APIs involved, the number of bytes copied must be changed...or not. - Some APIs can be used with different parameters type. - 32 bit OCX...