Recent content by dzdncnfsd

Thank you for all of the replies. I think there is a lot of useful info here that I can use in several situations I am dealing with. Gladys Gladys Clemmer

FVTrainer, Wow, lots of info!! I don't have access to the VB code for this particular application, so I think the stored procedure method will work for me. Thank you so much for your help. Gladys Gladys Clemmer

Thank you mjia. Will let you both know how it works out. Thanks, Gladys Gladys Clemmer

Thank you Zhavic. I will give it a try ASAP. Gladys Gladys Clemmer

FVTrainer, They are running it from within a VB app. I am using Avery Label 5161, so there are 20 labels per page. (2 x 10) I have a parameter field that allows them to specify one item that they need multiple labels for. They may need 1, or they may need 50. Thanks, Gladys Gladys Clemmer

Is there any stored procedure I can run that will show me all of the tables with 0 records in a database? Thanks, Gladys Gladys Clemmer

I have a report that allows the user to specify an item that they want to print a barcode label for. Now I need to add the capability for them to print multiple copies of the same label. I can set up a parameter field for them to choose the number of copies they want, but I don't know how to...

Are you sure they are in the page header and not the report header? Gladys Gladys Clemmer gladys.clemmer@goldkist.com

How do I suppress a pageheader for a Group Footer that I want to print as a separate page? If I use "Not OnLastRecord" in the conditional suppress box in the PageHeader section, I might not get any pageheaders at all because the last record may be on the first page. I need it to...

I left that company over a year ago, so don't have immediate access to the code any longer, but I believe that I did wind up using a running balance field on the report. However I am working on something similar to it today, so I will advise you if I find a better way to do it. Gladys Gladys...

Fantastic! Thank you so much Naith. Gladys Gladys Clemmer gladys.clemmer@goldkist.com

I have a report with a couple of group footers that contain running totals, and a report footer with a grand total. I have a page break after the second group footer, so everything is fine until the end of the report - the report footer prints on a page by itself. Is there any way to force it...

Thanks, I was afraid of that because it is on a very busy server, but at least I can just resort to that and stop wasting time looking for an alternative. Thanks, Gladys Gladys Clemmer gladys.clemmer@goldkist.com

Thanks, Terry. Turns out I cannot do anything anyway because of two active processes that are using the database. I can't kill them, I can't force them to process, I can't detach the database, can't shrink the log file size, etc. Do you have any ideas on how to get rid of them? One is in...

Thanks,Terry. I read some of the info on the links you provided and I think detach, attach will work for me. After I detach the database, I want to delete the log file, but since the the database name no longer appears in the database list, how do I delete the log file? Do I delete the physical...