Search results

  1. A

    Table Design help

    Hi Fran Im struggling with the setup of the Receive Detail Form, Have you got any pointers. I want the form to load working out the quantity already received for each item if any. And be able to receive more items which will in turn create a new record in the Receive Detail Table. thanks
  2. A

    Loop through SubForm recordSet

    can you use an append query to loop through all the data on a continuous form?
  3. A

    Loop through SubForm recordSet

    Is there a way of looping through a non update able continuous subform, and using information from each line. Which creates a new record in another table? so if there are 3 records in the subform it creates 3 new records in the other table and so on? thanks!
  4. A

    Add new records to subform on load

    Has anyone got any ideas? thanks
  5. A

    Add new records to subform on load

    The form is used to populate the Receive table and ReceiveDetail Table. So when ever the form is opened it is to receive an item line. therefore it will create 1 Receive PK and if there are 15 items for that order, it will create 15 Receive detail PK. The aim is to automate all of Receive...
  6. A

    Add new records to subform on load

    I have got a received form that has 2 subforms. The main form is based on Received Table The 1st subform is based on a query that shows the order detail and how many units are outstanding. The 2nd subform is based on a receivedDetail table. so will have a list of items with the original order...
  7. A

    Sum a field then minus

    i managed to sort it with the following, seems to be working ok! RemainingQty: Avg([tblOrderDetail].[Qty])-Sum([tblReceiveDetail].[QTY])
  8. A

    Sum a field then minus

    Im trying to sum a qty field naming it 'TotalRecieve' and then minus a qty from that sum? i've tried the following RemainingQty: Sum([tblReceiveDetail].[QTY])-[tblOrderDetail].[Qty] but i get an error saying 'Your query does not include the specified expression as part of an aggregate...
  9. A

    Table Design help

    Thank you Fran, can you give me any pointers or sample code before i get stuck into coding? thanks
  10. A

    Table Design help

    Thank you Fran im glad im on the right lines, i have also added a partial received too. With regards to marking an order as fully received how did you go about this do you need to Code? e.g all 3 items in the order detail table are fully received this in turn should now make the Order header...
  11. A

    Table Design help

    Hi There im after some advice im setting up a Purchase order System, i am now onto the Receiving orders section. I have an Order table and Order Detail Table. I was thinking of setting up a Receive table and Receive Detail Table. Does this sound like the best way to set it up? I want to...
  12. A

    Change Subform allowadditions from mainform

    Hi George I have tried that, I cant seem to refer to my subform as it dosnt like the name? even though sfrmPurchaseEdit is what its called?? I did copy this subform from another and renamed it could that of caused an error??
  13. A

    Help changing code

    Thank you namliam just got round to trying your suggestion! works a treat thank you!!
  14. A

    Change Subform allowadditions from mainform

    I have tried me.sfrmPurchaseEdit.form.allowadditions = True but im still getting a Method of data member not found and it highlights the sfrmPurchaseEdit. This is the name of the subform so im a little lost?
  15. A

    Change Subform allowadditions from mainform

    Is there not a way to refer to the subform, to allow additions basically I want to click a command button on the main form, to switch the property of the subform to allow additions? thanks
  16. A

    Change Subform allowadditions from mainform

    I have tried the above but get a Compile error: Method or data Member not found? i think it is the name of the source object is that where i am going wrong?? what should i be referring to?
  17. A

    Change Subform allowadditions from mainform

    Hello, i am trying to change the allowadditions property of a subform from the main form? but having little luck the main form is called frmPurchaseEdit and the Subform is sfrmPurchaseEdit i have tried a few variations but nothing seems to work? any ideas? thanks
  18. A

    Help with Continuous form

    I have a continuous form and having trouble with the layout. When i fill in the record and then tab to the new record it displays the textboxes on top of the last one instead creating a new line bellow? Ive tried everything but cannot figure it out? thanks
  19. A

    Help changing code

    Hi There i have the following code that hides 5 buttons depending if the user has permission which works fine. im trying to incorporate an IF statement if there is only 1 of the buttons visible then to automatically click the button. but if there is more than 1 do noting? Private Sub...
  20. A

    Option button to filter Query on Form

    thank you for the post. i have tried the following code, it dosnt throw an error but dosnt create a filter? If Me.OptUser = 1 Then Me.RecordSource = "Select * from qryOrderSummary where Username=" & Chr(34) & Environ("Username") & Chr(34) Else Me.RecordSource = "Select * from qryOrderSummary"...
Back
Top Bottom