🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #380

Help, I need an answer, can you, the expert help???????

#380
From: Jay
Date: Sat, 15 Aug 1998 00:00
36 lines
2532 bytes
Can nobody in the .net universe answer this question???

I am a first time user of these 'ere newsgroups and i thought they might be
somebody out there who can answer this........

I have a problem that I hope somebody out there can solve.....

I am transferring data into an Access 95 database from a text file which is
held on my server.

I have a macro set up that does the job effectively, but I want to make it a
bit more user friendly.

Currently at the beginning of the Macro I have set the systems warnings to
'off', I have now written some code to carry out the import procedure, I now
want to add a splash screen to show the progress of the importation.

What can I use to gauge the time left i.e. the Growrate?

i.e. on the click event of the import button to DoCmd.OpenForm
"frmTimeIndicator" and graphically show the amount of time remaining by
having a blueline on the Splash screen.

I appreciate that the recordset that is produced from the standard Microsoft
Application is probably well hidden deep inside one of the .dll files but if
I knew where it was I might be able to start using it....

Please O please will you help if you can....

Attempts and even duff answers accepted.....(at least it's a starting point
for me to have a look..!)

Top stuff..

Jay
jason@attraxion.force9.co.uk
Technical Details
Message-ID: <6r2euf$a89@news3.force9.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111a5a,5f8f5f1c154466d0,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: fb7cd,5f8f5f1c154466d0,start
X-Google-Attributes: gidfb7cd,public
X-Google-Thread: 109eae,5f8f5f1c154466d0,start
X-Google-Attributes: gid109eae,public
X-Google-Thread: ff0ac,5f8f5f1c154466d0,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10a93f,5f8f5f1c154466d0,start
X-Google-Attributes: gid10a93f,public
X-Google-Thread: 10c7bc,5f8f5f1c154466d0,start
X-Google-Attributes: gid10c7bc,public
X-Google-Thread: 1143dd,5f8f5f1c154466d0,start
X-Google-Attributes: gid1143dd,public
From: "Jay" <jason@attraxion.force9.co.uk>
Subject: Help, I need an answer, can you, the expert help???????
Date: 1998/08/15
Message-ID: <6r2euf$a89@news3.force9.net>
X-Deja-AN: 381281815
Organization: Force 9 Internet
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,microsoft.public.access.3rdpartyusergroups,microsoft.public.access.3rdpartyusrgrp,microsoft.public.access.chat,microsoft.public.access.conversion,microsoft.public.access.customcontrols,microsoft.public.