Unbound Continuous Subforms
Feb 24, 2005
how do you make them?
i've just started going through all of my forms and making them unbound, as the people i'm creating this program for are far too stupid to create good data with bound forms. a few of my forms, however, contain continuous subforms. how do i get the records to show up for them? it's actually about three levels deep, but i'm sure i can figure out how to take care of that once i hear the concept (customer form > job form > job details [continuous subform]).
thanks guys
added after i saw there's another post on this subject: sorry about the double post on the subject. i looked at the other post on this, though, and was not convinced on how to do it. i understand they're a pain in the buttocks, but these people are REALLY stupid. on second thought, is there any way to have a BOUND continuous subform from an UNBOUND form? for instance, when the user selects the record and it is brought up in the form, the bound continuous form pulls up the records based on the ID's and whatnot? will this work? thanks
View Replies
ADVERTISEMENT
Feb 4, 2006
I forum could someone tell me:
I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.
When I try to link them it says you cannot link items on an unbound form.
regards in advance
Peter:eek:
View 1 Replies
View Related
Feb 8, 2005
Okay. I am trying to build a form where I could get information like this but also editable. It can be either bound or unbound with enough information to update the records. I could do this several other ways but would prefer it just like it is below. Any ideas is greatly appreciated. Sam.
REPORT_NAME_1
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
REPORT_NAME_2
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
REPORT_NAME_3
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
View 1 Replies
View Related
Feb 22, 2006
I have searched this site and tried several things over the last 3 days and am getting frustrated. All of my forms are built from existing tables.
I have a main form (frmevent) with the primary key being EventID. I have many "continuous" subforms e.g. event type, initial action taken, initial outcome that the user can enter more then one record.
My Event Type continuous subform has a cascading combo box. One combo box displays the Event Category and the other combo box displays the Event Types. I have the cascading combo working so that when the category is selected on those types that apply to it show up.
If the user tabs to the next record and doesn't enter anything in it I want it to tab to the next sub form.
I tried (please note that EventInitialActionTaken is the first field in the form)
Private Sub EventInitialActionTaken_LostFocus()
If IsNull(Me.EventInitialActionTaken) Then
Me.Parent.[frmeventFsubform].SetFocus
End If
End Sub
I am getting a run-time error on the form '2452' The expression you entered has an invalid reference to the Parent property.
What does this mean and can anyone help.
Thank you in advance.
View 1 Replies
View Related
May 24, 2006
Greetings all,
I have a question regarding subforms that are set to show continuous forms and how they can relate to each other. I have attached a jpg of what i'm trying to do, you may want to open it so you can follow along with what I will now explain.
I have 3 subforms on a main form. The subform on the left shows high level info. A user would find the record they want in the subform on the left, double click, and that would in turn populate the two subforms to the right.
My question is how do I reference the name field in the record selected in the left subform , for criteria purposes in the queries for the right hand subforms? I thought maybe using the bookmark property but that hasn't worked.
Any help would be greatly appreciated.
TIA,
Tim
View 3 Replies
View Related
Jun 15, 2006
From another forum, I found a way to kind of sort of use an unbound continuous form.
Create the form with no recordsource.
But create the textboxes with a recordsource of the field name where the data is going to come from.
in Form_Load you open a recordset, then set me.form.recordset = rs.
The form is not actually bound to the table or query, but to a copy of the records in the recordset. It is read-only.
To get around it being read-only I want the user to click on the field they want to change. This opens up a editable text box where they can change the text. I then do an update sql to update the source table.
But the recordset still shows the old value. So I have tried to do a me.form.requery. The first time it appears to work. The form has the updated value, but more often than not, all the records after the first seem to be dead, the click event does nothing.
If I had edited the first record, more often than not, all the fields in all the records will say "#Name?"
Any ideas what is happening?
Thanks,
David
View 9 Replies
View Related
Jul 7, 2005
hi guys, i have a continuous form with a check box and a button on each record's row.
now if i dont bind the check box to a control source when you tick it, it gets ticked for each record, i am using the tick box to pass a state to the button ( uses an if statement ) so that it will done different things if it is ticked when the button is pressed.
can anyone help me to get this to work without having to bind the check box to a control source?
best regards
View 3 Replies
View Related
Feb 21, 2006
Hello,
Please see the attached images (screen shots from my db).
I'll start by explaining the function of this form. Invoices are raised through a different area of the system - they then appear in the outstanding invoice list in my payment processing screen while awaiting payment. When a payment is received the user creates a payment using the controls at the top of the form. When created - payments will appear in a list box at the bottom of the screen. I then want the user to be able to highlight a payment from the list and type the amount to allocate against each line in the outstanding invoices subform. Then (once happy with the allocation) press the "Allocate" button which will cycle through the allocations the user has made inserting rows into my Transaction table - allocating the payment against multiple invoices.
The fields displayed in the outstanding invoices subform are selected in a query which calculates the amount still outstanding. In trying to illustrate my aim I've added an unbound text box to the subform (the column Allocate). What I'd like to be able to do is type a different amount against each outstanding invoice. I understand this is not the way that unbound controls work in continuous forms - i.e. that they are multiple instances of the same control hence when I type 100 against the first item in the list it appears against every item in the list. I can't use a bound control because the query is not updateable - and in any case, the entry won’t exist in the transaction table until it has been inserted anyway.
I'm pretty competent with Access and VBA but haven't really explored recordsets - I'm usually able to achieve what I want by binding my forms to stored queries. This, however, is a bit more of a complex problem than I'm used to dealing with.
So, to the point then. I guess my first question is - is it possible to achieve this? I'm sure it must be. If so please can someone try to shed some light?
Secondly, I have an idea but have absolutely no idea of how to implement it. I seems to me what I would need to do is build a temporary recordset for the form and add a field to it i.e. the "Allocate" field I've been talking about. The user would then be able to manipulate this recordset because the form wouldn't be directly accessing a query. Nor would there be any unbound controls on the form. Once the user had typed in all of the allocation figures they are happy with they would be stored in my temp recordset. They could then hit the "Allocate" button which would cycle through the recordset inserting rows into my Transaction table (as long as various validation rules were passed).
Does this sound possible? If so can anyone give me any help or point me in the direction of any material they know of that might be of any help?
Thanks in advance for your help.
To give a flavour of how I originally built this form I've attached another image - PaymentProcessingOld.gif. It's a similar kind of setup. Payments are created at the top of the screen and appear in the list box bottom left. The outstanding invoice subform serves only as a point of reference. The user actually allocates payments by selecting the item from a combo box and typing the amount. This builds the transaction I've talked about above. It's quite straight forward when there are only a few payments and allocations, but in practice payments are usually large and split across up to 100 different invoice lines. That makes it a very tedious task.
View 1 Replies
View Related
Oct 5, 2004
Can I populate unbound fields on a continious form, if it is possible would you give me some code to look at or direct me to an article
Phil
View 2 Replies
View Related
Dec 17, 2014
I have a continuous form with a number of unbound fields and bound fields. However, I would like to sum an unbound fields (Text28). Text28 is an unbound calculated field based on another calculated unbound field (Text22). I would like to sum Text28 in the footer or somewhere in the form.
Here are the codes for my field:
Code:
Text28 = iff([Text22>0], [Text22], [Text20] --- This works
Text29 =sum(iff([Text22>0], [Text22], [Text20]) --- this is not working
and it did not work.
View 3 Replies
View Related
Dec 19, 2014
I found a few regarding continuous form data but its not the sample that fits.
Attached here is my screen shot and my accdb file (MSAccess 2013)
How do they populate unbound continuous form from msaccess connecting to mysql server.
It should display 5 data but in my case it does show only one data.
View 8 Replies
View Related
Mar 8, 2014
I have a continuous subform recording the information of various wireless products for an employee embedded in an employee main form. Please see screen shot enclosed.
There is a check box "BYOD/Personal" on the subform. I want to hide a number fields when this check box on independent record is checked. However, if I use the following codes, the changes apply to all records under that employee.
Private Sub BYOD/Personal_AfterUpdate()
If BYOD/Personal.Value = True then
Me.Provider.Enabled = False
Me.XXX.Enabled = False....etc.
Else
Me.Provider.Enabled = True
Me.XXX.Enabled = True....etc.
End If
End Sub
How can I just disable those fields on the subform of a specific record when the BYOD/Personal field for that record is checked?
View 8 Replies
View Related
Nov 18, 2013
Working with Access 2000
I have a Continuous subform based on a query based on few linked tables.One of those tables has a Yes/No field which shows in the subform.
I want to be able to change the status of this field for each record independently, so I placed an unbound check box in the subform Detail section and a Command button on the subform Header section. However when I click one record check box, all of them change, I did not expect that. How do I move forward to get this done?
View 10 Replies
View Related
Oct 27, 2014
I have unbound TextBox in continuous form and I would like that it never get focus. In property I specified Enabled=No and Locked=Yes. But it doesn't work.
View 8 Replies
View Related
Feb 20, 2006
Hi,
I want to show some text from another table based on the values of the bound fields in each record of a continuous form. I thought it would be easy, but I can't get it to work.
I step through the records in the bound recordset and use some of the values to query another table. Then I use the value from the query to populate the unbound text field.
It works fine for each record. But every time the unbound field is updated, all the records in the continuous form are updated.
I'm stuck on this one. It's probably something simple to fix - if you know what to do!
Do you have any suggestions?
Thanks!
-Daniel
View 10 Replies
View Related
Apr 16, 2015
I have a continuous form with a text field that says "Select". There are two other fields, one of which is Brand. When the Brand Combo box has nothing in it I want the text box to appear (instructing the user to select a Brand) But once the user selects a Brand and goes to the next records, I would like the "Select" in only that record to become not visible. I tried conditional formatting but can't apply that to an unbound control ( or at least it is grayed out when I select the text box) and any other possible solutions I have found changes all of the selects - not only the one in the changed record.
View 7 Replies
View Related
Jan 23, 2007
I am trying to create a database for a cub scout pack that just keeps scouts information, medical info, parents info, and parents medical info each is a seperate table. I have created a Tab controlled form with 4 tabs. On each tab the ONLY thing I have is a subform that contains the appropriate information. Each table has it's own form with the table as it's record source. I link the scouts table to the medical table by SID which is a primary key in the Scouts table. I link the Scouts table to the Parents table with a PID which is the Primary Key in my Parents table, and I link the Parents with the ParentsMed with a PMedID, key in the ParentsMed table.
Question #1 - Using a Tab Control you can only have 1 record source. What should I use? I have tried the tblScouts and I have also created a query with every field from every table.
#2 - When I try to use the parent and child links on the subform I get the error "Can't build a link between unbound forms" but each form is bound to the table and the record source on the tab control has had a table and my qryEverything, neither work. I can type in SID but it still doesn't function properly.
Any suggestions or comments on a better relationship method or any insight on how tab controls are supposed to be setup or anything would be greatly appreciated.
Thanks a lot
Rick
View 4 Replies
View Related
Aug 9, 2005
What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.
when I put the subform within a subform, access comes up with the following message:
************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.
You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************
which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.
does anyone know of a way around this?
what about Access2003 does it allow this?
help much appreciated.
Steve Ferry
View 8 Replies
View Related
Jan 30, 2015
To make it simple, I have a list of contact names and their email. I want to have a form with no control source and have 2 simple drop down boxes for their Name and their Email. What I would like to happen is the user choose a name from the drop down in field 1 and then the field below auto-populate their email in field 2. I understand I can use conditional IF/THEN and list out each email, but the contact list is ever changing, so I want to first drop down to link to the TblContacts, have the user pick the name from the list and then have the 2nd field autopopulate from that same TblContacts with their email respective to the Name entered in field 1. My form has two field [Traveler] and [Email]...The tblContacts two fields are [Name] and [Email]
Code:
DLookup("[Email]", "tblContact", "[Name] = [frmEmail]![Traveler]")
View 5 Replies
View Related
Jul 25, 2013
I am running in to a brick wall with this. I have an unbound text box with the control source set to =IIF([text42]=0,0,[text42]/[text44])*100 and in continues to return a #name? error.
I am not sure how to get this expression to work. I have even tried to put =[text42]/[text44] and I still get the #name? error.
View 3 Replies
View Related
Jun 28, 2007
I have a form with 5 subforms in it.
I am using recordsets to step through a table that contains a field with the names of the subforms.
Depending on the code, I want to make visible or hide the subform for that particular record.
ie Table has 5 records with a field called subForm. the values are as follows:
Record1: Field1: Value="Yes" Field2: Value="subForm1"
Record2: Field1: Value="Yes" Field2: Value="subForm2"
Record3: Field1: Value="Yes" Field2: Value="subForm3"
Record4: Field1: Value="No" Field2: Value="subForm4"
Record5: Field1: Value="Yes" Field2: Value="subForm5"
When I step through the table if the code finds "No" in Field1 then id makes the subform referred to in Field2 invisible and if it finds a "Yes" it makes it visible.
Can anyone help me with this?
View 2 Replies
View Related
Dec 13, 2005
Does anyone know how to have a datasheet view in a subform fill the top of the main form?
I want to be able to see the records in a datasheet view and when the record in the datasheet view is selected it prefills the top of a form ?
View 1 Replies
View Related
Feb 18, 2005
This is a question from yesterday that a member had helped me out with.
I have additional questions while I am waiting for response from him. If anyone of you can help, I would really appreciate it.
1. How can I make a form that gathers information from multiple tables?
2. Lets say it is possible, how does this info get saved to these multiple tables when the user clicks on the next record button on the record navigator.
Thanks for the assistance!
View 2 Replies
View Related
Aug 12, 2005
is it possible to have more then 2 subforms?
Lynda
View 1 Replies
View Related
Sep 18, 2005
Heya --
So if I haven't scared everyone away with the post's title, maybe someone out there can help me. I need it.
I have a many-to-many relationship with the following tables:
Companies
CompaniesProjects
Projects
I also have a query with the following:
CompaniesProjects.CompanyId
CompaniesProjects.ProjectId
Projects.*
Pretty straightforward. Now, I have a form to view Companies, inside of which is a subform listing Projects associated with the Company using the above query.
The issue that is stumping is that I would love to be able to add a new project from the subform. I thought it would be pretty easy, but I'm totally dry. I guess I need to grab the CompanyId from the parent form, and assign it to the new record before I can add any more data to the new record. But I have no idea how to do this, or even if it is the right thing to do.
Any help would be _greatly_ appreciated. I've been slamming my head against a wall with this for two weeks.
-Lucas
View 2 Replies
View Related
Nov 29, 2005
Hi,
I have 3 tables : Products, Description and ProductDescription. Products can have more then 1 description, Descriptions can be used by more then 1 product, that is why the third tabel ProductDescription exists (normalizing..:) ). The Productdescription table has 3 fields: id, productid, descriptionid.
I want a form in which you choose a product, then you see all the descriptions along with it. In this same form I want to be able to add a description, e.g. by pushing a button NEW. After that user enters description form etc. After returning to the mainform, a new record must be automatically added to the ProductDescription table and ofcourse a new record has been added to the Description table. I thought I would use subforms to realize this but it isn't working..:( . I have tried so many things that I dont know anymore what to do, i am totally confused. I know how to program in VB and ACCESS, but for now i don't see it anymore. Can someone please help me with this?
I just need to know how to start, what to use as subform and what as masterform, which links between fields, etc
nelleh:rolleyes:
View 2 Replies
View Related