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

How To Link Subforms To Other Subforms On An Unbound Form

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

Continuous Forms With Subforms?

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

Tabbing In Forms/ Continuous Subforms

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

Subforms Showing Continuous Forms

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

Unbound Continuous Forms

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

Continuous Form With Unbound Check Box?

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

Continuous Subform Unbound Control Problem

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

Populate Unbound Fields On A Continuous Form

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

Forms :: Sum Unbound Field In Continuous Form?

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

Forms :: How To Populate Unbound Continuous Form

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

Forms :: Hide Number Fields Of Specific Record On Continuous Subforms

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

Forms :: Continuous Subform - Unbound Check Box For Each Record

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

Forms :: No Focus For Unbound TextBox In Continuous Form

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

Unbound Text Field In Continuous Form: Update One Record, They All Get The Same Value

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

Modules & VBA :: Change Formatting Of Unbound Text Field On Continuous Form

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

Tab Control With Subforms / "Can't Build A Link Between Unbound Forms" Error

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

A Continuous Form And Continuous Subform, Possible?

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

How To Make Unbound Field Auto-populate Conditionally From Another Unbound Field

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

Forms :: Unbound Text Box Calculation Using Two Other Unbound Text Boxes

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

Subforms

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

SubForms

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

Subforms

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

Subforms

Aug 12, 2005

is it possible to have more then 2 subforms?

Lynda

View 1 Replies View Related

Many-To-Many And Subforms

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

Subforms?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved