Using Keys To Perform Data Entry Or Query
Oct 26, 2011
In my company we use Oracle Applications. Almoust every form in these applications have a common behaviour, which is:
Whenever the forms is opened one can immediately start entering data but one can also press F7, which makes the form to enter in query-mode. You can then fill one or more forms fileds with the data you are searching for and press F8, which executes the query and returns the data into the form. The query mode can be interrupted by pressing Ctrl+Q, returning to data entry mode.
My question is if there is a way of having similar behaviour on building VB forms. I'm using VS 2010.
View 6 Replies
ADVERTISEMENT
Nov 3, 2009
How Do I Make Button.click Event Perform both the enter and period(del) keys on the numeric keypad? [Code] Case Keys.Enter and Case Keys.Separator do not work. Nor does anything like Keys.OEMPeriod for the period(del) key. I've also tried calling the enter key in a KeyPress event etc. But to no avail. Any ideas? I'm trying to mimic Windows calc.exe for a school project and thought I'd try throwing in a few extras such as numeric keypad functionality.
View 1 Replies
Sep 16, 2009
I've been reading the official DNS RFC [URL].. and looking at articles like this that explain how DNS query packets are structured [URL].. but I'm having a hard time trying to combine the two and actually get to a point where I know what to do
Basically I know that I need to use UDP to send the query and there is only one type of query I actually want to perform - an MX lookup. So I'm hoping that means I dont need to account for a lot of things that anyone creating a complete DNS Resolver would need to implement.
The only experience I have with network communication like this is with protocols that are text based (and use TCP, but I dont think that makes much difference here, if anything UDP should be easier). DNS however is binary based and I just cant figure out how I would know what bytes to send down the wire for a specific MX query..
View 5 Replies
Jun 21, 2010
I have created a SELECT FROM WHERE query to perform a search here is my code:
SELECT EmployeeID, DepartmentID, Forename, Surname, Role, Email, Telephone, Extension, Mobile, Photo FROM Employees
WHERE (Forename = ? or ? = '') and (Surname = ? or ? = '') and (Role = ? or ? = '')
I have then put the folllowing code to rung the query within my form:
Me.EmployeesTableAdapter.FillByName(Me.myDataSet.Employees, Me.ForenameTextBox.Text, Me.ForenameTextBox.Text, Me.SurnameTextBox.Text, Me.SurnameTextBox.Text, Me.RoleTextBox.Text, Me.RoleTextBox.Text)
When i search by forename or surname it works fine but when i search by role i get this error..oledbException occured No value given for one or more required parameters.
View 1 Replies
Dec 19, 2009
How do I perform an sql query onto a DataTable not a Database table?
View 1 Replies
Jan 2, 2010
How can i perform order by tCount in this Query?
Public sub StatReport()
Dim Transaction = xmlDataset.Tables("ebus_transactions")
Dim TranCounts = From T In Transaction Take 2 _
[code]....
View 1 Replies
Jun 9, 2010
I can achieve in VB what the following C# snippet does but it seems very clunky since I perform a Linq query to obtain the events for the relevant user. Is there a neat way?
ctx.FetchEventsForWhichCurrentUserIsRegistered((op) =>
{
if (!op.HasError)[code]........
View 2 Replies
Jul 8, 2009
I want to know if it is possible to perform a mySQL query to get a single record (searched for by ID) and then split each field into a seperate text box.I think im ok with the SQLQuery to get the record. its the splitting it into individual text boxes that im strugling with.
View 1 Replies
Feb 2, 2011
I'd like to take all suggestion either in C# or VB.NET.I have a DB diagram like the image below. I also include the database script here [URL]In the Students table, CountryId and RoomId column are allowed null. Because some records do not have info about room and country yet.Also, some students do not have essays.I'm doing a joint query with all tables. I want to select all students to project the result like this:Wanted query result.
Here's my current query that gives the result like the image below:
Dim db As New DBDataContext
Dim query = From st In db.Students _
Join c In db.Countries On c.Id Equals st.Id _
Join r In db.Rooms On r.Id Equals st.RoomId _
[code].....
current query result I got only one result back because I have (2) William NoMan record in every table. But I don't get anything about others, like (3) Sync Master who has everything but RoomId.What do I need to modify the query above so it will give me all students like in the wanted query image above?
View 2 Replies
Oct 13, 2010
Currently we are using a VB script macro created in word to create some fairly simple forms based off of data entered on a data entry form. I am very new to VB, and I have been able to create many applications using forms, but I have absolutely no history creating reports. I have been reading up on the reports, and it looks like they are designed to use with data sources like tables. I merely want to take either data from the entry form, or from data derived internaly from processing the user entered data and populate a defined report "form". I have been searching, but there is so much on printing reports, that I feel overwhelmed. I am not looking for the exact answer as much as a link or place to look for a sample for what I want to do.
View 2 Replies
Oct 26, 2010
create website involving payments plus some data entry eg booking of some facilities with the main data kept at a LAN window system.
View 4 Replies
Apr 16, 2012
CODE:
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
View 2 Replies
Oct 21, 2008
I have a problem detecting whether one of the arrow keys is pressed, all the other keys seem to be detected apart from the arrow keys??? I have set key preview to True........ It detects the arrrow keys BUT ONLY if I have NO other controls on the form??? example..
Me.Text = e.keycode
It works, but then if I add a button for example, it stops.
View 3 Replies
Sep 26, 2011
I have an application that receives data input from an automated set of devices. This data stream I have managed to capture & get it into a list box which I can sort based on the Device ID & the time that the response was received.There is a set time window for the devices to transmit their data into the application and during this each device is not limited to the number of responses it can send (ie :- Device 1 can send in 2 responses where Device 3 can send in 40 responses, etc).All of the responses are captured, listed & sorted within the listbox (this bit is working ).I now need to extract the last (ie:- latest) entry in the listbox for each Device ID & this is where I am stuck. I can retrieve the last item in the list but cant seem to extract the last item for each Device ID.[code]
View 2 Replies
Sep 21, 2011
Basically, our users enter values onto a spreadsheet and I have been asked make the spreadsheet output to a CSV file preferably each one completed appears as a single line in the CSV.Upon examining the spreadsheet, I cannot figure out the best way of acheiving this, or if it is easily acheivable in the first place.I have attached an example of the spreadsheet data, to give it some context the spreadsheet records times that carers have visited a client, which can happen many times a day over many days per week, there is also a yes/no for each day on the sleepin.
View 5 Replies
May 27, 2009
I have a data entry screen to collect data. At the bottom of the form I have buttons to add a new record, save current and add, save current and end, and an end without saving. The buttons all function properly. After clicking the save current and add new record button, a new blank record comes up with the cursor on the save current and add button. I haven't been able to figure out how reset the tab order so the first field in the entry screen is ready for data. I'm coming up empy on my research.
View 2 Replies
Jan 12, 2011
I have an Access database that has thousands of records. The fields in the database are EMPID, FIRST, LAST, JOBTYPE and PAGES. I would like to know how to loop through the database and for each individual EMPID to calculate the sum of the PAGES foreach JOBTYPE. There are four JOBTYPE's: "E", "K", "O" and "R".
Her is some code:
Dim
WebAllEmployeeQuery As
[code].....
View 12 Replies
Jun 10, 2011
How can i perform a drag and drop in the data grid?
I am trying to make a program that can swap row to row or column to row (vice versa) contents.
View 2 Replies
Mar 23, 2009
I have code to extract each entry in an event log. If the entry is after a set date (the value of my startDate variable) then it gets the information from the log and outputs to an email (I can do all this, the bit I am stuck on is as follows) I am currently using the following code extract:
[Code]...
View 4 Replies
Sep 8, 2009
i am pulling together a cash register that will allow both bar code product entry and manual key entry.imagine if you have a tin of beans in front of you, in a small corner shop they would probably type "47" and then hit "Produce". Fairly straight forward as I have the button Produce to act upon my code and update my salestrans.mdb but,if you scan the bar code I want the same form to handle both 'real' actions, (i assume that keyboard emulation barcode scanner includes "ENTER" after providing 13 digits)....
Q. in perhaps a long winded way i want to know how to kick off an event based on the "ENTER" key being activiated by the barcode scanner)?i do not want to have to hit any buttons if i am scanning bar codes.
View 9 Replies
Nov 4, 2011
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
View 2 Replies
Aug 23, 2011
i am trying to write a program which reads a data from the database and perform some calculations. what i am intending to do is when a user selects an item from a listbox and clicks the submit button the program, calls a function to calculate using the value stored in the database and display the result in a textbox.the problem is i cant store the data retrieved from the database into a variable so that the calculations can be done. i am using vb and microsoft sql server.can anyone tell me how do i store the data retrieved by the query into a variable.
View 12 Replies
Mar 13, 2010
how to perform the database operation such reading data and using them for comparison within the VB programming..
Please guide me with explanation as i have very little knowledge regarding the database operation...
i am using VB.Net 2008 as frontend...and MS SQL Server 2008 (express edition ) as back end...
View 2 Replies
Jan 13, 2011
I have an Access database that has thousands of records. The fields in the database are EMPID, FIRST, LAST, JOBTYPE and PAGES. I would like to know how to loop through the data table and for each individual EMPID to calculate the sum of the PAGES for each JOBTYPE.There are four JOBTYPE's: "E", "K", "O" and "R".Here is some
Dim WebAllEmployeeQuery As String = _
"SELECT ELPallEmployees.[EMPID], ELPallEmployees.[FIRST], ELPallEmployees.[Last], ELPallEmployees.[JOBTYPE],
[code].....
View 2 Replies
Nov 14, 2009
I am trying to create a data entry wpf form and I am getting the following error when trying to create a window1 loaded event: "table name table adapter is not a member of file name.new data connection set table adapter.table adapter manager" I understand the error message and checked all my names but to no avail. Below is my class statement and window 1 loaded event:Private data connection as new data connection setprivate tatable as new data connection set table adapter.table name table adapterprivate tamanager as new data connection set table adapter.table adapter managerprivate view as collectionvie
View 1 Replies
Oct 9, 2010
I have a program to make for a class i am in and i am stuck on this one part, its a form application where you have to enter the first and last name of five students along with their final grade then you click a submit button after each one and i need it so that after all five buttons are clicked it activates the summarize button and i can't figure out how to do that and another thing when you hit the summarize button it has to compare the grade against the value of a text box containing the pass threshold to amount how many passed or failed.
View 1 Replies
Jul 1, 2010
Suppose I have a parameter query called FillByStatus in my "Customer" DataTable and I want to fill the CustomerTableAdapter On Form_Load using this query. So I can do that by using the following code:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.OrdersTableAdapter.Fill(Me.CustomerOrdersDataSet.Orders)
Me.CustomerTableAdapter.FillByStatus(Me.CustomerOrdersDataSet.Customer, "Active")
End Sub
View 3 Replies
Jul 10, 2009
I am trying to make a program with a bar code reader for the first time. I am programming with VB 2005. I want to differentiate a bar code entry to keyboard entry. My questions:
1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
View 2 Replies
Jan 11, 2012
i want to know that how can we add two cells of a datagrid view.I have 5 cells, quantity,rate,discount,tax and Total amount.I want to show the total amount in "Total Amount" cell.
View 3 Replies
Nov 11, 2010
I'm writing a program which has to perform several operations on data exported from a CAD software.The amount of data to be processed is huge and even by simplifying the program at maximum it will still take about 10-15 minutes for average models.
The operations are performed on an array from the first to the last element. Let's say for a list of 10 elements (as example) that I start from element 1 and I finish when element 10 has been computed. I thus thought that since I'm working on a 8 processor machine would be convenient to make use of multi-threading. My idea is, for the case of 10 elements, to make thread1 working from 1 to 5 and make thread2 working from 6 to 10.I already wrote a working code for a 2 thread process which is working, but I want to extend the number of threads and eventually decide in function of the threads available. The basic structure is given below:
[Code]...
View 9 Replies
