Recent content by GinaWhipp

  1. GinaWhipp

    combobox.setfocus "not working" on a continuos form

    Hmm, do you have a Set Focus anywhere behind that Form? Also, you did put it in the KeyUp event not the OnChange event right? The code I provided will fail in the OnChange event. EDIT: Stepping away for a bit, dinner and a movie. Will check for replies when I return.
  2. GinaWhipp

    combobox.setfocus "not working" on a continuos form

    Did you completely remove the On_Change event? You cannot Set Focus to the Control.
  3. GinaWhipp

    combobox.setfocus "not working" on a continuos form

    Hmm, give this a try. In the KeyUp event procedure of the Combo Box (might need some tweaking)... If Len(Me.Combo0.Text) >= 2 Then 'Set the row source to match user search criteria Me.Combo0.RowSource = "SELECT taglio.[num taglio], taglio.[cod modello], taglio.Quantita...
  4. GinaWhipp

    Attendance/Membership/Dues Database Example

    I took a peek.
  5. GinaWhipp

    Creating an Inventory System with Bills of Materials

    You are updating (subtracting) the parts the tblMainItemParts table from tblInventory. Though in your case you might be adding to your Transaction table to be subtracted from tblInventory. Can't say for sure how you add\subtract parts from your tblInventory without seeing it. You need to do...
  6. GinaWhipp

    Creating an Inventory System with Bills of Materials

    Not individual tables for each item, so... tblMainItem - wagon tblMainItemParts - linked to tblMainItem includes all the parts and there quantities linked from the inventory table. Then on the BOM you would use the ID from tblMainItem and run a query to UPDATE the Inventory table.
  7. GinaWhipp

    Creating an Inventory System with Bills of Materials

    Do you have a tables that hold the four items and the parts they need?
  8. GinaWhipp

    Creating an Inventory System with Bills of Materials

    Wouldn't the completed item go on the BOL? Oh, I see @arnelgp has posted a document. See if that helps as I would not be assembling the finished goods on the BOL that is where the completed item gets shipped.
  9. GinaWhipp

    Solved Loop through continuous form and assign value to textbox

    What new data? If it's a simple look-up from the drop down why aren't you showing it in the combo box instead of the ID? Or you could just show the specific column from your combo box in the text control. What am I missing?
  10. GinaWhipp

    Creating an Inventory System with Bills of Materials

    Ah, glad to know you are not starting from scratch. Well, not sure this will work for you but this is what I do. In the Inventory table there are two additional fields: iBillOfLadingID and iStatusID (it's shipping status). When the inventory items gets added to the Bill of Lading but has not...
  11. GinaWhipp

    Creating an Inventory System with Bills of Materials

    Welcome to the Forum! Hmm, You're new to Access and you are developing a small database for inventory, bill of materials, work order, purchase orders with all the other pieces and parts necessary AND you want suggestions. How new are you? This is relatively a hard business model for your...
  12. GinaWhipp

    Input Form to display sessions on one page

    Well, linking your subform on Weekday so you're right that won't work. Since you are showing all the Students why are you linking those Forms? That said, if you want to store which Students attended sounds like you are going to need an update query. Also, the Sessions subform should not be on...
  13. GinaWhipp

    Input Form to display sessions on one page

    So the Staff log on and see there Sessions? If so then why not show the Students attending that Sessions? Or do you just want to who all the Students?
  14. GinaWhipp

    Input Form to display sessions on one page

    Hmm, not getting it. Do students sign up for these classes? Because it seem to me you pick the Staff Member and then the Session which should then show the Students signed up for that Session. You can then enter the date and check off those that are present.
  15. GinaWhipp

    Solved How to automatic put file name [Microsoft Print to PDF]

    I think what you are looking for is a Loop. Have a look at... https://www.access-diva.com/vba3.html
Top Bottom