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...
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...
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...
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...
In Access 2010 I have a db table with a field that has only numbers imported into it. The datatype is "NUMBER". I have been struggling trying to format as below:
NUMBER 4562359 format to 45623.59 The right 2 numbers always the cents.
NUMBER 4562300 would be 45623.00
I tried to do this in...
Hi All,
I am a novice. I am using Visual Basic 2010 Express. Can someone help me with code for using an SQL stmnt to load records from an Access db into a data grid on a form?
I am somewhat familiar with SQL statements but need help with the vb2010 or .net code to load and display into data...
Hi All,
I am using VB2010 Express. I have a bound control on my form and want to write an sql stmnt. I select the control(text box) and go to the "Data" menu. There is NO "Add Query" command in the drop down box. According to the "step by step" book there should be. I have tried various...
I built an Access form tied to a db. I have a comments box that I want to make a txt box. The 255 character limit for a field is not enough. Is there a way to have a txt box that is exclusive to each record where I can enter more than the 255 characters?
Thank You
faxpay
I have a text file with about 40 lines and at the end of the file, on a line all by itself at the very left, is a small box with the letters "SUB" inside it. I copied it below and it shows up as a small square.
Can anyone tell me what this is...
I am stuck. Want to add a line of text at the beginning of a text file. I have explored the File Object, the FileSystemObject, and the TextStreamObject. It looks like I can append to the file easily but I can't find anything that will allow me to add a line at the beginning of a file.
Then I...
Here is the code:
Public Sub F5ScreenAdjust_To_Date_Amts_For_Entry_To_DB()
Dim LenOfName As Long
Dim cntr As Control
Dim MTDTextBox As Control
Dim TxtBoxName As String
'Loop thru controls on frmF5AddEmpEarn to find text boxes.
For Each cntr In frmF5AddEmpEarn.Controls
If TypeOf cntr Is...
Here is the code:
Public Sub TotalNetPay() 'This proc is called from proc PlaceDecimal.
'It is called from two different places within proc PlaceDecimal.
Dim StorNetMTD As Double
Dim StorNetQTD As Double
Dim StorNetYTD As Double
Dim GrossWageMTD As Double
Dim GrossWageQTD As Double
Dim...
Right now on my Win 95 machine I can re-boot into the dos mode to run my dos based software. I re-boot by assigning a dos re-boot in the properties of my desktop icon. This provides me with enough memory for the app to work. The XP machine will not allow me to assign a re-boot.
The app will not...
In vb6 I want to convert a text file(assci file) to the pdf format. I need to manipulate and massage the file in vbscript first. Is ther a pdf converter I can use in vb6?
faxpay
Tom
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.