Results 1 to 2 of 2

Thread: Database Code Help Needed

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2001
    Location
    Chester, England
    Posts
    2

    Question Database Code Help Needed

    Hi All,
    I have been preparing my stable quotation database interface for my company but I need desperate help with the code.
    I am a complete beginner to VB, as in earlier thread, and I have arranged how I want it to look.

    This can be found here: link

    Can anyone take a look and help me out a bit. I want to make my office life easier.
    I was wanting to get the program to display a quote for a horse in our stables so I can print a copy and give it to their owners.
    The pricing I use is as follows:

    Basic Stabling (Must Have!) £1.00/day
    Bedding £0.50/day
    Feed £1.00/day
    Cleaning Out (Weekday) £2.50/day
    Cleaning Out (Weekend) £3.50/day

    If possible I wanted to save to a text file or similar so the information could be backed up if needed.
    I have also included some arrow buttons so I can move through each record individually.

    I would be grateful to anyone who can help me out with this?

    Cheers
    eternity

  2. #2
    Hyperactive Member
    Join Date
    Jul 2001
    Location
    FL
    Posts
    258
    Well all you have so far is the GUI.
    The simplest approach to this may be to create a Access Database with a Table to hold the fields you wish to keep data for.

    Then add a Data Control to your form, set its DataBase Name to your Database and its RecordSource to the Table. You can find these setings on the Properties window for your DataControl.

    Then Bind your Text Boxes etc by setting their DataSource properties to your data control and their DataField to the field name in the Table it belongs with. Likewise you can find those properties in the properties window of the individual conmtrols.

    Then you will have to add code to Add, Delete and Update records etc.

    Just about any beginners VB book will show you how to do most of what I have described.
    So I suggest you start there to get a basic understanding of this.

Posting Permissions

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



Click Here to Expand Forum to Full Width