Recent content by HeavyD

  1. H

    Auto Duplicate Record based on QTY

    New snag, same thread. One of the fields I am trying to duplicate is an attachment field to a PDF. I learned quickly that this can't be done. In addition, duplicating PDF's for every record will quickly increase the size of the DB to undesired proportion. I explored using OLE instead, but I...
  2. H

    Auto Duplicate Record based on QTY

    @arnelgp Well sir. That would have taken me a long time to do. Thank you very much for the bump in the right direction.
  3. H

    Auto Duplicate Record based on QTY

    Ok, I have the loop functionality working. Next: I need to make N new records from the same form. @arnelgp , tell me more about this INSERT INTO I Public Sub Command134_Click() Dim i As Integer Dim QTY As Integer QTY = Forms!Purchases!Quantity.Value i = 0 Do While (True) 'MsgBox "Loop" INSERT...
  4. H

    Auto Duplicate Record based on QTY

    @ plog Good 'ol trial and error. Private Sub Command134_Click() Dim i As Integer Dim QTY As Integer QTY = Forms!SCA_Add!InvoiceDetailActualQuantityReceived.Value '<---- seems to work i = 0 Do While (True) MsgBox "Loop" i = i + 1 If i = QTY Then Exit Do Loop End Sub
  5. H

    Auto Duplicate Record based on QTY

    @plog, yes please! Tell me how. The actual form name is SCA_Add and the Field name is InvoiceDetailActualQuantityReceived Private Sub DupeRecord() Dim i As Integer i = 0 Do While (True) MsgBox "Loop" i = i + 1 If i = SCA_Add.InvoiceDetailActualQuantityReceived Then Exit Do '<------ this...
  6. H

    Auto Duplicate Record based on QTY

    I'm spinning my wheels here. Overall objective remains the same, I'm just breaking the problem down into smaller pieces. How do I pass an integer value from a newly filled form to a subroutine. This is just a testing subroutine. I'm trying to pass the integer value of the Quantity field to the...
  7. H

    Auto Duplicate Record based on QTY

    Good day folks, I have an inventory DB that generates current inventory by comparing two tables, "Item Purchases" and "Returns". During the form entry of Item Purchases, I would like to duplicate the record N times, where N is equal to the QTY of items on the form. I would like to incorporate...
  8. H

    Programming Languages used in Access

    Hello folks, So far Access has proven to be a very powerful tool. I have enjoyed the learning experience. I do have a question regarding the different programming languages used in Access. How many languages are there? I've seen this: Public Sub MakeNew_Click() DoCme.SaveRecord...
  9. H

    Copy fields to new record

    Thank you The_Doc_Man, I'm exploring the Command Button Wizard -> Duplicate Record. I keep getting an error, "command or action 'paste' isn't available now" If I click the button to save the record first, the DuplicateRecord works for about 3 entries, but then throws the same error. I tried...
  10. H

    Copy fields to new record

    Lovely folks, I would like to be able to copy select fields from one entry to the next. I have product return forms that can have an arbitrary number of items on it. The items may vary in serial number, asset tag number, and possibly product name. All other fields on the form will be the same...
  11. H

    Solved Change record field using Form fields

    Hmmm, try Find Unmatched Query Wizard. I got this... +1 for HeavyD :)
  12. H

    Solved Change record field using Form fields

    Alright folks, I took your advice and created a table of Orders and a table of Returns. The current Inventory is realized by by comparing the Orders and Returns tables. Anything not common to both tables is my Inventory. Each item in the Orders Table and Returns table have unique serial...
  13. H

    Solved Group By Name then Count on criteria of another field

    Well s*&^%! Turns out I can't display the results of a query in a text box. I read that I have to use DCount(). Is there a translation for the query above to DCount() format?
  14. H

    Solved Group By Name then Count on criteria of another field

    Thank you arnelgp. This is exactly what I was looking for.
  15. H

    Solved Group By Name then Count on criteria of another field

    Thank you pbaldy. While your suggestion did fix the error, the result was not what I was looking for. This gave me the number of ProductNames that individually don't have AssetNumbers. This is lilely a result of my poor ariculation of the problem/question. Thank you though. I will put this in...
Top Bottom