UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Relinking and splash screen.    
 
   
WildBird
post Sep 9 2008, 02:16 AM
Post#1


UtterAccess VIP
Posts: 3,725
Joined: 19-August 03
From: Auckland, Little Australia


Have seen acouple of questions about how to relink tables via code and thought I would show what I use. It also has a splash screen which is handy if it is a slow network as it shows the users what is happening, and stop them saying it is not working when the main form doesnt appear.

In the zip file, there should be 2 files, a mdb and a ini file. I use the ini file for storing things such as backend paths and many other paths. I have a method that brings down the front end as well as the ini file when they start it up, but that is for a different post. For this, it uses a ini file that is in the same path as the mdb. To test, link some tables, and place the path and name of the file in the ini file. Then close and reopen open the file. The frmMain should be set as the startup form. I use generic form names when I can.

Notes- Limitations. This assumes that all the backend tables are in a single backend file. It is still possible to have multiple backends, but it requires some consistent naming convention and a tweak of the code. Majority are just one backend.

Developed in Access XP, and I have done some testing in Access 2007. Dont have earlier versions installed, so not sure what versions it will work on.

Oalso have another form, frmSplash. Should I remove this and just leave it as a barebones sort of app to go to the archives? Splash is used the same way and I use it alot when running anything such as a loop and I can use the names of the loop such as
CODE
Splash "Processing " & qdf.name , i & " of & " qdf.count


To close, in the ExitHere section, it is simply
Splash,,,True

Look forward to any feedback.

Cheers,

Coop
Attached File(s)
Attached File  LinkAndSplash.zip ( 66.89K )Number of downloads: 697
 
Go to the top of the page
 
Raizyros
post May 11 2020, 03:13 PM
Post#2



Posts: 3
Joined: 12-January 09



This does not work on a 64 bit system. Is there an updated version?
Go to the top of the page
 
johnochoa
post May 25 2020, 03:29 AM
Post#3



Posts: 1
Joined: 13-January 20



Just make the change in the statements:

Declare Function

by

Declare ptrsafe Function.

John Ochoa from Colombia
Go to the top of the page
 
tina t
post May 25 2020, 10:15 PM
Post#4



Posts: 6,690
Joined: 11-November 10
From: SoCal, USA


there's a bit more to it than that. see https://docs.microsoft.com/en-us/office/vba...ptrsafe-keyword. suggest you read the Help page at the link and do more research as needed; this is actually not a trivial subject.

hth
tina

--------------------
"the wheel never stops turning"
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    12th July 2020 - 01:39 PM