Search results

Thank you !!!! This is great. I am now involved with various other projects, and I will be able to incorporate this solution with some of them. Again, thank you !!!

Thank you very much, you have just saved me a morning each week that was used to empty various tables in our database.

Hello all, I am in need of a fast way to drop all the contents from a table that has over 65,000 records, it is being refreshed weekly. Any help is appreciated. Thanks.

Is there a way to just drop all to the right of the decimal instead of rounding: mynum=55.123456 drop=55 or mynum=55.785 drop=55 Thanks.

Any suggestions will be helpful. I have a number "55.154523", and I only want to show "55". How can this be done? I need to drop everthing after the decimal. I know it is probably an easy task, but I am at a loss. Thank you in advance for any assistance.

Thank you for the fast reply. I am not sure how to make the module run once I get it setup, but I will try it out. Again, thanks.

Here it is: '------------------------------------------------------------ ' FC_KG_ADOP_Payment_Report ' '------------------------------------------------------------ Function FC_KG_ADOP_Payment_Report() On Error GoTo FC_KG_ADOP_Payment_Report_Err ' 1 DoCmd.OpenReport "01 Payments -...

To anyone who might know: I have a macro that calls up 36 different reports, but at the same time, after each report has started to print, it brings up a dialog box "Print Macro Definition". What I have been doing is cancelling this dialog box because it is not needed. How can I cause this to...