keleko Posted November 24, 2006 Share Posted November 24, 2006 i know nothing about access (almost) v.need to create some reports specifially, access 97 (i know i know i know, somewhere around april they'll be migrating to sql) i have about 50+ reports that need to be run, copied to another folder, then about 14 emails sent (different reports to different addresses) currently, it's : radmin (remote desktop) to open database on server, run a report, open database local, run another report alternate between the two as they finish, save as *****.snp to a specific directory, overwriting current file and there's 3 different databases to do this on save all the newly created files to a new folder with that day's date (i.e. 11-22-06) make new email, use distribution list, copy shortcuts to a specific file or set of files (the .snp) and send make another new email, repeat process with different list and different files as you read that, and then read more, you might ask why create a new folder and then copy those new reports there instead of just making the final folder and saving to that i don't know, that's just how they want it, so we'll keep it like that takes about 2 hours to do right now, would like to make it take 2 minutes (excluding time to actually run the reports, some take up to 5 minutes and some take 2 seconds) but i have no idea how to make a script to do this i need my time available for other things that need to be done around here, not running reports that can and should be done automatically obtw, these are critical reports, otherwise they managers in various depts. of the plant have no idea what needs to be done that day they HAVE to be emailed by ~8am (i get up at 5 and start running them by 6am) in the past, (years ago, v.7 or something) to do some automated tasks i have used AutoIT, but i haven't used it in several years, and this is all access anyway so it SHOULD be able to do this itself so, where do i start? Link to comment Share on other sites More sharing options...
Thatsgreat2345 Posted November 24, 2006 Share Posted November 24, 2006 (edited) could u uhh shortly abbreviate what u want. Run a report? what happens when you run the file. _INetSmtpMail can send emails and there are some other emailers in the example scripts as im confused here are some commands to check out _FileListToArray() Run() FileCopy() _date udf _INetSmtpMail Edited November 24, 2006 by IQuitToLearnASM Link to comment Share on other sites More sharing options...
keleko Posted November 24, 2006 Author Share Posted November 24, 2006 (edited) could u uhh shortly abbreviate what u want. Run a report? what happens when you run the file. _INetSmtpMail can send emails and there are some other emailers in the example scriptsthere's no abbreviation here, it's all lonnnnnnnnnng drawwwwwwwn outto run reportslaunch radminconnect to serverlaunch accessopen databaserun report*wait while report runs*when report is done, save to a directory as ******.snpoverwrite current filelaunch access on local while waiting for said report to runopen same databaserun a different report*wait while report runs*when report is done, save to a directory as ******.snpoverwrite current filerinse and repeat until all reports are done (some take 2 seconds, some take 5 minutes, some take massive cpu cycles, which is why we open local and remote)rinse and repeat for all 3 databasesonce all reports are doneon remote server save all newly created files to a new folder, dated today (i.e. 11-24-06)open outlook localcreate new emailTO: <specific distribution list>attach: shortcuts to specific ****.snp filessendcreate new emailTO: <specific distribution list>attach: shortcuts to specific ****.snp filessendrinse, repeat until all specific files are sent to all specific distribution listsis that clearer anyway? Edited November 24, 2006 by keleko Link to comment Share on other sites More sharing options...
Uten Posted November 25, 2006 Share Posted November 25, 2006 OK, So you just wipe up access and creates a script in it to do your work? Isn't that the simplest solution? Please keep your sig. small! Use the help file. Search the forum. Then ask unresolved questions :) Script plugin demo, Simple Trace udf, TrayMenuEx udf, IOChatter demo, freebasic multithreaded dll sample, PostMessage, Aspell, Code profiling Link to comment Share on other sites More sharing options...
Thatsgreat2345 Posted November 25, 2006 Share Posted November 25, 2006 although we make codes to do stuff like that we arent magical enough to do what you want as a request. In order to debug and everything like that takes time. I suggest you start learning autoit again because if you would like to automate your job then uh i can't help you. Link to comment Share on other sites More sharing options...
Paulie Posted November 25, 2006 Share Posted November 25, 2006 For future reference, when posting a thread , make its title remotely pertinent to question/subject you are posting about.This is the support section of the forum, its meant for questions, so naming a thread "I Have A Problem", or "Question", or "Help Me My, Code Doesn't Work", or "Noob Requesting Assistance" Is redundant, and makes it harder for anyone else who has the same/similar questions as you to find the answer by searching the forums, which in turn means people often have to make extra threads and people who are answering the threads just end up repeating themselves several times over. Link to comment Share on other sites More sharing options...
keleko Posted November 25, 2006 Author Share Posted November 25, 2006 OK, So you just wipe up access and creates a script in it to do your work? Isn't that the simplest solution?sure, if i knew how to do that i wouldalthough we make codes to do stuff like that we arent magical enough to do what you want as a request. In order to debug and everything like that takes time. I suggest you start learning autoit again because if you would like to automate your job then uh i can't help you.i wasn't specifically asking "can you do this for me", i'm asking if this app will follow through to do what i wantlast i knew, autoit would "follow" your mouse clicks, and create a script that would essentially do thosebut like i said, i haven't used it in a whole lotta years so i don't know if it will do what i wantif it comes to having to re-learn access and scripting all over again, what's the point of using autoit? Link to comment Share on other sites More sharing options...
Locodarwin Posted November 25, 2006 Share Posted November 25, 2006 last i knew, autoit would "follow" your mouse clicks, and create a script that would essentially do thosebut like i said, i haven't used it in a whole lotta years so i don't know if it will do what i wantif it comes to having to re-learn access and scripting all over again, what's the point of using autoit?AutoIt is designed to automate tasks, as you know, and it is incredibly flexible and powerful in that regard - but with that power comes a responsibility on the part of the user to learn how to effectively wield it. That's the price we all pay when we use this particular user-supported (not to mention free) scripting language.It takes only a few hours of studying and scripting to save yourself hundreds more.That, I believe, is the point of AutoIt.As to your task, it sounds like a reasonably straightforward assignment, and I can assure you AutoIt can handle every step of it. To start out, I would break each of your steps down into pseudo code and then work on coding each step in succession, testing the whole script as you go.When you have a question about a particular step, bring it here, and make sure you detail out the problem. Quite a few of the people here sit on this board for hours waiting to help someone with a well-explained problem. A lot of people are full of passion regarding AutoIt and WILL help you if you show an interest in helping yourself as well. It worked for me.Breaking a big project down into a series of manageable steps helps to calm the sensation of being overwhelmed, and also helps to keep code from turning into spaghetti.I would also plan on attempting to learn AutoIt COM. It will interact with Access on a lower level than clicks and keystrokes, greatly streamlining your task. Seasoned AutoIt users will tell you that when it comes to MS Office, COM is the way to go.The AutoIt help manual is really good. I mean, REALLY good. I use it every day. I strongly recommend you get to know it.-S (Yet Another) ExcelCOM UDF"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly...[indent]...specialization is for insects." - R. A. Heinlein[/indent] Link to comment Share on other sites More sharing options...
keleko Posted November 25, 2006 Author Share Posted November 25, 2006 (edited) AutoIt is designed to automate tasks, as you know, and it is incredibly flexible and powerful in that regard - but with that power comes a responsibility on the part of the user to learn how to effectively wield it. That's the price we all pay when we use this particular user-supported (not to mention free) scripting language.It takes only a few hours of studying and scripting to save yourself hundreds more.That, I believe, is the point of AutoIt.you make good points all aroundthe problem is, i have zero desire to invest that much time or effort into learning something i won't use ever again once it's working (other than minor maintenance if reports change)we'll be moving to SQL in 4-5 monthsi'd just like to sleep a bit later (or use my time to fix other problems on the network) and have a computer do what it's designed to doautomated tasksAs to your task, it sounds like a reasonably straightforward assignment, and I can assure you AutoIt can handle every step of it. To start out, I would break each of your steps down into pseudo code and then work on coding each step in succession, testing the whole script as you go.When you have a question about a particular step, bring it here, and make sure you detail out the problem. Quite a few of the people here sit on this board for hours waiting to help someone with a well-explained problem. A lot of people are full of passion regarding AutoIt and WILL help you if you show an interest in helping yourself as well. It worked for me.Breaking a big project down into a series of manageable steps helps to calm the sensation of being overwhelmed, and also helps to keep code from turning into spaghetti.what i posted above is pretty much the entire step by step processI would also plan on attempting to learn AutoIt COM. It will interact with Access on a lower level than clicks and keystrokes, greatly streamlining your task. Seasoned AutoIt users will tell you that when it comes to MS Office, COM is the way to go.hmm, haven't heard of that onewhat about following mouse clicks, and translating/transforming into this COM?The AutoIt help manual is really good. I mean, REALLY good. I use it every day. I strongly recommend you get to know it.-S no doubt it is Edited November 25, 2006 by keleko Link to comment Share on other sites More sharing options...
Locodarwin Posted November 25, 2006 Share Posted November 25, 2006 the problem is, i have zero desire to invest that much time or effort into learning something i won't use ever again once it's working (other than minor maintenance if reports change)we'll be moving to SQL in 4-5 monthsi'd just like to sleep a bit later (or use my time to fix other problems on the network) and have a computer do what it's designed to doautomated tasksMy apologies, then. What you seem to be saying is your time isn't worth your time - and, while I don't quite get it, I respect your decision. The problem is, you're asking for some very specific help to problems that aren't quite detailed enough yet to answer accordingly.Perhaps you should commission someone to write the script, for a donation to AutoIt.A parting word or two:AutoIt is akin to a savings account with a 90% interest rate. An investment of time returns to the principal far more than invested.Or, in simpler terms, it makes much more sense to spend a few hours of work to gain a hundred hours of laziness, than to spend hours working - all the while pining for the extra time you don't have.Here's to hoping those 4-5 months pass by quickly! -S (Yet Another) ExcelCOM UDF"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly...[indent]...specialization is for insects." - R. A. Heinlein[/indent] Link to comment Share on other sites More sharing options...
Paulie Posted November 25, 2006 Share Posted November 25, 2006 (edited) Perhaps you should commission someone to write the script, for a donation to AutoIt.http://www.rentacoder.comPeople here don't often take kindly to being bothered by PMs in which people offer money to code.But locodarwin made many excellent points in those last posts of his. You should take his advice.And i agree with him wholeheartedly===========================Here is my problem, you say thisi wasn't specifically asking "can you do this for me"...Then say this:the problem is, i have zero desire to invest that much time or effort into learning something i won't use ever again once it's workingHow do you plan to get this script done? You don't want us to do it for you, but you don't want to learn how to do it yourself. Is there another option that I'm missing? Edited November 25, 2006 by Paulie Link to comment Share on other sites More sharing options...
Thatsgreat2345 Posted November 25, 2006 Share Posted November 25, 2006 and the problem with hiring people to code they are limited to the input the user gives them, they can't come over to your house set up their laptop and check out how everything is going down Link to comment Share on other sites More sharing options...
Uten Posted November 25, 2006 Share Posted November 25, 2006 ... the problem is, i have zero desire to invest that much time or effort into learning something i won't use ever again once it's working (other than minor maintenance if reports change)we'll be moving to SQL in 4-5 monthsi'd just like to sleep a bit later (or use my time to fix other problems on the network) and have a computer do what it's designed to doautomated tasksNow there is a contradiction for you. You want your computer to do automated tasks but you don't want to learn the automation tools.hmm, I suppose you have read the tutorials in the help file by now and are well into solving your problem. Please keep your sig. small! Use the help file. Search the forum. Then ask unresolved questions :) Script plugin demo, Simple Trace udf, TrayMenuEx udf, IOChatter demo, freebasic multithreaded dll sample, PostMessage, Aspell, Code profiling Link to comment Share on other sites More sharing options...
keleko Posted November 25, 2006 Author Share Posted November 25, 2006 ....Here is my problem, you say thisThen say this:How do you plan to get this script done? You don't want us to do it for you, but you don't want to learn how to do it yourself. Is there another option that I'm missing? i dunnomaybe if there was a really short script that would open that remote database, run a report, and save it to a diretory, i can expand on it and make it do things i needi.e., just something small to start off with but if autoit can follow my clicks and emulate them it shouldn't be a problem, right? Link to comment Share on other sites More sharing options...
Paulie Posted November 25, 2006 Share Posted November 25, 2006 (edited) but if autoit can follow my clicks and emulate them it shouldn't be a problem, right?I recomend looking at Au3RecordComes with SciTE4AutoIt3 Edited November 25, 2006 by Paulie Link to comment Share on other sites More sharing options...
Kickassjoe Posted November 25, 2006 Share Posted November 25, 2006 AutoIt is akin to a savings account with a 90% interest rate. An investment of time returns to the principal far more than invested.That is a great analogy, if you invest some time into AutoIt, you will be very pleased with the results. For example, if you make a script to do your reports for you... you will be able to sleep later EVERY DAY! Do you enjoy waking up at 5:00 every day?P.S. I want a savings account like that! What goes around comes around... Payback's a bitch. Link to comment Share on other sites More sharing options...
keleko Posted November 25, 2006 Author Share Posted November 25, 2006 I recomend looking at Au3RecordComes with SciTE4AutoIt3what's the difference between these versions? Link to comment Share on other sites More sharing options...
MHz Posted November 25, 2006 Share Posted November 25, 2006 Too many idiots in this thread.Go Com with database...http://www.autoitscript.com/forum/index.php?showuser=9401Pay the piper.Au3Record is absurd for database. Link to comment Share on other sites More sharing options...
Paulie Posted November 25, 2006 Share Posted November 25, 2006 Au3Record is absurd for database.He said:autoit can follow my clicks and emulate them it shouldn't be a problem, right?That would be EXACTLY what Au3Record does. No? Link to comment Share on other sites More sharing options...
Thatsgreat2345 Posted November 25, 2006 Share Posted November 25, 2006 paulie yes i see what your saying but the fact is this is his job and personally i dont think he knows what he's getting into. Thus since mouseclicks are so unreliable and this is his job which if this stuff isnt done then his job is at stake mouse clicks would be jeopardizing his freakin job . Say the window doesnt pop up in the same place each time or there was an error and yeah mouse clicks aint going to be able to help him out Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now