locked frames

[jeebob]

i know that i can lock individual items, but when i leave the frame, can i lock that frame and all items inside there, and at the click of a button can i unlock the frame and all contents?

thanks

[wildsurf]

What do u mean by "leave the frame"?

[MartinLiss]

Sure. When you lock a frame all its contents are locked and when you unlock it all the contents are unlocked.

[Harsh Gupta]

AFAIK, Frames do not have Locked property. please correct me if i am wrong. dont have VB here.

[MartinLiss]

Since frames don't have a LostFocus event then I guess to lock it when you leave it youd need to put Frame1.Locked = True in the GotFocus event of all other controls on the form except for the command button where you would say Frame1.Locked = False.

[MartinLiss]

AFAIK, Frames do not have Locked property. please correct me if i am wrong. dont have VB here.

You're right. I should have said Enabled instead of Locked.

[wildsurf]

I think what Martin trying to say is, u set the frame.enabled = false and eureka! the frame is now locked!

Hope that will help!

[jeebob]

so simply a case of if txtbox.text = "whatever" then frame1.enabled = false.... and that should lock the frame and all contents?

[wildsurf]

yes, that's right..but only the objects inside the frame will be locked..that's mean u have to put the text box and other thing inside the frame..

[Simply Me]

frame has no .locked property. They are right, use .enabled=false property instead. All controls inside the frame will be disabled.

[jeebob]

i tried to set the frame.locked = false (frame name is fraCustomers) and even though i have done this, it stil doesnt lock now all the objects are located inside the frame, but is there a way i have to link the frame to the objects????

[wildsurf]

frame has no .locked property. They are right, use .enabled=false property instead. All controls inside the frame will be disabled.

try

fraCustomers.enabled = true

good luck!

[jeebob]

now im overly confused, it stil wont do anything, i have tried fraCustomers.Enabled = False
fraCustomers.Enabled = True - and neither will lock the frame and contents?????? any clues??????

[wildsurf]

sorry..it should be

fraCustomers.enabled = False

when u use the above code, u mean u still can write in the textbos and click the buttons inside the frame?

bcoz, when the frame in disabled (.enabled= false), all the objects inside the frame doesn't appear to be locked but u still can't use the objects inside it i.e. write in the textbox or click the buttons in the frame.

[jeebob]

i no this seems impossible but it stil doesnt do anything

Private Sub txtOtherContact_LostFocus()
fraCustomers.Enabled = False
'fraCustomers.Enabled = True
End Sub
and

Private Sub txtOtherContact_LostFocus()
'fraCustomers.Enabled = False
fraCustomers.Enabled = True
End Sub

neither way works is there any way i need to link the objects to the frames for it to work because i really dont know why this isnt working

[wildsurf]

i tried ur codes and it worked just well..when the txtOtherContact textbox lost it focus (if u click on other objects), the frame will be locked..that's what i've got..

[jeebob]

al send ya the project if ya like see if you can find out anythin thats wrong with it.... becuase its really driving me crazy....

[Hack]

There is no reason to "send" it. Just zip it using Winzip and attach it.

[Simply Me]

Are you sure you are using the correct control name?

[jeebob]

i have only zipped up the form, not attached the tables etc. hopefully you can see what i mean...

[Hack]

The only thing in your Zip file is an Access database.

Are you doing this in VB6 or Access VBA?

If it is Access VBA, then that may be way the Frame disabling isn't working.

[jeebob]

Im using microsoft access 2003, and the coding behind it is done through vb6.0, but its the default that the program opens to edit the code. and if i cant do it through the vb6 coding, how else can this be done? and i will try reposting the full project and see if anyone here can make sense of it.

[jeebob]

so does anyone have any clues as to what might be going on becuase im at a loss for an idea. i really dont have a clue whats going on with it.... the laws of programming say that what i have used, should in theory work, but it hasnt... if anyone could help would be extremely grateful!

Thanks

[MartinLiss]

All you attached was the database. Where is the VB6 code?

[jeebob]

to access the code:

right click on an object (for example the text box next to "Event Time")
open up the properties of the box
select the "All" Tab
scroll to "On Change"
Click the On Change text box
select "[Event Procedure]"
just next to that will appear an elipse of three dots, click that and that opens the coding behind the form.

[wildsurf]

ive tried ur code and...yes, it doesn't work..i think the frame is different with the frame in vb6..so, i think that u have to lock each item..or see what anybody else have to say!

[jeebob]

so might be a case of..... that idea is out the window, does anyone know of any ideas as to how i could possibly link the frames and objects and lock the frame that way, so i could link the frame around the customer details, to the final box in that frame? so when that box loses focus, the frame is then disabled? just becuase i created the frame after the text box, so does this explain why it cannot be disabled?

[Hack]

All you attached was the database. Where is the VB6 code?

There is no VB6 code. This is an Access VBA project.

Moved to Office Development.