Search results

All contributer, thanks for your time. Got it. See my post #6.

@The_Doc_Man , I started thinking about a method bit like you described, but got a bit confused as I'm aiming to display the 'progress' visual on a continuous form. Simple on a single form but I could not get it to work on a continuous form. @theDBguy 's technique worked fine. I just might...

@theDBguy , worked fine. Thanks for the prompt response. I continue......

@theDBguy , never thought if that!. Will give it a go.

Friends, I have a continuous form, a bound control 'PercentProgress' into which the user enters a value to represent their progress with the task & an unbound textbox 'txtProgress' into which I wish to populate some kind of progress bar to visualise the task progress. I have simulated this with...

@The_Doc_Man , yes i agree. Sometimes it may be tempting to invest a disproportionate amount of time into some 'ideal' routine that really does not add significantly to the project. My 'issue' became a somewhat technical issue as i could not figure out how to do what i wished via a public...

@Gasman, i'd come to the same conclusion. If have to pass in the control name to the function, then i may as well just add one line of code to each subform to hide the control! I just thought there should be a smarter way. Cheers & you confirmed my thoughts.

@Gasman, i know the table well. My issue is that i refer to this module from multiple forms. The 'bttnDelete' routine is on each subform only. Id prefer to pass the control name as a variable. Its simple to disable the control on each form load event of the subform, but i was trying to figure...

@The_Doc_Man , Yes I could adapt an approach as you suggested & had thought about a technique similar to what you described. But, for now, I've added a one line of code to the on open event of each subform to hide the 'bttnDelete' control. This is easy, but my goal was to try and not repeat any...

@CJ_London my dilemma is that my code as in post #8 is in a stand alone module. I have 2 parent forms that use this code on the formOpen event to set up the user rights of each main form. Within each main form are several tabbed subforms. Each of these also uses the same code on their form...

@CJ_London , thanks. Got that bit I think, but This bit cdoesnt work, If IsSubform(frm) Then frm.BttnDelete.Enabled = False ' That is to disable the 'BttnDelete' controls on subform What I aim to do is disable the 'BttnDelete' control on each subform when Case is "1". I think I'm referencing...

So, if I may, I have one more question. On each subform is a button 'BttnDelete' that runs a deletion module. I wish to disable this for certain users. The 'BttnDelete' control is not on the mainform as I do not wish the user to be able to delete the parent record. I thought I'd check whether...

Well, that was pretty simple! I've learn't about form objects. Cool. Thanks to all whom contributed.

Friends, yes it works thanks. One question about; Call AssignUserRights(Form_FormName) I'd like to have formname provided by the system, that is me.Name. then concatenate as AssignUserRights("form_"&"me.Name") but I get an error when compiling. Won't accept a string...

All, thanks for the prompt response. Will have a go and let you know. Cheers

Hi, I have a mainform 'frmPersons' on it are a number of tabbed subforms. As an example one is called 'frmAddress_Subform, and the subform control is called 'SubfrmTab' to be original! My intention is to pass the form name to the below function to assign user rights. All works on the main...

@arnelgp , I downloaded your demo & yes, I can work with this. Exactly what I meant. A clever work around. Thanks a lot.

Gents, thanks for your input. Will have a go over the next couple of days & let you know how i get on.

Gents, thanks for the prompt replies. I figured what @arnelgp deduced. @arnelgp do you know of a demo database that displays this technique? Appreciate your help as always.

Friends, So I have a combobox 'ContactPurpose' on a bound continuous subform. I wish to populate the combobox with all records except when the user enters a new record, in which case I wish to restrict their selection to only 'Active' records. So, i have 2 select queries as below on the...