Recent content by CosmoKramer

puppy39, Give this method a shot... faq703-3587 Si hoc legere scis, nimis eruditionis habes

z3q3, Yes, it is possible. Look in Access help about a form's Close Button property..... Si hoc legere scis, nimis eruditionis habes

This has got to be one of my favorite euphemisms of all time: The PC term for failure? ‘Deferred success’ Si hoc legere scis, nimis eruditionis habes

snyperx3, I never said you couldn't use VBA for calculations, I was just pointing out another method that does work with less considerations necessary for its use. Si hoc legere scis, nimis eruditionis habes

Kent, This is a typical downfall of using VBA to calculate totals. The problem is the code could be called multiple times, once for preview, once for printing, etc., explaining the incorrect printed totals. Can you use the RunningSum textbox property to calculate your totals instead?? Si hoc...

Wow, I didn't realize we had implemented voting for preferential solutions here in the threads. That being the case, I'll say that I prefer mine. [wink] Si hoc legere scis, nimis eruditionis habes

Robert, There may be a more elaborate way to accomplish this, but this is what has worked for me: Create a query (qrySelectDistCustomers) that is nothing more than: SELECT DISTINCT Customernr FROM T_Sales; You main query SQL should look something like this after you add the subquery you just...

Or, try Googling "Outlook redemption" Si hoc legere scis, nimis eruditionis habes

Bob, Check out Duane's response in this thread: thread703-823391 Si hoc legere scis, nimis eruditionis habes

batteam, Can you change your Select Case statement to an embedded IIf statement?? An IIf statement will work in the Field/Expression section of the Sorting and Grouping dialog box. You have to repeat the calculation logic there, not refer to the calculated control.... Si hoc legere scis, nimis...

THWatson, Changing margins page-to-page is very difficult, if not impossible. I had bookmarked the following site that shows how to simulate moving margins by moving controls. If your report doesn't have a lot of controls, this might be an option..... How to simulate odd and even margins...

Check Access help for the Find Unmatched Query Wizard.... Si hoc legere scis, nimis eruditionis habes

In a new module, add a function using this as an example: Function Xferxls_LateChgs_Daily() Dim strFileName As String strFileName = "c:\Charge_Posting_Daily_" & Format(Date - 1, "mm-dd-yy") & ".xls" DoCmd.TransferSpreadsheet acExport, 8, "qryLateChgsDaily_xtab", strFileName End Function This...

Sure, grouping is inherently part of the solution I suggested. Just specify the grouping to be done by your date field and include that date control with your text string of meds and you should be all set..... Si hoc legere scis, nimis eruditionis habes

Here's another FAQ: faq703-3587 Si hoc legere scis, nimis eruditionis habes