Re: SubForm in Datasheet View

From: w_a_n_n_a_l_l_ -@xxxxxxxxxxxxxxxxxxxxxxxxxx
Date: Thu, 08 Jun 2006 02:08:50 GMT

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.
.

References:
- SubForm in Datasheet View
  - From: s_wadhwa

Prev by Date: Manipulating external images
Next by Date: Re: Suggestion for default value property setting on page 2 of tab control
Previous by thread: SubForm in Datasheet View
Next by thread: "Bucket Of Hours"?
Index(es):
- Date
- Thread

Relevant Pages

Re: Detail Form Scroll After Insert Record
... continuous form. ... the form has enough height to display completely around 5 lines ... > Is it possible that your subform is set to SingleForm ... >> Dim rs As DAO.Recordset ...
(microsoft.public.access.formscoding)
Re: Use of Option Buttons
... using the subform datasheet for the moment, it would show all the sources ... If you could use a query that pulls the names of the sources into a separate ... If you had a list of all possible sources on the subform, ... I want to display on the main form 'buttons' indicating which of the ...
(microsoft.public.access.formscoding)
Re: purpose of subform?
... display in column format in the subform in form view, ... I'd change the Default View property of the subform from Datasheet to ... Query in design view and change the order of the columns. ...
(microsoft.public.access.forms)
Re: Visible Property
... continuous form or datasheet. ... You may be able to use conditional formatting to alter the background or ... > I have a form with a subform. ...
(microsoft.public.access.forms)
Re: Subforms in 2003
... I do not want a continuous form but a datasheet view. ... I have a subform in a mainform and want to hide the field names in the ... field names so I have control of the font, eg. make them bold etc. ...
(microsoft.public.access.forms)