Search results for query: *

  1. N

    Native Printing: Adding a header and Page Numbers to each page

    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...
  2. N

    Converting packed data and inserting to SQL Server

    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...
  3. N

    Print form prints a solid black box!!!

    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...
  4. N

    Sorting a two Dimensional Array

    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"...
  5. N

    Do I need a sortedList?

    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()...
  6. N

    Do I need a sortedList?

    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...
  7. N

    Inserting Into Access Table - Parameter has no default value

    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.
  8. N

    Inserting Into Access Table - Parameter has no default value

    I have run successful inserts into Access 2007 databases using named parameters in VB.net. Perhaps I should of posted this in windows forms.
  9. N

    Inserting Into Access Table - Parameter has no default value

    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...
  10. N

    Question Problem with Insert Command

    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.
  11. N

    Question Problem with Insert Command

    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?
  12. N

    Question Problem with Insert Command

    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...
  13. N

    Question Datareader only depth=0 but there are 2 records

    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.
  14. N

    Question Datareader only depth=0 but there are 2 records

    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...
Back
Top