469,360 Members | 1,782 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,360 developers. It's quick & easy.

What do I tell a code to click a button?

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
5 3039
Dormilich
8,652 Expert Mod 8TB
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
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
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
8,652 Expert Mod 8TB
what is the program/language you use for that all?
Jun 5 '17 #5
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.

Similar topics

4 posts views Thread by Grant | last post: by
reply views Thread by [Yosi] | last post: by
5 posts views Thread by Steve | last post: by
12 posts views Thread by Thammarat charoenchai. | last post: by
5 posts views Thread by laziers | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.