Access Database Help please

[josh.clare]

Hi all,

i have created a very basic access database that contains all the information i need for our jobs at work. a majority of the data is in 1 table.

All i need to do now is create some userfriendly forms to add/edit data in the tables.

i have uploaded my basic database here:
http://81.134.132.58/josh/Database7a1.zip

Can someone please help me in creating these forms, as you can see i have made several attempts but am struggling. i want to create forms for sections of the table if possible,

Thanks,
Josh

 

[Trevor G]

Hey Trev,

sorry to keep bothering you, i am near the finishing stages of my access database and am just tidying and completing a few things.

I have a few forms with fields that i want to be locked unless another field/tickbox is filled out.

Can you please help?

cheers,
Josh

This can be a little problem area, but here goes lets try this.

Open the form in Design view select all of the fields you don't want to be enabled and then open the properties you will be able to select the Data Tab and change the enable From Yes to No.

Next take a note of the field names then open the properties for the tick box and look at the events tab and select On Click then use the 3 dots on the right and select Event Procedure in the code screen create an if statement like this

if me.TickBoxName.value=True then
me.textBoxName1.enable=True
me.textboxName2.enable=true


and so on

else
me.textboxname.enable=false
me.textboxname2.enable = false

and so on

end if

 

[josh.clare]

hmmm... it seems to work but is a bit messy,
i was also wondering if i have three yes's on various fields on the table, can it then automatically put a yes in the complete field?

Thanks,
Josh

 

[Trevor G]

You can do the same sort of thing in the on click event.

If me.checkbox.value=True then
me.textName.value="Yes"
me.textName.value="Yes"
and so on
else
me.textName.Value=""
me.textName.value=""
and so on
End IF

 

[josh.clare]

hmmm... i dont think thats right, i dont really know much about code but wouldnt the if checkbox value = yes have to be for three fields and then the textname value = yes?

the other problem i have is that these fields are not all on the same form or does that not matter?

Thanks for all the help,

Josh

 

[Trevor G]

Checkboxes relate to Boolean events which are True or False or 0 or -1 not "Yes" or "No", unless you have them as Combo Box with Yes or No as values.

As far as making other forms trigger options based on you clicking a tick box then that does matter as there is more involved.

I would suggest you start using new threads so others can answer your questions, you may get quicker responses and methods that you will understand.

 

[josh.clare]

ok thanks