vba from 32bit to 64bits

[Ana12322]

Mike Krailo​

Yes, it is that in access 32bits it works fine, but in 64bits it doesn't.

The button does not work when I go to search for a file

 

[Mike Krailo]

What do you mean it doesn't work in 64bit? Is there an error message? Please tell us exactly what the error is. If there is no error message, then describe in detail what is not working. I tried to open and use the form in your project, but this is just a front end application to many other databases that are on your local network so I cannot test anything here.

 

[isladogs]

I haven't gone through your file in detail as there are a lot of APIs to check.
However, whilst adding PtrSafe to each API will allow the code to compile in 64fbit, it doesn't mean it will work or indeed that there will be no errors.
As I said before, you need to go through each API and check they are all correct.
Nobody else can test the app for you as its use depends on the linked tables that aren't included

 

[Ana12322]

Mike Krailo​

Ok, I send you these videos. where i run on 64 bit windows with 32 bit access and the program works perfectly, if you see it opens to add the necessary files and work with them

 

[Ana12322]

Mike Krailo​

In this video I run it on 64bit windows with 64bit access, if you notice that it doesn't open to search for the files. This is what I mean when I say that in access 64bits it does not work

 

[Mike Krailo]

This is getting into an area that I'm not as familiar with so hopefully someone will chime in with and idea on how to get that Data Wizard to work properly.

I'm not getting any specific errors to point us in the right direction. This seems to be either missing references of some type or runtime issue. Those are a little harder to troubleshoot. As Colin said, this might need to be done from your end with access to all the linked tables.

 

[Noson5434]

I made some changes.
See if you are still having issues.

 

[Ana12322]

[USUARIO=162873]Noson5434[/USUARIO]​

Hello thank you very much!!!

It worked, now I only have a problem with the button when I go to search for the folders, I must add the address manually.

I send a video

 

[Noson5434]

[USUARIO=162873]Noson5434[/USUARIO]​

Hello thank you very much!!!

It worked, now I only have a problem with the button when I go to search for the folders, I must add the address manually.

I send a video

I will review this tomorrow

 

[Ana12322]

Noson5434​

Thank you so much

 

[Noson5434]

@Ana12322

See if this works.

 

[Ana12322]

Noson5434​

Hello!

It doesn't work for me, the other one that you sent me first does work in 64bits, but the browser button doesn't

 

[Noson5434]

Any errors?

 

[moke123]

Wow, That code goes back to 1994?

Is all that (or most of it) just to get a file dialog and a print dialog?

 

[Ana12322]

Noson5434​

Hello!!!
Opened!! Everything worked perfect.

Thank you so much!

 

[Ana12322]

moke123​

Hello,
Yes, it was only for the open dialog, why didn't it open

 

[moke123]

Hello,​

Yes, it was only for the open dialog, why didn't it open

only tried in 32 bit.
Just seemed overly complicated for a file dialog but I didn't look very hard at it.

 

[Ana12322]

moke123​

In Office 32bits it worked perfectly, the problem was in Office 64

Thanks to Noson5434 I was able to solve it

 

[Noson5434]

Noson5434​

Hello!!!
Opened!! Everything worked perfect.

Thank you so much!

Perfect

 

[Gasman]

moke123​

In Office 32bits it worked perfectly, the problem was in Office 64

Thanks to Noson5434 I was able to solve it

Well the important item here is to understand what the issue was, not just move on.