Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. turnerk200

    Round Down

    Thanks Bob that works a treat! kt
  2. turnerk200

    Round Down

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

    loop through fields

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

    loop through fields

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

    loop through fields

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

    refreshing recordsource

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

    refreshing recordsource

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

    refreshing recordsource

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

    DATABASE LOCKED

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

    DATABASE LOCKED

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

    SEARCH IN SQL STRING

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

    DATABASE LOCKED

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

    SEARCH IN SQL STRING

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

    changing color of record (not control) on continuous form

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

    List Box colours

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

    changing color of record (not control) on continuous form

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

    Generating a form from the selected items in a list box

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

    Field Type Memo in Automatic Export

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

    Field Type Memo in Automatic Export

    Yes, it is definitely bigger than that.
  20. turnerk200

    Field Type Memo in Automatic Export

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

Part and Inventory Search

Back
Top