Search results

Hi all, Is it possible to not showing a specific field in a report based on a query if a checkbox in the same query is active?

Thanks a lot. I will do the calculations in a query instead of doing them in the table. It makes much more sense. When you say "you'd do a calculated field in a query, then bind the form to the query", if I do this, will the form register further inputs in the actual table where the query is...

Hi all, Very basic question here. I need both to have a calculated field in a form and register the result in its table. The calculation function needs to be placed in the Control Source, right? How can I select then in which field the result must be registered? Should I just do the same...

I get a "Enter Parameter Value" request on Forms!NameofMyForm!ClaimID (PK of the main table) and then an "Ambiguous name detected: Form_Current

As an attempt to make this work, following the advice given to someone with the same problem, I created a non-visible subform with the query result in the form. The amount that I need is now there in the form. Can I bound that with the field in the main table so it gets registered in there? I...

Thank you very much for this suggestion. It makes totally sense. The problem that I'm facing at the moment is what it should be the easiest part. I created the query that gives 4 columns as a result, being the result that I want to show in the last one. The query itself works and get the...

Actually I would prefer having a texbox instead of a combo, since the result is unique and users woudn't have to choose anything. The purpose is only to inform about the nr. of invoices with the same Case Number.

There are 2 items in the query results. The CaseNo and the NrOfInvoices, that's why I think that it should be: Me.cmbNrOfInvoices = Me.cmbNrOfInvoices.ItemData(1)

Thanks both for the answers The query results shows 2 values, the "CaseNo" and the "NrOfInvoices" in the query for the first example (NrOfInvoices), but it is still not working: The code looks like this Private Sub CaseNo_AfterUpdate() Me.cmbNrOfInvoices.Requery CaseTitle = CaseNo.Column(1)...

This is very basic but it bothers me a lot that I can figure out why it is happening. I have 2 different combo boxes on my form that get the result from 2 different queries. My problem is that for getting the result to show, I have to pick it up from the combo box. It is not showing...

Now it works if "SavingsDetails" is 0 or Null ; the result is 0. But if not, it just shows the same amount that TotalAmounttoPay(GBP) Edit: No worries, I made it work without the Dim, just inserting the whole thing instead of dblSavings. Thank you so much!

Arnelgp, it works partially, thanks a lot. I need to include that if "SavingsDetails" is 0 or Null, Me.testsaving should be 0. Could you please help me with that?

Hi arnelgp, Thanks a lot for your help. I would prefer to use it as a calculated field in the table, since I don't need the info in the form. But since you said that it was too complex for being in a calculated field, I don´t mind if I get it in the form. The ProviderID is in the form with...

Dear all, I am trying to calculate an amount on a text box based on a TotalAmount present on the form and the discount percentage related to the provider selected on the same form with is in the table "ProviderDatabase" in the field "SavingsDetails" With the help of an user here, I got to the...

No prob. I am trying to do this on the form in VB but I am still getting a debug error :( "Data type mismatch in criteria expression" I am trying: Private Sub cmbTotalAmountToPayGBP_AfterUpdate() Me.testsaving = [TotalAmounttoPay(GBP)] * (1 - Nz(DLookup("SavingsDetails", "ProviderDatabase"...

I tried only with the Dlookup : =Nz(DLookUp("SavingsDetails","ProviderDatabase","ProviderID=" & """" & [ProviderID] & """"),0) I get the error: The expression cannot be used in a calculated column

Thanks a lot. I am using the following: =[TotalAmounttoPay(GBP)]*(1-Nz(Dlookup("SavingsDetails","ProviderDatabase","ProviderID=" & """" & [ProviderID] & """"),0)) and I am getting the error "The expresion you entered contains invalid syntax"

Dear all, Apologies for the newbie question. I have a form calculating a discount on a "TotalPrice" field based on the supplier name. On the suppliers table there is a "discount" field for every supplier (0,1 for 10% disc) I did the calculation on the actual form, based on a query with a...

Great. Thank you so much one more time!

Could somebody help me with the AfterUpdate() VBA for a texbox in a form? If the value is >9000 the checkboxA must be checked. Thanks in advance!