Forms :: Check Box In ComboBox Selection?
Nov 22, 2009Wanted users to choose two options 1.(tick) 2 blank text so they can write things.
Was thinkin how this can be achieved using a comboBox. ?
ADVERTISEMENT
Forms :: Assigning A Value To A Combobox Selection?
Nov 26, 2009I have a combobox with multiple names. When I select one of the names from the combobox I want to display a value(number) instead of the name itself. How could I do that?
View 3 RepliesForms :: Get Hidden Value / Tax From Combobox Based On Selection
Feb 17, 2010I have a combobox populated from the DB with:
-ID
-State
-Tax
State is the only value that is shown.I'm trying to get the hidden value, Tax, from the combobox based on the selection but can't figure it out.
MS Access 07 - Use Button To Have A Combobox Appear And Selection Opens Appropriate Forms?
Jan 23, 2010I am creating a document control system for standard operating procedures (SOP) in MS Access 2007. I have just started an online VBA class and have moderate MS Access 2007 experience. This thread is very detailed and lengthy.I have the tables set up and forms created for CREATE, SUPPLEMENT etc. I need to create a user interface so that when they open the database it pulls up a form that has buttons for "Start New SOP Process" and "Modify Existing SOP Process". Every step of writing an SOP is dated so that management can have outputs for target measures (to see why it takes so LONG to write an SOP from start to finish). After the user selects "Start New SOP Process" or "Modify Existing SOP Process" I am trying to have a Combobox appear with a drop down box of change types: CREATE, SUPPLEMENT, and REVISE.
Primary Key Explanation:Each document has a 3-part number comprising a 3-part PK. 1.001v1.0. Where 1 is (1-6) identifying what type of SOP: Document Type,.001 is the Document Series (a sequential number for each type of equipment--the 2nd SOP written for a document type 1 would be 1.002v1.0) and v1.0 is the version.
For example, lets say Document Type 2 indicates field equipment. The very first SOP written for a piece of field equipment would be 2.001v1.0. If a supplement is made to the SOP for that same piece of field equipment, then it becomes 2.001v1.1, if a revision is made to that same piece of equipment it becomes 2.002v1.0. If we buy a new piece of field equipment it would be assigned SOP document number 2.003v1.0.
After a document is changed (any part of the 3-part number is changed) the previous record is put into an archive table so that the technicians/general public have access only to the most recent version of each SOP. I am going to store them on Sharepoint with an Archive Folder and an Active Publications Folder and a link to the document is provided in the database. However, while a document is being modified (going through the SOP process of reviews and drafts) the users are going to need access to the previous version until the most recent version is approved (maybe I could have the document be archived upon completion of the Document Link control).
For each Combobox option I need a different "On Click" command to open the associated forms for each "Change Type". I have the necessary forms already grouped (using subforms and tabs) for each change type: CREATE SOP (has all of the forms needed when creating an sop), SUPPLEMENT SOP (has all forms needed when supplementing an sop), REVISE SOP (all forms for revising). I am trying to use If Then statements for this...
The modify part is the simplest. I think the Combobox for the "Modify Existing SOP Process" should consist of "Change Type" (CREATE, SUPPLEMENT, REVISE), "Document Type", "Document Series", and "Document Version". I want the "Change Type" to open up the correct group of forms with "Document Type", "Document Series", and "Document Version" finding the existing record that needs to be modified (i.e. so that the user can add dates for completed activities as the SOP process progresses: draft revisions, reviews).
The "Start New Process" is even more complicated. Each change type does more unique event procedures than just opening the forms (which I can't even figure out to begin with!!). The Combobox would still be "Change Type" (CREATE, SUPPLEMENT, REVISE), "Document Type", "Document Series", and "Document Version". However the following is what I am trying to do for each "Change Type":
When "Create" is chosen from the Combobox it will find the next record in the document series by the user selecting the correct "Document Type". I would like to add a formula so that it adds .001 to the previous record (giving the next sequential number), and force v1.0 to be entered and not able to be modified, since a newly created document can only be version v1.0. Then it would open the "CREATE SOP" form (all forms associated with "Create" compiled on one form by tabs and subforms--I already have this complete for each "Change Type") and require the user to fill out all document information controls (title, description, etc) before closing.
When "Supplement" is chosen from the Combobox it will find the most recent record by the user's input of Document Type and Document Series. I would like to add a formula so that it adds .1 to the previous Document Version. Then it would open the "SUPPLEMENT SOP" form. It would be useful if the fields for the document information controls (title, description, etc) were appended to this form but it is not necessary.When "Revise" is chosen from the Combobox it will find the most recent record by the user's input of "Document Type" and "Document Series". I would like to add a formula so that it adds 1 to the previous Document Version and forces the decimal value to be 0 (revise and create change types have to end in a "0"). Then it would open the "REVISE SOP" form. It would be useful if the fields for the document information controls (title, description, etc) were appended to this form but it is not necessary.Additional buttons I would like to have on the Main Menu Form--opened when the database is opened (includes "Start New SOP Process" and "Modify Existing SOP Process") would be:
"View All Publications" where a user can not edit anything, just gives them access to the current "active" SOP links. It would be a complete list of all of our SOPs. I think I could use a query "Retire" which would put an SOP into the Archive table/folder on Sharepoint. This would be useful in addition to the automated retiring of previous version in case we discontinue use completely of a peice of equipment or administrative procedures (yes we have SOPs for EVERYTHING!!)"Target Outputs" which would be a report showing the timeline of the SOP process so that management can see where we are spending too much time (my vote is for the design of the document control system!!)"Maintenance History" which would show all previous versions for each piece of equipment and administrative procedure."List of Archived SOPs"which would show all of our inactive SOPs, for the Quality Analysis/Quality Control person's benefit.
Forms :: Populate Textboxes Based On Combobox Selection NOT Using Databinding?
Apr 27, 2010how to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
[Code]...
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
Forms :: Clear The Dgv When The User Blanks The Combobox Without Necessarily Changing The Selection Index?
Oct 25, 2010I have just realised that ComboBoxes don't have a Change event. I have a combobox filled with a few items, eg. Bakery, Deli, Fruit & Veg, etc. Choose one of these items, all the related items show in the dgv. However, when I blank the text in the Combobox (press Delete key whilst Combobox has the focus), what event fires so I can blank the dgv? The combobox does not contain a Blank item. Even if it does, the Blank item only fires the ComboBox1_SelectedIndexChanged when the user scrolls down to, or clicks on, the blank value.
I want to clear the dgv when the user blanks the combobox without necessarily changing the selection index.
Update Source Combobox To Printer Combobox Selection?
Mar 27, 2011Is there a way to update source combobox to printer combobox selection?So going from printer1 to printer2 the source will update according to what that printer has to offer.
View 8 RepliesCombobox - When Select A Value From The Combobox The Selection Won't Validate?
Feb 22, 2012I'm having a problem with combo boxes. I usually use Java and it's been awhile since I used VB but I never remember having this much difficulty.My application is using an SDF file. From Data Sources, I drag the details on one of my Tables to my Form to get all of the fields. Three of them are comboboxes. Each of the three is an INT64 and each corresponds to a primary key in a different table. I click the tasks button on a combobox and for data source I select the appropriate table that has the data to go with the combobox, for display member I select the field that I want users to see, and for value member I select the primary key. Then I run a quick test and start the app, open the form, and add a new record. When I select a value from the combobox the selection won't validate because it doesn't think it's an INT64 like it should be. It seems to be using the display member as the actual value instead because if I change display member to the primary everything works great.
View 11 RepliesFill A ComboBox On The Selection Change From Second ComboBox?
Jan 15, 2012I have two comboBoxes, one is CountryCombo and second is StateCombo.What I want is the that when i the clicks country combo and select a one country then the States of that the country should get populated in the State Combo.I have tried things many many many but nothing working. Below is my code of how my CountryCombo is getting filled.
query="select CountryName from CountryMaster"
if dr.hasRows()
{[code]......
Populate Combobox From Selection Of Another Combobox?
Jan 1, 2012I currently have a form with two comboxes. The first cbo is being populated with a project number, which is being pulled from the first column of a spreadsheet. I now want the second cbo to read the first cbo and then find that project number on the spreadsheet; when it finds that project number, I then need it to copy data from the row the project number is on. I have converted to vb from vba. Below is the code I used in vba (which obviously does not work). I only need certain cells from the project row.
Dim proj_num, rng As Range
Dim data, i As Long, j As Long
With Sheet1
[code].....
ClearDataGrid On New ComboBox Selection?
Aug 15, 2011i have used the following code to populate a DataGrid based on the contents of a textbox. the users searches for a name which is populated into a combobox based on the name in the combobox several textboxes are populated with data based on the data in one of these text boxes Private bindingSource1 As New BindingSource
[Code]...
Get Value Of Selection In A Checked Combobox?
Jan 28, 2012I have put all of the items from my Database into a Checkbox Selection, I now want to take the selection that the user makes from the checkbox and turn that into a string that I can then COMPARE through antoehr table.[code]...
View 7 RepliesLoad A Combobox With Selection From Another?
Mar 26, 2009Load a combobox with a selection from another?[code]....
View 2 RepliesMulitple Selection Combobox?
Jun 18, 2012Basically, I need a combobox populated by data in a table column that I have created.The user will need to be able to pick more than one option.
For example:
Pizza Topping
+ onion
[code]......
Validate A ComboBox Selection?
Jan 18, 2011I know this seems like a .Net 101 question but everybody has their own way of programming and I'm curious as to what is the preferred event for checking a ComboBox when a user makes a selection?
View 2 RepliesBasing ComboBox Values On Selection Of Another One
Mar 7, 2011Is it possible to have a different selection of values in the 2nd combobox depending what was picked on the first combobox? For example an American state is picked in the first combo box and the second combo box loads the cities in that state? I'm just using a basic form in Visual basic 2010 there is no database behind it.
View 6 RepliesComboBox Value Selection - Using Specified Table As Reference?
Feb 6, 2012I have a vb application sitting on an sql server with 4 different tables. I want a scenario where when I select any table from the combobox, every query I will run should use that table as a reference.
E.g. ComboBox values(tables)=A,B,C,D
If A is selected then
SQLQuery="Select * from A "
If B is selected then
SQLQuery="Select * from B " etc
Databound Combobox Selection Retention
Apr 20, 2009On my form I have three fields and a datagrid view.One field is a combo box.All fields are databound.The datagridview is a detail grid, bound in the "normal" way. Scrolling through records, etc., all work fine.What doesn't work is when a selection is made using the combo box.The underlying table has a self-join of one-to-many: ParentID, ChildID. ChildID is the main ID for the underlying table.Children may have a parent This is just by way of example.So, the combo box's Value is bound to ChildID, and the SelectedValue is bound to the ParentID.On the form one chooses the Parent with this combo box.When I test this arrangement, I select a Parent, then click Save (using the default toolbar actions). However, the combobox seems to "reset" the selection to the first in the list.
View 1 RepliesFilter A DataGridView By Combobox Selection?
Jan 22, 2012I have a ticketing system that reads a MS 2003 MDB. I can easily fill the DataGrid view with all of the items on the data set How ever I need to be able to have agents filter the rows by login(key)
I have a large list
made this way
csrLogin.Add("james", "TomJim")
I select agents on the menu strip and the combo box populates all the names in that collection (combo box displays TomJim in this instance
I have an SQL query made (I think it is correct)
[Code].....
Open A File Into A Rtb From Selection From Combobox?
Sep 18, 2010I cannot seem to load the saved .rtf document into the richtextbox when i click on that file in a combobox. I checked msdn and tried what it suggested, but got no results.
View 1 RepliesOutputting ComboBox User Selection?
Feb 3, 2009I have a combo box that has multiple options, when the user selects one of the options (world wide city destinations) a specific value is assigned to a variable. For example if "New York" is selected the variable "x" is assigned the number 155. What I want to do is output the destination that has been selected ie "New York" in a label called "lblOutput1", do I need to store the destination as a seperate variable to be able to produce it in this label as I cannot seem to get it to work:
At the moment I am using:
lblOutput1.Text = "bla bla bla " + cmbDestination.SelectedText + " bla bla bla " + Today()
Populate A Datagridview With A Selection From A Combobox?
Apr 9, 2012How can i bind a comobox selection to a datagridview without writting code...
i Need to select an item from a combox and based on that item refresh the datagrdiview. I did something like that in Access but i don't know how to make it work in visual studio 2008.
once i select the datagridview itme that i want to edit i'd like to be able to update back to the database. I know i need to write code for this but at least i'll have the data refreshed on the datagridview.
Saving New Selection From Combobox To SQL Database?
Jun 17, 2010I have an app I'm working on with multiple forms. One of the forms, frmLocationInfo, has textboxes and comboboxes which are automatically populated based on a combobox selection from a previous form, frmLocations. I've been able to get any changes made to frmLocationInfo's textboxes to save to the SQL database, however, when attempting to select a different item from any of its comboboxes, it's not saving to the database and instead, I receive a "Procedure or function...has too many arguments specified" error.
Here is the code for the Save button:
'Save changes to Locations db
Private Sub btnSaveClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
Use Constant Values Upon Selection From ComboBox??
Apr 3, 2010I have the following constants declared:
Private Const LuxuryRate As Double = 74.84
Private Const FullSizeRate As Double = 48.44
Private Const MidSizeRate As Double = 44.91
Private Const CompactRate As Double = 30.46
And a combobox that lists each option. How can I set an if statement that uses these values if the option is chosen from the combobox? This is going to be part of a calculation performed when the button is pressed.
WinForms ComboBox Selection Color?
Jan 23, 2012I have a Win Forms app written in vb.neIn it, I have a combo box with an OwnerDraw Item routineUsing this routine, I am able to implement an application-wide default value for a selection color like shown below:This works great except for one tidbit:ction color again in teh textbox portion of the control
View 5 RepliesCellClick Event - Selection From ComboBox Not Smooth
May 28, 2012I have a DataGridView with two columns. One is DataGridViewComboBoxColumn and other is DataGridViewButtonColumn. To capture the button click from the DataGridViewButtonColumn, i have written the CellClick event and it is working fine. However, this is not making my selection from the DataGridViewComboBoxColumn 'smooth'. What i mean is that i have to click on the combo-box twice for it to show the drop-down list. I have noticed that at every click, CellClick is fired. But only after the second click the drop-down pops out. What is the work-around for this?
View 1 RepliesChange Text In Combobox When User Changes Selection?
Aug 19, 2011I have a combobox on a form with the dropdownstyle set to drop down. Users can either salect a value from the list, or type in any value they wish. This all works fine. However, when one particular item in the list is selected I wish to set a different value. Unfortunately I don't appear to be able to set the combobox Text property from within any of the events that fire when the selected item is changed.
[Code]...
Changing Content Of A GroupBox With ComboBox Selection?
Jul 16, 2009I have a ComboBox, and I have a GroupBox. What I want is for the content of the GroupBox to change when I change the selection of the ComboBox.
View 6 RepliesCombobox Listing Depeding On Previous Selection?
Jul 6, 2009i'm new here and a little bit of a noob anyways i'm using VB.NET 2008 what i'm trying to do is list about 7 items in combobox1 and then depending on the selection list certain items in combobox2 but if the selection in combobox 1 changes then combobox 2 items need to change as well.
View 2 RepliesCombobox Selection Alters Listbox Contents?
Feb 22, 2012I have a form with a combo box and a checked list box. When I select one item in the combo box, I want the list in the checked list box to change to the appropriate choices.
View 19 Replies