Search results

please find db attached hi would be really grateful if you can help me with this. open db - enter/view stock control and the bottom sub form needs to calculate with the units on hand in the main form. many thanks

Hi I have a main form and two sub forms for a stock control db. The main form shows the product with controls for units on order and units on hand. The first sub form handles stock transaction from a seperate purchase order form. This sub form has 'units ordered' and 'unit received' fields...

Hi I would like a control to have focus when a form is opened or press a button - how do i do this? Many Thanks

I have two sub forms and need one field to equal a field in another sub form. When I enter data (a number) I would like the field in the other form to add up all the fields in the form I just enetered the data in. Both sub forms are datasheets. thanks

thanks for helping. how do i get a record to get focus when a form opens or a button is clicked on? thanks again

tried so if i link the employee id field in the main form/table with the employee id field in the subform/table this will update the subform for me automatically - when i do this it says intermediate link? thanks

A liitle more explaination I have subform within the main products from that shows all the trasnactions. in the manin form i have a 'units on hand' and 'units on order' control. Main Form looks like this in the properties =[Products Subform].[Form]![UnitsOnHand] =[Products...

this helps but still a little unsure Although I can see the emplyee id in the main form - and in the sub form - i would like the sub form employee id to automatically have the main form employees id in it when i create the record in the sub form? thanks for your patience! scott

hi is there away to filter rows when certain values in three different tables are the same. e.g. it is a stock control db - so when goods orded = goods in = goods taken - can this then be filtered automatically to hide rows and avoids congestion on the user interface (form)? thanks scott

hi i have a stock control db - when placing an order in the purchase orders from - i would like to use the sum function to work out how many units i have on order in the products form then when goods are recieved have this work out units in stock - and then when goods are taken out have this...

hi is it possible to update a field after exit from another one? i have a purchase order form (main) with employee id. i then have a sub form (datasheet) that can have unlimited products relating to that purchase order. I would like the employee id once entered into the main form to...

explained better can i not use a bit of code e.g. on exit update the required field? I have an employee table - the thing is the person entering the data is usually not the person who ordered it, which is what i need, the person who ordered it. In the main purchase order form there is an...

can i not use a bit of code e.g. on exit update the required field? I have an employee table - the thing is the person entering the data is usually not the person who ordered it, which is what i need, the person who ordered it. In the main purchase order form there is an emploee id to show who...

Hi Forgive me - but i am new to db. I have an employee field in my purchase orders from and when I do stock transactions - i have an employee field against each item in the purchase order. I would like to just copy the employee field from the purchase order form automatically next to each...

hi i have a stock control db. when new stock is ordered it updates 'units on orders' field, then when goods are recieved the subform field is updated and this automatically updates the 'units on hand field'. i then have another subform for stock going in and out, i would like to be able to...

Hi I would like a form to get focus on a record when the form is in view. I would also like to close a form when it is not in view. This needs to be done automatically i.e if another form is opened by pressing a button etc. thanks

A bit unsure Hi thanks for the reply. I do not want to delete the records, I just need the db to tell when the date has passed? Thanks.

Hi I have a db that has 3 tables for an archive. tbl 1 - contains details of a contract contract no pk contract name etc. tbl 2 - contains details of a box there can be any number of boxes relating to a contract contract no pk box no pk yes/no - is it in the archive tbl 3 - for when a...

Hi I have a form and on it I have two date fields, what I would like to do is enter one dat in one of the fields then have the other field automatically update to five years from that date. I would then like a message box to tell me when the date that is five years later has passed and I can...

Hi I would like to create a db that assists me when I type. I would like to select from a drop down box the make of a laptop then once selected it fills out the other fields for me i.e the model and whether it is suitable. The makes used are all the same model so the is fine. Thanks in...