10,989 Topics

Member Avatar for
Member Avatar for BORIS_4

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

Member Avatar for BORIS_4
0
48
Member Avatar for Xiao_1

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 …

Member Avatar for Xiao_1
0
98
Member Avatar for razstec

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 …

Member Avatar for Reverend Jim
0
121
Member Avatar for bonzo2008

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 …

Member Avatar for BitBlt
0
191
Member Avatar for Xiao_1

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

Member Avatar for Xiao_1
0
118
Member Avatar for Jeremybcent

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 …

Member Avatar for Jeremybcent
0
195
Member Avatar for Xiao_1

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 …

Member Avatar for Santanu.Das
0
97
Member Avatar for Lacrecen

Good day!~ May i know the difference between creating database using Visual Data Manager and using MS Access. which is better?

Member Avatar for Lacrecen
0
245
Member Avatar for bonzo2008

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 …

Member Avatar for bonzo2008
0
1K
Member Avatar for Shafra

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?

Member Avatar for deceptikon
0
40
Member Avatar for Xiao_1

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) …

Member Avatar for Santanu.Das
0
169
Member Avatar for Lacrecen

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 …

Member Avatar for Lacrecen
0
82
Member Avatar for metchoy tumanda
Member Avatar for Lacrecen

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 …

Member Avatar for Lacrecen
0
155
Member Avatar for Xiao_1

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 …

Member Avatar for Xiao_1
0
178
Member Avatar for Pintu82

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.

Member Avatar for David_50
0
48
Member Avatar for Xiao_1

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 = …

Member Avatar for Santanu.Das
0
145
Member Avatar for Sal_1
Member Avatar for happygeek

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 …

Member Avatar for happygeek
1
1K
Member Avatar for pikai

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

Member Avatar for Santanu.Das
0
241
Member Avatar for Silvainius

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 …

Member Avatar for Reverend Jim
0
157
Member Avatar for Xiao_1

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 …

Member Avatar for Xiao_1
0
237
Member Avatar for Xiao_1

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) …

Member Avatar for Santanu.Das
0
117
Member Avatar for Xiao_1

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)*

Member Avatar for Santanu.Das
0
110
Member Avatar for shivam.prabhat
Member Avatar for Santanu.Das
0
91
Member Avatar for Silvainius

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 …

Member Avatar for Silvainius
0
169
Member Avatar for jared.geli

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 …

Member Avatar for waterm
0
2K
Member Avatar for don75cua

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 …

Member Avatar for don75cua
0
123
Member Avatar for andrew80

Hi, i have 25 questions with images in quiz. i want to make the quiz in Visual Basic. Any idea on how to start making this project? The quiz will have time limit to answer the questions and score in the end. any help is welcome thanks a lot

Member Avatar for llgms
0
84
Member Avatar for Xiao_1

The End.