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 RepliesI 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 RelatedI have a form with three fields named 'quantity' (numberfield), 'service' (combo box) and 'amount' (calculated field with controlsource =[service].[Column](2)*[quantity].
I try to sum the amount field in the formfooter with =Sum([service].[Column](2)*[quantity]) but I receive an error.
Somehow it does not get the value for [service].[Column](2)
How can I do this?
The table for the form is called customer_detail
I've got a subform (simple table view) inside a main form, the subform (sfrmRecipes) just has an IngID field (which stores ingredient ID's) and a percentage field
I've added a few calculated fields to this subform, to assist users in making decisions, however each of these fields needs a sum total
So far my percentage field (which is an actual stored field in tblRecipes) is the only one with a functioning sum
for some reason the two calculated fields (which are both plain numbers, no text) do not give me a sum total option, i am only able to use the count function on them
Why calculated fields dont sum up and if there is an easy way to get it working (tried creating my own text field in the footer and manually typing SUM(fieldname), but it does not work).
On a form I have the following field:
Name: PaymentsMade
Control Source: =DLookUp("SumOfPrePaymentValue","qryInvoicePrepaym entSum","InvoiceId = " & [InvoiceId])
In the form's footer I have the unbound text control:
Name: SumOfPaymentsMade
Control Source: =Sum([PaymentsMade])
SumOfPaymentsMade returns #Error
How do I get it to return the sum of PaymentsMade?
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.
I have three tables (Group, Customer, Savings).
Every member of a group do savings once every 15 days and each group has maximum 20 members, group has one to many relationship with customer and customer having one to many relationship with Savings (there is no direct relationship between group and savings) i have created a continuous form for saving entry. in this form i select a group which is unbound and based on that group, its members are listed in the combo box named CusID, after selecting customer other saving details are entered.
What I want, is that for every group i want a total saving for all that specific group's members selected in the mentioned unbound combo box in that continuous form, this total should be based on the group selected in the mentioned unbound combo box, in case i select another group the total should also be based on newly selected group.
I have a continuous sub form linked to a master form. The sub form contains fields such as [date], [increase], [lastdateincrease], [task], and multiple other fields. The sub form can have one record or multiple records linked to the master form.
Each sub form record represents a service, monthly cost, and a price increase amount. I'd like to be able to enter data in two fields and have this data populate any remaining records, or for that matter, new records that I had to the sub form.
The fields that I would like to have populate are [date] and [increase].
When I enter the [date] and [increase] in the first record, I'd like all remaining records in the sub form to update with the [date] and [increase] amount automatically.
I apologise if this question has been answered elsewhere but I have tried looking and can't find anything that helps.
I'm in the process of upsizing an access database to an adp front end and a sql server back end. One of the forms in my original database was a continuous form with some calculated text boxes in the form footer. One for example had the formula
=Sum(IIf([field1]="valueA",1,0))
which worked quite happilly.
I've now changed my forms recordsource to a stored procedure which works fine, however none of the calculated text boxes in the footer of the form work. I have read that complex expressions might not work in adp's and that I should use CASE instead of IIF, which I've done. I've taken the iif part of the formula and added a calculated field to my underlying query so all I need to do in the calculated text box is an =sum([aField]) but I still get a #Error.
Even if I do a =count(1) or something really simple like that I still get #Error.
Can anyone see where I'm going wrong?
I have a continuous subform with an unbound Concat textbox and would like to populate another field for each record with the results with a main form button onClick event.
How do I accomplish this?
Access 2002 . Can I condition a field to 'locked' on just one record of a continuous form subfile, based on the contents of a 2nd field in same record?
View 14 Replies View RelatedI have a form listing tasks to which I make personnel assignments with a multi-value list field type. It takes some time to select from 15-25 employees on the list for each task, especially considering that small groups of employees will be assigned to the same selection of tasks.
What I want to do is select multiple records with the mouse, then click a command button opening a form in dialog mode with the selection list. The user then clicks to make his selections and clicks ok, which then updates the multi-select field for the selected records.
My form is setup with Continuous view, with data feeding from a table. The structure is straighforward (excel style). AgentID, workHrs, holidayPaid, holidayUnpaid, sickHrs etc. The structure is not normalized, and I know the risk. This is basically only for human interpretation, not really a structure that will cause instability or patched up working of the DB.
I have the continuous form view, so it can be viewed in one single display, I have placed a Totals at the footer, which is populated by nothing but a simple = Sum(columnName). This works great in most of the computers, except one. My boss's computer. Which is where it actually needs to work. I am baffled, because I have tested it on almost every single computer in my office, everyone's work. Just his computer is playing up. I am unable to pin point the problem. The status bar keeps going "Calculating..." but even after giving it a solid 5 minute it does not seem to work !
in a continuous form i want to click on one record and have the one field change the background colour to highlight it. When I use the code: Field. BackColor = vbYellow it changes the background on all the records. Is there a code to say only for the record with focus?
View 1 Replies View RelatedI have a continuous subform which queries a table of attachments. I'm using Access 2007 but not using the Attachment datatype; this DB will grow considerably and I don't want to waste precious space by filling it with bulky files. So instead, I have code which makes a copy of the attachment and adds the hyperlink (to the copy) to the table instead.
Now - I want to add a control to the subform to display an icon / image reflecting the file type of the attachment (Word doc, Excel s/s, PDF etc.)
But not sure how to go about it.
I was thinking I could use FileSystemObject.GetFileExtension at the point in the code where the attachment is added, and add a new field to my attachments table (i.e. translate "*.xls*" to "Excel", etc.) Then store / embed a handful of images for the core types I would expect and use an image control on the subform to display the image based on the value of that field.
But is that even possible / feasible?
Or, is there a handy API which can retrieve the icon associated with a file type based on what has been installed on the local machine (even if there is, there's still the problem of setting up the image control to display the appropriate icon specific to each record...)
Or, is there another control available which would be better suited to something like this than an Image control?
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]...
Can Somebody plz tell me how to give the form ,a footer & header. I want to write in Heaer-REPORT FIRST
But i m not getting how to type the text in Header & Footer, plz reply.
Bydefault the user is able to resize the form,I also want that the user is not able to resize the form.
I DO That FOR THE ABOVE BUT ITS NOT WORKING--
I open the from in Design View. Select form properties,Select Form Header from drop Down List,On Which property name I have to write the text for footer/Header,plz tell me dat.
Secomdly I select FORM from dropdown list,&click Format Tab,& Set Auto Resize to NO.But Its not working.Form is still resizing.
I have a problem with calculating sum of fields in the footer of subform
The subform consists of following 5 fields
Opis kolicina txtCena rabat CenaSpop
Opis is combobox (cbododatki), which takes values from another table (tbldodatki)
SELECT DISTINCT [IDdodatki], [Opis], [Cena] FROM tbldodatki ORDER BY [Opis];
Kolicina is enetered manually
Rabat is entered manually
Cena is calculated with =cbododatki.column(2)
Cenaspop is a calculation of [kolicina]*[txtCena]*(1-[rabat])
In such case i cant get Access to calculate the Sum in the footer of the subform
On the other hand, if i add an additional column to the source table (tblPodrobNaroc) of this subform (frmPodrobNaroc) where i enter Cena manually (instead of only being part of cbododatki), then all calculations are fine.
Which option do you reccomend, should i:
a) add to the source table of subform (tblPodrobNaroc) another column with values of Cena from tbldodatki (how is that done?), which would be filled in through cbododatki, and then perform needed calculations
b) call Cena in subform in such way that the Access recognizes it (not as cbododatki.column type) and performs the calculation.
I have two forms (attendance & member details). I put the attendance form in the member details form as a subform. My problem is that my attendance form has buttons in the footer that I want to keep (and need), but I don't want them showing up in the subform
View 2 Replies View RelatedI have a form, frm_Master we'll call it, and on that form, within it's 'form footer' I have a tab control containing a few sub-forms, namely frm_Child.
Now, if I turn on my form footer's visibility, then the form's detail section is not shown; likewise, if the form's footer is not visible, then the detail section is.
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?
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 RelatedI 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..
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.
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! :)
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)