Check boxes and actions

[colkas]

Hi

we have a quotation form which is all working now. the next stage is we want to when we receive a customer Po do this

1. Have a range of check boxes (perhaps in another form) that have to be ticked (based on a quote number) , for example

Is customer name correct
is customer address correct
Is price correct etc.........

At the end if not all are ticked, I want a message box to come up and tell the user, all boxes must be checked do you want to continue Yes/NO. If Yes go back to the form, if No close the form and dont save the record...

If they are all checked then I want the user to be prompted with
"Do you want to create an order" If yes then I want all the quote details being copied into anothe table called orders which will have an autonumber for orderno...

So could someone help with

1. How to make the code for the check box
2. How to do the code for the create order
3. Also any advice how to populate the order table with the relevant data from quote table.Hi

Many Thanks

 

[plog]

Honestly, its not that easy. I would suggest hiring someone or giving us your code/ideas about how you are going to accomplish it so that we can guide you. This open ended question for code, just isn't going to work.

Essentially, you are going to have to make your form, then work through each task you want to accomplish piece by piece until you have put together something that does everything you want.

Possible look through examples and customize them for your situation.

 

[colkas]

Hi plog

Thanks for the reply. I appreciate it wont be easy but also feel access as more than the capability of doing it.

I have searched for some examples but cant seem to find any...

I think I need examples on check boxes and also example of turning a quote into an order.

do you know or anyone else know of any good demo or examples. I can then as you suggest try and adapt what I want to do and if I get stuck post the code and seek advice.

many thanks

 

[Rabbie]

Colkas, You will find sample databases supplied by Microsoft with Access when you install it. There is also a section of Sample databases on this forum. You will find that the more specific you make your questions the more and better answers you will get here. People are happy to help someone who is trying to learn but they don't want to do all the work for you.

Remember Google is your friend and can be very useful. Also see some of the Sticky threads at the beginning of the General section for advice on how to word your question so you get an answer.

 

[colkas]

Hi Rabbie

Thanks for the reply. Firslty I certainly dont expect anyone to do any work for me and I have learnt alot form this site alone.

All I am looking for was a point in the right direction, then of course I would be giving more specific questions regarding coding or whatever.......

I have searched the web, and I use google alot, alot for a similar example but to date I have had no luck, hence I am asking the experts on here.

Thanks for the input