943,685 Members | Top Members by Rank

Ad:
Oct 30th, 2008
0

data search from msflexgrid

Expand Post »
I attach a file what was send by Shaik Akthar. I work with it a new
access file. He use Table, I use querie. But it not work.I modify some
code like:
MSFlexGrid.FormatString = "<DATENOW|<NAME|<DIAGNOSIS|<REMARKS"
MSFlexGrid.FormatString = "<Student ID|<Student Name|<Jamal|<Roll No"

Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\DB2.MDB"
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\student admin.MDB"

rst.Source = "profile2"
rst.Source = "Student"

MSFlexGrid.AddItem Format(rst!DATENOW, "DD/MMM/YYYY") & vbTab & rst!Name & vbTab & rst!DIAGNOSIS & vbTab & rst!REMARKS
MSFlexGrid.AddItem Student ID & vbTab & rst!Student Name & vbTab & rst!Jamal & vbTab & rst!Roll No

It not worked. I don't know what I did wrong. anybody can help me?

if I want to work it with datagrid then what I need to do?
Similar Threads
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Nov 3rd, 2008
0

Re: data search from msflexgrid

Hi,

Its not vbTab,
Column seperator here is Chr(9)

Regards
Veena
Reputation Points: 84
Solved Threads: 140
Posting Shark
QVeen72 is offline Offline
923 posts
since Nov 2006
Nov 3rd, 2008
0

Re: data search from msflexgrid

pls check it.
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Nov 3rd, 2008
0

Re: data search from msflexgrid

pls check it.
Attached Files
File Type: zip SEARCH.zip (44.0 KB, 100 views)
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Nov 6th, 2008
0

Re: data search from msflexgrid

help me with this project.
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Nov 6th, 2008
0

Re: data search from msflexgrid

Hi,

What Part of your Code is Not Working...?
Post your code here..
(dont Attach the project)

Regards
Veena
Reputation Points: 84
Solved Threads: 140
Posting Shark
QVeen72 is offline Offline
923 posts
since Nov 2006
Nov 8th, 2008
0

Re: data search from msflexgrid

I just modify thats line what I write above. and others line like attach project.
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Nov 8th, 2008
0

Re: data search from msflexgrid

Dear Taher,

Your entire logic is correct. there is no mistake except for the fieldnames which u r using. they have a space in between. if u need to specify fieldnames which have space then use either of the following ways to denote them.

For field Student Id use
rst.Fields("Student Id")
or
rst![Student Id]

I have modified the project and am uploading it back for ur reference. hope this solves ur problem.

Another suggestion is that try not using the fieldnames with spaces, instead use a underscore to connect if the fieldname is of two words like

u can use "Student_Id" instead of "Student Id"
"Student_Name" instead of "Student Name" and "Roll_No" instead of "Roll No"



Regards
Shaik Akthar
Attached Files
File Type: zip SEARCH.zip (46.4 KB, 94 views)
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: print issue problem
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: TreeView, adding more than 32767 nodes to the tree???





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC