Search results for query: *

Hi Duane, Yes, this is correct and I was able to play around with the placement of "" and finally got to work =Code128("~212" & "91" & [Delivery Docket Temp.SpecNo] & "" & "(37)" & " " & [Weight],1,True) Thanks,

Hi, I have a barcode report that prints the following barcode in the following format. (91) 10200169 (37) 1 It use the following control source: =Code128("~212" & "91" & [Delivery Docket Temp.SpecNo] & "" & "(37)" & [Weight],1,True) which is taken from a table called Delivery Docket Temp...

Hi Duane, Sorry, the code works fine. It is called from the main form that calls the popup print form which the user just clicks a control to print the report (record source the Delivery Docket Temp Table) Your right the name of the source object is the Delivery Docket Temp Table which is...

Hi, How do you call/refer to a subform (Delivery Dockets) of a form (Jobs) from a popup form (Print Screen). I have a form called Jobs and subform called Delivery Dockets. I have cmdButton on the main form that runs the code below to open a popup form called "Print Screen" for printing reports...

@PHV Thanks very much that did the trick....

@Trevil620, Thank you for your reply Sorry but I am not calling through the SQL method I am using the DoCmd to run this append query from the main form DoCmd.OpenQuery "AppendDeliveryTemp", acNormal, acEdit How would I use your vba code with this? Thanks again,

I need to append a single record of a subform named Delivery Dockets on a form called Jobs to a temp table named Delivery Dockets Temp more than once depending on the number entered in a field named "Pieces" in the subform. I currently have a button on the main form Jobs that currently calls...

@dhookom No I don't need to create and save records. only generate records in a query to be used in a report.... Main Form: Jobs Datasource, Table: Jobs JobID - Autonumber Subform: Delivery Dockets Datasource, Table: Delivery Dockets Delivery DocketID - Autonumber JobID - Number...

Hi Randy, Thanks, will toy around with your example. Hi Duane, Yes, I was thinking the same approach Basically, there is a data field named "Pieces" on the subform datasheet. Users can enter a number from 1 to 20 or more. What I need to do is generate a delivery note for however many number...

Hi, I have a form called Jobs and a subform called Delivery Dockets. In the the subform I have a the following fields called pieces and description. In the field called pieces our user can enter any numbers from 1 to 20. I need to some how create a code that can generate multiple records for...