Continuous Forms custom view for each record
Everything I have tried so far shows or hides my control on all records and not just the ones I need them to. Is this possible and how would I acomplish this? And by the way I have looked at conditional formatting already, and it just doesn't have the ability to accomplish this in the way I need, so other suggestions are needed
Thank you for taking the time to report an issue.
What's wrong... Please write below.
It has been working fine for over a year, but yesterday when i opened it, there were no old records. It only shows the new record, and the buttons at the bottom show that there is only 1 record.
I checked the table and all the records are still there, and i can still run reports from it, but none of the form settings have been changed so i cannot figure out why all of a sudden all the records are missing.
Could be a bug with the continuous forms? Even though the arrow is on a record, it isn't really selected. Any way to select a record with VBA?
This works by dynamically populating the form with whatever questions are required from the relevant tables
The check-list actually works quite well however I can only get the form to display 1 question at a time in single form view or all questions at a time for continuous form view. I do not want to use datasheet view
So therefore is there more customisation I can do with continuous view in code to show a certain number of questions per page for example, I don't like the scroll options I want to do everything with command buttons?
How can I get the screen position of a control for the current record in a continuous form?
Private Sub Form_Close()
!tabTCN.Value = !Listing.PageIndex 'open the tab for TCN listing
How can I can close the form and setfocus on the same record I double-clicked on
From this continuous form I am also able to Send Folders around the network.
Each record for all sessions has a Status field that is a text box defaulted to "Open". This Signifies that each session is still open and receiving files.
Once the session folder has been sent to it's destination, I am after a way of toggling a button that will change the Status Field of each record for that room to "Sent".
This will tell the OP who might be processing presenters from the processing form that the session has been sent and to contact admin. It will also give the sent status for the continuous form for each record.
I have looked at all things continuous, and have not found a method to click and change all records to "Sent" for each individual Room Session. I am a bit confused about the finer workings of a continuous form, although everything is working well with what I have learn't so far.
Currently, only one record from the continuous form appears in the word template, which is the the record that has the focus.
I'm using this code
.Selection.Text = (CStr(Forms!FormName!FieldName))
NB - I have tried a split-form, but that is not acceptable for other reasons.
I have tried to set DefaultView from VB but get an error saying it must be set in form design mode. I have tried setting AllowAdditions to No, but this results in not being able to input any data into the blank record which is displayed on form opening.
Is there a way to switch display modes for this sub-form dynamically, this time with the sub-form DefaultView set to SingleForm, anduse it for the special situation of entering a new employee?