3 Replies - 676 Views - Last Post: 01 October 2012 - 08:07 PM Rate Topic: -----

#1 compucrazy  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 30-September 12

Help displaying information from access database in VB

Posted 01 October 2012 - 11:53 AM

Hello,

I am trying to display out of stock items and bills to today's orders in a listbox from an access database with the click of a button.

When I click the bill button i need to display the customer name, address, items ordered with costs and the total cost as well.

This is what I have so far, and I already made the BINDING SOURCE connections to the access database and created the forms. Please help me figure out how to do this or at least get me started. Attached is my code and a picture of what it needs to look like.

Thanks so much!

Imports System.Data.OleDb

Public Class frmMicroland

    Dim dbConnection As OleDbConnection


    Private Sub btnStockItems_Click(sender As System.Object, e As System.EventArgs) Handles btnStockItems.Click

        lstOutput.Items.Add("Here are the items taht are out of inventory or must be reordered.")
        lstOutput.Items.Add("The numbers shown give the minimum reorder quantity required.")


    End Sub

    Private Sub btnTodaysOrders_Click(sender As System.Object, e As System.EventArgs) Handles btnTodaysOrders.Click
    End Sub

  
End Class

Attached image(s)

  • Attached Image


Is This A Good Question/Topic? 0
  • +

Replies To: Help displaying information from access database in VB

#2 compucrazy  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 30-September 12

Re: Help displaying information from access database in VB

Posted 01 October 2012 - 12:49 PM

Yeah the database already has tables and attributes and all that is done. I just need to display the information within the listbox.

I was thinking I would need to write a query to get the pieces of information from the database but really I have NO idea where to start at all.

any pointers?
Was This Post Helpful? 0
  • +
  • -

#3 CharlieMay  Icon User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1605
  • View blog
  • Posts: 5,162
  • Joined: 25-September 09

Re: Help displaying information from access database in VB

Posted 01 October 2012 - 01:37 PM

You can see if these videos help you any.
Their short and very well explained.
Was This Post Helpful? 0
  • +
  • -

#4 compucrazy  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 30-September 12

Re: Help displaying information from access database in VB

Posted 01 October 2012 - 08:07 PM

any other information you can give me to help? like sites with code examples?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1