Populate Unbound Fields On A Continuous Form
Oct 5, 2004Can 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
ADVERTISEMENT
Forms :: How To Populate Unbound Continuous Form
Dec 19, 2014I 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.
Modules & VBA :: Populate Word Fields From Access Continuous Form
Jun 3, 2015I have a form that I have exported certain fields into a word doc (it is up and running just fine). I created bookmarks in word and put some VBA into my access form, so when I click on 'Create word report' it pops up and automatically populates the record I am on. Here is the tough question,
How to make this work with a continuous form? My main form has several subforms, one being a continuous form. The main form shows one bridge at a time. The sub continuous form shows information for all of the bridges spans (could be anywhere from 1 to 9).
Forms :: Unbound Combo Box Populate Fields Linked Tables
Jul 18, 2014I have form with an unbound combo box which is populated from a query
It should populate a field in a table which is related to another - however it only works when i query by id number (primary key) and not the text value i want - is it possible to query both so it returns say 1,option 1 - then when selected it will place a 1 in the table - which is related to option 1 in another table instead of just having to select '1' which will mean nothing to a user?
Continuous Form With Unbound Check Box?
Jul 7, 2005hi 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
Forms :: Sum Unbound Field In Continuous Form?
Dec 17, 2014I 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.
Forms :: No Focus For Unbound TextBox In Continuous Form
Oct 27, 2014I 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 RelatedCan You Populate A Unbound Continious Form
Feb 18, 2005Can you populate a unbound continuous form. If yes how do I do it
Phil.t
Unbound - Populate Textbox In Form
Nov 13, 2012I'm trying to populate a form textbox which is unbound.
I have table with a list of peoples login names and a query filtering these names once a user logs in. If the GetUserName() matches one of the names in the table then user is authorised. this part seems to be working fine. User not on the GetUserName() list the filter says blank ie Not Authorized.
How to take this confirmed user name and place it into a textbox on a form?
Table name: [tblUserNames] with [IngEmpID] & [UserName]
Query Name: [qryUserNames] with a Criteria GetUserName()
Unbound Text Field In Continuous Form: Update One Record, They All Get The Same Value
Feb 20, 2006Hi,
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
Modules & VBA :: Change Formatting Of Unbound Text Field On Continuous Form
Apr 16, 2015I 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 RelatedForms :: Continuous Form - Click On ID To Populate Single Form
Oct 4, 2013I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.
View 14 Replies View RelatedGeneral :: Use Unbound Controls On Form And Populate With Pure VBA Recordsets
May 16, 2013
What really is the best way, programming-wise and user experience-wise when presenting records in a form:
1) Use the form with sub-forms to show records. Add new records via a popup form and use recordsets in VBA to allow validating.
2) Use unbound controls on a form and populate with pure VBA recordsets. For data with more than one row use list boxes. A popup form used for adding new or editing etc using VBA.
3) Another I haven't thought of; new or a combination of above?
Modules & VBA :: Using Unbound Form On Front End Of Database To Populate Backend Tables
Apr 12, 2015Is there any particular reason I would choose to use
DoCmd.RunSQL "insert into...
Versus
CurrentDb.Execute "insert into.... ??
I am using an unbound form on the front end of my database to populate the backend tables (multiple tables). Some forms only have a few fields, while other forms have about 15 fields with 3-4 tables updating.
I am okay using the DoCmn.RunSQL , but I keeping reading on the forum that others chose CurrentDB.Execute and it has me thinking.
My database is stored on a network drive with only on front end.
How To Make Unbound Field Auto-populate Conditionally From Another Unbound Field
Jan 30, 2015To 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]")
Unbound Continuous Subforms
Feb 24, 2005how 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
Unbound Continuous Forms
Jun 15, 2006From 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
Sort Continuous Form By Two Fields
Jun 25, 2006Is it possible to sort a continuous form by two fields?
ie. If two records have the same value in one field, look at the second field to see which one is displayed first.
I was thinking that it might help to combine the two text boxes into one (a not visible text box) and sort it by that, but I don't know how to sort by an unbound, not visible text box either...
Any suggestions?
cheers, joe
Locking Fields For One Record On A Continuous Form
Jul 22, 2005How can i apply the following code to the immediate record in my subform. I would like when the assigned check box value = true, then the fields for that record become locked.
Ive written the following code to an onclick event for a check box labeled "assigned" on my form, the problem is it executes on all the records in my form.
Q. How do i apply the code to only the immediate record?
Private Sub Assigned_Click()
If Me.Assigned.Value = True Then
Me.Serial_Number.Enabled = False
Me.Component_Group_ID.Enabled = False
Me.TypeID.Enabled = False
Me.Description.Enabled = False
Me.Status.Enabled = False
Else
Me.Serial_Number.Enabled = True
Me.Component_Group_ID.Enabled = True
Me.TypeID.Enabled = True
Me.Description.Enabled = True
Me.Status.Enabled = True
End If
End Sub
Forms :: Sort Continuous Form By Two Fields?
Jul 6, 2013I have a form I would like to sort by:
first - by App_Flag (a yes/no field) - have all the clients with "yes" on top
second - by App_Date - from the earliest to the latest
The query sorts it fine but the form does not - even if I requery the form (added a requery button).
Can a macro or coding make it sort it the way I need it?
Modules & VBA :: Sort Continuous Form On Two Fields
Jul 20, 2015I am using the following by Allen Browne to sort one field. But now I need to sort on two fields.
Code:
Function SortForm(frm As Form, ByVal sOrderBy As String) As Boolean
On Error GoTo Err_SortForm 'Provided by Allen Browne
'Purpose: Set a form's OrderBy to the string. Reverse if already set.
'Return: True if success.
'Usage: Command button above a column in a continuous form:
' Call SortForm(Me, "MyField")
[Code] ....
Continuous Subform Unbound Control Problem
Feb 21, 2006Hello,
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.
Forms :: Continuous Subform - Unbound Check Box For Each Record
Nov 18, 2013Working 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?
Populate An Unbound Text Box
Oct 26, 2004Hi,
I have a form that has a list of sitting on when you select a sitting I would like to produce list of centres that are registered with that sitting. I would like to do this by having an unbound text box. I need to do it this way for part two.
So I have
SittingID The user can select a sitting from the combo box of sitting ID. I have this code behind the combo box to look up the sitting details:-
Me.RecordsetClone.FindFirst "[SittingID]=" & Me.cboSittingID
Me.Bookmark = Me.RecordsetClone.Bookmark
I then have a table that holds all the centre that belong to that sitting this table has the Centre ID and the sitting ID I would like the user to select a sitting using the combo box and then the unbox text box populates with:-
CentreName, CentreNumber, VenueName, any idea's how I go about this one. Thanks
Queries :: Open A Query Based On Two Or More Fields Of A Continuous Form
Nov 22, 2013I have a subform which is a continuous form displaying a single combobox of trade names so there may be up to 4 or 5.i want to click on a button on the main form which will open a form based on a query that will display all personnel matching all or 1 of the trades in the subform?
View 2 Replies View RelatedUsing A Query To Populate Fields In A Form??
Feb 7, 2006I have very minimal knowledge of MS Access and I have to create a database to input, update and display project information. How do I write a query to populate fields on a form, from either a single table or multiple tables?
View 3 Replies View Related