Search results for query: *

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...

We use NT along with Citrix ICA Client to log on to MSTS desktop, Access 97. I can confirm that the Environ function works with this combination. PassingBy

I believe you have a few options available to you here, trouble is all will probably end up with a lot of work. You could 1) Have one Tabbed form with a Tab for each 'medical department' thus only putting the required fields on each tab. This would be OK for up to 10 departments and then it...

Ricco No, you do not need to do anything special to your query just as long as it is providing you with the data you want in your spreadsheet. PassingBy (back from lunch)

Rico I had presumed you would be familier with creating the query. Not wishing to sound demeaning or insulting but I suggest you do some playing around or readup about creating queries prior to learning code. PassingBy

Rico If you leave the Output path and File name blank the user will be prompted for a file name and location to save a new file. Revised line on your command button DoCmd.OutputTo acQuery, "qryName", "MicrosoftExcel(*.xls)", , , "" PassingBy