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
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)...
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...
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]...
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...
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...
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...
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...
: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...
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...
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...
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...
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.