473,322 Members | 1,755 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,322 software developers and data experts.

Hide calculated fields in continuous forms A2K

I have a form of club members with a continuous subform on it showing boat
details.
I hold the boat length and beam (in meters) in a table. On the subform I
also calculate and show the imperial equivalent length and beam. You can
enter lengths in either the metric box when an AfterUpdate event shows the
imperial eqivalent, or converseley you can enter the lenght in feet and
inches in the imperial box and on AfterUpdate the metric equivalent is
displayed and stored in the corresponding metric box.
The appropriate imperial measurements are calculated OnCurrent of the
Subform

The problem is that the the same calculated fields are displayed on every
record on the subform + the blank new record corresponding to the current
record. Is there any way of hiding and locking the Imperial calculated
fields on all but the current record. Its a sort of conditional formating on
the current record.

TIA

Phil
Nov 12 '05 #1
2 1972
I think I've had similar problems to you and couldn't find a way round it.
Sorry.

Anyway, what are they waiting for, the Spanish Armada to come floating up
the channel again? Tell them to work in metric and save you the grief.
(pssstt, it's 2004)

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:40***********************@mercury.nildram.net ...
I have a form of club members with a continuous subform on it showing boat
details.
I hold the boat length and beam (in meters) in a table. On the subform I
also calculate and show the imperial equivalent length and beam. You can
enter lengths in either the metric box when an AfterUpdate event shows the
imperial eqivalent, or converseley you can enter the lenght in feet and
inches in the imperial box and on AfterUpdate the metric equivalent is
displayed and stored in the corresponding metric box.
The appropriate imperial measurements are calculated OnCurrent of the
Subform

The problem is that the the same calculated fields are displayed on every
record on the subform + the blank new record corresponding to the current
record. Is there any way of hiding and locking the Imperial calculated
fields on all but the current record. Its a sort of conditional formating on the current record.

TIA

Phil

Nov 12 '05 #2
Some of our members sailed with the armada, and still use roods, poles
perches and fathoms.

Tradition!!!!!!!!!

Phil
"Mike MacSween" <mi***********************@btinternet.com> wrote in message
news:40***********************@news.aaisp.net.uk.. .
I think I've had similar problems to you and couldn't find a way round it.
Sorry.

Anyway, what are they waiting for, the Spanish Armada to come floating up
the channel again? Tell them to work in metric and save you the grief.
(pssstt, it's 2004)

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:40***********************@mercury.nildram.net ...
I have a form of club members with a continuous subform on it showing boat details.
I hold the boat length and beam (in meters) in a table. On the subform I
also calculate and show the imperial equivalent length and beam. You can
enter lengths in either the metric box when an AfterUpdate event shows the imperial eqivalent, or converseley you can enter the lenght in feet and
inches in the imperial box and on AfterUpdate the metric equivalent is
displayed and stored in the corresponding metric box.
The appropriate imperial measurements are calculated OnCurrent of the
Subform

The problem is that the the same calculated fields are displayed on every record on the subform + the blank new record corresponding to the current record. Is there any way of hiding and locking the Imperial calculated
fields on all but the current record. Its a sort of conditional
formating on
the current record.

TIA

Phil


Nov 12 '05 #3

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

Similar topics

1
by: SJH | last post by:
I have been given an older database and asked to make upgrades and what not. One interesting thing I have come across with the database is that it was at one time set up so one of the tables would...
14
by: Allen Browne | last post by:
Subform is based on a single-table query that contains a calculated field: Amount: Round(CCur(Nz(*,0)),2) Continuous subform displays this field in a text box named Amount. As user enters new...
2
by: Phil Stanton | last post by:
I have a form of club members with a continuous subform on it showing boat details. I hold the boat length and beam (in meters) in a table. On the subform I also calculate and show the imperial...
2
by: Cro | last post by:
Dear Access Developers, I am developing a form with 'default view' set to "continuous forms". I am suffering with a problem I can't yet see a solution too. Each record has many fields. Two...
1
by: tconway | last post by:
I have an Access program that displays Customer data into a form and OrderID data into a subform. The totals in the Subform are based on calculated fields, i.e. the Total Amount field Calculates...
3
by: S P Arif Sahari Wibowo | last post by:
Hi! I would like to make an editable continous form, where most fields will be from table A and editable, except 1-3 fields are a glimpse into table B and uneditable. Table A relate to table B...
2
by: Shawn Yates | last post by:
I have a form with two subforms on it which are both continous forms. The subform on the left shows the tasks that the employee was assigned to accomplish (each as a seperate record) while the one...
5
by: Henrik | last post by:
The problem is (using MS Access 2003) I am unable to retrieve long strings (255 chars) from calculated fields through a recordset. The data takes the trip in three phases: 1. A custom public...
3
by: OzNet | last post by:
Hi I have a main form and want to put two subforms on a tabbed control (on the same tab) Subform 1 will display data if it corresponds with the data on the main form. When this is true, subform...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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...

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.