|
-
Jul 15th, 2001, 06:03 PM
#1
Thread Starter
New Member
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
-
Jul 15th, 2001, 10:21 PM
#2
Hyperactive Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|