Search results

  1. T

    If statement for image

    hey On one of my forms (Products In) has a text box on it the shows what unit a product is in, either 9 or 10, and basically when the unit shows 9 i want an image to show of unit 9 layout, if its 10 then i want an image to show a picture of the layout of unit 10. Can anyone assist me in...
  2. T

    Oat-so-simple but i dont have a clue

    I have doen this but like i said before when the text box is idle I.e i havent pressed enter, it is showing #Error until i do press enter?
  3. T

    Oat-so-simple but i dont have a clue

    Ok so what code should i input to get this to work correctly and where should i input it? Thanks guys
  4. T

    Oat-so-simple but i dont have a clue

    aha here you go BTW i closed my database and restarted it and the solution bob gave that worked originaly well now its showing ####Error when its idle but the once i input a test value and press enter it does the function it should. Any idea?? Im goign now but i will be back online...
  5. T

    Oat-so-simple but i dont have a clue

    I htink thats it?? :S
  6. T

    Oat-so-simple but i dont have a clue

    Sorry guys its not letting me upload but i dont know why.
  7. T

    Oat-so-simple but i dont have a clue

    How do i compact and repair?
  8. T

    Oat-so-simple but i dont have a clue

    It works! Ok like the other person i am also curious as to why the original calculation didnt work because if i was substracting or dividing it would, it just didnt add :S
  9. T

    Oat-so-simple but i dont have a clue

    None of the text boxes are bound to any of my tables I created them in the form using the controls.
  10. T

    Oat-so-simple but i dont have a clue

    HAHA ok ok i totally know where your coming from honestly and i will take your advise. Sorry for wasting your time, i do have a basic knowing of access but i learnt that a long time ago and its just slipped my mind :/ Ill take it all on the chin
  11. T

    Oat-so-simple but i dont have a clue

    What do you mena number format? how do i do this? Regards
  12. T

    Oat-so-simple but i dont have a clue

    K im going to sound really silly now but i just cant figure it out. I have a text box on my form called Quantity and it get its data automatically inputted from a combo box also on the form. I then have another text box called Quantity_In that the user inputs a number. this hasnt had any...
  13. T

    Error when clearing form

    Hi guys Basically i have created a form (Majority unbound) and wanted the user to be able to save the form (done) and then clear the form in order to input the new data. I already have a clear button that clears a majority of the controls on the form using this VBA code Private Sub...
  14. T

    Combo box help

    Ok forget everything said in my last post!!! I HAVE IT WORKING!! Galaxiom you are The galaxy of galaxies, your such a life saver, is there any way i can recommend you or put a star against your name, anything? And if you dont mind with any future problems would it be possible for me to...
  15. T

    Combo box help

    So i created the query by entering the code you gave me and replacing with my values into the SQL part of the query but it doesnt affect the table or anything:S any guidence please? What does this code actually do? Also what is the last part line of the code doing? And also how do i...
  16. T

    Combo box help

    Thanks thats alot simpler haha, so if thats to reduce by one, what if i want to reduce the amount by however much the user inputs into a textbox (Quantity out)?? How to i actually create the query on Access?? Also will this store with the record so when the next user opens up light ones...
  17. T

    Combo box help

    But i dont have a rental table heres my table structure: Basically i have a table (Product_tbl) with the following fields: Product_ID Product_Name Product_Qua Unit Section And a second table (Cost_tbl) with the following fields: Cost_ID Product_ID Job_price Rent_price RRP...
  18. T

    update quantity - ALREADY READ ALLEN BROWNE!!

    OK so can you help me do this in simple english language? lol its just eveyone uses jargon to me and then i still dont understand. Literally a step by step guide for me to do this?? Thanks
  19. T

    Combo box help

    thankyou very much for your assisstance. I have managed to get the first part working! YAY! But i dont fully understand what you mean by the second part of your post OR maybe i didnt make my post clear enough. For the second part what i want to do is lookup a piece of equipment (LIGHT1) and...
  20. T

    update quantity - ALREADY READ ALLEN BROWNE!!

    Hey guys, Im really quite new to access 2007, and im trying to build a simple inventory system where a user can bring up the item he/she wants and it automatically shows the quantity of the product, the unit the product is in and the section its in (I also want to show the costs etc in a later...
Back
Top Bottom