Recent content by turnerk200

Thanks Bob that works a treat! kt

Hi, I have a simple bit of code that makes a calculation (see below), then rounds it to 2 decimal places, but it always rounds it up, I need it to round down. I've looked through here and I'm sure it's simple but cant work it out! Any help would be greatly appreciated. Thanks, Dim intBPS As...

Hi Craig0201 - disregard my previous post, have got it working - thank you very much for your help and have a great day. kt

Thanks Craig0201 for your post, however, some of the fields the code you have given shows an error when trying to asign a null value to an array. Am I missing something? Thanks again for your help. kt

Hello all, I have a situation where i am trying to check a recordset, the recordset will only have 1 record in it and I need to loop through say 12 fields and check that at least one of them has the value "-1" in it. Is there an easy and quick way of refering to the fields as a set and looping...

Tried both, still doesnt work, it works adding the second record but never the first.

Hi, thanks for your response, i tried it but still the same. It adds the data to the underlying table but the subform doesnt refresh.

Hi there, I am trying to refresh the recordsource on a subform - my code is below. When you click the add button once it doesnt refresh, when you click it twice it does - can anybody see what I am missing here. Thanks, kt Private Sub Command10_Click() Dim db As DAO.Database Dim rs As...

Take that back - it is still doing it! Any more ideas?

Thanks very much for your response, i had released the d/base object, but not the recordset object, this seems to have done it. Thanks again.

Thank you!! Yes it works, so simple yet drove me crazy! kt

Hello there, I am currently using DAO to open a recordset in my database which is working fine, however when i go to run the code a second time i get the following error message. Run-time error '3734' The database has been placed in a state by user 'Admin' on machine 'W00497' that prevents it...

I have a form which is used for searching, i am using a field called "txtMatterName", in this field, for example i want people to be able to type "turner", and the code will find anything in the field with "turner" in it, for example "Ray Turner". I am doing this by opening a record set with a...

Thanks Bob, that was a great help, managed to get it working with conditional formatting.

Hi ChrisPerkins - I am having the same issue as you, did you find out how to get msflexgrid?? Thanks, kt