Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Runtime Error '5'

Discussion in 'Information Technology' started by Eddy, Jul 28, 2006.

Tags:
  1. Eddy

    Eddy
    Expand Collapse
    Guest

    Dear all

    I have a problem on my Access database.

    It is developed on Access 2003 SP2, with 2000 format.
    I designed the Forms for resolution 1024x768.

    Some how, runtime error '5' occurred when my users open the Forms, with
    Access 2003 SP1 or with resolution different from 1024x768.

    But, for users using Access 2000 or Access 2003 SP2 with resolution
    1024x768, there is no problem.

    Moreover, because the computers of some users are having 16:9 screen and
    using 1280x768 resolution, so it is not convenience to ask them change the
    setting everytime when they use the database.

    Can you help to provide some solutions?

    Thanks & regards
    Eddy
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Runtime Error 5 is "Invalid procedure call or argument", so it's hard to see
    how resolution could be causing the problem.

    Have you tracked down what line of code is raising the error?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Eddy" <Eddy@discussions.microsoft.com> wrote in message
    news:E233DC7E-5A02-46A9-8842-2A9ED744D41C@microsoft.com...
    > Dear all
    >
    > I have a problem on my Access database.
    >
    > It is developed on Access 2003 SP2, with 2000 format.
    > I designed the Forms for resolution 1024x768.
    >
    > Some how, runtime error '5' occurred when my users open the Forms, with
    > Access 2003 SP1 or with resolution different from 1024x768.
    >
    > But, for users using Access 2000 or Access 2003 SP2 with resolution
    > 1024x768, there is no problem.
    >
    > Moreover, because the computers of some users are having 16:9 screen and
    > using 1280x768 resolution, so it is not convenience to ask them change the
    > setting everytime when they use the database.
    >
    > Can you help to provide some solutions?
    >
    > Thanks & regards
    > Eddy
     
  4. Eddy

    Eddy
    Expand Collapse
    Guest

    Hi

    When debug, the following code being highlighted:

    If IsNull(Me.Vacancies_Form.Form.RecordSource) Or
    Me.Vacancies_Form.Form.RecordSource = "Vacancies Query" Then

    Where "Vacancies_Form" is a sub-form.

    Thanks to investigate.

    Eddy

    "Douglas J Steele" wrote:

    > Runtime Error 5 is "Invalid procedure call or argument", so it's hard to see
    > how resolution could be causing the problem.
    >
    > Have you tracked down what line of code is raising the error?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Eddy" <Eddy@discussions.microsoft.com> wrote in message
    > news:E233DC7E-5A02-46A9-8842-2A9ED744D41C@microsoft.com...
    > > Dear all
    > >
    > > I have a problem on my Access database.
    > >
    > > It is developed on Access 2003 SP2, with 2000 format.
    > > I designed the Forms for resolution 1024x768.
    > >
    > > Some how, runtime error '5' occurred when my users open the Forms, with
    > > Access 2003 SP1 or with resolution different from 1024x768.
    > >
    > > But, for users using Access 2000 or Access 2003 SP2 with resolution
    > > 1024x768, there is no problem.
    > >
    > > Moreover, because the computers of some users are having 16:9 screen and
    > > using 1280x768 resolution, so it is not convenience to ask them change the
    > > setting everytime when they use the database.
    > >
    > > Can you help to provide some solutions?
    > >
    > > Thanks & regards
    > > Eddy

    >
    >
    >
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Where is that code: in the module associated with the form that contains the
    subform, or in the module associated with the form that's being used as a
    subform? (It needs to be in the form that contains the subform)

    In what event is the code?

    While Vacancies_Form may be the name of the form that's being used as a
    subform, is it the name of the subform container on the parent form?
    Depending on how the subform was added, the container may be named something
    else.

    Finally, there's no reason for the IsNull check. RecordSource will never be
    Null: it's a zero-length string if it's an unbound form.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Eddy" <Eddy@discussions.microsoft.com> wrote in message
    news:A6562712-9942-4132-82CE-CF7B62BA54A0@microsoft.com...
    > Hi
    >
    > When debug, the following code being highlighted:
    >
    > If IsNull(Me.Vacancies_Form.Form.RecordSource) Or
    > Me.Vacancies_Form.Form.RecordSource = "Vacancies Query" Then
    >
    > Where "Vacancies_Form" is a sub-form.
    >
    > Thanks to investigate.
    >
    > Eddy
    >
    > "Douglas J Steele" wrote:
    >
    >> Runtime Error 5 is "Invalid procedure call or argument", so it's hard to
    >> see
    >> how resolution could be causing the problem.
    >>
    >> Have you tracked down what line of code is raising the error?
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >> "Eddy" <Eddy@discussions.microsoft.com> wrote in message
    >> news:E233DC7E-5A02-46A9-8842-2A9ED744D41C@microsoft.com...
    >> > Dear all
    >> >
    >> > I have a problem on my Access database.
    >> >
    >> > It is developed on Access 2003 SP2, with 2000 format.
    >> > I designed the Forms for resolution 1024x768.
    >> >
    >> > Some how, runtime error '5' occurred when my users open the Forms, with
    >> > Access 2003 SP1 or with resolution different from 1024x768.
    >> >
    >> > But, for users using Access 2000 or Access 2003 SP2 with resolution
    >> > 1024x768, there is no problem.
    >> >
    >> > Moreover, because the computers of some users are having 16:9 screen
    >> > and
    >> > using 1280x768 resolution, so it is not convenience to ask them change
    >> > the
    >> > setting everytime when they use the database.
    >> >
    >> > Can you help to provide some solutions?
    >> >
    >> > Thanks & regards
    >> > Eddy

    >>
    >>
    >>
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page