473,890 Members | 1,164 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

subdatasheet and "You can't carry out this action at this time"

Hi.

I'm having terrible trouble with a form that displays several
parent/child relationships at one time. It is a sales force hierarchy
- Sales force, district, territory, sales rep are the tables linked in
parent/child relationships.

I'm using a form to choose the main-parent and then several subforms
in datasheet view.

Sales force (20 records)
|==>District(su bform) (<15 records for each parent)
|==>Territory(s ubform) (< 50 records for each parent)
|==>Sales Rep(subform) (<100 records for each parent)

Because all the subforms are in datasheet view, I have the (+) expand
and (-) collapse buttons at the left of each record. If I expand
several of the children (at any level) and start navigating through
the Sales Force, then the district subform still has any expanded
child records still expanded (territories).

If I continue to navigate through the sales forces with any
Territories expanded, I eventually get an error "You can't carry out
this action at this time". This disables any functions from working
and I have to kill MS Access to get out of it.

I've searched for "You can't carry out this action at this time" but
have not found anything promising.

What I am looking into is how to call the Subdatasheet => collapse all
from the format menu when in Datasheet view. I can't seem to find
that either. It's not available from the runcommand and what you
would think the "DoCmd.DoMenuIt em acFormBar, 4, 9, 1" doesn't work
either. The 4,9,1 are the values from counting down on the format
menu (format = 4, Subdatasheet = 9, and Collapse all = 1)

Thanks in advance for any help.
Paul
Nov 12 '05 #1
2 3012
Hi Paul,

You must be using Access 2003, because I am not familiar with some of the
things that you're describing here...

I'm also assuming that hopefully each of these subforms are independant (one
main form with 3 independant subform controls) and that each subform is
based on it's own table, correct?

Based on what I think you are saying when you say "<100 records for each
parent"...
Is the LinkMaster property for all subforms solely dependant on the
SalesForceID field on the main form?
If so, I think that may be causing you some grief.

IMHO, you need to have "cascading" subform dependencies in place.
In order to explain, let me "rename" your forms (and likely your tables
also) in the interest of clarity.

Main form: "frmSalesFo rce" based on tblSalesForce
Subforms:
"sbfDistric t" based on "tblDistric t"
"sbfTerrito ry" based on "tblTerrito ry"
"sbfSalesRe p" based on "tblSalesRe p"

1.) Create 2 new unbound textboxes on the main form.
2.) Name them "txtDistric tID" and "txtTerritoryID "
3.) Use "=Me![sbfDistrict].Form![DistrictID]" and
"=Me![sbfTerritory].Form![TerritoryID]" , respectively, as the Control
Source for these text-boxes.
4.) I'd leave the .Visible property for both textboxes as "True" for now,
but they can be set "False" later, if you like.
5.) Now set the Link Master / Link Child thusly:
sbfDistrict: SalesForceID / SalesForceID
sbfTerritory: txtDistrictID / DistrictID
sbfSalesRep: txtTerritoryID / TerritoryID

Now navigating thru mainform records (or subform records in the first 2
subforms for that matter) will cause cascading refreshes of the related
records in the dependant subforms.
--
HTH,
Don
=============== ==============
Use My*****@Telus.N et for e-mail
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.

Do Until SinksIn = True
File/Save, <slam fingers in desk drawer>
Loop

=============== =============== ==
"Paul Malcomson" <pm**********@h otmail.com> wrote in message
news:23******** *************** ***@posting.goo gle.com...
Hi.

I'm having terrible trouble with a form that displays several
parent/child relationships at one time. It is a sales force hierarchy
- Sales force, district, territory, sales rep are the tables linked in
parent/child relationships.

I'm using a form to choose the main-parent and then several subforms
in datasheet view.

Sales force (20 records)
|==>District(su bform) (<15 records for each parent)
|==>Territory(s ubform) (< 50 records for each parent)
|==>Sales Rep(subform) (<100 records for each parent)

Because all the subforms are in datasheet view, I have the (+) expand
and (-) collapse buttons at the left of each record. If I expand
several of the children (at any level) and start navigating through
the Sales Force, then the district subform still has any expanded
child records still expanded (territories).

If I continue to navigate through the sales forces with any
Territories expanded, I eventually get an error "You can't carry out
this action at this time". This disables any functions from working
and I have to kill MS Access to get out of it.

I've searched for "You can't carry out this action at this time" but
have not found anything promising.

What I am looking into is how to call the Subdatasheet => collapse all
from the format menu when in Datasheet view. I can't seem to find
that either. It's not available from the runcommand and what you
would think the "DoCmd.DoMenuIt em acFormBar, 4, 9, 1" doesn't work
either. The 4,9,1 are the values from counting down on the format
menu (format = 4, Subdatasheet = 9, and Collapse all = 1)

Thanks in advance for any help.
Paul

Nov 12 '05 #2
Paul Malcomson wrote:
Hi.

I'm having terrible trouble with a form that displays several
parent/child relationships at one time. It is a sales force hierarchy
- Sales force, district, territory, sales rep are the tables linked in
parent/child relationships.

I'm using a form to choose the main-parent and then several subforms
in datasheet view.

Sales force (20 records)
|==>District(su bform) (<15 records for each parent)
|==>Territory(s ubform) (< 50 records for each parent)
|==>Sales Rep(subform) (<100 records for each parent)

Because all the subforms are in datasheet view, I have the (+) expand
and (-) collapse buttons at the left of each record. If I expand
several of the children (at any level) and start navigating through
the Sales Force, then the district subform still has any expanded
child records still expanded (territories).

If I continue to navigate through the sales forces with any
Territories expanded, I eventually get an error "You can't carry out
this action at this time". This disables any functions from working
and I have to kill MS Access to get out of it.

I've searched for "You can't carry out this action at this time" but
have not found anything promising.

What I am looking into is how to call the Subdatasheet => collapse all
from the format menu when in Datasheet view. I can't seem to find
that either. It's not available from the runcommand and what you
would think the "DoCmd.DoMenuIt em acFormBar, 4, 9, 1" doesn't work
either. The 4,9,1 are the values from counting down on the format
menu (format = 4, Subdatasheet = 9, and Collapse all = 1)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Found the RunCommand parameter:

docmd.RunComman d acCmdSubdatashe etCollapseAll

and, if you want:
acCmdSubdatashe etExpandAll
acCmdSubdatashe etRemove

The focus has to be on the top level of the expanded sub-Data-Sheets.
IOW, if you have this:

1 line 1
2 sub of line 1
3 sub of line 2

The focus has to be on line 1.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIRAH4echKq OuFEgEQI7WQCgj4 PpUCrwe8r7Rdova kabIQ0mkLMAn3JO
WR6kewvYxq5ZzFG nwqzdyMAh
=2CoU
-----END PGP SIGNATURE-----

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4365
by: Zhidian Du | last post by:
I am using java to write to url, http://fatigo.bioinfo.cnio.es/ , but I found the form is : <form method="post" action="/" enctype="multipart/form-data" name="fatigo"> I have no idea why the action is not a URL, can you explain it why. Thanks.
2
1453
by: Don | last post by:
Can someone tell me what I'm doing wrong here. I can't believe I'm having this kind of problem. Think maybe I've been working on this for too long, and everything is starting to look the same. I'm trying to use JS on a client-side page to prefill "action" of a <form> tag. Here's what I'm using: document.forms.action.value = "http://..." Can someone please give me a hand with this.
1
2020
by: tnhoe | last post by:
Hi, <Form method='post' action="next.htm?btn="+"this.myform.myobj.value"> What is the correct syntax for above ? Regards Hoe
2
4683
by: kma | last post by:
I am designing an Access 2000 database on a computer running Windows 98. I have one form with several tabs; all of which have sub forms, some with a subform on a subform. For example, on my main Job form I have a tab for PO's to keep track of all purchase orders pertaining to a specific job. The first subform is for the PO numbers related to the jobs on the main form and the next subform is for all of the PO lines for each PO. ...
0
356
by: Paul Malcomson | last post by:
Hi. I'm having terrible trouble with a form that displays several parent/child relationships at one time. It is a sales force hierarchy - Sales force, district, territory, sales rep are the tables linked in parent/child relationships. I'm using a form to choose the main-parent and then several subforms in datasheet view.
1
6846
by: RC | last post by:
If I want to explicitly save the record before executing a Close action. Which of the following should I use? Or does it depend on whether it is based on a Form or something else? If Me.Dirty Then RunCommand acCmdSaveRecord End If DoCmd.Close or
7
1908
by: Petr Jakes | last post by:
I would like to do "some action" once a minute. My code (below) works, I just wonder if there is some more pythonic approach or some "trick" how to do it differently. minutes=time.localtime() while 1: min, sec = time.localtime() if sec==0 and minutes!=min: # first occur of sec==0 only!! polling 10x a second minutes=min
9
2333
by: Alexandra | last post by:
Not sure why none of these permutations are working. I appreciate a second set of eyes! .... <form id="form1" name="form1" > .... <input name="Submit1" type="submit" tabindex="10" onClick="parent.mainFrame.location.href='SelectSystem.html';" value="Done" />
0
9820
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10812
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10462
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
8016
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7169
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5848
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6041
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4676
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3276
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.