Using insert into command

[andyrew30]

Hi,

I am at work, and I have acquired a database that prints labels. They now want the database to be coded so that after certain labels are printed the database will print a blank label. I have the code figured out as a Do While statement in order to print the blank label. The problem I am having is that I am trying to use the Insert Into command to insert the filepath into the table that adds the blank label.

|DoCmd.RunSQL "INSERT INTO Rod_tmakLabels ( Print, [Order] ) SELECT Yes AS Expr1, 'Rods Labels' AS Expr2"|

If I run the above command, it just adds the text "Rods Labels" at the end of the table. Is there anyway with the INSERT INTO command that I can insert the new label between the 2nd and 3rd row and add another row? Or is the command designed only to add a new row to the end? I haven't had any luck searching for this yet. Hopefully someone can help me out.

Thanks

 

[Mile-O]

Trying to understand this...you're trying to insert blank rows into a database table? If so, it goes against the idea of a database.

coded so that after certain labels are printed the database will print a blank label.

Is there any logic to these 'certain labels'?