Form creation

Hi all,
I am trying to make an order sheet and my idea is that all the orders are shown on one sheet and when clicked on a macro button then it goes to its details. But the problem is that I don't how can i store the records, make them come when clicked on the show order button and browse through records. I also have attached my current work to make it easier to understand.

Testing .xlsx

So you have multiple orders on Sheet1. Do you want the macro to run when each ID is clicked? Otherwise, when you click the show order button as you currently have it, how do you want to identify which order to show?

Well I want to show the orders when the show order button is clicked and they will be identified using order ID.

No one has replied yet so I guess either noone has understood my problem or don't know how to solve it. So plz can anyone tell me what is it? As I need to get this done urgently.

Its like this I want to store order data that is the items that have been ordered on the items sheet and in order sheet I want to show the order id, date, whether its paid or not and other stuff, while the job of the button show order is to extract the order id and show its relevent data for each customer. The problem is that I am not getting how can i store data as an order can have multiple items.

hi

This is a lot more complicated than you imagine.

Attached is my first version of a file for you.

type in a number in the order id box and press go.


I will now amend this to give you two more functions

okay thx will check it out.

Mehmetsik I typed the order I'd and pressed go in the workbook u provided and well nothing happened. Also what do u mean by it is more complicated then u can imagine.

Hi Try this

Order_Tracker1.xlsm

Ok

Where the order number is enter 7 and then find. The macro woill convert this to 000007 and find the data and populate userform.

Change the 000007 to 000005 and press save, the macro will find the order 000005 and overwrite this information.

press New. This will create a new number and you can type in your new data.

Enjoy

Okay mehmetsik thx, but u guys have got only the half part of my problem. U see I want my order to be shown by the form and it should contain the fields that are in sheet 2 that is items, description etc. But where would i store them. Like if i make one order then store all of its details then i want to make another order where would it details go. I can make a new sheet and put everything there but what about the things in the description and item no. that are in sheet 2. These would contains multiple items so how would i store them.

Ok

This Version allows to search for all orders of a customer

enter 07 in customer id and click "Find Cust" click it three times and three customer orders will be shown.

With regards to the details of the order.

You sheet 2 will need to start each data list with an empty line, an order number and then list all items on that order.

I could then pick up all the items on a particular order and show them on either a scrolling box or a combination box.

Thx mike7952 for ur file and that's what I wanted except that I want it to show the order when order id or show order button is clicked in the order sheet and I don't want the order ID and customer ID to be in the table with the other fields I want it at the top of the form and how can I add new orders to this form. Also I didn't ask anybody to make something like I stated in my post#13 I just wanted someone to tell me how could I make a form like that.

@mike7952 can u tell me how can I see the sheets in the workbook u provided because they are locked.

Can anyone help me with this plz as I need to do work on this urgently.

Ok lets see if I understand you.

You want a Form to populate a table on sheet 2.

there maybe several tables on sheet 2, but you would like to be able to select a specific table as an when required. ie Customer 1 or Customer 2 so dependent upon which one

You also want to be able to select items on the form a populate the selected table with this information on a new row.

is that correct

ok this should point you in the right direction

http://www.excelforum.com/excel-gene...-using-if.html

Okay i started making the form for items but ran into some problems. The problems are the search and delete button as I don't know how to make them. I will attach the workbook i have made until now.

Test1.xlsm

Hi everyone,
I finally managed to create the workbook that I was talking about but all that missing are some validation rules for the form. I have searched a lot of forums for it but was not able to found anything. So can someone plz tell me how can I create validation rules. I want to create two validation rules in my order form one for the date that is should be less than or equal to today's date and should be greater than 1/1/2013 and the date format is mm/dd/yyyy. The other validation rule i need if for my order id I want a rule to check that all order id's that are to be saved by the user should start from "OD-". Finally my workbook is attached below.

Test2.xlsm

Originally Posted by saiyan x

Hi everyone,
I finally managed to create the workbook that I was talking about but all that missing are some validation rules for the form. I have searched a lot of forums for it but was not able to found anything. So can someone plz tell me how can I create validation rules. I want to create two validation rules in my order form one for the date that is should be less than or equal to today's date and should be greater than 1/1/2013 and the date format is mm/dd/yyyy. The other validation rule i need if for my order id I want a rule to check that all order id's that are to be saved by the user should start from "OD-". Finally my workbook is attached below.

Attachment 223245

Does anyone have a solution for this yet.

I think I understand what Saiyan meant. Maybe you want the Userform show this list of item that ordered by 1 customer. For example in Sheet 1 there are several numbers of customer that hold their own unique id. Then once you click the id, the the userform pop up and enable you to type the list of item that the customer order as potrayed in sheet 2. Is it right Saiyan? If it is right. I hope somebody can help to solve this problem.

Originally Posted by azarafie83

I think I understand what Saiyan meant. Maybe you want the Userform show this list of item that ordered by 1 customer. For example in Sheet 1 there are several numbers of customer that hold their own unique id. Then once you click the id, the the userform pop up and enable you to type the list of item that the customer order as potrayed in sheet 2. Is it right Saiyan? If it is right. I hope somebody can help to solve this problem.

Finally, everything u say is right but now I have done it, thx to mehmetsik and now all I want is a way to validate information that is entered in the userform. I want to validate the date field in the order form by allowing dates that are less or equal to today's date and should be greater than 1/1/2013 (date format is mm/dd/yyyy).