newbie questions 2

[Ddegroof]

Hello all,

I'm a newbie to access and have a few question someone and hope that some of them could get solved:

Situation:
----------
File with customer information
Form is created but needs some *features*

Help needed for:
----------------
1) I want to add a combo & checkbox to have some comfirmation of certain checks that are done, e.g. cust.contacted via ... etc
I'm able to create these but I want them to be different for each customer i browse and the form needs to remember the flags that I check and the option I choose per cust.

2)Tabs, I want to have a tab for info and a tab with some sheet where I can add info about my actions.
How can this be done, it must be remembered per cust. and be clean when I browse for the next one.

3)I want to be able to print a single cust. info, not the whole DB as I have now. also report, how can this be done per customer instead of the whole DB ?

Can anyone help me out here, even point me to some information that I can use to help me get my goal.
Or even some nice examples or webpages where I can look for a solution ?

Thank you very much in advance,

David

 

[DougP]

Next time One Question per post Please

Answer to 1
your customer table needs to have a Yes/No field "bound" to a check box. So if you check it for Customer 1, it will stay with them. And so on
Combo box same way
Add another field in the customer table that is what that combo box is
State is a good example Arizona, Alaska, Arkansas etc.
there are 50 choices but the customer only lives in one state.
So you need a State Table that has all 50 states the Combo box Control source is looking at the 50 states table
then the customer form combo box is bound to state in the customer table
Now when you move to next customer the sate stays correct cause it is really stored in the customer table

The combo box has a Creation Wizard that will make it all happen with button clicks.
so create your table with the choices than come back and create the combo box and it will prompt for a table choose it and then it will prompt for which customer field pick it.

OK

Question 2 later


DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Thanks]

Thanks Dougp, Sorry about the questions, next time I post I will only post one at a time, didn't know.

I tried to bound them and it works great !!

Cheers & have a nice day,

David

 

[gusbrunston]

Dear David:
You've just gotten some great help from a real pro. Why not click on the link that says, "Let DougP know this post was helpful!" ? ...it's another star in his crown...
Gus Brunston
An old PICKer
padregus@home.com