Search results for query: *

  1. G

    Question Classes, Best practices question

    Excellent, thanks guys! For the benefit of others, here is an article I found after your responses which I think describes the process pretty well. (even though it's a 16 year old article) https://msdn.microsoft.com/en-us/library/ms973803.aspx
  2. G

    Question Classes, Best practices question

    Hello, I'm writing my first application that I will make use of classes in. I've read some on Object Oriented programming and would like to take my code to the next level (over standard modules). Let's say I have 3 distinct email types that my application will produce (Type A, B, and C)...
  3. G

    refresh data within combobox within datagrid view

    JmiCilhinney, Here is the code for the form: ublic Class frmAddTag Dim con As New OleDb.OleDbConnection Dim dbProvider As String = "PROVIDER=Microsoft.ACE.OLEDB.12.0;" Dim TheDatabase As String = My.Settings.Database_Location Dim FullDatabasePath As String = TheDatabase...
  4. G

    refresh data within combobox within datagrid view

    I've tried that... Hello Jmcilhinney, Thank you for the response. I have tried the brackets, based on a web search before I posted last. I also had changed my select statement to only pull the required colums. I'm using Dim sql As String = "Select [Description], [Comments]...
  5. G

    refresh data within combobox within datagrid view

    Still trying I'm still struggling with this. I've read and re-read the tutorials here: Visual Basic .NET programming for Beginners - How to Add a New Record I have a basic understanding now of how the dataset, and data adapter and connection objects work (hopefully) Here's my new code...
  6. G

    refresh data within combobox within datagrid view

    Jmchilhinney, Thank you for the response. I've reread it multiple times, and I'm digesting the fact that I don't really understand the "flow" of data here. I've spent time this morning reading on the MSDN site, and trying to get a basic grasp of datasets, datatables, and their flow to form...
  7. G

    refresh data within combobox within datagrid view

    Hello, I have a form (frmRecord) which has a datagridview on it that represents related "tags" for the record shown on frmRecord. This datagrid view has a combo box, which shows available "tags". The data source for the datagrid view is tblJunctionBindingSource. The datasource for the...
  8. G

    Question Code repository and "mini applications"?

    Hi everyone, I'm new to this forum. I'm trying to learn VB.NET and visual studio. I've programmed for years in VBA within Access, as a Power user. But stepping up to VB.net as my first "real" programming language. I have a few questions below, just to point me in the right direction. I'm...
  9. G

    Question How to insert into Access db?

    :unhappy: Just spent an hour chasing my tail. I got it to update during the debug sessions, but it wouldn't "stick" for the next one, and I thought something was wrong.....Until I research and found this...
  10. G

    Question How to insert into Access db?

    Jmcilhimmey, Thank you for your response. Yes, I do have one field in that table that is an attachment field. But I'm not referencing it in this form. I'll have to find out why I still have this error. I did drag it over to the form, but then I deleted it. What is the best way to...
  11. G

    Question How to insert into Access db?

    Yes, sorry about that. I wasn't sure what information would be helpful. I'll know next time. Here is the exception that was thrown: Exception thrown: 'System.Data.OleDb.OleDbException' in System.Data.dll Additional information: An INSERT INTO query cannot contain a multi-valued field...
  12. G

    Question How to insert into Access db?

    Hi Everyone, I'm brand new to this forum, and to VB.NET. I've been an intermediate Access VBA programmer for a few years, and decided to try and improve my skills by learning VB.NET. I'm running visual studio community 2015 if it matters. I figured I could start by duplicating one of my...
Back
Top