Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PassingBy
  • Order by date
  1. PassingBy

    How to hide/show excel sheet

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

    How to hide/show excel sheet

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

    How to hide/show excel sheet

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

    How to hide/show excel sheet

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

    How to hide/show excel sheet

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

    How to hide/show excel sheet

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

    Login form

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

    How does one REALLY make it in VBA?

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

    Tracking Changes to Data

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

    Tracking Changes to Data

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

    Tracking Changes to Data

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

    Tracking Changes to Data

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

    Set focus to a subform

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

    Set focus to a subform

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

    Onlostfocus - how to override/defeat

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

    Environ("UserName") on Windows NT

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

    Visible/Non-Visible Objects on Form

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

    Creating excel files

    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)
  19. PassingBy

    Creating excel files

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

    Creating excel files

    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

Part and Inventory Search

Back
Top