I have a simple program that prints a report that is about fifteen pages long. I am a beginning programmer so I picked up some generic print code off of the internet. It works well but I need to include a header and page numbers on each page of the report. Also, on future projects I would like...
I am transferring files from an IBM system 36 to a text file on my PC. Then my VB program reads the text file and inserts records into a SQL database. Everything is going well but unfortunately some of the fields are PACKED data. I am using an Nlynx twinax adapter card. It does not appear that...
I am using a very simple print form procedure that I found on the internet. In one project it prints the form flawlessly. In another project it prints a solid black box!!! I'm not sure what is going on. Any assistance would be greatly appreciated.
<code>
Public Class RateSheet
' create a...
I am writing an auto insurance application. I need to sort a three dimensional array in descending order based on an integer value in third field in the array.
The CalcPremium function returns an integer value.
Dim CarDriverArray(3, 3)
CarDriverArray(0, 0) = "D1"...
I think I figured it out!!
Dim DriverList As New List(Of Decimal)
DriverList.Add(Dclass1factor)
DriverList.Add(Dclass2factor)
DriverList.Add(Dclass3factor)
DriverList.Add(Dclass4factor)
DriverList.Add(Dclass5factor)
DriverList.Sort()...
I am a beginner VB programmer--I just finished the intro course!
I am writing an auto insurance application. In the application there can be up to five cars and five drivers. Each driver is assigned a driver rate (a decimal factor) and each car is assigned this factor which determines the rate...
Thanks you guys for you help. I put the parameters back in the order they are listed in the insert statement and it works perfectly! Now I can move on to the next problem.
I am trying to do an insert into a table called Policy. I keep getting an error that says parameter @Split has no default value. To try and resolve the problem, I set the default value of the split field (of type text) in the Policy table to "0" in Access 2007. I am passing in the value of a...
What was wrong
What I was missing was a connection.open at the beginning of the select statement and a insertcommand.ExecuteNonQuery(). It works now!1 Thanks for you guys' time.
Database Layout
While trying to figure out this problem I removed all of the table relationships so its pretty straightforward. I have a Customer table, Policy table, PaymentsDue table, and a Customer Transaction table.
Does this answer your question?
I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. The copy and paste below from VS is a little messy. When I execute this code below the...
Datareader depth=0 but there are two records
You are exactly right-it works correctly now. I greatly appreciate your input!
I wondered why it was picking up the second record and not the first.
I am in a intro VB.net college class and am a little frustrated with a problem I am having using a data reader to read the result set of a query.
Dim automobile As New Automobile
Dim connection As OleDbConnection = PaulMeadeInsuranceDB.GetConnection
Dim selectStatement As...
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.