Search results

Done it!! Thanks guys, the end result looked like this: strFilter = "ItemReferenceNumber = '" & Me!ItemReferenceNumber.Column(0) & "'" and it worked. Phew

Yes and yes, to be honest, I'm glad it's not just me. I lifted this code out of Northwind (why reinvent the wheel?!) where it is also in a subform and it works fine there but is also included within loads of other coding. I will set up a new database with just this table in and see if it works...

Thanks for that I got "Run Time Error 451 Property let procedure not defined and property get procedure did not return and object." So I changed it to this: strFilter = "ItemReferenceNumber = " & Me!ItemReferenceNumber.Column(0) That got rid of the run time error 451. I added: MsgBox...

Thanks. I tried: strFilter = "ItemReferenceNumber = " & Me!ItemReferenceNumber & "" and it came up with the 2001 error so the syntax error is gone. Looking at previous threads, this code should now work but I just can't seem to get it!

Hi All I've been wrestling with this for a while. I have tried many variations of the below code. Basically, I have a combo box for ItemReferenceNumber and I want it to bring up the price as allocated in tblProducts: Private Sub ItemReferenceNumber_AfterUpdate() Dim strFilter As String...

Hi. I don't think you can nest in this way with a Vlookup as you are trying to achieve two different things. The vlookup will return data based on a common field and match will give you data which is in the same position on a spreadsheet. What are you trying to do?

If your data is coming from one table, I assume that you have simply selected both those fields and added the sum function into the totals row of the query so you end up with two columns SumofFees and SumofDiscounts. If you add a third column to the query and in the field row write...

I had got to the point where I had over-complicated things to such an extend that I think it gave up on me! Have removed all the coding and it's fine now. :)

Hi, Are you using the combo box to search for a particular record? If so, you can use an unbound combo box which lists all the records' primary keys and locates a record and also have your primary key as a separate text box. Primary keys should not generally be edited, you shouldn't use names...

Hi Thanks for having a look. I tried to change the postage field rather than the calculated field, should I be unable to do that?

I have a form based on a query for viewing and entering data. It is a stock form and I have three fields from the query (Order value, Shipping Supplement and Postage) which are totalled into a Total Cost field. If I try to change one of the values I get an error message saying "you can't...

Hi Thanks for that. It's really useful in another part of the report but I'm not sure how to use it in this case. The current address field [CustomerAddress] looks like this: 41 Highfield Roadn/Londonn/NW10 6QR And I need it to look like: 41 Highfield Road London NW10 6QR Would I use this...

Hi I am using a data source which is downloaded from a 3rd party website. The address format has the whole address as one string and each address line is separated by a "/n". I would like to use the delimiters to start a new line within the text box of a report so the address looks correct...