Loading

Visual Basic 6.0 with MS Access Database

20 posts / 0 new
Last post
Lynesus's picture
Offline
Joined: 01/25/2010
Visual Basic 6.0 with MS Access Database

Guyz,, need help

pwede ko ba maiconnect ang project ko sa MS database from the server computer

client-server kc project q pero ms access database q.. asap..

tnx...

Anonymous
heLp NmN

guys help how to connect vb sa access database.. enrollment system kc project qoh.. plz..

Offline
Joined: 02/12/2010
Maraming connection na pwede

Maraming connection na pwede itry...

* RDO
* DAO
* ADO

Lynesus's picture
Offline
Joined: 01/25/2010
re

hi there!

First, you need to make connection string of your data base from your vb project,,like this

Public cn As ADODB.Connection
Public rs As New ADODB.Recordset

Public Sub myCon()
Dim mDataSource As String

mDataSource = "database/kiosk.mdb"
Set cn = New ADODB.Connection

cn.CursorLocation = adUseClient
cn.CommandTimeout = 0
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mDataSource & ";Persist Security Info=False"

Set rs = New ADODB.Recordset
End Sub

hope makatulong ito sa problema mo..

=>> jhaye.info <<==

blowfly's picture
Offline
Joined: 01/18/2010
Help bros.."invalid use of null"

what should i do with this error,.. if my MSaccess db has no field value is there any extra code to be written on my form to skip to next validation?? anyone here who can help.. thanks! i.e:

"Live and let live!."
glenn_blowfly@gmail.com

born_2_code's picture
Offline
Joined: 06/10/2010
On error Resume Next

Try the "On error Resume Next" command..it will skip the null value.

Hope this help.

born.2.code.06@gmail.com

Lynesus's picture
Offline
Joined: 01/25/2010
re

more explanation about your problem in database please..

=>> jhaye.info <<==

blowfly's picture
Offline
Joined: 01/18/2010
i.e. I called data from

i.e. I called data from access txtStudName.Text = rs!Student_name.. kung walng laman ung feild na Student_name "invalid use of null" shows up..

"Live and let live!."
glenn_blowfly@gmail.com

Anonymous
I called data from

try this code

if isnull(rs!Student_name) then
code here
else
code here
end if

yan lng ang logic nyan
sna mkatulong

Offline
Joined: 02/12/2010
test first

test the field if is null or not before passing to the control

If Not IsNull(rs("Student_name")) Then
txtStudName.Text = rs!Student_name
End If

Anonymous
visual basic 6.0

i have a problem using imagebox to search and retrive data from ms access.
pls help

Offline
Joined: 04/05/2010
Just use adodc... simple

Just use adodc... simple lang..

Anonymous
idno w/ pictures

how to save the data boot idno w/ pictures & query

Anonymous
VISUAL BASIC 6.0

i need some help about VB .. is posible to make LIBRARY SYSTEM using VB and MS Access ?? w/out using ADODC

Lynesus's picture
Offline
Joined: 01/25/2010
Anonymous

Yah,, you can make a Library System using VB and Access without using ADO Data Control or ADODC.. Much better to use ADODB or any hard coding..

=>> jhaye.info <<==

Anonymous
form submission

hai..

I m doing a VB Project.I m designing a information request form. The details of the form that are entered should be submitted to the backend(MS Access). What is the code for that?

Anonymous
guys help

how can i add pictures to a database?

Anonymous
hi

how to filter data records...

Anonymous
I NEED A SOURCE CODE FOR "SEARCH" in VB6.0

I NEED IT. the logic goes like this: i add data, then i update/save, then i will search a data in database.
please any example? a little bit of code will help. or paste here a link in that source.

Anonymous
Vb with Access

one text box given in db column field name and another text box given in db row value, then click the command button the particular db row and column value display in the label box in vb

one model with coding for me

please help

with regards

Pages

Add new comment

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.