old file problem (1 Viewer)

[alqareeb]

i am not professional in access but i created this file long time ago and since then i did not use access but with the new version of access i cannot open the file and i cannot figure the problem if any body can help i will be great full

 

[theDBguy]

Hi. Welcome to AWF!

Which version of Access are you using? I was able to open it using Access 2016.

 

[alqareeb]

2019 version

 

[theDBguy]

2019 version

I see there's an API in it. Can you please verify that you're using 64-bit version of Access 2019? Thanks.

When you open the file, what error message do you see?

 

[alqareeb]

this message! at start and the form are not opening

 

[theDBguy]

this message! at start and the form are not opening

That usually indicates a missing reference. Can you check? What happens when you click OK? When I open the file you posted, I see the startup form open.

 

[alqareeb]

just blank screen

 

[theDBguy]

just blank screen

Try the attached...

 

[alqareeb]

thanx but this error pop up

 

[theDBguy]

thanx but this error pop up

Right, that's the part I asked about earlier. You must have a 64-bit version, but could you please confirm it though?

Go to File > Account > About Access

 

[theDBguy]

Try changing it to this:

Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As LongPtr) As Long

Private Declare PtrSafe Function ShowWindow Lib "user32" (ByVal hwnd As LongPtr, _
     ByVal nCmdShow As Long) As Long

 

[alqareeb]

ok

 

[theDBguy]

ok View attachment 84242

Okay, thanks. That confirms it. Please try modifying the code as I showed you above. Good luck!

 

[alqareeb]

thanx

 

[theDBguy]

thanx

You're welcome. Let us know how it goes...

 

[alqareeb]

it is ok now thanx alot