I have been struggling with the below code trying to get it to work. I have never used the OleDbDataAdapter & OleDbCommand and am not sure what I am doing. Keep getting this err msg at the high-lighted code, "Object reference not set to an instance of an object". I must have more than one thing...
I have a DataGridView that is bound to a db. When I package the App the db is installed in a subdirectory of the App directory. The user is allowed to install the App in the default dir or a dir of his choosing.
When I install the App and start it I get an err saying the db cannot be located...
Hi jebenson,
Where do I use or put Application.StartupPath() & "My.exe"?
I can see that I use Application.StartupPath() & "\AppData\Database1.accdb" when I want to point to the db, such as:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Application.StartupPath() & "\AppData\Database1.accdb"...
Hello All,
I am in VS 2013 Express writing in Visual Basic. I am trying to write to allow for Installation by the user of my project package to any directory they so choose.
I am a novice programmer. When the project is opened by the user it needs to find the .exe file absolute path to start...
Hi MajP,
I see what you mean now. My SQL stmnt was constructed all wrong. I should have seen that when I looked at the Text Visualizer and saw that neither variable was being resolved.
I am a sometimes novice programmer. Thank You Very Much for your help.
Tom De
Struggling with this one. I have the below INSERT INTO statement. Using vs2013 Express Visual Basic.
SQLStr = "INSERT INTO Clients " _
& "(ClientID, EIN) VALUES " _
& "('Name', TIN);"
My err msg: "A first chance exception of type 'System.data.oledb.oledbException"...
I am using INNO to create an install package. The install goes fine except the installed .exe is not looking for the application files in the installed app directory.
It looks in the dir that Visual Studio created when I designed the app.
I understand that I have to write code within my app to...
Hi Jebenson,
I downloaded INNO. I will give it a try even though it is a complete mystery to me. Looks like you need to know what files are needed and insert them into a script file. Then build the script into a distributable .exe file. Is that pretty much it?
Thank You for your reply.
faxpay,
Tom
I am programming in Microsoft Visual Studio Express 2013. I understand there is no longer a Package & Deployment Wizard in this software. I have looked at Flexera but the free version is not sufficient and the pay version is way too complex, costly, and much more than I need. Any suggestions...
Hello All,
Has anyone found a good Add-in for VB2010 for designing reports?
I am relatively new to VB2010 and am looking for a flexible ADD-in that would make report designing easier. I remember when using VB6 that there was one but can't remember name. As I recall it wasn't that good...
Hope I have the correct Forum here.
I am using vb2010 Express.
When I draw a combobox or listbox I am unable to size in the design mode. In properties there is no Autosize property to select true or false. In the size property it will not allow me to change sizes.
When I look up the...
I am using vb2010 Express.
When I draw a combobox or listbox I am unable to size in the design mode. In properties there is no Autosize property to select true or false. In the size property it will not allow me to change sizes.
When I look up the properties for these controls there is an...
Below is my code. Getting Argument Exception(see subject) at "Using connection....." line. Looks like the connectionString is causing it but I can't see anything wrong with the string. This is the string: "C:\T&NDevelop\EFTPS_Access_TestSQL__App.vbp\database6.accdb\"
Where might I look?
Public...
Hi PH,
I missed that timestamp thread "Did you try my suggestion timestaped 29 Aug 14 19:12 ?" That fixed it. I did not know you could use Format in a SQL.
Thank You. Learned a lot.
Tom
tnfaxpay
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.