Search results

thanks for the posts guys, is it a similar sort of proceedure if i would like to select a particular field for a record? So pretty much the same as writing as i have just done, but in reverse, so just reading the value into a string in vba?

I know, it'll have taken me approx 200 hours to create!!! But dust seems to be a common problem with students work :p grrrrr but you never know, if it passes the seal of approval it may go on to be used for the purpose intended :)

It tells me that I'm about to update 1 row but would ideally like to turn this off so then the user just clicks and the program does its job. I don't ever require feedback as the records will never change apart from what I initially asked for :) how do i go about turning off the update warning...

Everything should be ok for now. My whole system has got spaces in and is a pretty big thing to go back and change it all so will have to leave it like it is for now. Its for my final year university project so hopefully when I submit it and its been graded, it will just sit there gathering...

Thankyou very much WayneRyan thats worked an absolute treat!!! I can't tell you how much you've made me smile. Been tearing my hair out for hours wondering what to do :o

Why is that? What sort of things will it complicate? Thanks for your help so far, your a life saver. Just hope i get it to work :)

Basically I have a table, "Turbine Parameters", that contains several fields, 2 of which are "Yaw Colour" and "Yaw Failure Date" and these are the ones I want to update. I am selecting the specific record set from another field called "Turbine Number". In the VBA code I am returning values for...

Hi all, Pretty much a complete n00b to anything thats more advanced than a few tables and forms but have managed to write a whole load of VBA script which essentially returns values into strings from a whole load of stuff in excel. Now my question is, can i take the value in my string from the...