Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

access database automatic

Posted on 2013-06-04
7
196 Views
Last Modified: 2013-07-03
I have an access database that has a form that will import a text file into a scanning software.  All I have to do is click the button on the form and the import happens.  I was wondering if there is any way that this can be done automatically?  Can access do scheduled tasks or is there another software that could perform this task?
0
Comment
Question by:mkramer777
7 Comments
 
LVL 7

Expert Comment

by:Robert Saylor
ID: 39219867
Macro software can do this.

Here is one I googled: http://www.autohotkey.com/
0
 
LVL 57
ID: 39219870
Access itself doesn't have scheduling built-in, but you can easily write something or simply use the Windows task scheduler, passing the name of a macro with the /x switch, or using /cmd switch to pass in arguments which you can then act on.

Most to the latter.

Jim.
0
 
LVL 21
ID: 39219910
All I have to do is click the button on the form and the import happens.

I like to create a separate front end that has a start up form the runs the code in the form's On Load event. Add a line of code to the end to .Quit. Once the database will auto run without any human interaction and close it is ready to be called from the Windows Task schedule.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 49

Accepted Solution

by:
Gustav Brock earned 425 total points
ID: 39221250
You can set the form to open automatically when Access launch your app.

Set the Timer Interval of the form to, say, 10000 for 10 seconds. The number is milliseconds.

Then use the Timer event of the form to call the OnClick event of your button:

Private Sub Form_Timer()
   ' Simulate a click of your button.
   Call btnImport_Click
End Sub

Now the button click event will fire every time the timer runs out.

/gustav
0
 

Author Comment

by:mkramer777
ID: 39298067
I've requested that this question be deleted for the following reason:

Figured it out
0
 
LVL 7

Expert Comment

by:Robert Saylor
ID: 39298024
What was your solution? Did any of us help you towards that solution?
0
 
LVL 57
ID: 39298068
Please post the method you used, then accept your own comment as answer.

Thanks,
Jim.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question