Search results

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...

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

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...

@ 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

@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...

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...

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...

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...

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...

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...

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

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...

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?

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

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...

Hello lovely people, I'm trying to Group By ProductName, then Count the ProductNames that are still pending an AssetNumber. InventoryTable ProductName AssetNumber ProductA pending ProductA pending ProductA pending ProductB 1234 ProductB...

Thank you June7 and arnelgp. I feel like you're both on the same page with your respective recommendations. This raises some fundamental questions about the database that I have. Thank you both for your insight. Thanks for the welcome, theDBguy.

Good day lovely people, Still getting familiar with the various Access Functions. Status: Intermediate Noob. I've built an inventory table that looks like below. The Order# is always maintained with the database record. Inventory Table: Product | QTY | Order# A ------- 4 ------- 1111...