Any Visual Basic programmers online?????
15-01-2005, 11:12 AM
#1
PassionFord Post Whore!!
Thread Starter
iTrader: (1)
Join Date: May 2004
Location: Liverpool :o)
Posts: 4,715
Likes: 0
Received 0 Likes
on
0 Posts
Any Visual Basic programmers online?????
If so I need help (not in that way)....anyone got any ideas how to set the firstrow property for a datagrid....looks like a piece of piss in the MSDN help but it doesnt work & always returns an error 
found lots of people with the same problem online but no-one seems to know the answer!!!! 
Anyone???
found lots of people with the same problem online but no-one seems to know the answer!!!! Anyone???
15-01-2005, 12:13 PM
#2
BANNED
BANNED
iTrader: (1)
Join Date: Jul 2003
Location: Wiltshire
Posts: 12,483
Likes: 0
Received 0 Likes
on
0 Posts
Lee_R21Turbo,
Do you have the latest RUNTIME librarys on the machine you are running on ?
Perhaps you are getting confused with the "TOPROW" property ?
I have had similar problems so many times and no one I know has a
definite fix that works.
I got around it by creating the datagrid object at runtime rather than visually
creating it but this is a lot of work.
Had so many problems with VB in the past that I no longer use it by choice.
Much prefer DELPHI or C ....
Do you have the latest RUNTIME librarys on the machine you are running on ?
Perhaps you are getting confused with the "TOPROW" property ?
I have had similar problems so many times and no one I know has a
definite fix that works.
I got around it by creating the datagrid object at runtime rather than visually
creating it but this is a lot of work.
Had so many problems with VB in the past that I no longer use it by choice.
Much prefer DELPHI or C ....
15-01-2005, 12:40 PM
#4
PassionFord Post Whore!!
Thread Starter
iTrader: (1)
Join Date: May 2004
Location: Liverpool :o)
Posts: 4,715
Likes: 0
Received 0 Likes
on
0 Posts
I'm running VB SP5 not SP6 - heard tooo many bad things about it! 
Naah not getting confused with TOPROW (that doesnt seem to be a property on mine) - I've got a datagrid that I am using a combo box with, to alter values - it actually alters an underlying SQL table but the results are queried using a SQL view i.e. 1 = Supplier1, 2 = Supplier2 etc - the view shows the Supplier1 whereas the table shows the ID 1. Once the value has been changed in the table it needs to refresh the datagrid & place the pointer back exactly where it was on the datagrid & physically in the same place too so not to confuse the user - hence the reason to set the FirstRow in the datagrid to what it was before the recordset was refreshed.
I've just managed to sort it now by setting the bookmark property of the recordset to the firstrow value before it got refreshed then setting the bookmark value to the record pointer!!!
So easy when you think about it - was pulling my hair out all yesterday afternoon!!! Fresh head and all that..... 
I've seen Delphi - thats basically a windows based Turbo Pascal is it not - used TP7 programming language when I did my A levels. I would like to look at another programming language prob VC but I never seem to get time to play with it!! TBH I'll probably move onto VB .NET as its the next logical step!!
Naah not getting confused with TOPROW (that doesnt seem to be a property on mine) - I've got a datagrid that I am using a combo box with, to alter values - it actually alters an underlying SQL table but the results are queried using a SQL view i.e. 1 = Supplier1, 2 = Supplier2 etc - the view shows the Supplier1 whereas the table shows the ID 1. Once the value has been changed in the table it needs to refresh the datagrid & place the pointer back exactly where it was on the datagrid & physically in the same place too so not to confuse the user - hence the reason to set the FirstRow in the datagrid to what it was before the recordset was refreshed.
I've just managed to sort it now by setting the bookmark property of the recordset to the firstrow value before it got refreshed then setting the bookmark value to the record pointer!!!
So easy when you think about it - was pulling my hair out all yesterday afternoon!!! Fresh head and all that..... I've seen Delphi - thats basically a windows based Turbo Pascal is it not - used TP7 programming language when I did my A levels. I would like to look at another programming language prob VC but I never seem to get time to play with it!! TBH I'll probably move onto VB .NET as its the next logical step!!
15-01-2005, 12:42 PM
#5
PassionFord Post Whore!!
Thread Starter
iTrader: (1)
Join Date: May 2004
Location: Liverpool :o)
Posts: 4,715
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by sjoyce666
what error is it returning ??
Scott
Scott
The syntax I was using was Me.DataGrid.FirstRow = FRow (a variant) which is how it says to do it everywhere!!!
15-01-2005, 12:52 PM
#6
Too many posts.. I need a life!!
Join Date: Aug 2003
Location: Yeovil
Posts: 886
Likes: 0
Received 0 Likes
on
0 Posts
java's the way forward !!
im using VB at the moment and havent used it for a while but starting to get back into it now, confusing running two programming languages together tho as i find myself writing java in VB and vise versa
happy days
Scott
im using VB at the moment and havent used it for a while but starting to get back into it now, confusing running two programming languages together tho as i find myself writing java in VB and vise versa
happy days
Scott
15-01-2005, 01:01 PM
#7
PassionFord Post Whore!!
Thread Starter
iTrader: (1)
Join Date: May 2004
Location: Liverpool :o)
Posts: 4,715
Likes: 0
Received 0 Likes
on
0 Posts
Not done much in Java or Javascript - tend to use VBScript cos its very similar to VB!
How much better do you feel when you've fixed a problem you've been having for ages....relief isnt in it!!
How much better do you feel when you've fixed a problem you've been having for ages....relief isnt in it!!
Trending Topics
15-01-2005, 01:30 PM
#8
Too many posts.. I need a life!!
Join Date: Aug 2003
Location: Yeovil
Posts: 886
Likes: 0
Received 0 Likes
on
0 Posts
yeah loads, ive got a presentation on friday about my project which i hadnt started until yesterday, i got loads of technology proving done to show i could do it as i said i could, just got a 3000 word report to write about it now
Thread
Thread Starter
Forum
Replies
Last Post
massivewangers
General Car Related Discussion.
30
01-10-2015 07:40 PM