FEOA Forums banner

1 - 9 of 9 Posts

·
Registered
Joined
·
710 Posts
Discussion Starter #1
Guys and girls, got a dilemna, looked for the answer in the books, online help facilities, groups etc. Here´s what I want to do. I´ve created an Access97 database which allows our daytime auditors to audit the Central Rates workgroup. Each morning at 5 am datacenter uploads a table of all the work they did that night to an Oracle table. My database will download the daily data and make it available to the auditors based upon either customer or who the rate clerk is. That´s simple enough. The problem then is, I want a macro to pull down the data ONCE a day. A simple autoexec macro would accomplish this BUT, I don´t want it run each time the database is opened. I want it to only run the very first time the dbase is opened each day. Conceivably, a user could open the database, audit a rater, then close it and come back later the same day. Loading the data twice might corrupt the existing data. So, how do I set this up to run ONCE only, and to flag it so that attempting to download the data again will not be possible? I have a couple of ideas on how to make this work but none are elegant, nor simple. Can anyone help? I have limited VB experience so would prefer a macro solution if at all possible. Thanks to all who might offer their assistance.
 

·
Registered
Joined
·
1,927 Posts
i haven´t done much at all with access, but my friend who happens to work in the same building as me knows pretty much all the ropes - i´ll pose the question to him, see if he knows. though he mostly does use VB...
 

·
Registered
Joined
·
710 Posts
Discussion Starter #4
My job is moving more and more into database administration so VB is going to be inevitable, just wish I had the knowledge now rather than later.

But I think I have a solution. I´ll setup a control dbase which will do the Oracle job, and then call the macro from the server autoscheduler. It will run each morning at 7AM, so that when the auditors arrive at 8, the data will already be there. They will then use a front-end dbase to access the data, thus never needing to run the macro themselves, and doesn´t matter how many times they open the dbase, the data will already be there. That would let me avoid a VB solution......
 

·
Registered
Joined
·
1,927 Posts
VB isn´t really all that hard to learn anyways. it´s not called BASIC for nuthin :-]

i´m actually quite fond of QBasic, made some cute RPG games and my own version of space invaders :cool:
 

·
Registered
Joined
·
710 Posts
Discussion Starter #6
Oh yeah, Qbasic is what I use in our older autorating platform and it pisses off some of the new tech people who want to do everything in modern code, or the system gurus who believe that their mainframe can do anything. Qbasic IS simple, I have no problems programming in that, but have found VB more difficult, to me it´s not like the next step from QB, but more like going from counting 1-2-3 to learning Algebra.

Just talked to one of the I/S guys and my idea will work - they´re setting it up to run at 7 am everyday to pull down the daily feed. Looks like a winner!
 

·
Registered
Joined
·
709 Posts
Yeah, VB is a little rough, I spend most of my time in Excel with limited use of access. I can help with any of the excel macros and VB but Access i know just enough to make things go bad at an alarming rate!
 

·
Registered
Joined
·
710 Posts
Discussion Starter #8
This is cool. They like what I´ve been doing and so want me to create more dbases to handle other auditing tasks. Spoke w/my immediate boss today and he was interested in paying for me to take additional classes in Access and to start VB classes this summer. Aint that grand!
 

·
Registered
Joined
·
1,927 Posts
sweet deal!!

i wish i could be sent to a class/workshop for report writing and application development for JD Edwards OneWorld software that I´m using at work. Unfortunatly i´m not only just a Co-op student, I´m also a consultant! No hope for respect for moi :-]
 
1 - 9 of 9 Posts
Top