Search results

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...

I understand the performance penalty with this. It is something we have to just put up with it, unless there is another way of counting records effectively. I have still not completely solved my problem, the code still runs through without stopping at the appropriate place.

Thanks Banana, Mm, okay, I have taken your advice and did the following, now the code just runs without taking into account of the first part of the IF statement. It never takes into account if one value is higher than the other, it should give a message. I'm fairly sure this is simple to do...

Could I ask another teeny weeny question please? I need the DCount to count the results of the rst rather than straight from the table like below. How would I reference that? intCountMCQBatch = Nz(DCount("MCQBatchID", "MCQBatchTbl"), 0) I tried intCountMCQBatch =...

Of course!!!! Yet another d'oh moment for me :p :D Thank you very much for you help guys, much appreciated.

Hi ByteMyzer, Thank you so much. It is at least going through some lines of code, makes me feel hopeful again. But, it gives me an "object required" error on the line below. Any ideas why? intQuoteLimit = QuotesTbl.NoOfCands The QuoteID is the primary key of the QuotesTbl, so, it is a...