Access 2007 trying to make a control source tick box

[blueyedsamurai]

I Havent used access much, so hopefully this is a pretty simple thing to do.

I have a database with about 16,000 people, i didnt create the database and what im trying to do is create a tick box like the ones in the database that only effects that client and not the entire database which is what is happening to me. I can make a tick box in design view but the box just effects everyone

any help would be great thanks

[June7]

How is it affecting all records? There must be code or it is because of table relationships or the textbox is not bound to a field.

My suspicion is that it is not bound, therefore the value is not saved to a table and the checkbox selection will show the same for all records on the form. Must have field in table for the checkbox to be bound to.

[blueyedsamurai]

hi thanks for the reply,

Yeh thats what im trying to do, there are tutorials on the net but they dont really show you how its done properly.

Is there a tut somewhere that i can try?

[June7]

Open table in design view, add new field.

Open form in design view, add new textbox. Set ControlSource property to the new field.

This is the most basic Access functionality. Access Help has guidelines.

[blueyedsamurai]

hi june,

i know how to do that, but as i stated the tick box just greys out when i try to create a control source, or just effects every page

i want to create an expression/control source like the unsuscribe or hottie
as they are listed in the property sheet.

[June7]

Don't understand how simple edit such as adding a field and control could be so problematic. You could provide project for analysis. Make copy, remove confidential data, run Compact & Repair, zip if still large, attach to post.

[blueyedsamurai]

its ok i figured it out, ive never really used access much even at all.

Not sure if i should make another post, but is it easy to make a box or notification pop up with a u tick a box.

On that database when u tick 3 boxes, a notification comes up saying "client call customer service" in bold red.

as shown in pic

[June7]

You want a message to pop up if checkbox is checked 'yes'? This requires code, I use only VBA.

You could use MsgBox. Search Access VBA Help about MsgBox and InputBox.

[blueyedsamurai]

well not a message box like you would get when u close a program and it ask you yes or no.

that box just appears but u can not interact with it. In design view u can edit its text or size. Once those 3 boxes are ticked it becomes part of that page(like it was part of the page to begin with).

But of course it only effects that client and it goes away once u untick one of the boxes

[June7]

That red letter message box is probably just a label that is set to not visible until certain condition is met, such as the 3 check boxes are checked. You want another message like that? Then explore the code that works to control that box and replicate it.

[blueyedsamurai]

yes im pretty sure that would be it.
thanks for the info by the way, i havent used access since highschool so im basically a scrub at the moment

ill try and see if i can find the code thats making the box appear

[blueyedsamurai]

i could attach a copy of the database, if it would help.

its over 300MB so i can delete a bunch or records and save as another

[June7]

If you are totally lost on finding the code, you could try condensing and then zip. Up to 2mb zip allowed.

[blueyedsamurai]

can only compress it to around 50MB, even after deleting every record and anything no related to the code

[June7]

Did you run Compact & Repair? If still too large, can upload to a fileshare site such as box.net and post link to the file.