ravno
Last Activity: Apr 27 '09, 07:42 PM
Joined: Apr 11 '08
Location: Denmark
-
I have ran across an OptionGroup in Documentation. I think, that's what I've been looking for - but how do I get it into my ToolBox, so I can use it on a form ? -
Visual Studio 2008 - radiobutton databind
I have a problem binding a radiobuttongrou p to a dataset/datasetbindings ource.
I have a field - among many others - in the dataset, holding int values 1-6
All fields are shown in textboxes on the windows form.
But how do I make the radiobuttongrou p show the value of the int field.
value=2 => radiobutton2 is selected
Can annyone xplain ?
mvh ravno -
This thread can be closed
ravnoLeave a comment:
-
Hi OuTCasT
I didn't make it work - but your use of 'position' really made something:
In my form I have
- dataset DS with a datatable DT
- a bindingsource BS, where
BS.DataSource=D S
BS.DataMember=D T
- a tableAdapter and a tableadapterman ager
- a datagridview with DataSource=BS
The command
BS.Position=BS. Find("KeyName", keyvalue)
moves focus/currentrecord...Leave a comment:
-
Thank you for the answer.
It looks as the same functionality, I get from:
databindingsour ce.movenext() or databindingsour ce.movelast()
What I really want is
"move to the record, where Key=something"
In Access2000 I did it this way:
Dim rs As DAO.Recordset
Set rs = Me.Recordset.Cl one
rs.FindFirst "MemberId = " & someValue
Me.Bookmark = rs.Bookmark...Leave a comment:
-
Dataset / Datatable in Visual Developer 2008
I am developing a Windows-application - database mssql - visual basic.
I add Datasets to forms, bind them to daatagridview/textboxes - fill with dataadapter - everything's fine so far.
Here's my question:
how do I programmaticaly move from a record/datarow i a dataset to another.
I know the value of the key-field and want that record to be shown.
If I use the dataset.datatab le.findbykey-method, the program... -
Hi Sierra7
Sorry bout the long time - I had to do som Access-programming ....
About connecting to back-ends: When I tried to connect to Access Back-end after having connected to SQL - se previous - it looked as the connection to my sql-server got broken - I couldn't connect - not even using the Enterprise Manager. I had to delete my server-registration and make a new one using the IP-address - before I used a server...Leave a comment:
-
Hi blad3runn69
Maybe - but have you got a better idea, when I want to connect to the MS Sql-back-end ?
ravno...Leave a comment:
-
Hi Sierra7
Now you're getting technical - I do not know, what to answer - could you tell more ?
ravno...Leave a comment:
-
Hi Stewart
In my front-end, the users are able to select the backend-db, using an 'OpenFileDialog ' and then the function below. It works fine, when the backend is an Access-db. I would like to set up, if it should link to an Access- or to a MS SQL-backend - the user should be able to switch - otherwise I would have to maintain 2 front-ends.
When I open the front-end, the linked-table-manager tells me, the front-end is linked to the...Leave a comment:
-
Hi Stewart
It now looks like what I wanted - thank you very much.
One final question - I would like to be able to link to the original msAccess-database - using this
where I use the first to connect to mssql. When I try the second and have pointed the...Code:'ConnectStr = "ODBC;DSN=RideCenter;UID=RideCenter;PWD=***;DATABASE=xxx" ConnectStr = ";Database=" & FileName
Leave a comment:
-
Hi Stewart
Looks like the docmd.runsql () works all right - I use it together with the begintrans and the committrans
Would it be an idea to run my inserts/deletes in the same way ?
And finally - how do I avoid to have to confirm all updates - ms acces asks something like: "you're about to update 1 row - you won't be able to undo - do you wan't to update? "
ravno...Leave a comment:
-
Thank you - I am sorry to see, I've 'quoted' my code wrong - I use the currentdb.execu te("Update").
ravno...Leave a comment:
-
MS Access2000 frontend - MS SQL2000 Backend - dbSeeChanges
I am developing an application in MS Access2000 - back-end database MS SQL 2000.
When the application starts up, it refreshes link to backend like:
...Code:ConnectStr = "ODBC;dsn=rd_venteliste;UID=xxx;PWD=yyy;DATABASE=Venteliste" For Each t In CurrentDb.TableDefs If t.SourceTableName <> "" Then t.Connect = ConnectStr t.RefreshLink End If
No activity results to display
Leave a comment: