Forms :: Calculated Fields In Continuous Forms
Aug 14, 2015
i have a continues form that lists all my active items and I'd like to use it to quickly check if they have all the data inserted, ie entries in each separate table. it looks like this
I perform a simple check on form load chk = DCount("[phID]", "preh", "[phbID] = " & Me.tID) where me.tid is the item ID and this gives me 0 or 1 and writes ok, or missing into the appropriate box.Problem is it tkaes value for the first item and repeats it for eah other, so I get ok or missing throughout the continuos form.How can i force a check for each line?
View Replies
ADVERTISEMENT
Apr 6, 2013
I have a form that is displayed continuously and there is a text field in it (Text12).In the footer of this form I would like to add a textbox that is the sum of all Text12's on the form.I tried =Sum([Text12]) in the textboxes control source but that is just displaying an error when I run the form.
View 2 Replies
View Related
May 29, 2015
I have a bound continuous tabular form,However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown below, and I am looping through each record. To show that my code is referring to the field with required data content, I display it as a message box and it works, yet my checkbox does not enable.
I have the code in the form_load event, however, for testing purposes I have it behind a button.If I am seeing this properly, the code behind the button enables the checkbox for ALL records once the criteria in the required field is true, and based on the last record, which has no data content, it disables the checkbox in ALL records. I also have the PK ID for each record hidden in the form. Can I utilize that to target the checkbox of each individual record??
Form Detail
-Form does not allow additions or deletions. Edits allowed
-All fields are disabled and locked
-I only want the check box to unlock if data is found in the "RequiredField" as referred to below. I have also tried if not isNull(requiredfield.value) then -enable checkbox, which yields the same results
Here is my code
Code:
Dim rstMyForm As DAO.Recordset
Set rstMyForm = Forms!MyForm.Form.Recordset
rstMyForm.MoveFirst
Do While Not rstMyForm.EOF
If Not RequiredField.Value = "" Then
[code]...
View 14 Replies
View Related
Feb 8, 2006
Hi Guys,
I currently have a subform which relates to the primary key of the main form.
This subform contains possible 'Answers' which related back the main form/table 'Question'. Each possible answer has a true of false field to show whether or not it is the correct possible answer from the question field.
Currently the subform performs correctly, in that it shows up the 3 possible answers for each question... (in continuous form view)ie all three appear at once in 'form view' - but in the subform the only one answer and one true or false attribute appear at once.
Here is where the problem is - i need to be able to access the individual field values for these 3possible answers (in VB code). I cant work out how to do this? Does anyone know how access calls them? What will the checkboxname be? The problem is because there is only one checkbox on the form in 'Design View' (to see if the answer is the correct one), but then 3 in 'Form View', I cant work out how access distinguishes between them.
Many thanks
Ross
View 2 Replies
View Related
Jul 6, 2013
I 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?
View 7 Replies
View Related
Sep 9, 2006
Now I can create a Query that adds, subtracts a specific column, but im having a hard time trying to get the information into a form since it don't seem to allow me to pick the query field which is calculated as a datasource. Can someone tell me how to make a calculated query column appear on a form as a field? Such if I type in monday in the regular table, the form will add a few days to the next available game? I have the information/code already in a query that displays the query right in a new table using the Expr method but I can't get the form to just simply display the field. Someone please help!
I see a few people asked close to the same question but nobody never answered so I am thinking it is impossible
View 3 Replies
View Related
Feb 10, 2015
I'm trying to use the following code to programmatically sort four fields on the continous subform:
Code:
Me.SPlanChange_03_OFFSET.Form.OrderBy = "AOBJ ASC, ORG ASC, AVAILABLE DESC, AGFND ASC"
Me.SPlanChange_03_OFFSET.Form.OrderByOn = True
It appears that the code works partially - the values in the "AOBJ" field are as they be and so are the values in "AVAILABLE" field. The values in the "ORG" and "AGFND" fields will not sort.
Is what I'm trying to do even possible?
View 1 Replies
View Related
Apr 7, 2014
I have a form where the record source is a table.The form has about 5 calculated fields on it. The screen flickers quite badly and at the bottom says calculating. Sometimes the database locks up.
To stop this flickering i created a query so that the calculations are done in the query. Then i linked the form to the query instead of the table. Am i doing this correctly as i didn't think the table would show any new data that i entered into the form but it does seem to work. Is it because i am only using one table.
I am using Access 2003.
View 6 Replies
View Related
Jan 30, 2014
Why can't I ever get these to work properly? I want to use them to ignore null fields so that I won't get the punctuation but it isn't working.
Here is what I have but the commas still show up:
=IIf([Status]=1,(+[MailBoxOrPOBox]) & (+", "+([CompanyLocID].[Column](2))) & (+" ,"+([CompanyLocID].[Column](3))),"")
is there a better way than trying to use these + signs??
View 14 Replies
View Related
Apr 17, 2015
I'm still very new to Access.I have a form with subforms.Some of the fields are calculated fields.I cannot figure out what some of the fields will not update automatcally. Once I click out of the form and then back in, it will update.Tried many things like, Refresh, Requery both on the form and on the text box(es).I wish I could figure out how to attach my test database to show you.
View 11 Replies
View Related
Oct 16, 2014
How to store a calculated field into a table
I am preparing an invoice and I have a field called deposit .Now this field calculates %40 of the total of the order .but if the user wishes they can enter what they like .Now this field must be stored in a table for ever and a day and must not change or the invoice will be useless .I can see no other way of doing this and my research tells me (allen Brown) that this is sometimes necessary .
View 4 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
Jan 13, 2014
In my form I have a calculated field that works out the time elapsed for a job, worked out as the QTY/RUN RATE which gives me the time in hours. However I couldn't format the box as a date/time, as it is a calculation and the times may go over 24 Hours which results in the date/time giving me something like 31/12/1899 16:00 for example.
I've got around this now and I've formatted the results as HH:NN:SS using a public function in a module, but the problem is this is now stored as a text field. I've tried setting this to a number field but the formatting doesn't carry over. I've tried setting a custom format in the table as HH:NN:SS but then all I get is just a bunch of 0's, no calculation results.
So how to format this as a number field properly?
Also for any extra information:
- I know you're not supposed to store calculated results, but this is slightly different, the calculated field is a standalone text box and the bound field is a formatted text box.
- The reason I have to store the calculated results is because my boss wants to eventually see a chart of the total hours of jobs each day, hence why I'm asking if this can be done as a number field.
View 4 Replies
View Related
Mar 21, 2013
I need to pull the calculated values from approximately 10 forms into another form. This is a summary form that should have all the totals pulled from the other forms.e.g. Form A has a textbox that reflects the sum of the amount. This is the total balance of form A.Form B, Form C, etc. all have a total Balance.Now, i need to pull all these totals into a summary form
-Form A Total Balance: x
-Form B Total balance: y, and so forth.
How and what is the best method to approach?I have tried using Forms![Formname]![Total] to get the data. This necessitates the need to hide all these forms and I ended up with blank forms, etc.Even so, the total sometimes appear and sometimes it does not. so it is very unstable.
View 11 Replies
View Related
Aug 17, 2015
I'm trying to set up a sum field in the footer of a continuous forms form but I'm stuck on the code. The field is amount and I need the sum field to show the total of all the records on the form.
View 5 Replies
View Related
Apr 14, 2014
I have a drop down box on a continuous form called (cmbItem).When the users choose Option 6 (Other) and on the open event I wish to show another field txtOther which allows the user to give a description of what 'other' means but I only want to show the field for that record. (the user could potentially have more than one record as other)Using conditional formatting I have managed to change the colours of the box so that the background is the same colour as the form unless other is chosen when it reverts to white. However I can't do the same with the border as this is not one of the options provided.
View 2 Replies
View Related
Jun 18, 2005
I am creating a continuous form where each record has a couple calculated controls. The problem is, as you scroll down through the records, the computer hasn't performed the calculations yet. It only starts to perform them once they are visible on the screen. So the result is blank fields for about 1 or 2 seconds every time you use the vertical scrollbar until they all get populated. Is there any way to get access to populate all the calculated text boxes when it is loaded, like a report is? I have played around with not using a continous form but rather creating a form with MANY text boxes on it that are filled with a loop. It works and all calculations are performed prior to displaying it on screen its just tricky to work with in a realistic situation and I figured their must be a better way.
Thanks for your help!
View 1 Replies
View Related
Feb 26, 2006
I have just created a new continuous sub form within a main form to display bookings of a particular date. The date field is in the main form, when updated, the data in the sub from updates. Before this, I was using a list box, however I changed to a continuous sub form since I wanted to have conditional formatting.
Now I'd like to have the option to choose a row of data from the sub form and then enable/disable a command button on the main form depending on certain critera...i'd like to know what is the best way to let the user choose a particular row of data...
i have thouhght of a command button or a option button, but it seems that the control wouldn't have a unique identity pertaining to the row..
any ideas appreciated..
many thanks..
View 2 Replies
View Related
Aug 24, 2006
I have a contiuous subform on a main form that i use to enter multiple products for a price check.
I am using Dlookup to pull the description and other details into their respective unbound textboxes on the subform.
The problem im having is that when i enter a partno into the text box on the next line it changes the description and other details on all the lines.Is there a way to stop this or any other way of adding multiple product lines.
Thanks in advance.
View 1 Replies
View Related
Oct 14, 2006
I have a form where I'm entering data relating to each inbound shipment such as date of arrival, vessel name, etc...however i'd like also to enter invoice numbers and values that cover each shipment. one shipment can have more than one invoice. this means that for one shipment i need to enter , for example, 10 invoice numbers and 10 values.
I thought abt having two tables...one table having the shipment data and another table that keeps the list of invoice numbers/values of the shipments (having a foreign key relating to the shipments table).
now...i have an issue on how i'm entering the invoice numbers/values on the form..since the number of invoices might vary with each shipment...i thought abt having a continuous form...i set up one with two unbound fields...invoice number and value...but as soon as i enter data on one row, all the rows become with same value. any feedback on how should i approach this issue?
am not quite sure at what stage would the data in the continuous data be appended to the table..i'd like to have it save to table as soon as a command button in main form is clicked..
appreciate feedback....thanks! :)
View 14 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
Oct 9, 2005
Hello !
I am pretty good at coding in many languages and i learn fast good some realy complicated stuff but hey...when it comes to easy...i am just out of luck :(
What i am trying to do here is have a continuous form linked to a table of loged event and on the Form Header have fields ([eventNumber],[DateFrom],[DateTo]). I would like people to be able to "filter" by event number (that would bring a single event and the probleme is not there) but in many cases, we need to get events from a range of date.
1) How can i make it so that when someone change in [DateFrom], it will display only those from that particular date
2) How can i make it that when people change [DateTo], it will give the events in my continuous form from [DateFrom] to [DateTo]
3) Why easy things are so complicated :(
View 1 Replies
View Related
Oct 22, 2006
I am having problems with Continuous forms....I had already started this in another thread but now i restructured a bit and better to start new...
Attached i'm attaching a sample DB with what I have...
In Form1, i have a subform subInvoices....in the footer of the continuous form i have a total that sums the invoice amounts. i'd like that when the user clicks the command button, that total is transferred to the text box 'value of goods FCY'. i tried doin it as u can see in the DB but i'm getting an error...
also, i'm still not feeling comfortable with the updating of the continuous form table 'SInvoices'. i'd like the changes to the subform are updated to the table when the user clicks the command button. is this at all possible? also is it possible to update certain fields in the table that are not mentioned in the form..for example i'd like to remove the columns currency and shipment ID from the subform and these would be taken automatically from the main form controls (Shipment ID and Invoice Currency respectively).
I appreciate very much your feedback.
Thanks:)
View 8 Replies
View Related
May 4, 2005
This may seem like a silly question but, Is there any way when a number of records show in a continuous form (that is a subform) and you allow additions, for the new record to be at the top of the subForm and the rest of the records to sort below it.
The sorting seems to effect the existing records not the new one (which being new has no data).
I know I could append the new record and then open the form without the capability of additions and sort it so that the new record is on top.
Thanks
View 2 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
Oct 5, 2005
I have a continuous form, that displays in the body the results of a number of selections from a previous form.
In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current” event;
Private Sub Form_Current()
If Text29.Value = 0 Then
Label32.Visible = False
End If
End Sub
The default form Label32 is for it to be visible. Text29 is unbound and derives it's value from "=Min([WareHouseID])-Max([warehouseid])" no problem there.
The problem is that test does not perform as I expect it to. I have tried all sort of combinations and permutations but can not get it to respond correctly. It seems to think that Text29.Value is equal to zero regardless of the result it is showing
I'm guessing that there is something about continuous forms I have not yet learned :(
View 3 Replies
View Related
