Search results

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

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?

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

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

I htink thats it?? :S

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

How do i compact and repair?

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

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

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

What do you mena number format? how do i do this? Regards

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

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

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

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

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

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

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

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

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