473,390 Members | 1,348 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,390 software developers and data experts.

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 3973
Dormilich
8,658 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,658 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

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

Similar topics

4
by: Grant | last post by:
Can I add/code a button on my form that will print only the selected record? Thanks Grant Dayton
0
by: [Yosi] | last post by:
I search solution for a little bit strange problem , I working on an application which includes a button. Click on this button will create number of threads each one execute deferent executable...
5
by: Steve | last post by:
Hi, Is it possible to make hitting the enter key in an ASP textbox run the code behind an ASP button on a form? I have a search page which users tend to type in the query then just hit enter...
0
by: radders | last post by:
Hi guys, What I'd like to do is place three edit boxes with three static text labels on a click button. This would let the user input RGB values to the three edit boxes and then click the...
3
by: eddie69 | last post by:
Hi, Newbie question here: I am creating an application in VB Studio 2005 which reads the status of an USB PIR Motion sensor. So far, I have managed to get the application to read the motion...
12
by: Thammarat charoenchai. | last post by:
Hi, I'm try to learn vb.net. in delphi have .click method for click button by coding. Can I do that with vb.net Thank you very much.
4
by: nittin14 | last post by:
hi guys i m a beginner in Asp.net can u tell me that how to open page in new window after click button as well as i want to pass some data from this page. thanks
1
by: yog1612 | last post by:
hi, i have problem regarding,how to creat code for button. means that button will be capable to read current file name & converts into new file name. & after all save it under under the new file...
5
by: laziers | last post by:
Hi, anyone know how to write a single-cilick button? I use this: <asp:button id="ButtonAdd" runat="server" text="Anuluj" onclick="Click_ButtonAdd" /> if ( !isPostBack){...
0
by: abdulazees | last post by:
when click button i want to print autometicaly reportveiwer data, i not need to show reportviewer.
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.