64 Bit Conversion (1 Viewer)

NauticalGent

Ignore List Poster Boy

Local time

Today, 06:58

Joined

Apr 27, 2015

Messages

6,319

• Sep 21, 2019

• #1

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?

 

Attachments

• CurrentRecord_PassObject_AC2016_64.accdb

  1,004 KB · Views: 72
• CurrentRecord_PassObject.mdb

  1.4 MB · Views: 87

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 18:58

Joined

May 7, 2009

Messages

19,231

• Sep 21, 2019

• #2

I will keep this, very interesting!

 

Attachments

• CurrentRecord_PassObject_AC2016_64.zip

  79.2 KB · Views: 93

NauticalGent

Ignore List Poster Boy

Local time

Today, 06:58

Joined

Apr 27, 2015

Messages

6,319

• Sep 21, 2019

• #3

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

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 06:58

Joined

Apr 27, 2015

Messages

6,319

• Sep 21, 2019

• #4

arnelgp said:

I will keep this, very interesting!

Click to expand...

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...

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 03:58

Joined

Aug 30, 2003

Messages

36,123

• Sep 21, 2019

• #5

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.

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 06:58

Joined

Apr 27, 2015

Messages

6,319

• Sep 22, 2019

• #6

pbaldy said:

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.

Click to expand...

I have read some of his posts after I found this and I agree, he was phenomenal.

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 06:58

Joined

Apr 27, 2015

Messages

6,319

• Sep 22, 2019

• #7

@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/forums/showthread.php?t=227665

Thanks again