I find it useful on occasions to sort continuous subforms in date order, with the latest date on the top, and the blank new record line above the first record as per this illustration.
Basically it consists of a standard continuous form, but with an identically formatted subform in the header just above the detail in the main form.
It all works perfectly, but it would be nice to see the record selector in the new record, and not in the continuous subform.
If I show the record selector in the subform, the alignment goes wrong.
Have you tried:
Design View
Show your property sheet > Format
Ribbon>Form Design Tools>Arrange
Here's the fiddly bit
Select some controls
At this point
Ribbon>Form Design Tools>Arrange>Table tools should become active
Select Tabular
THIS WILL MESS UP YOUR LAYOUT
while your new table is active
<Ctrl><A>
Your format tab in the property sheet should now show the gridline style, color, width, etc... I usually set these to 2pt, dots, purple because I don't tend to use these styles in forms.Typically the new cells/rows/columns that you insert will not have the gridlines set you have to fiddle with these settings.
Here's the beauty of this, you can now add rows, columns, split and merge cells etc...
Ok PhilOfWalton
I'm up WAY too late tonight - should have been in bed hours ago...
Two Screen shots showing POC for the table/layout
The Solid red-lines are the gridlines for the table, normally they would be transparent.
The parent and subform are just some forms I had to play with... for POC these should work for an example.
With a bit more tweeking I'm sure you can obtain the proper control alignments your're after.
The subform in the header also has the table/gridlines also shown in solid-red lines
Have played around with grids with no joy.
The reason is that say a record selector is 1/4" wide. The closest any control (including a subform control can be to the left hand side if the form is 1/4"
So the left most control on the subform will be 1/2" from the main form's left border. They can never be aligned
Plan B is a blank Main Form "container" and 2 subforms - SubFrmAdd set to add only which goes in the Main Forms Header, and a continuous SubFrmEdit which allows editing and deleting records.
So the problem with that is we have 2 current record indicators.
Ideally, if the top SubFrmAdd has the focus, there would be no Current Record indicator in the continuous SubFrmEdit, and conversely, if SubFrmEdit had the focus, there should be an * in the SubFrmAdd Record selector.
IIUC:
+You only want the record selector arrow to show in the subform in the header of the parent.
+You want the the records on the parent form flush aganst the left hand edge of the form
If this is correct then your parent/double-subform maybe your only option.
If you use the grid, you should be able to offset the parent records by the width of the child subform record selector; thus, aligning the fields in both forms. While I didn't get this exactly right in the POC images I posted I was hoping to show this as a possible solution.
.
+ Can you attach your database that you are using to demonstrate the desired effect?
There are 2 versions of the main forms - FrmMain & Modifications. Both self-explanatory, I think.
As a total aside is that I have TblModifications in all my FE databases, and record all design changes to the DB. My standatd Menu (Switchboard) system shows the version number, so if a client contacts me with a problem it is easy to establish if he has the latest version.
In the BE database, I hold a table called BEMods where I record any changes to the BE tables. So when the Menu loads, one of the first checks is that the BEMods table version is identical to the TableVersion in the FE.
This is particularly useful when different organisation use the same FE and each have their own BE (Yacht Club, Bridge Club etc) using identical table structures. Obviously not all the fields are relevant, to different organisations, but if I have to modify a table for one Club, and give them a new front end with the new TableVersion, and forget to do the same modification for the second club, I get an error message.
That idea put me on the right track, but the problem was that the record selectors didn't show up on the continuous form.
Ok, I didn't get the concept that you wanted the record selector to show up in the continuous form too...
Without taking a look at your revised DB... we had my God-Children along with my four for a sleep-over last night (8 kids from 3yr to 15yr) - my ears are still ringing from the cacophony :)
My thought here is in the current_record event check if on new record and if true then set the empty cell width as I have it now, set the show record selector to false for the continuous form, set the show record selector true for the subform and a bit of vba to get the other field widths to line up. May be able to pull the grid-columns up thru the header and subform. I'll have to think about that when I get more time tomorrow.
Sorry I obviously didn't make myself 100% clear on what I am trying to achieve.
Ideally, MS should have provided an option with continuous forms to have the New Record above the first record i.e., if you use the navigation buttons to go to the first record, the New record would be above it. All implementations of Access have the new record after the last record. Particularly illogical if the form is sorted in something like date order, where logically, a record with zero date (New Record) should appear before the first record with a genuine date.
Anyway what I am trying to achieve is what appears to be a completely normal continuous form, including filters, sort orders, the ability to select multiple records (for deleting or copying etc), shortcut right click menus that behave normally and the ability to paste multiple records.
I think this could be a useful addition to many developers, as it is a pain in the a.se to have to scroll down a long continuous form
Hai all,
I've two or more forms on my app.
My requirement is, Have to show the first form asa the user press a button
have to hide the first form and show the second form. If the user press the...
I would like to add some javascript to show/hide a certain row of a
table. The first row of the table contain the hyperlink that calls the
javascript the second row is the one i want to show/hide...
I'd like to have a show/hide widget on my web site, kind of like "show
details" / "hide details" in Google Groups. Is there a tutorial
explaining how to make them? Google's is a bit complex and...
Hi All:
I have a very long page of html that I want to take portions and hide
them in divs, then show when a link is clicked. I have the hide show
part working when the link is clicked, however...
I'm new to Java Script.
I'm displaying comments people have made. Below each persons' comment
I want to add 2 buttons "Reply" and "Amend". Clicking "Reply" would
display an empty text field...
Hey Guys!
Found some great scripts here on this topic but have to make to changes to the code that I can't seem to figure out.
First,
In the following code clicking on the headers shows the...
hi,
I want to show hide layers. I am able to show and hide layers but i am facing problem that, cant view the cursor in Mozilla,but i can type in input text box, its overlapping the layers.
...
I have a linked Sub Form in Access 2007.
It is designed to only show one Record. (Always 1). How do I Hide / Remove the Record Navigation bar for the subform?
Thanks
Brad
Well, I am trying to use the footer row of a GridView for insertion
purpose. There are some articles about this, for example, the
gridviewguy.com has an example, which always displays the footer...
Hello,
I am trying to create a small post forum that via a database, the asp code displays a topic, author, and date submitted. on clicking the post, the messages of the user appears.
I tried to...
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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...
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
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...
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...
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...
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...
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 ...