Recent content by Rik_StHelens

I altered the code as you suggested. Unfortunately the result is still the same: If the query is searching for a matching record without brackets it returns it, but if the record contains brackets it fails to return a result. I tested the theory by removing the brackets from the tyre sizes...

I did place the code in the sub form's OnCurrent event as advised. Unfortunately I didn't get an error message, and nothing changed on the form. As CJ said it could be design specific in regards to how i've constructed the form, and I appreciate the help offered. As there are a mass of linked...

Nope, just a standard form with two sub forms.

No luck there I'm afraid. As I said, could it be that when the record is changed, the values in the hidden text boxes are outside of VBA, and therefore changed after the VBA has been run?

AhA! It works, but not when I click on the RECORDS in the grid view, only when I click on the subform elsewhere. Any ideas?

Hi there, After posting I managed to find the following: http://bytes.com/topic/access/answers/609424-how-do-i-requery-subform-another-subform So I tried the following which didn't work: Private Sub Form_Click() Me.Parent![qryFindTyres subform].Form.Requery End Sub I also tried as you...

Hi all, I have two sub forms on a main form. Subform 1 displays information which comes from a query, filtered using two combo boxes on the same form. The active record on the data sheet has two field values output to hidden text boxes on the form. These text boxes then provide the values...

Hi all, I have a query which uses values in two hidden text boxes, in order to populate a sub form. Unfortunately some times the data in the text box contains brackets within it as follows: '120/60 ZR17 (55W)' When this occurs the query returns no data, even though records with a matching...

Does that also apply when I am solely using that underlying query, in the update query, to update a different table. The sub query I am using which calculates the selling prices uses the Round() function to limit the result to 2 decimal points. This could also be part of the problem too? Also...

Yes pricing report is a query, and uses a formulae to calculate prices based on Wholesale Price, RRP, Base margin and % margin for each marketplace (Amazon, Ebay, Play) As for the RIGHT JOIN, I tried left, right and no joins just to see if it helped....

Hi Plog, Thanks for your reply, I have added responses as follows to give a bit more information: 1. This is a one off update of a file which sits outside this database as standard. This database (which I inherited from someone who no longer wants to support his customer) is used purely to...

Hi all, I am trying to execute a query to update a table with pricing values calculated in a seperate select query. This comes back with an error messahe of "Operations must use an update query". I have checked that the database and linked data files are not in read only folders, but still get...

Thanks for that Bob! I thought that as it was a calculation Sum was necessary, but removing it worked just fine! Thanks for your help.

Hi all, I have a text box on a form which is a calculation based on two other text boxes bound to a query. The code for this text box is as follows: =IIf([Forms]![frmQuote]![Check47]=True,(Sum([Text72]*[Text64]),"0")) When Check47 = True the text box displays #Error, and when Check47 is False...

Never mind! I decided it was easier to store individual instructions against each region and use DLookUp to pull these in through the Account Details query. Thanks again!