Check boxes 1

[ITheadache]

I am looking to create a check box of options that executes when I click a button. I am doing a sales log database, and would like to when I select a new order, have a table that pops up that allows the user to select which product is being sold. Any help would be greatly appreactiated.

 

[ITheadache]

Okay, maybe I need to be more specific (or more patient). I have a sales log data base that I want the user to be able to enter the proper amount of each item that is sold. So far my idea is to create a form that has all the possible items in check boxes. Then when the user selects new order, a pop-up box asks how many units, and then would automatically pop up this for so they can select what kind of units. The only problem is I am not sure how to code this, or how to make the form go away after the selection has been made.

I am open to any other ideas that may be easier to implement, but my programming knowledge is limited so thus far this is my best idea.

Thanks,
Bryan

 

[lespaul]

Have you developed a normalized data structure? What is the structure of the tables?

Are you sure that you want a single form with every possible product listed? You realize that anytime a new product is added you will have to modify the form?

Have you looked at the Northwinds database sample? There are many samples and ideas there for order/sales tracking.




Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[ITheadache]

I don't mind having to add onto the form for each new product, we only have a total of 10 products, and won't be adding much down the road. I was hoping that it would pop up the new form (which I can do) and then once the user places a check mark, it would record the selection, and then close the form (which I can't do) any ideas?

 

[lespaul]

So you want a form:
[tt]
? Product 1 ? Product 2 ? Product 3
? Product 4 ? Product 5 ? Product 6
? Product 7 ? Product 8 ? Product 9[/tt]

when the user selects the check box next to Product 1 you want to open another form:

How many? _____
[OK] [Cancel]

When they press OK, you want to write a record to a table storing this information.

Do you have "customers" that order these products? Do you not need to know which customer ordered it?

What if someone wants to order 2 things? Does the user have to do this twice?

Why not have a "SALE" form that has a subform that allows the user to select a product from a drop down and enter the number of items.

Then if the user needs to add another product to the Sale, they just move to the next line and select the other product.

Did you look at the Northwind samples like I suggested?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[ITheadache]

Either way works, I have customers in the database already, what I am doing now is an add on. Where is the Northwind database?

Another idea is to use enter boxes so it a form looks like

# Product 1 # Product 2 # Product 3
# Product 4 # Product 5 # Product 6
# Product 7 # Product 8 # Product 9

(Button) Submit order.

This then would enter the number of each purchased into the record that was just created in teh previous steps.

The reason this works best for me is because I don't want to display this information in the main form. That will just display all of our customer information, and shippment details.

Again, thank you for your help.

 

[lespaul]

If you search for 'Northwind' at office.microsoft.com in the download section, you can find it there.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi