I have a .accdb as a data source with numerous tables. I needed to add a table to the db and did not want to disturb all I had done in the data set designer with the data source. I went to the db in the bin/debug in hopes I could insert table and just have it then show in the data source...
I use the current data row index to feed info used in another SQL statement. I notice that if I sort the columns it maintains what was originally in that row. How do I get it to see the sorted state?
App works fine and has several tables from one Access Data Base. After compiled i try to open and get an error that it can not locate the Access Data Table ( in a strange address that I did not specify). On creation i saved the DB in the output file. Any reading material on how to get this set...
I hit the "close" button that is auto generated on a form to close it and it does not close. I added a form closing event to see what was going on and it handles the closing event first and then goes back to the load event. Any ideas on where to look or what I might have inadvertently changed.
I have been letting the wizard create the table adapters. After learning how to use the dataset designer to generate my fill criteria; I can not update using the table adapters update command. The latter I am sure has nothing to do with it. I have included the access tables in both the output...
Can not figure out why I get a "data type mismatch in criteria expression" when the criteria is a string and the access data base field is "Text". "Crew" is a field name in Access data base and it's data type is "Text".
Private SubButton1_Click(sender As Object, e As EventArgs) Handles...
I have a DGV with wizard created connection, ds, and da. I have another DGV that is filled and managed with code. I make changes to the first and it updates. I make changes to both and only the second one will update. in a btn click event :[If dsGM.HasChanges Then...
I want to capture a two field values in a selected row which will be used in another query for another table. I can reveal the cell value of a cell clicked in "currentcell.value" but not the one beside it.
Using Access Lookup Wizard I created a lookup list for a field. When I bind a dataGridView to it, and when I add a new row, the lookup list does not appear. Information says the listbox appears on query datasheets that contain the field. Any idea on how to get it to display in a dataGridView ?
Loaded a project and selected File,New,Project-then cant seem to find Other Project Types to choose Setup and Deployment node so I can enable it. I am sure this is basic but can not seem to dial in on solution. thanks for any help.
From a DatagridView I can update back to an access table but I can not to a access query table. Update is not a member of that adapter. Anybody understand this?
using VS.2015 design screen and VB, i drop in a Data Grid and use the VS to add the dataSet, binding, and connection. All is good but i can not get the code correct to update changes back to data table. any simple techniques?
Above medium proficiency using VB.net 2003 until stopped 5yrs ago. Self taught to create business solutions I could not get support for through company IT dept. I want to get started back using the latest versions-where do I start? How do I get latest versions- I had to purchase the 2003 version...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.