Hi. I'm new to Access and I wonder if someone could help me with this problem I am having while constructing a database. We need to create a database of reservations to a program we offer. We will need to store the quantity of reservations per person. What we needed to do is multiply the quantity of reservations by the value of each reservation and get a 3rd field with the final amount. So we need a field with the result of the multiplication of the quantity of reservations by the value of each reservation, which is a fixed amount. I'm having problems getting access to do this, I get an "error" message on the resulting field. Can somebody help me with this?
I'm trying to multiply the values of two number fields together, but it is not working. I used to be able to do this easily in earlier versions of Access. Here's the problem:
On the form, I need field A x field B to appear in field C. I've tried this as an expression in the build event function on the control, but it is not working. My code reads as follows: = (field A) * (field B).
Hi, I have a problem, I want to split up form input into several rows but I don't know how. Alright here's the deal: I have a textbox in a form were I write down all the ipaddresses for one computer and all the addresses end up in the same row in the same field in the table, I want the addresses to end up in different rows but in the same field, how do I do?
I am try to do all in one queries which has two queries imbedded into.
"SELECT Filter_ID, Channel, SpeedBands, Filter_Channel, Filter_type FROM (SELECT [Tbl_Lookup_Channels].[ID] AS Channel, [Tbl_Lookup_SpeedBand].[ID] AS SpeedBand FROM Tbl_Lookup_Channels, Tbl_Lookup_SpeedBand) LEFT JOIN (SELECT [Site_ID] AS Filter_ID, [Channel] AS Filter_Channel, [Type] AS Filter_SpeedBand FROM Tbl_SiteResults WHERE Site_ID=" & ID &") ON ((SpeedBand = Filter_Speedband) AND (Channel = Filter_Channel)) GROUP BY Filter_ID, Channel, SpeedBands, Filter_Channel, Filter_type HAVING Filter_Channel Is Null AND Filter_type Is Null ORDER BY Channel, SpeedBands;"
If is not work at all it is just asking that it is invalid join to the main query
Does anyone know how to count a field and multiply the answer automaticaly.. so if i have a count function on number of names repeated in a table via nameID the result would be presented in the new query with how many times name repeated multiplyed by a defualt set number.instead of name repleated 3 times, it be 30 times..using a query. any help appreciated..thanks
Occasionally, staff may just want all incidents (records) to be shown for the selected StudentSurname and so, just select the surname and leave the date fields blank.
i tried the following: Field :Date of Incident Crirteria: [Forms]![frmSearchStudent&Date]![cboStartDate] And [Forms]![frmSearchStudent&Date]![cboEndDate] Or: [Forms]![frmSearchStudent&Date]![cboStartDate] Is Null And [Forms]![frmSearchStudent&Date]![cboEndDate] Is Null
then when i tested this by leaving the date fields blank and selecting a valid student surname it simply returned all incidents (records) for ALL students not the selected one.
is it possible to achieve this? if so, could someone please help!
If CIS = False Then CIS_Payment = "£0.00" Else CIS_Payment = "£20.00" End If
which works ok but what i want to do but do not know the correct way/syntax is:
If CIS = False Then CIS_Payment = "£0.00" Else CIS_Payment = "Labour_Total*18/100" End If
Where CIS_Payment and Labour_Total are currency fields, and CIS is a checkbox updated using an update query with the same info as detailed in another table (Couldnt get the conditions to work referencing the checkbox in the other table, so duplicated the box in both tables and used a query to sync)
I have the time per item, and I would like to multiply that by the quantity, so I can tell the total time. But I cant find in access how to * data/time by a number.
I have a text box in a form that is producing a number from the query that the form is based on.In another Text Box i want to show the Value of the first Text Box multiplied by 3 because i am going to hide the first text box to only show the calculated number.
At the moment i have this in the control source of the text box [CountOfJobID]*3 but all i am getting is #####...I have set the format of the text box to General Number.
My question is that can we do multiplication of data of two columns and result is automatically displayed in third columns in datasheet view.? Is it possible ?
I am trying to make a report in which I can see the amount of money that I have to pay weekly to an employee. To explain myself clearer, I have different rates for each employee. For example:
NameNormalPayRateVacationPayRateSickPayRateOvertimePayRateStandbyPayRate John Smith$15$10$15$30$8 Ken Jonson$10$8$10$20$8
I am doing this in a query. So what I want to be able to do is, for example, take 4 hours that the employee worked at NormalPayRate and multiply it. But if tomorrow the employee worked at a different rate, for example 3 hours overtime, I want those 3 hours multiplied by OvertimePayRate.
The way I saw it on my Google researches, is that they have only one rate and the amount will be [SumOfHours]*[Rate]. But how can I tell my query to skip, for example, one rate because the employee didn't work at that rate that day. So I can have different amount for the different rates.
By the way, entering the information I can divide at what rate the employee worked x day. So if the employee work 6 hours at regular, and later on 4 hours at standby, I have those information separated in my table.
Results that I am getting: I can easily get the amount in money multiplying the whole hours by a rate, so my result in my report will be multiplied by the same rate.
I would like to create a command button on my form that copies values from 5 fields in the current record into a new record leaving all the other fields blank except for the new record ID.
The fields that contain the data that I want copied into a new form are:
I would like passing values from first form until third form.
In the first form I have a list box after selecting items (For each selected item in first form I have 4 values) and pressing button (or right click of mouse) the second form will be open, then in the second form I have 2 option (inserting, deleting), when I select inserting or deleting in the second form, third form will be open, in the third form there is a "OK" button, when I press that, passed values from first form will be used for inserting or deleting records to the table.
I have form named home page in this homepage form in the form header i have inserted some fields from some tables like province, district, community etc. these fields are unbound and are used for filtering purposes, when i select a province all districts related to that province displayed and when i select a a district all related communities displayed, there is a one to many relationship between district table and community table,
What I want is, when i select a district on the form header(it is unbound as i explained before) of this homepage form, the DistrictID should appear in community subform under DistrictID(as there is a one to many relationship between district and community) .
For more clarification find the snap shot attached...
I am creating a customer database for an independent insurance agency. Within that customer database, we have a lookup field that references another table "Carriers". This is where we select the insurance carrier we have placed the clients insurance with (ex. Geico, progressive, etc). This field allows multiple entries since clients can have policies with different companies.
We also have contact detail forms for each of our insurance carriers where we store information like web logins, contact phone numbers, and other notes. These forms are based on the same table as the lookup field.
I would like to create a hyperlink so, if we are looking at a clients form with all of their contact info we can click the insurance company in the carrier field and it will bring us to the contact details form of that carrier.
i just created two forms which r so inter-rel. with each other 1. FormName : Invoice_SL Form controls which need to be copied to another form : a> PO No b> PO Date c>Dispatch Details d> - is a filtered list depending upon UID of Invoice_SL Form
2. formName : Challan_DLR Form fields are : ChallanID, Challan Date, PO no., PO Date, Dispatch Details list of items to be sent-- a filtered list depending upon UID of Invoice_SL form
now what i want: Just a command button in Invoice_SL Form to Open(pre-made form) Challan_DLR form and Copy-paste all these controls (same named) from Invoice_SL to Challan_DLR form
Have one form that contains values AssociatedProject and AssociatedRelease that need to be passed onto another form that opens with a new record. Have tried different variations based on what I read here and couldn't get them to work.
Initial form - frm_ViewList contains the values that I need to pass on and has a "Add" button to bring up the new form that also creates a new record. The add button contains the following:
Dim stDocName As String MyAssociatedProject = Me.AssociatedProject MyAssociatedRelease = Me.AssociatedRelease stDocName = "Frm:ManageQuestionsAnswersProc" DoCmd.OpenForm stDocName, acNormal DoCmd.GoToRecord , , acNewRec
Then in the second form Frm:ManageQuestionsAnswersProc the following code is contained in the Before Insert:
How do you update a table using unbond fields in a form? I have several combo boxes that, once the user selects the desired value, passed to a table. Also is the event 'on double click' available for combo boxes and does it make sense to use that event.
hi! I've a question.. I've a form with two fields (min and max). How can I copy those two fields in another form and generate a list of values that are between min and max?? the two form and the data are not linked with tables..
Right. What I want to do is use a value obtained in the form (obtained from a list-box selection) to select a record in a table, then return one of the fields to a text-box on the form. All the values coming from the list-box are unique, and the value returned is a simple integer.
I am using the following code in the open event to set the gloves label on my form frm_Delivery_2 equal to the gloves label on form frm_delivery_1. I receive the error that the form frm_delivery_1 cannot be found. When I set the gloves label equal to another label or frm_delivery_2 using the same synax it works.
Private Sub Form_Open(Cancel As Integer) Me.Gloves_Label.Caption = Forms!frm_Delivery_1.Gloves_Label.Caption End Sub
What or where would I need to setup the code so that it sees the glove_label value on my form frm_delivery_1 and sets the glove label on my frm_delivery_2 equal to it.
how could i get multiple values shown in 1 form only? i currently have a code to look through 6 fields and if the fields iar blank, you get a a message box. you press ok and the next message is shown for the next field if it is blank but it would be so much better to have 1 message box showing all blank fields required to be filled in.
all it does is check the fields as these are required before continuing. if anyof the fields are blank, then it tells you and you cannot continue untl they are all filled. it seems easy in my head!!
im sure this can be done but im not quite sure how.
I have a simple parameter form where the users enter selectives for their queries. They usually want the top 100 records, but would like to select the number of records from that same form. I tried adding the forms' field name into the top records field in the query but it will take only a number. Any suggestions about setting it form the form or using VBA?
I would like to have a control on my form which displays the opposite value to that stored in the table.
ie, if the table says "TRUE" then the form should display false.
Having the value displayed is simple enough. I have two fields on the form - Field1 is the value from the table and is hidden and DisplayField has a RC of =not [Field1]
DisplayField always displays the opposite value. However, when I click DisplayField I am unable to change the value as it is "bound to Field1 and cannot be changed".
Elsewhere in the database Field1 is used in its normal form so simply changing the field is not an option and to save space I do not want to add another field which is simply the opposite of this one.
Is there any way to of updating Field1 when DisplayField is clicked?
(Note: this must be on a continuous form and the values will not be the same for each entry!)
Any ideas would be gratefully received.
Cheers.
PS (this is probably on here if I search, but whilst I am typing...) is it possible to change the colour of a single row of a continous form based on the value of a field? ie, red text if a value is false, green if true, as you can on a report