Am Developing a program that requires alot of questions on a database. each question have four options in answer. one of the four options is .is the correct answer. i need idea on how to arrange the question and four answer options table in access. do i need different access database for the question and each of the answers options.?
View 2 RepliesI am using Visual Studio 2010 and SQL Server 2008. I made one preject using Employee table and Employee_Permission Options(Yes/No/Override/Never). I want to both table in form detail view most using combo box. if I used Employee detail view and Employee_Permission Datagridview than its work fine to add/edit/update but if table Employee_permission I used detailview (all Combobox) than I can not add/edit/update records. I can add only employee but can not add record in employee_pemission. I have relationship with two table EmpID in both table Primery key with auto increase in Employee table.
View 1 RepliesI originally posted this to the XML forum and it was suggested that I post here to see what other options might be available. The complete post is here. [URL] Wondering if someone can offer me some advice on a suitable solution for an application I'm developing. I've used xml and text files in VB.net fairly extensively for storing configuration files and the like but I'm wondering if there
[Code]...
I'm using the code from the following site to create a file manager within my app: [url]Which, I think is great. When I first started programming, I wanted to use this code, but I couldn't understand it. I love how now, I understand most of it and know how to implement it. Which, I owe much of my progress to some of you at this site Well, back to what I was saying. I want to be able to make a right click menu and have it access options like copy, paste, etc. I'm sure I can figure that out, but I can't seem to figure out how to make a right click menu.I thought I could manipulate a menustrip, but I wasn't sure how.
View 3 RepliesI am in need of a form that shows various options, exactly like the Options in Visual Studio. Since there are so many options I too want them categorized, with a TreeView to the left taking care of showing the right category.The usual 'easy' approach here would be to just place a TreeView control on the form, add some nodes, and give those nodes a tag or key that corresponds to a panel or UserControl with the options for that category.Since there will be a lot of options however, this is not really feasible design-wise; the form would be cluttered with possibly 50 panels, all of which I would need to select and bring to front from time to time to add controls to them that represent the options.
So I decided to create a custom control that does exactly that. The control is very similar to my Wizard usercontrol, users can add OptionsPanels at design time, which inherit Panel and simply represent one panel of options. When they do, the panel is added to a container panel, and at the same time a TreeNode is added to a TreeView. The control uses a custom ControlDesigner to handle design-time clicks in the Treeview, selecting a different node would select and bring to front the corresponding panel, allowing the user to add the controls he wants.
Due to the design time support the problem of having 50 panels is no longer present, only one panel will be visible at a time and selecting the right panel is as simple as selecting the corresponding TreeNode, just as during run-time. Anyway, I got all this working, but only for a single 'level' of categories. As you can see in the Visual Studio options, there can be multiple levels of categories. For example, the Environment node has a bunch of children, where each child represents one 'options panel'. There can even be deeper nesting, see the Text Editor node for example.Let me begin by drawing out the basics of how my control works so far.
The main control is an OptionsView control, which contains a SplitContainer with a TreeView to the left and a OptionsPanelContainer to the right. The OptionsPanelContainer is merely a Panel to which only OptionsPanel controls can be added, and which raises events when this happens, as well as when OptionsPanels are removed from it. An OptionsPanel also inherits Panel, and these are the actual panels the users will see in the control, one for each option category.For now, each OptionsPanel has exactly one corresponding TreeNode (and vice versa). In the Visual Studio options, each 'parent' category usually has a 'General' node as the first child, and the parent and this General node show the same option panel, but I am ignoring that for the moment.
The OptionsView control has a property Panels that returns the ControlCollection (Controls property) of the OptionsPanelContainer (in other words: it returns a collection of OptionsPanels that are in this container panel).
vb.net
<Editor(GetType(Designers.OptionsPanelCollectionEditor), GetType(UITypeEditor))> _ <DesignerSerializationVisibility(DesignerSerializationVisibility.Content)> _ Public ReadOnly Property Panels As Control.ControlCollection Get Return Me.PanelContainer.Controls End Get End Property
A custom CollectionEditor for this property takes care of the designer: even though the property type is ControlCollection, the CollectionEditor knows it should create instances of the OptionsPanel control instead of just Controls.When it does this, a corresponding TreeNode is also created and its Tag property is set to the OptionsPanel. Vice versa, the Node property of the OptionsPanel is set to the node. Hence the node and panel both know their corresponding object.
vb.net
Public Class OptionsPanelCollectionEditor Inherits System.ComponentModel.Design.CollectionEditor Public Sub New(type As Type) MyBase.New(type) End Sub Protected Overrides Function CreateCollectionItemType() As System.Type
[code]....
So far so good, this all works fine. I can add Panels via the designer and when I do a new TreeNode appears in the TreeView. I can select this node and the panel becomes visible (comes to the front).Now, I am a little stuck. How do I implement child option panels? And more importantly: how do I let the user add child panels?The most logical choice I think is to let each OptionsPanel have a property (ChildPanels or something) that returns the child OptionsPanels for that panel. Once the user selects an OptionsPanel then, he can look in the property grid to find its ChildPanels property and add child panels to that.
There is a problem though: what would this property return? It must return a ControlCollection of some container (this is, I think, a requirement for the designer features to work, otherwise panels are not added to the Form.Designer.vb file). But there is no container. I cannot add them to the OptionsPanel itself, that would make no sense because the parent OptionsPanel has its own set of controls (the options itself...), there cannot be another (fully docked) Panel on top of those obviously.The container of the main OptionsView then? That is not an option either, its Controls collection holds ALL OptionsPanels, not just the children of the selected panel. I cannot 'select' only the right panels either, that would require me to return a new instance of ControlCollection, it would be impossible to return the actual ControlsCollection that holds merely a small selection of its controls.
I want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
With the following piece of code
CODE:
The Or keyword is confusing me. So in the above example which variable gets set. Does options = options or does it set RegexOptions.none.
I'm trying to connect to an Access table who's name includes spaces ('look Material Type').How do I identify this table in an OleDB string
View 2 RepliesI get a Syntax Error with the following code"ALTER TABLE receipts RENAME COLUMN payees TO payee"what I am doing wrong
View 18 RepliesAs i'm learning more and more about developing ive just got my head around creating classes and modules, i started wondering about something to do with configuration of applications where deployment is in a more diverse environment say in a company where different branches dont need access to all parts of a program, so i thought id throw the question out there in a basic sense and get some feedback. so i can go off and do some more reading and learning.
So the scenario in my head is like this.
So we have for arguments sake FrmConfig which is the master configuration form, then we have FrmMain which is the root menu our application general user interfaces with. So here based on what options are checked as enabled in FrmConfig effects what controls (like buttons/menu options) are enabled in FrmMain.
I want to populate my table in datagridview from my access database table
I'm not just trying to bind the table in access to my datagridview...I want to put the data's in my access database to my table in datagridview
so far this is my code.....
Sub filldatagridview()
Dim conn As OleDb.OleDbConnection = New OleDbConnection(strConnect)
conn.Open()
[Code].....
I need to Update Access Database Table with Data from a Different Table. Not all the rows of original Table to be Updated will be affected. How do you loop through the 2 Tables to do the required Update.
The Table to be updated is called "RecordList" and Table with new Data is called "RecListReport".Every attempt I've made won't work. I tried to Use 2 Datagridviews but couldn't get it to work right.
NewTestConn()
Dim Testconn2 As New OleDbConnection(NewTestConn1)
Dim da As New OleDbDataAdapter
[Code]....
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
I'm trying to insert data from an Access unbounds form to an Access Table using the follwoing code:
View 2 RepliesI have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset. However, there should be something simpler and faster than that, shouldn't it? Any idea?
View 6 RepliesI have a simple form. In the top left corner I have a numericupdown box. Under that I placed a panel that holds a picturebox. I did that so I could use the panel autoscroll feature if I resize the picturebox to be bigger than the form. To set this up, I set the panel to dock fill. If I do this, it covers up the numericupdown box. The docking on a form is very, very sensitive. How can I make sure I set this up correctly.
btw - If I place the numericupdown box on the panel and I scroll later. The numericupdown box scrolls away also. I am trying to make sure it stays fixed.
Also - I looked to add the numericupdown box to a toolstrip, but the box is not available to be placed on it - This would be my first choice.
I have a listbox with many Items. How i can to arrange these items by letter? A b c d etc .... ?
View 2 RepliesI had made a media player program, i have some other posts regarding that, my question though is how do you reorder a listbox using drag and drop, kind of like you can do with windows media player. I want to be able to drag song 4 after song 1 and then have it play that song after song 1. I seen a different post but it looks to be in C and not VB.
View 11 RepliesHow to do in coding...
TextBox -----------------------------------------> ListBox
05,11,22,24, 31,37,41,44,52,59, 72,80 05,11,22,24,31,37
05,22,24,31,37,41
[code]....
I have a class called InternetAccessSupporter
How do I arrange that that IAS imply that class?
i have a panel. the autoscroll is set to true. and i have the menu called "add bar". when user click on it, the usercontrol will appear. but different placed. so there will be more that one usercontrol. i want to do the usercontrol y location is increase when the location x is more than 600 for e.g.
If x > 600 Then
y += 200
x = 0
End If
the code above is work, but the problem is, why when i scroll down, and click on "add bar" the value of y location is not same as the previous usercontrol, it should be same on y because it is not yet reach the codition x > 600.
how to arrange the display of my combobox..i dont want it arranged alphabetically..i have my code below
my access database looks like this
Acc1 Acc2 Acc3 Acc4 Acc5 Acc6 Acc7
Tax Electric NPF Loan NPF Saving Uniform Allowance
[Code].....
I have lines like this in my text file
T250
T169
T168
T170
T176
I want to arange this lines to be like this
T168
T169
T170
T176
T250
I want to arrange it in decending order.. Can we do this...
I am using VS2010. I am trying to make reports using Report Viewer. This is how I have arranged my fields (using Table).
I want to make it look like this
For b = 1 To 5
a(b) = InputBox("Input Grade")
ListBox1.Items.Add(a(b))
Next
ListBox1.Sorted = True
i input(98, 100, 93 ,94,96) then it displays ( 100,93,94,96,98)but it should be (100,98,96,94,93)
I need to display a set of images as rows and columns in a form. The layout should be user selectable similar to MS Word 2007+ - Table Insert functionality ie. rows & columns need to generated during runtime. Is there a built-in layout manager to support this functionality?
View 1 RepliesThe application I'm doing requires me to "enter the size of an array in a TEXTBOX, then click a button, a list of random number would show up, then re-arrange from Lowest to Highest".For ex, i enter "5" in the TextBox, then an array or list of 5 random number will show up vertically on the ListBox. I already got this part done. Now the thing is, I have to make a For...Next statement to rearrange them from Lowest to Highest.
View 4 RepliesI have made a database that stores images as each record. I want to add a feature where mum can select a few of the records that she likes the images of. Once that is done I want a new form to appear whereby she can drag those selected images about and arrange them in a simple collage. Then save that as a new image. The database is done and the images can be stored, however I am not sure what would be the best way to select the images she wants. What do people reckon? A form that displays thumbnails of all the images and she can click on the ones she wants? or a check box on each entry? Then does anyone know how I could allow her to arrange and save the images as one new image?
View 11 RepliesI am doing a project for a college assignment and im stuck on the print section, i have alot done but I need it to be able to print out like the photo from the link below, but i have no idea how to change the code.[code]
View 7 RepliesHow do i re- arrange the 3 strings into 1 string into a new text file?
what i have in the text file:
VERSION 600
LIBRARY [2009/6/15 15:02:14, 2009/6/15 15:02:14] temp.gds
UNITS 0.001 1e-009
[Code]....