+ Reply to Thread
Results 1 to 12 of 12

Run-time error '70': Permission denied

Hybrid View

  1. 04-08-2015, 02:37 PM #1
    Arvin.Amaro
    Arvin.Amaro is offline
    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.
    Reply With QuoteRegister To Reply
  2. 04-08-2015, 02:49 PM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    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.
    Reply With QuoteRegister To Reply
  3. 04-08-2015, 04:48 PM #3
    Arvin.Amaro
    Arvin.Amaro is offline
    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. 

    Private Sub UserForm_Activate()

    If Me.txtsupname.Value = "Bryan" Then cboagent.RowSource = "login!f2:f19"
    If Me.txtsupname.Value = "Daryll" Then cboagent.RowSource = "login!g2:g17"
    If Me.txtsupname.Value = "Adrian" Then cboagent.RowSource = "login!h2:h17"
    If Me.txtsupname.Value = "Lee" Then cboagent.RowSource = "login!i2:i18"
    If Me.txtsupname.Value = "Chris" Then cboagent.RowSource = "login!j2:j12"
    If Me.txtsupname.Value = "Erjan" Then cboagent.RowSource = "login!k2:k15"
    If Me.txtsupname.Value = "JB" Then cboagent.RowSource = "login!l2:l13"
    If Me.txtsupname.Value = "Jim" Then cboagent.RowSource = "login!m2:m19"
    If Me.txtsupname.Value = "Krissta" Then cboagent.RowSource = "login!n2:n16"
    If Me.txtsupname.Value = "Mond" Then cboagent.RowSource = "login!o2:o17"
    If Me.txtsupname.Value = "Carlo" Then cboagent.RowSource = "login!p2:p14"
    If Me.txtsupname.Value = "Darwin" Then cboagent.RowSource = "login!s2:s20"
    If Me.txtsupname.Value = "Louie" Then cboagent.RowSource = "login!t2:t17"
   
End Sub
    Reply With QuoteRegister To Reply
  4. 04-08-2015, 04:54 PM #4
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    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.
    Reply With QuoteRegister To Reply
  5. 04-08-2015, 06:13 PM #5
    Arvin.Amaro
    Arvin.Amaro is offline
    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.
    Reply With QuoteRegister To Reply
  6. 04-08-2015, 06:40 PM #6
    xladept
    xladept is offline
    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
    Reply With QuoteRegister To Reply
  7. 04-08-2015, 06:52 PM #7
    Arvin.Amaro
    Arvin.Amaro is offline
    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.
    Reply With QuoteRegister To Reply
  8. 04-08-2015, 06:53 PM #8
    Arvin.Amaro
    Arvin.Amaro is offline
    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.
    Reply With QuoteRegister To Reply
  9. 04-08-2015, 07:10 PM #9
    xladept
    xladept is offline
    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

    If Me.txtsupname.Value = "Bryan" Then cboagent.RowSource = "login!f2:f19"
    works!

    I 
    f Me.txtsupname.Value = "Bryan Durano" Then cboagent.RowSource = "login!f2:f19"
    doesn't work
    Reply With QuoteRegister To Reply
  10. 04-08-2015, 07:42 PM #10
    Arvin.Amaro
    Arvin.Amaro is offline
    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

    If Me.txtsupname.Value = "Bryan" Then cboagent.RowSource = "login!f2:f19"
    works!

    I 
    f Me.txtsupname.Value = "Bryan Durano" Then cboagent.RowSource = "login!f2:f19"
    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?
    Reply With QuoteRegister To Reply
  11. 04-08-2015, 07:48 PM #11
    xladept
    xladept is offline
    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.
    Reply With QuoteRegister To Reply
  12. 04-09-2015, 08:24 AM #12
    Arvin.Amaro
    Arvin.Amaro is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1