473,324 Members | 2,531 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,324 software developers and data experts.

SubForm in Datasheet View

Hi,

I have a main form "frmBldgFloor" and SubForm within the main form
"fsubBldgFloor".
In the SubForm the values in the text fields are being populated from a
recordsource.
I have these values being populated in Form Detail Section.
Also I have Form Footer where I have text boxes showing Sum of those
recordsource values.

When I set the Default View of subform to Continuous it shows the Sum
of recordsource values but when I change the Default view to Datasheet
it doesnot show the Sum of recordsources in the textboxes which are
there in the design time.

Please can anyone suggest how to solve this problem of subforms.
Thanks, any suggestions are welcome,
Shalini

Jun 7 '06 #1
1 3045
A datasheet view is not just a different looking kind of continuous form.
You can't display lots of things on a datasheet. For good or ill, it looks
exactly and to some degree acts like a spresheet. You can size columns, you
can size rows, you can re-order the columns. You can't display a footer.

You'll have to live with continous form in your subform or do without the
sum() in the footer.

That said, there are other ways to get stuff like that. If you can
construct the SQL you use for the subform and make it available in code, you
can put a textbox back up on the main form and possibly write a DLookup
statement on the fly to populate the textbox with sum from the same records
you're displaying in your subform.
Jun 8 '06 #2

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

Similar topics

2
by: ivan | last post by:
I have a form (CustomerImfo) that has a subform within it (order). Within that subform is another subform (OrderDetail). That subform (OrderDetail) is displayed in Datasheet view. When I am...
1
by: edself | last post by:
I have created a form with a subform that displays the results of a query in datasheet view. I'd like to be able to expand subdatasheets for each record listed in the subform datasheet. The...
4
by: MacDermott | last post by:
I have an Access 2000 form with a subform in Datasheet view. When I click on an item in the header of the subform (the title at the top of one of the columns), I'd like to be able to capture the...
4
by: wayne dooley | last post by:
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to many relationship. I created a form to show fields from CUST and a subform to show those in SUBS. The 2 tables are related...
1
by: Matthew Wells | last post by:
I have a a parent form with a subform. The parent form has two command buttons to change the subform view to single form view and datasheet view respectively. I can't seem to get this to work. ...
2
by: Smartin | last post by:
Using Access 97 I am trying to create a form that allows for user entry of search terms and displays a table of results. I thought I could accomplish this using a subform but it isn't quite...
7
by: Ken Mylar | last post by:
First a quick background on the form: I have a form that is normally viewed in Single form mode. It has a subform on it that is in datasheet view. The main form is for work orders and the...
1
by: runner7 | last post by:
Can anyone tell me if there is any way to change the default subform view from datasheet to only show a single record at a time? Can this be restricted in an application so that the user could...
4
by: Don Do | last post by:
Help I built a form/subform/subsubform setup using the access forms wizard. I have a table1 = parent, table2 = child, table3 = (grandchild?). There will be multiple records in table2 that tie...
4
by: Orv | last post by:
I have a search form which contains a non-linked subform. When I fill the criteria of my search and click the search button it returns the results in the subform, datasheet view. I then want to...
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...
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.