+ Reply to Thread
Results 1 to 12 of 12

Run-time error '70': Permission denied

  1. #1
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Run-time error '70': Permission denied

    Hi guys,

    Im receiving this error when I try to run my program. I tried to read the help file and the reasons provided i think does not make sense.

    I have two(2) forms frmlogin and frmcoaching, in frmlogin I have a combobox (cbousername) when user logs in frmcoaching will show with a combobox (cboagent), listview (Listview1) and a textboxes. I used one of the textbox (txtsupname) as a dummy for my to populate the names under the user who logged in. When I try to choose on of the name it is giving me te said error but when I run the program starting from frmcoaching it allows me to choose the name and view the details in Listview.
    Last edited by Arvin.Amaro; 04-09-2015 at 02:56 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run-time error '70': Permission denied

    Where do you get the error?

    Have you used RowSource to, initially, populate any of the comboboxes on the form?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Re: Run-time error '70': Permission denied

    Thank you for the reply Norie,
    I get the said error when I try to select a name from the combobox. For example Bryan logged in, the said combobox will only show agents under his name.

    Please Login or Register  to view this content.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run-time error '70': Permission denied

    Can you upload a sample workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

  5. #5
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Re: Run-time error '70': Permission denied

    Quote Originally Posted by Norie View Post
    Can you upload a sample workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.


    Thank you for the help.
    Last edited by Arvin.Amaro; 04-09-2015 at 02:08 PM.

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Run-time error '70': Permission denied

    Hi Arvin,

    I was unable to duplicate your problem - every time I selected a name from the combobox and pasted in the password - a form came up??
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  7. #7
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Re: Run-time error '70': Permission denied

    xladept,

    If your going to login lets say under bryan, a new form will show up... If you notice there are only two names showing... The main idea is that If incase I choose Bryan, agents under him should show up on the combobox which im really having trouble figuring out....

    BTW, I really do appreciate you guys for helping me out with this one.

  8. #8
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Re: Run-time error '70': Permission denied

    xladept,

    If your going to login lets say under bryan, a new form will show up... If you notice there are only two names showing... The main idea is that If incase I choose Bryan, agents under him should show up on the combobox which im really having trouble figuring out....

    BTW, I really do appreciate you guys for helping me out with this one.

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Run-time error '70': Permission denied

    Hi Arvin,

    The problem is that the names don't match up - I chose Bryan and erased his last name from the code and it worked

    Please Login or Register  to view this content.
    works!

    I
    Please Login or Register  to view this content.
    doesn't work

  10. #10
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Re: Run-time error '70': Permission denied

    Quote Originally Posted by xladept View Post
    Hi Arvin,

    The problem is that the names don't match up - I chose Bryan and erased his last name from the code and it worked

    Please Login or Register  to view this content.
    works!

    I
    Please Login or Register  to view this content.
    doesn't work

    Thank you for the reply,
    Actually it was just an error, I might have forgotten to save the file before sending it... But eventhough I remove the last name it will still give an error when you try to select a name from the combobox once logged in... Try to run just the frmcoaching it will show you the difference. Or maybe like adding an error handler that if there is no data yet entered for the said name it will show an error message the frmnew.show... do you think that might do it?

  11. #11
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Run-time error '70': Permission denied

    I'll look at it tomorrow - maybe it will be resolved before I log in again.

  12. #12
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Re: Run-time error '70': Permission denied

    Quote Originally Posted by xladept View Post
    I'll look at it tomorrow - maybe it will be resolved before I log in again.
    ok thank you. I'll try to find another way with this too (i hope!!!)....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Run time error 70 Permission denied.
    By sagar.rajula in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-10-2013, 11:50 AM
  2. RunTime 70 Error - Permission Denied
    By ross88guy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2011, 04:46 AM
  3. [SOLVED] error 70 - Permission denied
    By MT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2005, 03:06 AM
  4. [SOLVED] Run-Time error "70" Permission Denied
    By Audrey in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-04-2005, 06:07 PM
  5. Run-time error '70': Permission denied
    By Maury Markowitz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1