Noob Help

[Allisean05]

Hey all,

Ok I posted this question on another site and was basically told sorry, no help for me.

I was given a project to work on and create a D-base in Access 2000 for my library. The trouble is, I have very little experience in Access and have self taught everything I have done thus far in the D-base I am creating.

My question / issue is:
They want to have a check box that once checked, locks 4 other boxes from being changed.

Can someone tell me how I would go about doing this, please? Also, please take note I am a noob.

Thanks,
Sean

 

[maxmangion]

if by locked you mean, that data cannot be altered once the checkbox is ticked you can use the following code:

If Me.CheckboxName = True Then
Me.TextboxName.Locked = True
Me.TextboxName2.Locked = True
Me.TextboxName3.Locked = True
Else
Me.TextboxName.Locked = False
Me.TextboxName2.Locked = False
Me.TextboxName3.Locked = False
End If

You can place that code in the AfterUpdate event of your checkbox

 

[rainman89]

sure.

you can do this a few ways. you can "lock" them or disable them..

what you would do is check to see if the value of the checkbox is yes/no and from there lock the other text boxes

in the afterupdate event of the checkbox you could do

if me.checkboxname="yes" then
me.text1.enabled=false
me.text2.enabled=false
me.text3.enabled=false
me.text4.enabled=false
else
'do nothing because you want to be able to change them
end if

 

[Allisean05]

Total Noob

How / Where would I put this? Would I click on the check box and then got the properties and then on the "On Click" Event add it there in the code builder?

 

[rainman89]

you could, but afterupdate would be better

 

[MSAccessRookie]

As usual, RainMan has the right idea and after update is the right place

 

[Allisean05]

My brain is turning to mush

Ok so I try to enter the data in the coding, but it is giving me error messages, could this be because I have spaces in between my words?

 

[MSAccessRookie]

Ok so I try to enter the data in the coding, but it is giving me error messages, could this be because I have spaces in between my words?

Perhaps. If you need spaces between the words, add [] around them like this [two words]. In the long run it is better to use no special charcters, including spaces when creating variable names, form names, table names, macro names, etc.

 

[Allisean05]

Now you tell me

Ok, So I am going to re-do my form by making the field names in the table. Is that a good start to making the form?

 

[MSAccessRookie]

That will be a good start. All of the advice here is good, and a combiniation of it will get you foing in the right direction.

 

[Allisean05]

I know I am a PITA but

Is there someone that would look at my D-base after I completed it and tell me what I am doing right or what should be changed?

 

[MSAccessRookie]

Is there someone that would look at my D-base after I completed it and tell me what I am doing right or what should be changed?

Go ahead and upload it and someone can help you. I promise that will If I am here to do so.

 

[georgedwilkinson]

Sorry, what's a "PITA"?

Also, there is a little confusion in terminology. Every time I read "D-Base" I think of a non-Access program that neither I, nor most people here, have any valuable experience with.

 

[Allisean05]

Sorry, what's a "PITA"?

Also, there is a little confusion in terminology. Every time I read "D-Base" I think of a non-Access program that neither I, nor most people here, have any valuable experience with.

PITA = Pain in the behind
D-base sorry. I just mean an Access database.

 

[georgedwilkinson]

You're not being a pain. Many of us come here because we like to help.

Upload your work and somebody will look at it (make sure to post what version you're using, too).

 

[MSAccessRookie]

I second what GeorgeWilkinson said!

 

[Mike375]

For your field names in the table do them like:

LastName
FirstName etc. or

LName
FName or

LN
FN

Don't use names for fields such as Date, Time etc or you can have problems.