Recent content by PassingBy

Thanks for your help guys The final solution was Protect the sheets and leave the Workbook unprotected. It seems that it cannot change the sheet properties on opening if the workbook is protected. Star for your patience! PassingBy "Happiness is not getting what you want but wanting...

Thats cracked it! The workbook was protected as well. Remove the protection and the sheet became hidden, now all I need to do is re-protect once opened. Should I only protect the remaining visible sheet or the whole workbook? PassingBy "Happiness is not getting what you want but...

Skip/Rob I have 2 sheets in the workbook Post Codes Input Post codes is 100% protected Input partially protected. Could the protection be stopping the Call from working? I will try unprotecting and see if the error occurs PassingBy "Happiness is not getting what you want but wanting...

Guys I confess I was referencing the wrong sheet name - my humble apologies, however, I have now corrected this to "Post codes", closed it all down and reopened. Now I'm getting error 1004 unable to set the visible property of the worksheet class. My hair is falling out rapidly...

Skip The following is located in Module 1 Sub HideSheet() Worksheets("sheet1").Visible = False End Sub I am trying to call HideSheet as follows Private Sub Workbook_Open() HideSheet End Sub Is this completely wrong? I would like it to be xlSheetVeryHidden but its not essential...

Can someone take this one step further and advise how I can put this so that it works On the Open Workbook event. I keep getting run time error 9 subscript out of range I have put the code in module 1, called it HideSheet and called if from the Open event but it doesn't work! Very frustrated...

I use the Environ ("username") function extensively both within forms/code and default field values within tables This to me is one of the most useful functions I have come across. We are using NT4 and Citrix client server for logon, basically it picks up the network login name from...

As with many others I am self taught but have also been on various courses 'on the way', some books are OK some are not, life experience counts for a lot. Most of my stuff has been replacing/automating paper systems, this makes it easier because you have a model to work from. The 'REALLY' most...

Pressic Thanks for the link details, it looks just what I'm after, I will have a good read and digest. Bye for now PassingBy ... again

Pressic I maybe able to throw some light on your original problem. Because our users are all thin client (Citrix ICA client)I have not utilised the workgroup security, there are many arguments in these forums about how secure dbs are without workgroup admin but this method satisfies our needs...

Pressic Thanks for posting your method, sorry about delay in reply - serious network errors this morning! This is sort of along the lines, I already extensively use the Environ ("username") function rather that the workgroup to record user activity within table fields. What I am...

Pressic Sorry can't help you with your problem but I am interested in your data change tracking methods, can you post a brief description of how you 'record' record changes in a trail. Thanks PassingBy

Error code 2449 refers ErrorString There is an invalid method in an expression.@For example, you may have tried to use the Print method with an object other than Report or Debug.@@2@2015551@1 Doesn't tell you much really! I am using A97 and there does not appear to be any Event for Mouse Over...

I have not tried it and I maybe wrong, but I guess this will not be possible unless the subform is the current active form. If the parent form is active then there will be no events triggered on the subform. Once the subform has the focus or is activated then its possible you can do this for...

Alternatively, You could 'hide' the command button until such time as the 'Lostfocus' event has finished. This would prevent the user from clicking it to begin with. I very often hide my 'control box' and 'close' buttons until I am happy that the user has done everything they ought. Just a...