Checkbox issue

[powster2k8]

Hi Guys,

I am having an issue with my programing an access database for my business. I use access a lot and i am profecient in the area.

I want to be able to select services from a sub from using check boxes. The selected check boxes are then assign to the customer using a unique id that is generated from customer_table.

I have created a the sub form and the check boxes and have attempted to do to the above by building queries. For information on the queries i used please let me know.

Anyway, I am now looking for a solution in the sub form that i click on a button it then assigns the unique ID to the services so that i am able to see customers details the services that have been selected and the total sum.

Any help would be appreciated on this as i been working solind on this now for more than 72 hours and i am drawing blanks.

Thanks in advance

Powster

 

[Moniker]

1) This has nothing to do with a checkbox.

2) You'll need to post some more detail. What are the queries, what is the code?

If you can, strip most of the data (and any sensitive data) out of the DB, zip it, and post it.

 

[powster2k8]

Hi

Firstly, thanks for getting back to me. I have started the projetc again cause it was getting a bit out of control lol. What has started has side project has now lead to a full on one. I am still working on a solution but i have attahced my database to this mail to you gus can have a loook.

Many thanks on helping on this matter

Kind Regards

JAmie

 

[Moniker]

OK, to be polite, this is a broken DB.

There are a number of things just not right with the setup, but instead of going into paragraphs of detail, I'll keep it short and then post a response sample DB.

In short, it's not normalized at all, and there are a few two many tables than needed. The connection between the subform and main form is also out of whack.

Nothing major, and if no one gets to it before me, so be it, but if not, I'll make a sample DB that shows how to do this correctly.

 

[powster2k8]

Broken DB

Oh how my heart bleeds on this lol. That's cool mate thanks for taking a look. While i was working on a solution I found that I did indeed need more tables as there is too few tables because my inclination is for the services there needs to be at least two tables for e.g Services_Table PK Services_ID Prices_Table FK Services_ID this will provide the relationship I think.

If it would not take much of your time a quick sample database that jsut shows the working so I can understand the workings that would be a great boost.

If there is anyone in the forum that you pass by that you think I might be able to help I would be obliged to help in anyway I can.

Many thanks on your help mate!

Powster

 

[Moniker]

I'm getting to this today. Give me an hour or so.

 

[powster2k8]

Brilliant mate! It would be interesting to see how you could use the tick box in this scenerio. I studied the northwind example database got a few tips in term of data integrity and changed the selection from a combo box but it would be good to see if anything can be done with using the tick. I thought a new quite a lot but it turns out a only scraped the surface witht this application. One tip that worked for me is looking at the northwind database and trying to understand it it is a good learning tool. But cheers for helping me on this

Kind Regards

Powster