Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CosmoKramer

    Columns to List data separated by a coma

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

    microsoft access 97 close button

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

    Let's complicate it

    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
  4. CosmoKramer

    Grand Total wrong when report is printed

    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
  5. CosmoKramer

    Grand Total wrong when report is printed

    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...
  6. CosmoKramer

    query for 2 most recent periods

    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
  7. CosmoKramer

    query for 2 most recent periods

    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...
  8. CosmoKramer

    email via MS Access issue

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

    Make 3 reports into one (Access 2000/2003)

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

    Sort (order) by question

    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...
  11. CosmoKramer

    Margin settings by VBA code

    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...
  12. CosmoKramer

    Need Help... Query

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

    OutputToExcel

    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...
  14. CosmoKramer

    List items on one line on a report...HELP

    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
  15. CosmoKramer

    List items on one line on a report...HELP

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

    Generating a total of hours worked in a report

    lagg, Is [hours_worked] a calculated control?? You can't sum a calculated control, but you can have Access do it for you. Add another text box to your detail section with the same control source as [hours_worked], but set its Running Sum property to Over All and its Visible property to No...
  17. CosmoKramer

    Exporting results to Excel

    Yes, use Notepad, Wordpad, etc. Si hoc legere scis, nimis eruditionis habes
  18. CosmoKramer

    Exporting results to Excel

    I would export it to a .csv file (comma-separated values). Break that file into two files and import them into two worksheets in the same workbook.... Si hoc legere scis, nimis eruditionis habes
  19. CosmoKramer

    Report Header/Footer

    If you only want the signature to appear at the bottom of the last page, try something like this: In your page footer, if you don't have one already, add a text box whose control source holds the Page and Pages properties. Something like: ="Page " & Page & " of " & Pages Make it invisible if...
  20. CosmoKramer

    Assist with Totals Control on Form

    Ted, Is it possible that Expr2-5 could be null?? If so, try wrapping an Nz around them too: =NZ(Sum(([Amount])-(Nz([Expr2])+Nz([Expr3])+Nz([Expr4])+Nz([Expr5]))))*IIf([PayingInNo] Is Null,1,0) Si hoc legere scis, nimis eruditionis habes

Part and Inventory Search

Back
Top