Search results

Thanks Hi Thanks for the advice - great help - i see what you mean now. Still in the learning stages of access but really enjoying it and everyone on here has been a great help.

To Calrify Hi thanks for your help on this. Will i lose the use of the table, as i still need to have this in the table as searchses are done by the period? If, so the user will just have to use a pop up calendar and make sure the date is correct. If so maybe you could let me know how to...

Hi I have two date fields. I would like to lock the second one and make it reliant on the first one e.g. plus 13 days. Can someone explain how i do this? Thanks

hi I have serached for the answer but can not seem to find it. I have a combo box that when a value is selected it finds the record. I have four fields with one hidden. The fourth selects the lookup in another table and only shows the value. I am unsure how to have it show the project name...

to clarify HI Thanks for the reply. The field is not bound to a table or query it is unbound with the calc in it. I have three a number of tables. Purchase Order Table Transaction Table Product Table Stock Control Table Once products have been added i put the main order info in tblPurchase...

Hi I am trying to add a field to the following calculation: =[Products Subform].[Form]![UnitsOnHand]-nz(DSum("[QuauntityOut]","IntStockControl","Forms!Products.[ProductID] = [IntStockControl]![ProductID] and isnull([IntStockControl]![DateIn]) = true ")) The new field is in the...

Thanks Great works fine thanks

Thanks thanks all sorted now and working well. scott

Hi I have a from with unbound fields on and i have it set up so when you type in the field click the button - it runs a query and finds the records. I have tried to add a combo box that gets the actual value from the field (avoids people typing wrongly) which it finds the values fine, but the...

Adding another field to calculation Hi Further to the posts above - i would like to add a quantity back in to the on hand calculation field. The formula above works but i would like to add this extra field to the calc. Thanka for your help! scott

Hi I have a date out field and would like to have a tick box that is ticked to say it is not coming back. when this gets ticked it locks the date back in and quantity back in fields, also if it gets unticked then it enables them. Could someone help me on this? Thanks scott

Thanks Thank you - works fine now. Appreciate your help!!! scott

Help again Hi I have tried what you said but it seems to just ignore the text and say ' the field can not contain a null value'? Please help - thanks scott

Hi I have two problems. One when a required field is set to yes - i want to change the error message to something more meaningful. Two i would like to stop people enetering data into a sub form on the main form when there is no data in the main form? I linked them using the wizard. So main...

Please explain Thanks for the info - but how do i do that? When i open the main form with the sub form attached - it still allows me to enter data into the subform if the main product record does not have a record. I understand what you are saying but how do i make this happen? Thanks

Hi Could someone please tell me the code to stop a user accessing a subform if there is not a related field in the main form. I keep getting 'this field is required etc' then having to close the db before it will let me carry on. Thanks Scott

Hi Put this in the wrong forum - so here goes again.. I have an invoice table and then an invoice line items table. In the line items table I have field 'work order number' i.e. each line item will have a corresponding work order number. The db at the moment gets these numbers from a look up...

Hi Not sure if this is a form or table query, so here goes... I have an invoice table and then an invoice line items table. In the line items table I have field 'work order number' i.e. each line item will have a corresponding work order number. The db at the moment gets these numbers from a...

Hi I am trying to summarise how much of a product i have in stock but it keeps returning every line item that have been transacted. e,g 400 have been ordered in 5 transaction but rather than it list the item once and tell me how many are in stock it gives every transaction so say nails list 5...

Hi I am trying to create a query that when run will automatically take todays date and include the last 7 days into account. It is for stock received in the last 7 days. I have done a search but still a little copnfused. Many Thanks