Creating A 'smartform' - Click On A Search Feature In The Top Cell And Input An Employee ID #
May 17, 2010
I created 2 forms in Access 2003 (Form1 & Form2) for the purpose of creating a 'smartform' of sorts for my company. In essence they can click on a search feature in the top cell and input an employee ID # which automatically fills in about 10 to 15 fields.
- There is only 1 table attached to the forms.
- The group I created this for is uncomfortable using Access.
What I would like to do with VB.net:
- I thought I would create an internal webpage using VB.net so they wouldn't need to log into Access [the DB would be stored on a separate server.]
- I would need a clean & simple interface that has 2 buttons, one for each form.
-When the form is called up I would need a search feature "EMPLID _________" which would connect to the Access DB table and retrieve the correct information.
-Id also need to have the form printable & have the ability to search again or return to the front page.
View 4 Replies
ADVERTISEMENT
Sep 30, 2009
You need to design and create a program that accepts input of employee name, employee type, and the number of hours worked each week for two weeks.
You must be able to select an employee type. An employee of type Trainee makes $10 per hour. An employee of type Regular makes $15 per hour. An employee of type Manager makes $20 per hour.
The program should calculate the employee pay for the week. The employee should receive 1 times the regular pay for any hours worked over the prescribed 40 hours in a week. The program should output the following information:
-The employees name without trailing or leading spaces
-Regular hours worked
-Regular pay
-Overtime hours worked
-Overtime pay
-Total pay
The Problem that i am having right now is "Displaying " the overtime hours on my "FORM VIEW" i mean i did the math right its just when i type (lblOverHrs.Text = CDec(CDec(OvrHrsWrkWeek1.Text) + CDec(txtOvrHrsWrkWeek2.Text))
Its says the "OvrHrsWrkWeek1 and 2" are not Declared which are..im not really sure where i went wrong..
Heres my code
CODE:
View 4 Replies
Jan 10, 2011
How can I populate a single DataGridView cell with input of a textbox after click event of a button?
View 6 Replies
Jun 11, 2011
i wanted to show the name of an employee once he/she typed the correct id number and password.. and it will show the name into the name textbox... same as the the current time once the user clicked the time in button it will show into the time-in txtbox...same to the time-out how its logic goes..
View 3 Replies
Apr 25, 2011
I'm trying to create a program, that upon opening, will read an input file containing a delimited employee record. The record will contain the name of the employee, their salary and the number of years they have been employed.I'm looking to display only the name of the employees in sorted order(alphabetically) and then when the user of the program selects a particular employee, I want to display the salary and number of years for that employee.I would like the user to be able to edit the recors for the employee and I would also like to have a way for the user to be able to add/remove an employee record and update the input file before the program is closed.
View 5 Replies
Oct 17, 2010
Hey guys,
I am trying to make a search feature in my program. My program has a .csv file that the program will need to search for a equal value that was entered in thr text box. I am just not to sure how to go about this. Just need some insight on how to grt started. Insight please.
View 8 Replies
Sep 15, 2009
I have a VB project with a form where user adds/modifies the data, data are stored in SQL. On the form there are 2 tables that are linked by employee ID. When I test the process and insert a new employee record and add new comment for this new employee in DataGridView - when I save it I get an error that "Object reference is not set to an instance of an object". During more detailed debug it says that CurrentCell is set to Nothing - even that I do have values in all fields.I do set employee ID in the related table in the Grid to the value from the employee record - so all primary keys do have value and the comment is saved after all but I get an error and saved comment dissapears from the screen right after saving. When I pull the same new record again - everything is saved. What am I missing and how to avoid the error and dissapearing of the saved comment?
Also - I tried to save the new employee data in the first table first and then add comments - it didn't solve the problem. But if I add first part of information in the main table, save and close the form, then go back and add comment - it works fine. The problem is - it's not convenient for the user - they'd like to enter everything at once.
Private Sub TblCommentsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblCommentsBindingNavigatorSaveItem.Click
Me.Validate()[code]....
View 6 Replies
Mar 11, 2010
I am trying to do a record search feature in my datagrid, but I can't find any reference for this. What I want to do is I can search any of the row that contain the text that type in TextBox1 by clink on Button1. I am using VB2008 and the datagrid is connect to access.
View 1 Replies
Sep 17, 2010
I have a program that is reading an Excel (xlsx) file and I am trying to take the data found in one of the cells and split it based upon the '@' symbol inside that cell. Here's an example: value in cell is "XXX @ YYY" I declare 3 strings (strOriginal, strA, strH) strOriginal is the value from the cell ("XXX @ YYY") then my code is supposed to split up the values in the Original string based upon that '@' symbol.So when my code is done, strA should = 'XXX' and strH should = 'YYY'.
Here is my code
strOriginal = dtbExcelData.Rows(0).Item(0).ToString
y = strOriginal.IndexOf("@")
strA = strOriginal.Substring(0, y - 1)
[code]....
For some unknown reason, the y integer (in this case, it is '4') changes to a random number (it has changed to 44, 61, 124) and causes the error "Error with Excel file: Index and length must refer to a location within the string. Parameter name: length" to occur.I understand why the error occurs (my y integer is not staying at 4)...I just don't understand why that y integer is changing numbers when it should remain as the indexof the '@' symbol. I'm looking for any suggestions on how to pull out the data after the space after the '@' symbol (the 'YYY' portion of 'XXX @ YYY'). Also sometimes the 'YYY' is only 'YY' as well.
View 4 Replies
May 23, 2011
I am in VB.net and wondering if there is a way to call a search from a console application.For example when the user clicks cancel on the Input Box it brings up the file browser for their computer allowing them to choose a place to save the file.[code]
View 1 Replies
Mar 28, 2011
Here's the situation: I've got a form that has
- RichTextBox
- OpenButton (to load RTF file)
- SaveButton (to save RTF file after editing)
- Textbox (for search phrase)
- SearchButton
- ExitButton
- 2 RadioButtons (WholeWord and MatchCase search)
All of them are working just the way I want them to except search features; I don't know how to write them properly. At the moment, they search and highlight only the first word they encounter. E.g. say I search for word "the" in the document, only the first "the" it encounters is highlighted. The rest is just untouched.
I understand this is because I've only got few lines of simple code as follows
If rtfText.Find(txtSearch.Text, RichTextBoxFinds.WholeWord) = -1 Then
MessageBox.Show("No results returned. Please try again.", "No matching results.", MessageBoxButtons.OK, MessageBoxIcon.Information)
End If
I did try a few other snippets I found on the Internet including While loop but they didn't work as I wanted them to, and I couldn't understand them either. What I want is, which ever search option is used, when the matching result is found; it will highlight that word and when I click it again it will move onto another word. If I keep clicking, it will highlight the same words (but located in different areas) throughout the whole document and at the end, it will send back to the first matching word. Just like Adobe Reader search.
View 4 Replies
Jun 23, 2010
while entering in a textbox the collection is narrowed in datagridview. I have read that sqldatareader is faster than a sqldatadapter.
View 1 Replies
Feb 19, 2012
If my Category and Forum selection is incorrect I am sorry and feel free to move it. I'd like to have the users input in the message box that will show. For example: There is a textbox and the user puts in their name as Bob. Then the message box would be: What my main goal is, is being able to include the users input they type inside the textbox inside the message box.
View 6 Replies
Sep 23, 2009
Can we Use One Click Deployment Feature Visual Basic 6.0
View 3 Replies
Jan 13, 2009
I have an application which displays thumbnails of files in a folder. I want to add the feature where the users can right click on a file and get that windows context menu. You know the one. It allows you to choose an application from a list to open the file with.
I seem to remember asking this ages ago but I can't find the thread.
View 1 Replies
Jan 5, 2010
I'm creating a search function to search through a binary file and find a record based on the users input. Surprisingly, that isn't the problem! The problem I'm having is that as part of this I'm using a procedure to display results in text boxes, and I'm getting the error "Too many arguments to private sub display customer"I've encountered this error before, but never really knew what it was... Here is my code.
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
FilenameCust = "F:\College\CustomersFile.bin"
[code].....
View 4 Replies
Oct 2, 2009
I am having trouble with a separate program that keeps saying Adobe flash is not installed. And I have tried everything but it still wont go away (that was off topic a bit). I want to create a program that will auto click the words "Click Here" if the error message shows. Because if I click there then it will work normally until it pops up again.
View 3 Replies
Jan 10, 2011
I am wondering how you would go about making a search function for a grid in VB.net. Right now, I have it so that the person clicks a button and they see the last 50 records they've looked up. This works fine. I also have a search button that works like this[code]...
View 2 Replies
Aug 14, 2009
How do I input a combobox into a selected cell in a datagridview
View 6 Replies
Jul 28, 2009
I want my console application to be able to do one function I have when you click one option on the windows context menu, and another function when you click another option.
View 3 Replies
Jul 23, 2010
I have a VB.NET search routine, part of which is provided, below, that checks all Text cells in a DataGridView for a given string (inclusive), using a basic set of nested loops to perform the search:
' Search for the first occurrence of the given string
For Each row As DataGridViewRow In dgvMembers.Rows
' Skip the new row
[Code].....
is there a way to replicate this behavior using LINQ? Basically I would like the query to select (or return) the first DataGridViewCell whose text contains the search string. I've done some tinkering with sub-queries and the like, but I'm still having trouble wrapping my brain around the concepts (too many years of writing T-SQL, I guess).
View 2 Replies
Mar 7, 2011
I have a form with 2 datagridviews on it, each connected to to table in a database: dgv1 and dgv2.
- Dgv1 has a column called "Senders" and a column called "Recievers".
- Dgv2 has a column called "Recievers"(this is a master list of recievers) and a checkbox column in it.
Basically, when you click a checkbox in dgv2, it copies the name corresponding to it(from "Recievers"), to the "Recievers" column in dgv1.What i want to happen is, when the user selects a name from the "Senders" column in dgv1, it should automatically search the "Recievers" column (also in dgv1) for names(each name is on another line in the cell), based on the "Recievers" columnin dgv2, and if it's in the cell, it should check the checkboxs corresponding to the name in dgv2.
View 19 Replies
Jul 27, 2010
I have three classes Employee, Manager and Salesman. Manager and Salesman classes inherits Employee class.
Employee :
Public MustInherit Class Employee
' Field data.
Protected empName As String
Protected empID As Integer
Protected currPay As Single
[CODE]...
Manager :
Public Class Manager
Inherits Employee
[CODE]...
Salesman :
Public Class Salesman
Inherits Employee
[CODE]...
Now I have created a object of salesman and manager using the following code:
Dim objSalesMan as Employee=new Salesman("xyz",1,2000,5000)
Dim objManager as Employee=new Manager("abx",2,5000,"production")
Is this a good programming pratice or should I use:
Dim objSalesMan as new Salesman("xyz",1,2000,5000)
Dim objManager as new Manager("abx",2,5000,"production")
View 6 Replies
Mar 30, 2010
With the on-line one click install feature will the application install on a MAC?
View 2 Replies
Feb 4, 2011
I am creating an excel file and have to add a dropdown list to a cell. It looks like I need data validation, but my attempt errored on the .Add line.
With wkbSheet.Range("H" & rowCt).Validation
.Delete()
.Add(Type:=Excel.XlDVType.xlValidateWholeNumber, _
[Code]....
View 2 Replies
Jan 25, 2011
Before any jumps in and says, Why dont you just use a gridview, i have my reasons not to use it.I trying to dynamically create a table and then populate the cells via a linq object.
Good news, i can dynamically create the table and the cells.
Dim numrows As Integer = MyActions.Count()
Dim numcells As Integer = 5
[code].....
View 3 Replies
Dec 15, 2009
I am trying to search the 4 columns of my array by using this click event. The column is determined by a radio button as you can see. I changed my code from last time and now it works, but only for the first column. If i try to search out a string in the second or third columns I get an error based on the line highlighted in blue HTML accutally shows and it is green. the error says Index was outside bounds of array
Like i said It works fine for all values in the first column, accually the second (Numbered 1). If i enter a value in the partsnumBox and it is found in the the 2nd 3rd and 4th columns I want the value in the first column (0) of the same row.
Private Sub FindButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FindButton.Click
'Define Array
Dim PartsArray(,) As String = {{"PR214", "MR43T", "RBL8", "14K22"}, {"PR223", "R43", "RJ6", "14K24"},
[CODE]...
View 2 Replies
Dec 7, 2009
I have a DataGridView on my windows form. I am adding columns to the datagridview at runtime. In doing so, I create the columns by this code:
[Code].....
At least one of the DataGridView control's columns has no cell template.
I have looked and looked and I appear to be doing everything correct
View 2 Replies
Feb 17, 2011
I am able to add an existing MDF database to my project and apply it to a form with the appropriate binders and navigators and such and it works fine. I can hard code queries that are very successful. My question is this: Is there a way to add a textbox to the form, where I could enter a valid query that would execute on a button click event? It seems like I should be able to do so with SqlCommand, but I am just stumped.
[Code]...
View 3 Replies
Apr 25, 2009
I have a problem with Data Grid. I'm calling my function in dataGrid.cell_endEdit and it doesn't work exactly the way I want it to. If I'm editing a cell and click in menu (or press ctr +s which means Save cell in my program), cell_EndEdit is not running. I know it is correct, but what can i do to save my changes in these cases?
View 4 Replies
