I have a continuous subform (frmLabor) that has an unbound box in the footer. This unbound box totals all the numbers in the Total1 field using DSum. However, when I change the record in the main form (frmCustomers), that number still stays there, and when I add records (service hours) to the subform under a new record (customer) in the outer form, those numbers sum. I understand what's wrong, I just don't know how to fix it. How do I get it to calculate ONLY the records (service hours) in the subform per record (customer) in the outer form?
One shows my form with the Transporters Subform with 3 entries, and 1 entry.The three line items that say "Transporter" are in one subform. I used this code
Code: Private Sub Form_Current() If Me.RecordsetClone.RecordCount >= 3 Then Me.AllowAdditions = False End If End Sub
to limit the number of records I can add to 3 or less.My issue is that I lost the blank text box that allows you to add another record. So, if I only have one Transporter listed, there's no box to let me add a second or third.I have the following properties for the Transporters Subform set to "Yes":
Data Entry Allow Additions Allow Deletions Allow Edits Allow Filters
I have a table and a form with continuous records (218 items). In a different table I have the status of these 218 items. In design view of the form I have added a label at the end of the record.
I want to use the DMax to set the caption of that label to the status of the particular item, but it sets the status of all 218 items to the status of item 1. How do I get it to distinguish between the records.
I guess somehow the record source for that label must be changed to the status table after form has loaded, and then run through all records and update the label caption.
I have a continuous form that opens all of the records for a specific user on a specific date and displays them in a continuous form. Each record requires an approval check box be marked before it can be processed for reporting. I want the approver to be able to click a button and mark all of the records displayed at one time. Currently my button will only mark the current record. How to I select all of the records?
I have Main form, and Subform (which is continuous form). Now when i open main form (or even subform itself) i see continuous form, and two empty rows.Whenever i fill first row and press on second, third row appears, and so on.
Can i set somewhere to show me only 1 empty row on this continuous form, and when i fill it, second row appears, and so on. E.g. is there any options for customizing how many empty rows are displayed and the begining of continuous form?
And how "saving of records" work here, because if i fill one row, it won't save anything....it will save it only when i press on other row (when third row creates)
The Ignore, OverTime, AnnualLeave fields are bound to a I, O, A checkboxes respectively in this continuous form. The ExtraValue bound to a EV textbox in this form.
What I want is that when the user check O or A checkboxes, the EV textbox is enabled only for this form record NOT all the form records, when the user check I checkbox, the EV textbox is disabled only for this from record, NOT all the form records.
The problem is that whenver the user check, all the form records EV text box is affected by this action.
I've been trying to get my head round this one , but i'm just to thick to get it.
I have a continuous form that lists all items at a certain location. The user selects a record by clicking on the record selector and then clicks on a command button with this code:
The user then enters inspection details in to the "DivingInspectionCert" form which i want to store in a table (DivingCert) which will relate to the item. On completion of this form the user then clicks on a command button with this code:
DoCmd.RunCommand acCmdSaveRecord
If Me.RecordsetClone.RecordCount = 0 Then MsgBox "There are no items to Print", vbInformation, "EquiTrac" End Else DoCmd.OpenReport "DivingInspectionRpt", , , ("EquipmentID = " & Me!EquipmentID) DoCmd.Close
When i click on this button, the report doesn't print and i get a message "No current record". The inspection details are not stored in the table. I did have the forms RecordSource based on the table "DivingCert" but that didn't work and i have just tried a query but it is still not working.
Would be much appreciated if you can help me. Thank you
I have a form (Form4) which has a a list box (list11) that allows multi select. When I select on the records I need I hit a button that opens a form up with the selected records. This form is a continuous form. I have an unbound combo box (Combo55). Its values come from a specific table. I want to hit a button and change the field "Assigned" on all the records showing to the value that I selected in Combo55.
The problem is it only changes the value of the currently selected record. How Do I get it to change the value of all records that are showing?
I am only testing this idea with default field names. Before I implement the database I have to get a working model and present it. So I am building this and naming at the moment isnt important.
Is there any way to highlight duplicates across a number of records on a continuous form (conditional formatting I presume)? My continuous form is filtered on load to show only the records relating to the specified date (specified before opening the form), and there is one field that I would like to highlight if there is a duplicate value in the same field on another record on the form. Is this possible?
I have a main form with several continuous subforms. Each subform consists of several listbox controls. I would like to require the user to select an item from the listbox before being allowed to move to the next record in the subform, and upon reaching the last record in that continuous subform, to require an entry there in order to move to the first record in the next cont. subform.
As an added bonus, it would be nice, though not necessary, to automatically jump the focus from one record to the next after data is entered. But my basic goal is to avoid skipping records.
Caveat: I cannot use the "required" option in the field to which the control is bound because that field has a default value previously entered using an append query. (The default value basically means "not yet entered" and is not one of the options in the listbox. I am using this because this field is a foreign key in the table, thus it must have a value in order to have a record with which to populate the subform.)
My apologies if this has been asked and answered elsewhere, but I've searched and, while I found a few related threads, they don't quite answer my question. Here they are for reference:
Thanks for any help! Also, if you are going to recommend VB code, could you be specific about how and where I should use it? I'm not afraid of code, but I'm definitely new to it...
I 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.
I have a continious form with textfields as records. Its about total course hours that are calculated. There is a field in the records that holds and calculates the hourse that one have done and another field that holds the max hours they may follow for one year.
Every record has h different year.
When the amount of hours in the transmission textfield is negative, they can transmit the hours to te next year. Therefore i have to calculate the Max hours per Year + the transmission hours.
So the calculation is not a problem. Though i don't actually know where i can trigger the calculation. I have tried it with a button on the form, but then the user always have to click to see the right amount of hours for the next year. That's not handy. I am looking for a way to automatically calculate the field Max hours per year. Given that the Max hours per year is a bound field, its bound to a table where i stock the Max hours that i have calculated.
I also tried it with the button that's used for inserting new course hours, but then it calculates with the old values instead of the new ones.
How can i trigger the calculation automatically without using a button.
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
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.
Hi guys, I have a prob with summing up my subtotal figure in my query. Here goes:
I have an Orderdetails Table with : Qty,Unit Price,Discount. That makes my total in query "Total:[qty]*[unit price]*(1-[discount]). However, I can't use the SUM to sum up my "totals" as subtotal. How am I going to remedy this problem? THanks
I have created a form with a subform and has the following information displayed:
(Form) Tenant ID Mobile Telephone Number Title Credit Reference Surname First Name
(Subform) Date Due Amount Paid On
(Form) Total Of Arrears -
I need text box at the bottom of the form to caculate each tenants arrears. To show if the tennant has any arrears there will be no date shown in the [Paid On] box (If there is a date in this box it means the tenant has paid and therefore no arrears) so the [Amount] for that tenant owes will be totaled up in the box at the bottom of the page [Total of Arrears]. Also a tenant might miss a payment on one week and a pay another rent payment on time. Please could you show how to do this in access and not by VB code.
I've attached my database - well thanks for looking and hope you can help
I kinda new to access but What I need to happen is I have a Bill Table, and I have a search query, you type in the customers last name and the different services they request come up. I have it do a report, at the bottom I want the Cost field to add up and display total cost. any help would be apreciated... thanks,
Not exactly sure if a query is what I need in this situation or if it is what I need how to get there.
In the attached db example on the case form there is a section for technicians to go in and take credit for steps that they performed as part of the overall case
So clv1 might be done by User A Then clv2 might be done by User B
But the next case it might be switched.
I need a method getting the sum of the total clv's field for each technician in two different ways 1 would be the total clvs for USer A for the current month, 2nd would be the total for the year- or actually a prompt for a date range
Tried using the query wizard but it doesnt combine the names Then I tried an individual query on each set - that worked but then I only get the ones in the first column - not all the clvs that they did.
Hope that makes sense - is there a way to do this or am I in the wrong forum for trying to figure out a way?
Well the db example is imb so it cannot be attached
I have a form that has 7 text boxes, each of which contains a time value (hh:mm)
Two of them are to be permanently totaled into one text box (lets call it Rate1), and the other five are to be totaled into another text box (lets call it Rate2) - BUT, if the value of a combo above each one of the five text boxes is set to 'BH', I want the value to be totaled in with the Rate1 totals.
I did think about doing an After Update event on each of the five textboxes where the value of the totals text box is updated by doing the current value + the value in the textbox (and the totals text box that is updated is dependent on the value of the combo) - but that idea landed flat on its face upon the realisation that if a user entered a value, then decided to change that value, the old value would not be deleted from the total.
HELP! I’m working for a charity in a small town Tanzania and there is not a soul for miles who knows anything about access.
I have created a database to track requisitions of Office Supplies. I have table full of the requisitions which contains multiple rows for each item we have in the store and the quantity requisition on each occasion.
What I want is a query that will calculate the total quantity of each item requisitioned in a month. Is there an easy way to do this??
I have a form with Continuous Records as its default view. I would like to number the amount of records displayed on screen to about 5 or 6 at a time instead of having them scrolling right off the bottom of the screen. Is there any easy way to do this? Thanks
