I use Microsoft Visual Basic Express edition 2008 on my Windows XP SP2 and in it, in a Windows Form project, I add a button to my default form and set it's flatstyle to flat and borderwidth to 0. At runtime, when I click that button, I get a black color hollow box on that button at it's center...
View 6 Replies
I 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.
I have a listbox (20 Items) with multiselection and label that disply the selection and one button. So I wrote (it works fine)
[code]...
Now when I click on button the label show lets say Item2,Item5,Item10,How do I take off the last ","
somthing like that Item2,Item5,Item10
I used to do: Dim s As String = Trim(Label1.Text)Label1.Text = s.Substring(0, s.Length - 1) but it give me an error converting intiger to string
Private Sub ListOfCrops_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ListOfCrops.SelectedIndexChanged
View 9 RepliesI have a list with several fields that is created from dataset from a linqtosql query. At run-time, the user gets to specify what field he/she wants to display from the list. In other languages, I can dynamically do this like:
valueIwant=mylist(i).[fieldnameImInterestedIn]
Where 'fieldnameImInterstedIn is itself a variable. How do I do this in VB.Net?
non-working actual code follows:
Dim patientdata = (From patientvar In pdfdatacontext.tbPatients Where patientvar.PatientID = patientid)
Dim patientlist = patientdata.ToList()
fieldvalue=patientlist(0).(reportrow.userselectedfieldname)
for an application, I generate RichTextBoxes during runtime with the following code. The code generate a new node in Treeview under parent node "Notes".
Dim RichTextBoxCounter As Integer = TreeView_MainForm.Nodes_("NodeNotes").Nodes.Count
Dim NewNote As New RichTextBox
NewNote.Size = New System.Drawing.Size(845, 550)[code].....
Now, I want to show the RichTextBox if the associated child node is selected. I tried the code below, but it does not work.
If TreeView_MainForm.SelectedNode.Text = "Notes" Then
Dim NewNote As New RichTextBoxPrintCtrl
If TreeView_MainForm.SelectedNode.Parent IsNot Nothing Then[code]......
provide the code to display the RichTextBoxes after selecting the node.
I am trying to convert a value from a radio list box that is populated by an access database. The database loads fine, I have no trouble with that. My issue is that I am trying to take the value of the radio button chosen and turn it into a font color. Therein lies my problem. I see that it cannot be a string, but when I turn it into an object, I get an error. I will note that I am using VS 2008 (Windows Vista x64), and the database is compatible with a 2002 - 2003 Access database. I am using ASP.NET for my programming, however, I am trying to program it in VB. This is my code:
[Code]...
At design-time, when one clicks a control it is selected and this state is depicted with a frame drawn around the control. I would like to know how can I mimic the same effect at runtime; that is, how can I draw a similar frame around a control when the user clicks over it?
View 2 RepliesI want to retrieve all input, select and textarea fields only and possibly change their data value. I currently declare as: Dim theElementCollection AsHtmlElementCollection = WebBrowser1.Document.All ' which I then iterate through and select on tag name.
I would like to be more efficient and do something like: Dim theElementCollection As HtmlElementCollection = WebBrowser1.Document.GetElementsByTagName("input", "select", "textarea") but GetElementsByTagName doesn't appear to support multiple selections. I saw on the net where someone declared as Dim Tags As HtmlNodeCollection = docNode.SelectNodes("//input | //select | //textarea") I tried this but HTMLNodeCollection is not referenceable under HtmlDocument. I have played around a bit and can't see an equivalent.
I have a question how can I change the BackColor of all forms at runtime?
I tried to loop through each form but didn't work for me
I have the following in vb.net
<asp:RadioButtonList ID="rbEdit5" runat="server" RepeatDirection="horizontal" >
<asp:ListItem Value="1" >Yes</asp:ListItem>
<asp:ListItem Value="0" >No</asp:ListItem>
</asp:RadioButtonList>
I need to programatically select one of the 2 listitems.How do I programatically select say 'Yes' above in vb.net?
I 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 Repliesim kind of new to VB and im making a program for my dad to backup his hard drives nightly.[code], im wondering how i can make it so when people select 12:00 PM, my program will grab the user's time and sleep until it get to the selected time.
View 1 RepliesWanted 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. ?
ok, got a question here, two really. first i'll ask the hard one, as i think i have my other one out of the way so i'll save it for later but i made a program where a user enters in dimensions in several text boxes in inches. there are radio boxes that the user decides what thickness of wood they would like to use. what i'd like to do is add metric into the program and use two combo boxes. one combo box drops down and you can select inches, centimeters, or millimeters. the other one drops down to choose the thickness of the wood.ok now here's my question. say i pick inches in the first combo box, i'd like the second one to display only the thickness of the wood in inches, no metric. if i pick centimeters, i'd like the second combo box to display the thickness of the wood in only centimeters, no millimeters or inches. and the same goes for millimeters.i also have the program on a timer that runs at 100 milliseconds so the user can quickly see the differences in dimensions they put in instead of having to hit the calculate button over and over and over (not sure if that really matters or not, had a couple issues with the boxes earlier but don't think it was timer related now)but is this possible? basically just looking for the kinds of drop boxes that you see on a page like autotrader.com where you select dodge, and then only the dodge cars are listed, select chevy and the chevy cars are listed, etc.
View 7 RepliesI'm currently working on multi selection on the Picturebox. I'm kinda of stuck with these coding.
Public Class Page_2
' for selection on part of body
Private start As Point = Point.Empty
[code]....
I use vb2010 to create a simple windows form.I have a checkedcombobox which gets its items from a column (titles) from a .mdb database (this works). When I check an item or multiple items in the combobox, I want to display (multiple columns) the title and for example info in a datagridview.
View 2 RepliesI 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.
I have code to create a listbox and populate it, and would like the box to behave like it does when clicked, e.g. if you CLICK on "a" you see it blue and can press the down arrow to move down to "b". how do I achieve this programmatically?
Private Sub junkloader()
brandlist.Visible = True
brandlist.Items.Clear()
brandlist.Items.Add("a")[code].....
this code SELECTS it properly, but I want to be able to navigate with the up and down arrows. how do I do this? thanks.
I have just made a simple application with a questionnaire. The questionnaire has all 40 questions in the same page (that was one of the specifications) which makes for quite a long form. On top of that, each question has its own group box and each group box has 4 radio buttons for the possible answers (in total 160 radio buttons).
I want the user to be able to scroll down using the up/down arrow keys. However, if he has just selected an answer, pressing the down key will only change the selected radio button (as is the expected behavior of a radio button).
How do I disable the selection of a radio button through the up/down arrows?
I set an ampersand sign in from of a Radio button text. However the I could not select the radio buttons unless I used the mouse. In other words the shortcut setting is not working for the Radio button
View 3 RepliesHow would I display list items from multiple selection listbox in order they are clicked?
View 4 RepliesI've got 2 radio buttons on a form and am trying to allow a user to change the color of the form based on which radio button is selected. I've used select case in a separate procedure to do this because ultimately I'd like to have about 1/2 dozen or so color options to choose from.
The color changes when the first radio button is selected (pink or green, doesn't matter), but when I try and select a 2nd option, the program crashes (VB 2010 Beta).
My code so far is:
Public Class Form1
Private Sub SetColourScheme(ByVal colour As String)
Select Case colour
[Code]....
I get a 'StackOverflow' error, but I don't really know what this means. NB: Adding 'Return' keyword made no difference to the outcome - same error.
i want to show a panel when a particular item is selected in a radio button list. "Different selection have different panels"
View 2 RepliesOk so i'm trying to set up my program so that when I choose WinRar it opens a new window asking which architecture to use. I have a combobox set up with both architectures in it. I have the accept button disabled so that you have to choose an architecture and I figured out how to make it so that when you select one architecture it will enable the accept button but if you choose the other architecture it disables the button.
Private Sub cmbx_rar_wdw_arch_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbx_rar_wdw_arch.SelectedIndexChanged
If cmbx_rar_wdw_arch.SelectedItem = ("32-Bit (x86)") Then
[code].....
I m doing a touch screen interface, to browser a page I used a webbrowser control, and in order to get ride of the ugly scrollbar, i m trying to use mousedown and mousemove event on the webbrowser to move the page around, it worked but when i m doing it, it select and highlight the content on the web too, how can i stop that?
do I need to create a extended webbrowser control by Inherits the orginal one?
if so, which event should i capture and override the handler?
When we left click a grid cell, or list item, it highlights. Left click outside it and the selection jumps to the new place.
I can RIGHT click anywhere in the grid without disturbing an existing highlight, but I want it to work more like windows explorer would in terms of file selection..
i.e. if I right click inside the range, the range stays, if I right click outside the range, the range moves to a new single cell that I just right flicked.
Try it now on this page. Select some text, right click on the selection and it stays. Right click outside the selection and it goes. In datagrid (for example), the selection can only be modified with a left click.
How can we change this so the selection behaviour of a datagrid/list is more like this text pane?
On a related note. If I left click in a textbox I can drag a selection out. If i wanted to right click and drag the selection out, would it be the same process? (It's for a custom string manipulation picker control..)
how 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.
My problem is, I just finish creating a program, that loads a picture and description of a selection from a radio button.
Everything works on MY comp, but when i go to my lil sister comp and load the .exe file there, everything works too EXCEPT the image....the error is something along the line " C:documentspictures ame.jpg" not found.
My question is: how would I store the image to the program via another file or the program itself. so that when I "build" my program, I just need to run the .exe and lets say another file "for ex: .dll ", with all the images stored inside. And I dont know how to create and work with .dll file or whatever file is more convience.
I 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.
