Search results for query: *

Hi, How does one lock everything down so the the user can only interact with the forms of the system and have no other access to tool bars including the bare minimum. This is so that the system is tight disabling the user from doing anything outside of what should be accessible for the enduser.

The Subforms that I am trying to enter data into are unbound and reside within the Mainform for new owner, new register, update owner and update ragister. The subforms are not based on a query and are currently totaly independent from the navigation tree subform.

There is a Main Form The main form has buttons on the top to open appropriate subforms for record creation/viewing and updates. Also has a navigation tree subform on the Left hand side that is always visible but not operational for navigation at the moment. Problem that occurs is that when I...

That worked a treat. Thanks

This is probably a very simple answer, but one I do not know the answer to. How do I ensure that a Main form opens maximised? in size

Superb, that worked a treat. Thank you, I can apply this to all forms that need to be cleared when they become visible.

I see what the code is doing but when run it brings up a type mismatch error?

Have looked at data entry it was set to yes, I set it to no selected another form, came back to the changed form and data was there. (please note these are unbound forms).

I have a number of hidden forms in a main form. I can create records, update records and recalc forms so that all combos are current when I make eacj form visible. But how do I clear the contents of the form each time it becomes visible. Thanks

Hi, Problemo. The combos on the subforms do not refresh. E.g. I create owner (works) I then goto the update Owner subform (I can see owner) I go back to crate owner and create owner2 O go back to update owner and I can only see owner1 and not 2. How do I refresh/requery all subforms to...

Hi there, I think you have a point. I have just created a new form and then one by one added on the subforms and now it works. You have been a star with this, thank you for your help. I will be back with more as this system being developed will assist a multibillion pound project once...

this bit of additional info may help. The mainform that the subforms sit in does not show any data appart from have a number of buttons to call each of the subforms.

Initially I created a number of unbound forms for creating owner, creating register, editing owner, editing register etc. Each form had its own set of buttons such as clear form, save details and exit. These forms work ie I can create owners, registers, make amendments etc. Then I got the...

The foms used are all unbound. I use ADO to enter data into the tables. This works fine on the individual forms. As soon as I use the same forms as subforms I cannot enter data into the text boxes.

I have created an unbound textbox that I use to set focus to. That resolves the issue of hiding the form. Now the only problemo is the inability to type into the sub form. What causes this? Thanks. (by the way I am finding this site an excellent way to develop projects and learning through...

super guys that works. Problem now id I cannot enter any data into the forms. They allow me to click on drop downs and onto the text boxes but I cannot type anything in. Also for example when I click on lets say create owner, the form comes up I then click on the text box but then I think I...

I have a form called platform that has a navigation tree on the Left hand side showing registers and issues. On the top there are buttons that open forms called create owner, create register. I want the forms to open as subforms in the center of the form Plat form but not to be visible when...

I have created a generic form that has a TreeView on the left hand side, and on the top it has some buttons e.g. create register, create risk, create scoring grids etc. These buttons open up individual forms to carry out the task but now I want the forms to open within the Generic Form. Is...

There are 3 levels that the register can sit in: Level 1 - Strategic, Level 2 - Business, Level 3 - Project. The level table has PK LevelID and each register has a fk Level ID. How can this be encorporated to the above code so the tree shows: Level Register Risks Thank you.

Dough, Just renamed the control...I am jumping with joy. Does this mean that if I click on the risk I can have a form refresh using the risk ID to pull up the details. Thanks