Results 1 to 4 of 4

Thread: Adding Supplier to Database

  1. Sep 6th, 2003, 04:58 PM #1
    Rally
    Rally is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2002
    Location
    Central US
    Posts
    183

    Adding Supplier to Database

    I have created a Database in Access and made a form called Suppliers I am now able to see the existing data and I also am able to modify that data but I cant find no reference on how to delete or add data??
    Would someone please help??
    Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    Reply With Quote Reply With Quote
  2. Sep 6th, 2003, 05:14 PM #2
    Mike Hildner
    Mike Hildner is offline
    Frenzied Member Mike Hildner's Avatar
    Join Date
    Jul 2002
    Location
    Des Moines, NM
    Posts
    1,690
    How, exactly are you seeing and modifying your data. Some control?
    Reply With Quote Reply With Quote
  3. Sep 6th, 2003, 05:22 PM #3
    Rally
    Rally is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2002
    Location
    Central US
    Posts
    183
    by using the data control and setting its properties
    Reply With Quote Reply With Quote
  4. Sep 6th, 2003, 05:58 PM #4
    Mike Hildner
    Mike Hildner is offline
    Frenzied Member Mike Hildner's Avatar
    Join Date
    Jul 2002
    Location
    Des Moines, NM
    Posts
    1,690
    Well, I was just looking around, and didn't actually try it, but it looks like you would use something like
    VB Code:
    1. Data1.Recordset.Delete

    2. Data1.Recordset.AddNew
    where Data1 is a Data control.

    When you add a new form, you can choose to add a "VB Data Form Wizard", the default is to use add, delete etc. buttons. Maybe you can poach some code from there.

    HTH,
    Mike
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width