Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-21-2019, 04:03 AM   #1
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,019
Thanks: 450
Thanked 300 Times in 259 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
64 Bit Conversion

Good afternoon AWF,

I came across some nifty ( sorry Tony ) bit of code in the Sample Databases forum that ChrisO has posted.

It wouldn't work on my machine at home because I have AC365/64 bit installed.

So I set about trying to convert it, something I can only copy from google, and as you can guess, it does not work. It complies fine, even though the VB6 bit is in red, but when I click on the Update button on the frmShowRecords Form, Access closes and reopens a backup version of the DB.

Any suggestions?
Attached Files
File Type: accdb CurrentRecord_PassObject_AC2016_64.accdb (1,004.0 KB, 6 views)
File Type: mdb CurrentRecord_PassObject.mdb (1.44 MB, 11 views)

__________________
“It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious.” - with apologies to George Washington
NauticalGent is offline   Reply With Quote
Old 09-21-2019, 07:43 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: 64 Bit Conversion

I will keep this, very interesting!
Attached Files
File Type: zip CurrentRecord_PassObject_AC2016_64.zip (79.2 KB, 14 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
NauticalGent (09-21-2019)
Old 09-21-2019, 07:50 AM   #3
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,019
Thanks: 450
Thanked 300 Times in 259 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: 64 Bit Conversion

Excellent work Arnel! Simply brilliant how you figured that out. Grazie mille!

__________________
“It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious.” - with apologies to George Washington
NauticalGent is offline   Reply With Quote
Old 09-21-2019, 07:52 AM   #4
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,019
Thanks: 450
Thanked 300 Times in 259 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: 64 Bit Conversion

Quote:
Originally Posted by arnelgp View Post
I will keep this, very interesting!
It is...not sure if it performs any better than the other methods I have used but it does offer a more dynamic utility to any application.

Thanks again for sorting it out...
__________________
“It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious.” - with apologies to George Washington
NauticalGent is offline   Reply With Quote
The Following User Says Thank You to NauticalGent For This Useful Post:
arnelgp (09-21-2019)
Old 09-21-2019, 01:30 PM   #5
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: 64 Bit Conversion

ChrisO did some really neat things, I hadn't seen this one. He was way over my head; I'm honored he asked me to host some of his files.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 09-21-2019, 07:49 PM   #6
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,019
Thanks: 450
Thanked 300 Times in 259 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: 64 Bit Conversion

Quote:
Originally Posted by pbaldy View Post
ChrisO did some really neat things, I hadn't seen this one. He was way over my head; I'm honored he asked me to host some of his files.
I have read some of his posts after I found this and I agree, he was phenomenal.
__________________
“It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious.” - with apologies to George Washington
NauticalGent is offline   Reply With Quote
Old 09-21-2019, 08:03 PM   #7
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,019
Thanks: 450
Thanked 300 Times in 259 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: 64 Bit Conversion

@ArnelGP,

The link to the original post is below. I was going to put a copy of your 64 bit version there but remembered it wasn’t my code!

https://www.access-programmers.co.uk...d.php?t=227665

Thanks again


__________________
“It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious.” - with apologies to George Washington
NauticalGent is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Win 10 64-bit conversion from 32-bit justphilip2003 General 13 05-08-2017 07:55 AM
Conversion Marco Dell'Oca General 5 06-06-2015 10:04 AM
ADO Conversion knowledge76 Modules & VBA 2 03-17-2005 11:15 AM
Conversion jeffcravener Forms 6 09-04-2002 11:37 AM




All times are GMT -8. The time now is 05:21 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World