Search results

Hey guys once again i need your expert advice please. I have a form (frmEquipmentHire) with a subform (TESTSUB). in the subform is the prodcut ID and name, Quantity on hand, the Quantity order, and the price. Basically i need an update query to update the quantity on hand field in the back...

Hi guys ive got a login form and im trying to put together a change password form also. now what i have already is a form with combo box for the username (combo0) a text box (oldPassword), and two more text boxes for (newPassword) and (verifyPassword). I think its all quite self explanitary for...

Ok guys so i have an inventory database which is really simple. im not sure if i should use a form or report for my next stage though. Basically i need it to do this: Enter client name and address Enter dates times etc Enter location draw from an employee table what crew will be on the job...

Hey guys I need your awesome expert advise once more. Basically ive finished my database for the mean time and i want to implement it into the business i have created it for for a tral period of a month. Heres the database in boht 2007 and 2003 form: K so give me your views on the databse...

Hey guys On a form i have got a combo box for the Product_Name [Product] and 3 text boxes linked to the combo box to show quantity[Product_Qua], unit[Unit] and section[Section] for the product. They are linked to the combo box by the =[Product].[Column](2) command. All i want to be able to do...

K i built two forms with one of the templates, but ive decided i dont liek the template any more and want to get rid of the header and footer design, but when i right click and press page header and footer to take it off, i does it but the background that came with the template stays at the top...

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

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

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

Hey guys, Just undetaken a project for work using access 2007 Im not very literate with 2007, i knew a little bit of 2003 but not very advanced. Basically i have a combo box for the products which is link to my Product_tbl and the field Product_Name. This then obviously shows all the products...

Hi guys, Pretty big situation here. I have done a few access databases before, no higher then advance beginner maybe intermediate levels. But ive recently been given a job to do by the company i work for, and its to create a database with this specification: Input new stock - where it is...