10,991 Topics
 | |
| | in the reisgter how i put it togeter time and date of the code when i keyin the admin No and admin card then it record the the access datatbase. Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click If String.IsNullOrWhiteSpace(txtcard.Text) Or String.IsNullOrWhiteSpace(txtadmno.Text) Then MessageBox.Show("Please complete the …  |
| | Good day! I am now currently ugrading our database to mySQL. My problem is that, how to convert the any msaccess SHAPE command to a mySQL database syntax using 6 and get the same result? Below is the sample code: spath = App.Path & "\employeeaccnt.mdb" cn.Open "Provider=MSDATASHAPE; Data Provider=Microsoft.JET.OLEDB.4.0;Data Source=" … |
 | t = txtSearchMo.Text z = Combo1.Text Adodc1.Recordset.Filter = "br_name like '" + t + "'" Or "mo like '" + z + "'" why this code have mismatch error appear?? help me pls |
| | how i put it like i am a student so i choose student and key in username n password, if choose worng like i click lectuere but i not, so cant is worng cant login Private Sub cbinfo_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbinfo.SelectedIndexChanged Dim conn As … |
 | Hi everyone, I haven't touch in vb6 in 12 years so im very rusty... :s But now i need a little exe that allow to open and view office and pdf files, i dont need it to save or allow changes. Since its going to work with a batch file …  |
| | I have commondialog that i can search for *.bmp,*.jpg files thats okej, now the problem is. saving the picture to the rot + filename next time I start the program I will change the picture to another file that shall be saved in rot + filename the first picture shall …  |
| | when i login it will come 2 form one is info and other one is register form when i login that time my info come out come a samll form say error complet the box it should not come out this..!! where go worng |
| | I get the error "Syntax Error (missing operator) in query expression" sql = "SELECT Chores.ChoresID, Chores.ChoresDate, Materials.MaterialName, Advisers.AdviserInit, Advisers.AdviserSurname," _ & "Area.Area, Chores.StudentNo, Student.Forename" _ & "FROM Chores" _ & "INNER JOIN Materials on Chores.MaterialID = Materials.MaterialID" _ & "INNER JOIN Advisers on Chores.AdviserID = Advisers.AdviserID" _ & "INNER JOIN … |
| | at the projct No i have choses it should the the project name on the textbox but did not come out Private Sub cbbproject_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbbproject.SelectedIndexChanged Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim …  |
| | Good day!~ May i know the difference between creating database using Visual Data Manager and using MS Access. which is better? |
| | Hi the line with image4.picture don't work the rest of the code is printing out as it shall do. The image4.picture is in hidden position and the path is Okej.( can see it when the image4 is vissible=true) How or where is the problem ?? Help is use full with … |
| | I want a visual basic 6.0 project vb as front end and ms access as back end with atleast 2 users admin & operator. can any body help me to do my project please?  |
| | Why done work is it some thing worng i only wan edit one or delete one of it? Private Sub btnedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnedit.Click If String.IsNullOrWhiteSpace(txtadmin.Text) Or String.IsNullOrWhiteSpace(txtname.Text) Or String.IsNullOrWhiteSpace(txtcourse.Text) Or String.IsNullOrWhiteSpace(txtic.Text) Or String.IsNullOrWhiteSpace(txtgender.Text) Or String.IsNullOrWhiteSpace(txtaddress.Text) Or String.IsNullOrWhiteSpace(DateTimePicker1.Value) Or String.IsNullOrWhiteSpace(txttel.Text) Or String.IsNullOrWhiteSpace(txtemail.Text) Or String.IsNullOrWhiteSpace(txttype.Text) … |
| | can someone enlighten me what 's the difference between having a codeless database conenction and using manual code to connect to database. which is better? for me, i think it is easier to do database using connection using object properties like datasource, datamember. i find it difficult using manual coding … |
| | |
| | Hello!~ i'm currently doing a database about examination system.. i already have a database for login,registration, and questionaires. my problem is on my question database.. i managed to connect the questions and choices in visual basic (or so i thought) questions are on multiple choices.. my question is : how … |
| | is this coorrct if write like this: Public Class Lecturer_Form Private Sub Lecturer_Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim sql As String = "Select A.StaffNo,A.TimeIn,A.TimeOut, B.ProjectNo, C.AdminNo, C.UserName From tbl_lecturer … |
| | I have create a project, There are so many reports. I want change report orientation as Landscape and paper size is width =8.27" and Height=4".But I can't do this. Please Help Me. |
| | in stuednt admin i wan it to insert and also select from tbl_stuendadmin how to put it togeter If String.IsNullOrWhiteSpace(txtcard.Text) Or String.IsNullOrWhiteSpace(txtadmno.Text) Then MessageBox.Show("Please complete the on the box.", "Authentication Error", MessageBoxButtons.OK, MessageBoxIcon.Error) Exit Sub End If Dim Conn As System.Data.OleDb.OleDbConnection Dim ConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" Conn = … |
 | possible to setting Chrome, as similar IE, and get data from Chrome html page?  |
 | Think that macro viruses written in VBA (Visual Basic for Applications) are just something that people using the Internet a couple of decades ago had to worry about? Think again. Word macro attacks never went away, they just went into decline. New evidence suggests they could be making something of … |
| | Dim con5 As New ADODB.Connection Dim rs5 As New ADODB.Recordset Private Sub Command1_Click() con5.Provider = "Microsoft.JET.OLEDB.4.0;" con5.Open App.Path + "\da.mdb" rs5.Open "[DEMO]", con5, adOpenStatic, adLockOptimistic 'The above code can't work when the database is protected. 'Please Tell, How can I solve it |
| | Hello again. I am back with the problem of using booleans with command buttons. Any reasearch I've done for other methods to complete my memory game have been for Vb2005, VB.net, VB2010, etc. Where as I'm stuck with VB5 not Knowing what to do. `PLEASE NOTE: boolFirst is declared and … |
| | i trying to put this in the combobox why did not come out Private Sub Lecturer_Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim sql As String = "Select [StaffNo] From tbl_lecturer … |
| | Private Sub cbbproject_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbbproject.SelectedIndexChanged Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim sql As String = "Select * From tbl_assignment Where ProjectNo ='" & cbbproject.Items(cbbproject.SelectedIndex) & "'" Dim sqlCom As New System.Data.OleDb.OleDbCommand(sql, conn) … |
| | I have two listbox and two button, one button is assign another is unassign in listbox1 have adminNo I wan the listbox1 of adminno go to listbox2 one by one when pressing button assign and i also can unassign go back to listbox1 one by one also is it: *listbox1.item.forword(sqlRead("AdminNo").ToString)* |
 | Can anyone tell me how can i create a backup and restore form... in vb6.0 for my sql 2014 database |
| | I am trying to make a memory game using labels and command buttons, and I have run across an issue in which when I try to set up a timer with a loop within a Sub function. My current code for this: Private Sub Form_Load() tmrStart.Interval = "1" End Sub … |
| | I can post a single line of row I selected from datagridview but I want to select specific multiple rows then display it in my crystal report. BTW I'm using VB2010. Dim cmd As New OleDbCommand("Select * From Data1 Where ID = " & Form4.DataGridView1.SelectedRows(0).Cells(0).Value.ToString() & "", Form4.con) Dim adpt … |
| | Hi, Im teaching myself VB, specifically, how to create forms(im using VS Express 2013). I wanted to use the values from an xls file( already exported it as LMS.csv, a table with 4 rows X 3 columns) as constants for my form. I've tried the codes below but its not … |
The End.