Visual Basic 4 / 5 / 6 RSS Visual Basic 4 / 5 / 6 RSS

Problem with retrieving data from access 2003

Thread Solved
1 2

•
•
Join Date: Jul 2007
Posts: 42
Reputation: guru511 is an unknown quantity at this point 
Solved Threads: 3
guru511's Avatar
guru511 guru511 is offline Offline
Light Poster

Re: Problem with retrieving data from access 2003

 
0
  #11
Jul 18th, 2007
still itz showing the same error "type mismatch"
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2007
Posts: 300
Reputation: jireh is an unknown quantity at this point 
Solved Threads: 42
jireh's Avatar
jireh jireh is offline Offline
Posting Whiz

Re: Problem with retrieving data from access 2003

 
0
  #12
Jul 18th, 2007
•
•
•
•
Originally Posted by guru511 View Post
still itz showing the same error "type mismatch"
OK try to use a control, in General Tab select and click the Data then replace the rs into Data1.Recordset (Data1 is the default name of the Data once you put a first Data in the form)

So the code looks like this..

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
  1.  Set Data1.Recordset = db.OpenRecordset("Select * from [team_details]")
Last edited by jireh; Jul 18th, 2007 at 3:36 am.
A conclusion is the place where you got tired of thinking.
http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2007
Posts: 42
Reputation: guru511 is an unknown quantity at this point 
Solved Threads: 3
guru511's Avatar
guru511 guru511 is offline Offline
Light Poster

Re: Problem with retrieving data from access 2003

 
0
  #13
Jul 18th, 2007
hey i'm done ya...
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2007
Posts: 300
Reputation: jireh is an unknown quantity at this point 
Solved Threads: 42
jireh's Avatar
jireh jireh is offline Offline
Posting Whiz

Re: Problem with retrieving data from access 2003

 
0
  #14
Jul 18th, 2007
•
•
•
•
Originally Posted by guru511 View Post
hey i'm done ya...
Does it work? So does this thread is solved?
A conclusion is the place where you got tired of thinking.
http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
Reply With Quote Quick reply to this message  
Reply
1 2

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC