Search results

Thanks for that good info! Looks like I'll be moving some modules into their related forms.

I've been regularly converting my macros to VB assuming that they run more efficiently as code. Is there really any difference in performance by doing this or should VB be used only for functions that can't easily be coded?

I have a report that gets its parameters from a form. Users have a choice of running the report for a particular trade group, or leaving the trade group blank to return all trade groups in the report. The report title (in Report Header section)contains a text box that holds the Trade Group...

I have a form with a calendar control, tied to a table that holds the date selected, and it works correctly. However, if the user clicks the Cancel button,which closes the form, the date selected on the control has already replaced the date that was in the table before opening the form. I'd...

Is it possible, within a macro, to display a message (message box, etc.) upon the completion of an action query?

I used the DCount code and it works great. Can the same thing be done with queries? If so, is there a different way to refer to the query name? Thanks again!!!

I'd like to create an If..Then statement that exits the current function if a certain table contains no data. How do I specify the table and field and how should I word the Is Null part of the statement? THANKS!

Thanks for your quick reply. I already had Sorting and Grouping set up with the correct footers (the grouping displays correctly). I added headers to see whether that made a difference. However, I'm still getting the grand total rather than the group total in each group footer. Perhaps I am...

I'm creating a report that contains multiple subtotals. The report is divided into Rept header, Page header, Detail, Brand footer, Group footer, and Page footer. Each product is assigned to a brand, and each brand assigned to a group. I want to subtotal each Detail product in its appropriate...

I've created a report that is too wide for even legal sized paper. The leftmost column is Product # and the columns to the right give sales details for each month (current and previous years), which break to a new page. Can I format the report so that when the months that don't fit on the 1st...