Search results for query: *

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

Hello, I am not sure if this is possible in Access - hopefully somebody out there can help. At the moment I have a single form which searches for a record, then performs a calculation on the information in that record and changes the back colour of each control accordingly, ie. assigns a status...

Hello, I am trying to create controls on a form from the items selected in a list box on a seperate form. At the moment, my code only reads the first item selected in the list box, then jumps out of the If...end if statement, I am sure it is obvious, I just cannot seem to work it out, have...

Hey, thanks for the fabulous detailed response. Will give it a go. For the time being I'm exporting to comma delimited text files. Thanks again for the great responses.

Yes, it is definitely bigger than that.

Hi there, I've got an automatic export running off one of my tables into excel. I have recently added a field called "Detail", the field type is memo, when this field exports to excel it cuts half of the contents of the field out. Can anybody suggest the most efficient way to get around this...