Search results

Hi I want to create a query where the field being reference is an employee ID in a purchase orders table. I have a sperate employee table with all the employees in and the employee ID in the other tables is set so that it displays the name in the forms. I would like to set the query up so...

Thanks for helping Hi Neil Basically i have not done too much. I create three tables. One for the employee - name, department etc One for the Equipment - make, model etc One for the transaction - date out, date in etc. I then put the employee id and equipment id fields into the transaction...

Thanks for helping Hi Neil Basically i have not done too much. I create three tables. One for the employee - name, department etc One for the Equipment - make, model etc One for the transaction - date out, date in etc. I then put the employee id and equipment id fields into the transaction...

Hi I am new to db and would like to do a simple db for items of equipment going out and coming back in showing who has been allocated what. So one person could have many item but the item can only be issued once until it is booked back in. I would also like a history of transactions. Only...

thanks guys but... thanks for all your help - i am getting there - got the unbound controls on my form using combox box to link to query. the code pat gave me - i put in the on click event of my command button? do i need to change any of it or can i just copy and past it? Many Thanks Scott

thanks thanks for your help. got it working fine now. i do appreciate your input thanks scott

help still needed! Thanks for tthe advice, however i am still un sure what you mean. if i just add a command button and run the query it does not give me the option of users being able select how they want to search. In an ideal world - i would like people to run the query by - pressing the...

still need help Hi thanks for that. I think I understand the form/unbound controls bit. What do I do after that? Add all the code to each control? and where/how? sorry for my lack of knowledge but thanks for your help. scott

Hi Apreciate your help on this. I have a stock control db and when goods are recieved they could have a different references on them e.g. our internal ref, the purchase order ref etc. I would like to run a query that firsts ask what criteria i want to use to run the query e.g use the int ref...

refresh main form data after update from subform Apologies for asking this question again. I want to refresh the data on the main form to refrsh the calculations after updating a field on my subform. I am using the following code in the afterupdate event: Docmd.Runcommand.accmdrefresh...

further explanation Thanks for your reply. I now realise it is comples subject. And I am ok with db but not an expert by any means. I do not want to wish I did not start as it will really solve a problem here if i can getb this new feature to work. Now I am going to ask that you walk me...

Hi Firstly let me thankyou for your help because I feel this may be a difficult question. I have a stock control db that records transactions through purchase orders, which allocates each line item (product) in a purchase order to an employee and a project it is destined for. I have three...

could you explain this in more detail hi thanks for helping with my question but being new to db - i need this explained in detail. many thanks scott

More clarification Thanks However I am new to db - what will the code look like? thanks again

Hi I have a sub form and a button on the main form that needs to be pressed to refresh the data in the main form after data has been entered into the sub form. Is it possible to have the main form refresh on exit from the sub form field automatically without having to press the button?? Could...

Thank you Thanks you have been a great help!! Scott

Thanks - last question Thanks again for the reply - that works fine - by jumping between records. One last question. In the stock control how do i stop a record being entered if there is not a product and transaction record? At the moment if you click to enter a new product record it is...

hi Thanks so much for looking at that for me. The formula works but it only updates after you close the form then open it again? is there something i can do to make this update straight away? thanks again - you have been a great help.

hi Thanks so much for looking at that for me. The formula works but it only updates after you close the form then open it again? is there something i can do to make this update straight away? thanks again - you have been a great help.

hi Thanks so much for looking at the for me. The formula works but it only updates after you close the form then open it again? is there something i can do to make this update straight away? thanks again - you have been a great help.