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!

  • Congratulations Mike Lewis 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. danmeljeff

    Switching between Remote Desktop and Excel

    When I work within a terminal server environment via RDP, then switch back to Excel 2007 (local), I have to click multiple times within the Excel screen for it to respond. Typically, 15 clicks or so will do the trick, but this is becoming quite frustrating. I have had the same issue when...
  2. danmeljeff

    Record Selection to return active price amount

    You're right. I was linking the incorrect DATE fields together. Thanks for your help, the report is working as needed now. You rock lbass!
  3. danmeljeff

    Record Selection to return active price amount

    You're right, I left out some info. What you instructed me to do worked...I was able to limit the returned records to a single record per contract line (instead of 4). However, the Active Date returned wasn't correct in all cases. The table below is what is returned for product XC555KIT with...
  4. danmeljeff

    Record Selection to return active price amount

    I tried what you suggested, and I'm getting incorrect results. For instance, product XC555KIT has 4 returned records. Price Active Date Date Created $200 04/01/2008 08/24/2008 $200 04/01/2008 09/30/2008 $200 04/01/2008 01/21/2009 $200 04/01/2008 01/21/2009...
  5. danmeljeff

    Record Selection to return active price amount

    Using crystal reports XI with an Oracle Database. I have 3 tables: INVMASTER, CONTRACTLINE, and INVRENTALPRICE CONTRACTLINE is left outer joined with INVMASTER on the INVIID field. INVRENTALPRICE is left outer joined with INVMASTER on INVIID. The INVRENTALPRICE table stores the rental rates...
  6. danmeljeff

    Custom Outlook Form - Checkboxes Determine Recipients

    Wow...that seems quite easy. I've got to get my head around thinking vba vs dba, so yes, collection and not field :-) Thanks everyone.
  7. danmeljeff

    Custom Outlook Form - Checkboxes Determine Recipients

    I get stuck on how I need to reference the recipient field to add an address to it. Would you happen to have an example? Thanks
  8. danmeljeff

    Custom Outlook Form - Checkboxes Determine Recipients

    Hi All, I'm trying to figure out how to use the click event, so that when a checkbox is clicked, it'll add an email address to the recipient field of my message form. I'm using Outlook 2003. I would like to have 3 checkboxes, and each one will represent a department to email within my...
  9. danmeljeff

    Add recurring folder structure to exchange public folders

    I'm trying to figure out a way to automatically add a set of sub-folders within Outlook Public Folders. My company uses public folders to store all types of data (messages, pictures, excel files, etc...) regarding the jobs we are working on. We organize these files into sub-folders within the...
  10. danmeljeff

    Add recurring folder structure to public folders

    I'm trying to figure out a way to automatically add a set of sub-folders within Outlook Public Folders. My company uses public folders to store all types of data (messages, pictures, excel files, etc...) regarding the jobs we are working on. We organize these files into sub-folders within the...
  11. danmeljeff

    incorrect data on GL Transaction Report after update

    Hello all, I'm using crystal reports designer 10 with MAS500 v7.5 on SQL Server 2005. I know this is the MAS90/200 thread, but there aren't a lot of users on the MAS500 thread, and I thought perhaps this could be a universal issue for all Sage MAS accounting platforms. Prior to an update from...
  12. danmeljeff

    Use Excel Summaries on Export from Cross-Tab

    I'm using Crystal XI and SQL Server 2005. I have a crosstab report that has row and column totals, as well as shows the data that makes up the totals. I would like to be able to export this report to excel, and have excel's summing functions replace crystal reports' totals. This report will...
  13. danmeljeff

    how to use summax variable in formula?

    I realize this information is a lot too take in, and perhaps I'm not explaining it quite the right way, but I'll provide any info or reword my previous threads if anyone thinks they can help. Thanks
  14. danmeljeff

    how to use summax variable in formula?

    Here is an image of the detail, along with some explanations of what I'm trying to do. Sorry for the delay in response as the database crashed on Friday afternoon. All is better now.
  15. danmeljeff

    how to use summax variable in formula?

    I'm using CRXI and was having an issue summing group data based on formulas. After searching the threads, I saw how to use a variable to create a running balance and then display the final summed value. However, what I'm trying to do now is use the displayed summed value that resides in my GF1...

Part and Inventory Search

Back
Top