A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Runtime problems



 
 
Thread Tools Display Modes
  #1  
Old May 6th, 2008, 06:12 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Runtime problems

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault
  #2  
Old May 6th, 2008, 08:30 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Runtime problems

I added some code and now I get an error that the object referred to in the
code does not exist or is deleted (only when using runtime - it works fine on
a full version of access)
--
Daniel Pineault


"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

  #3  
Old May 6th, 2008, 08:49 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Runtime problems

To me, it really seems like a permissions issue, but I just can see the
problem. The form & underlying table, my group admins has full rights?

Let start over (make sure I'm not missing something), assuming I want to be
able to open a form and edit/input data what would the required perms. be?
--
Daniel Pineault




"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

  #4  
Old May 6th, 2008, 08:55 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default Runtime problems

I know Allen Browne has a good resource at www.allenbrowne.com on why forms
disappear. You might try there first.

"Daniel Pineault" wrote:

To me, it really seems like a permissions issue, but I just can see the
problem. The form & underlying table, my group admins has full rights?

Let start over (make sure I'm not missing something), assuming I want to be
able to open a form and edit/input data what would the required perms. be?
--
Daniel Pineault




"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

  #5  
Old May 6th, 2008, 09:03 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Runtime problems

You wouldn't happen to have a direct link?
--
Daniel Pineault




"Golfinray" wrote:

I know Allen Browne has a good resource at www.allenbrowne.com on why forms
disappear. You might try there first.

"Daniel Pineault" wrote:

To me, it really seems like a permissions issue, but I just can see the
problem. The form & underlying table, my group admins has full rights?

Let start over (make sure I'm not missing something), assuming I want to be
able to open a form and edit/input data what would the required perms. be?
--
Daniel Pineault




"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

  #6  
Old May 6th, 2008, 09:08 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Runtime problems

I understand that in some case there will be no records to display and thus
the subform will not display just be blank, but even when a goto a record
which I know has records, the subform remain blank.

I reviewed http://allenbrowne.com/casu-20.html but as far as I can tell none
of these conditions explain the current behavior.
--
Daniel Pineault



"Golfinray" wrote:

I know Allen Browne has a good resource at www.allenbrowne.com on why forms
disappear. You might try there first.

"Daniel Pineault" wrote:

To me, it really seems like a permissions issue, but I just can see the
problem. The form & underlying table, my group admins has full rights?

Let start over (make sure I'm not missing something), assuming I want to be
able to open a form and edit/input data what would the required perms. be?
--
Daniel Pineault




"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

  #7  
Old May 6th, 2008, 09:38 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Runtime problems

Here are all the details.

I had a db which was split and secured.

I had 2nd db which was not.

I imported a form and its subforms from the 2nd db into the 1st secured one.
I have checked the security and the permissions appear correct, but I still
believe they are at fault for the form not being displayed when deployed on
the network. I have recopied the security file which work on my local pc
onto the network but that has had no impact.

Anyone have an idea of what I am missing.
--
Daniel Pineault



"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

  #8  
Old May 6th, 2008, 09:41 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default Runtime problems

So sorry, I don't know anymore to tell you. I HAVE had that problem and got
it to go away by completely rebuilding the form. I hope you don't have to go
that far. By the way, your form is editable, right? You have the arrow and
asterisk at the bottom?

"Daniel Pineault" wrote:

I understand that in some case there will be no records to display and thus
the subform will not display just be blank, but even when a goto a record
which I know has records, the subform remain blank.

I reviewed http://allenbrowne.com/casu-20.html but as far as I can tell none
of these conditions explain the current behavior.
--
Daniel Pineault



"Golfinray" wrote:

I know Allen Browne has a good resource at www.allenbrowne.com on why forms
disappear. You might try there first.

"Daniel Pineault" wrote:

To me, it really seems like a permissions issue, but I just can see the
problem. The form & underlying table, my group admins has full rights?

Let start over (make sure I'm not missing something), assuming I want to be
able to open a form and edit/input data what would the required perms. be?
--
Daniel Pineault




"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

  #9  
Old May 6th, 2008, 10:13 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Runtime problems

It is sad to say, but I am at the point of having to redo my form and it is a
complicated one! I already did a fast test and it works, if I start
recreating it, so my problem has something to do with impoting the form
object(s) from the other db.
--
Daniel Pineault




"Golfinray" wrote:

So sorry, I don't know anymore to tell you. I HAVE had that problem and got
it to go away by completely rebuilding the form. I hope you don't have to go
that far. By the way, your form is editable, right? You have the arrow and
asterisk at the bottom?

"Daniel Pineault" wrote:

I understand that in some case there will be no records to display and thus
the subform will not display just be blank, but even when a goto a record
which I know has records, the subform remain blank.

I reviewed http://allenbrowne.com/casu-20.html but as far as I can tell none
of these conditions explain the current behavior.
--
Daniel Pineault



"Golfinray" wrote:

I know Allen Browne has a good resource at www.allenbrowne.com on why forms
disappear. You might try there first.

"Daniel Pineault" wrote:

To me, it really seems like a permissions issue, but I just can see the
problem. The form & underlying table, my group admins has full rights?

Let start over (make sure I'm not missing something), assuming I want to be
able to open a form and edit/input data what would the required perms. be?
--
Daniel Pineault




"Daniel Pineault" wrote:

I have a form with a tab contorl on which it has numerous pages with numerous
subforms.

For some reason, hopefullty someone can explain to me, on one particular
page the subform appear for me fine (in normal mdb w/ full access). When I
run the db with the /Runtime command line switch, it still works fine.
However, when I place it on the network and run it using runtime the form
disappears? The area appears as a white rectangle with no controls,
scrollbars,....

Why? What am I missing?
--
Daniel Pineault

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.