Recent content by fluffyozzy

Galaxiom, good to know the proper convention, thank you. I've just tried it with my code with the way isladogs suggested and it works too. I learn more on forums than any course I paid through the nose for :D

Mmm.. Yes, both fields are number datatype. Just ran about 10 tests with what I have and it is doing what I wanted. To clarify, the person ID is not a combo, only the QstID is selected from a combo, PersonID is just an ordinary number field on the form :)

Thank you to both of you! isladogs, I should have had that link ages ago! Very useful. And arnelgp, thank you so very much, it all works perfectly. I wasn't thinking clearly at all this morning LOL. So, the final working solution is: cmbValue =...

Hi guys and girls, What is the correct way to refer to a combobox column in vba? I'm trying to reference a combobox column on a form as a parameter in dcount statement but it's not working. It's probably something really simple but totally stumped me. This works: CountOfID =...

You are a star!!! That did it... These double-quotes and ampersands and where/how they are used will be the end of me. Need to read up on these things again. Thank you so much :D Have a lovely weekend :p

Thanks Minty, unfortunately, the field name is misleading, it is text... just can't seem to be able to get the syntax right

Hi everyone, I'm having a bit of a brain-freeze here and hope someone can help me. This loop does not seem to be working, could you please cast your experienced eyes over it and see why? It is getting stuck at rs.FindFirst strFind line. It's likely to be a really rookie mistake as I'm kinda...

Thanks for the replies... much appreciated. I thought I would need a second loop so that I wouldn't have to specify the ID number at the beginning, so that it would go through the entire table one-by-one, look for matching values on one field and update the others accordingly. I will look...

Actually, this is going to be a one-off operation. Trying to fix tables exported from Excel for the existing records (of which there are thousands without correct values in the correct fields, sigh). I do have a procedure set up to update the fields with the correct values for new records and...

I'm sure this is really simple and I'm missing something silly. The following code works perfectly for what I want to do only if I specify the criteria in the sql statement. Dim rst As DAO.Recordset Dim rsta As DAO.Recordset Dim data1, data2 As Integer Dim db As Database...

Oooh, that sounds nice and simple, just the way I like it :p Thank you very much :D

Hope someone can help me with this :)) I have a tabbed form on a database back style of which is set to transparent and works great when I uncheck the box "Use Windows Themed Controls on Forms" option in Tools > Options. Is there any way to uncheck this option automatically by a piece of code...

I think it can be done how you want it - everytime I have to do a form based on junction table I despair, if I'm honest LOL Apologies for not being more helpful. Fairly sure there are others here will know exactly what to do. Good luck :)

Respect! IT WORKS! Thank you so much for all your help Banana, very much appreciated :D

Okay, I have now used the rst.MoveLast - it sort of works, it does give the message at the appropriate time, ie, when the quote limit is reached - inching slowly to the final solution. rst.MoveLast assumes that there are records already present with the specified parameters. This is not always...