By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,483 Members | 1,039 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,483 IT Pros & Developers. It's quick & easy.

What do I tell a code to click a button?

P: 3
Hi,

I'm testing an upload in our current payroll system (Chris21) and am trying to import a file that will upload a batch of salary changes.
We have the original excel file converted to a text file using macros, but in the payroll system itself I need to tell the file to click 2 buttons (to recalculate the new figures) and to tick 2 check boxes (to apply the changes).

What do I need to tell the macros or the text file to click 2 buttons in a certain order, and tick 2 check boxes at the end?

Regards,
Nil.
Jun 2 '17 #1
Share this Question
Share on Google+
5 Replies


Dormilich
Expert Mod 5K+
P: 8,639
a text file can't click anything. it's just text, nothing more, nothing less.

btw. what kind of check boxes are you talking about? This doesn't seem to be XML related either ...
Jun 2 '17 #2

P: 3
NUT XOA CO THONG BAO YES/NO:
Private Sub Command5_Click()
If MsgBox("BAN CO XOA KHONG.?", vbQuestion + vbYesNo, "THONG BAO") = vbYes Then
On Error GoTo errmsg
Adodc1.Recordset.Delete
MsgBox " DA XOA", vbOKOnly, "THONG BAO"
Exit Sub
Else
errmsg:
MsgBox "KHONG XOA..!", vbOKOnly, "THONG BAO"
End If
End Sub
Jun 3 '17 #3

P: 3
Hi,
Thanks for your response.
I understand the text itself is just text, but it prompts certain actions when we upload it to the payroll system.
We already have the command to create a new form for a certain employee, and apply an effective date (e.g. cbr=spmadd, detnumber="100001", spmeffdate="2017-07-01") but the next step we need is to click a button in the payroll system that will perform a preliminary auto-calculation so we have figures to adjust.
Does this help?
Jun 4 '17 #4

Dormilich
Expert Mod 5K+
P: 8,639
what is the program/language you use for that all?
Jun 5 '17 #5

P: 3
No idea to be honest. I know that's no help, it is straight into the payroll system. We've got a guy coming out in a week or so who might be able to show us, but we've been given the run around before. Thanks for helping though!
Jun 7 '17 #6

Post your reply

Sign in to post your reply or Sign up for a free account.