I want to make simple quiz (100 questions), structure: 1 lbl = question, 3 radio buttons (answers) and 1 button(next question).I added access database to DataSource, binded data to lbl and radio buttons, it automaticaly added the code:[code]The form is loaded ok with the data I need but I can't write the code for the button "next" to load next row from database!The question is: HOW TO LOAD NEXT ROW FROM ACCESS?
View 14 RepliesHow we can show data from acess database in datagrid
View 1 RepliesI already registered a custom dll in gac,but i want top acess the .dll in vb.net code without help of add reference.in my dll one function is there for that reson i want to acess the function.[code]...
View 11 RepliesI have just bought a new PC which runs MS Office 2010 under Windows 7 and I purchased Visual Studio 2010 Professional. I have a program which was running successfully on an earlier version of Visual Studio running under Windows XP. I have been able to replace the 32 bit Custom Control and the program, which was compiled on the old PC, is running successfully on the new PC.
However, a part of the program transfers data to an Excel spread sheet and this does not work.Opening the project in Visual Studio I have found the error. There were some problems with XL Application and XL Constants, but I think I have worked around these.[code]...
frmAddUser is a simple form that is opened as a dialog by a command button on the primary form (frmPrimary). Once opened, it's only job is to collect information via textbox and combobox fields. Once submitted, the information is added to the database.
This works, or so I thought. If I open this form, fill it out, and submit the information; the record is created. However, if I turn around and do it all again with different information, another record is created but with the previous information (not the new). It will continue to make records as long as I keep submitted this form but no matter what information I put in, it always uses the original information that was used to create the first record.[code]...
How to access data from Ms-Acess and oracle?
View 4 Repliesi was wondering is there a build in class in vb.net for get a range of dates from a column:What i mean is say i had the following dates in a column
10/03/2012
11/01/2011
14/05/2011
[code].....
im working on a school project where i shall show/explain how a remote acess program work and i coded the most but when want to send all listbox items from server to the client and in the client is another listbox where it should be transfered over..[code]
View 4 Repliesi've been trying to figure out how to update a row in my database, using a set of fields from the current form. The code which i have made so far is shown below, however it always comes up with an error message:
Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnupdate.Click
Dim SQL As String
Dim updatelogin As New OleDbCommand
Try
[Code]...
I have built a search criteria for a table in my database. I have 3 textboxes first says anstnr second says firstname and the third lastname.The problem is that i cannot search if first field "anstnr" is blank. If i only will search on firstname thats not working.
Private Sub FillByolikaToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillByolikaToolStripButton.Click
Try
[code].....
now i am doing final year project in vb.net and ms.access.but how i will connect vb.net with ms.acess data base table.
View 5 RepliesI want to search record in the database and if the record all ready in the database something do. I use this code but it is not work
Str SQL = "SELECT* FROM student WHERE stdno = '"& txtstdno.Text &"'"
oledbcon.open()
ry
[code].....
thr are 02 fields username,pasword in database also two textboxes in vb.net form for username and pasword ... i need coding of if else which confirms that, if (username,pasword ) = username,pasword of atabase then
View 7 RepliesI've already finished the program and the last task was to add a password for my MS Access database. I've created the password in Ms Access and I've already modified the connection and saved the password but when I run the program all codes like this
Me.Table1TableAdapter.Fill(Me.Database1DataSet.Table1)got an error message says Not a valid password.
Trying to set a Combo Box RowSource to a field in a table that contains the choices separated by semi colons. Have tried both a query and a DLookup but it results in displaying the full contents of the table field, e.g. "10;12;14;16" rather than giving me the usual selection list
View 2 RepliesI have a small program on the menu written in VB6 retrieve data from Acess run very fast and now want to switch to VBNet2008. VBNet2008 conversion is still normal, but when running the menu does not appear that waiting in line, then click on the menu bar of this menu appears, but not the font is in Unicode data is available. Expect you to help debug programs that run on VBNet2008 still running good access Menu fast as running on VB6. Also supported is Unicode font on VBNet2008 does not function for unicode font. Attach program with VB6 and VB2008.
[Code]...
Having problem in updating an existing record. An error occurs "Data Type Mismatch in Criteria Expression"
Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click
Dim myBuilder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(dataAdapter)
[code].....
I have a textbox1 and button1 and panel1 (which is used as a popup control)i want if textbox1.text="show" then modalpopup control whose id is panel1 will be visible on buttonclick event other wise .... modal popup control panel1 will not be shown ...how to do this ? using vb.net ?
View 2 RepliesSQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
Can anyone help me to make a program which include a Button shows the current Month and the year and when clicking the button it shows a DialogBox ith a MonthCalender (this one I have done - the Monthcalender shown on a Dialogbox).Further I want to change the month shown as a Text of the Button when I click other Buttons to make the calender to go backwards or forwards,
Another thing I want to know is how to make the TreeView which expand / reveal another line or something on clicking the "Plus".I am learning only VB 2005 / VB 2008, please give the codes etc for VB 2005 only.
BTW, Can you tell me how to paste a picture in this writing place? I tried to paste the picture to shoow what exactly I want to do, but I couldn't do it.
I'm writing a program for my algebra students to practice integers.Stuff like....
3-6
-4 + (-5)
3(-4)
-15 � 3
etc.
I want to show an explanation and for the addition and subtraction, I want to show it on a number line. For example, if the problem is 3 - 7, the number line should show and arrow to that goes right to 3, and then left 7 units (starting from 3). Then the student can see that the answer is -4.I could probably do this with some string manipulation, but what would be the easiest way to do it in a picture format? Maybe a bitmap.
how do you show information from a datagrid cell to show up in a text box in another form, this is for a college project.
View 1 RepliesHow do you refresh a datagridview in code to show to show new data in the DB?
View 3 Repliesi allready have date values in a datagridview and datasource is Access table
dim endindex as integer
datagrid.currentcell = nothing
dim table =mydataset.tables("Booking")
[code].....
stock table
fkodsno
[code].....
how to copy, delete, show files, show current directory, change directory, make folder, rename folder. My problem is i have a method on deleting a file and copying a file, but i don't know how to pass the method so that when i click the delete button it would let me choose what file to delete. By the way im using buttons on each function.[code...]
View 2 RepliesIf NewEntryName.Text = "" And OpenFileDialog1.FileName = Nothing Then MsgBox("Please choose a name for your game.", vbExclamation) MsgBox("Please find your game.", vbExclamation) Else Button1.Text = NewEntryName.Text game1 = True Panel1.Visible = False End If
I want it to show the first MsgBox if the NewEntryName.text = "" and I want it to show the second MsgBox if openfiledialog1 = nothing... how do I do it?
What is the code for Hiding a mouse and make it go back when going to
Desktop1.vb
Cursor.Hide()
works
Cursor.Show()
is not working when going to Desktop1.vb .vb its still hiding what am i doing wrong here is my code.
[Code]...
As a continuation of my previous posting, which we were able to resolve, I am running into the same problem again, due to being unable to use frmForm1.Show().In my last situation I had to use frmForm1.ShowDialog(), which worked in that case, as it called another form, for example frmForm2.However, now I have a program that is sometimes required to recal frmForm1, and I get the following message: �Close the form before calling ShowDialog.But, in frmForm1,I include, Me.Hide() and Me.Close(). Also, before recalling frmForm1, from a procedure under Main(), I have added the following
frmForm1.Close()
To me that would suggest the form is closed, dead and buried, but the programme still stops at the point of:
frmForm1.ShowDialog()
With the same message: �Close the form before calling ShowDialog.
This is very, very simple question, I even posted on another forum, but apparently I didn't get the right answer.
View 3 Replies