473,320 Members | 1,829 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

subDatasheet setup on query behind form not being remembered


I'm trying to get a subdataSheet embedded on a form which will be displayed
in datasheet view.

I setup the 'record source' for the form to a query on a table. I go into
the query properties and setup a subdatasheet. I test this and it works. I
close the query builder - get prompted to save - reply yes. I reopen the
'record source' and the subdatasheet setting are gone.

Any ideas?

I using Acess 2k with sp/3...........

Thanks.
Nov 13 '05 #1
1 1890

"astro" <as*********@mn.rr.com> wrote in message
news:B1*****************@twister.rdc-kc.rr.com...
.... I setup the 'record source' for the form to a query on a table. I go into
the query properties and setup a subdatasheet. I test this and it works.
I
close the query builder - get prompted to save - reply yes. I reopen the
'record source' and the subdatasheet setting are gone.


I've found this happens occassionaly. Sometimes Access just gets grumpy and
stops saving changes. Sometimes closing all objects except the one you're
working on, expliciting saving, then exiting Access are restarting the
application is the only thing that works.

I've also found trouble saving with spotty network connections - not bad
enough to drop the connection or corrupt the database. Making the fixes
locally, then copying back to the network share is the only solution I've
found for that.

hth

Tim Mills-Groninger
Nov 13 '05 #2

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

Similar topics

2
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...
2
by: James | last post by:
Hi I have set up a subform in datasheet mode containing a second subform also in datasheet mode in order to be able to open it as a subdatasheet. In my application I make the first subform...
1
by: Per | last post by:
Hi, I have a problem that I can't figure out. I have a database application to keep track of boxes that contain files. For data entry, I have a form with a main form section for the box-specific...
8
by: ray | last post by:
I am at the moment manually setting Subdatasheet to in all the tables in this adp. If anybody can put me out of my misery by suggesting some automated way to do it, I would be most grateful. I...
0
by: burningthemidniteoil | last post by:
I have access 2002. I have a query that diplays a subdatasheet ( +/- subtrees are shown on the record), but when i make a datasheet form out of that query , it does not display the plus (+) and...
3
ebs57
by: ebs57 | last post by:
I'm currently not talking to my preinstalled version of Access 2003 mostly due to an argument I keep having with it regarding subdatasheets. Also because it has been drinking a lot lately. I...
4
by: MikeSA | last post by:
Hi All I have a Orders query and a Order Details query both derived from their respective tables, of which the Order Details query then eventually becomes a sub-form of the Form Orders. Standard...
0
by: Kassimu | last post by:
Hi all, I have a table which has a subdatasheet. I need to create the query that will have additional field(s) for each record in sub datasheet. How can I create such a query? To bring in the...
0
by: Papote | last post by:
I have a Food Menu ordering database. There is a daily menu and in that menu one can order any amount of food in that particular menu. I have these two tables where I want to create a form to enter...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.