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 Wanet Telecoms Ltd 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: *

  • Users: gard0128
  • Content: Threads
  • Order by date
  1. gard0128

    scheduling a table update

    Is it possible to schedule a process to update a table right from Access? We are connecting a pivot table to an Access table, and would like to update (daily) the pivot table, without having to go into Access each day. We are running against a table (versus a query) due to faster processing...
  2. gard0128

    Outlook - Importing emails from Excel

    We've got a customer email list, in Excel, that we'd like to import into Outlook. How can this be done? Thanks.
  3. gard0128

    Using Maximum value as a group category

    I am attempting to create a report that shows the last time a customer has been visited - by age categories (in days) - using the following data. Account Visit Dates Age of last visit Aged Category Acct 1 20050106 260 days over 180 days Acct 2 20050317...
  4. gard0128

    Group by calculated field

    I need to run a report that will pick up the last date a customer was contacted, and then group the report by categories (i.e. 0-30 days, 31-60 days, etc.) the data looks like this Customer id Date visited 001 20040101 002 20041231 002...
  5. gard0128

    Distinct count in Excel

    I am attempting to do a distinct count of a list in Excel. Is there a function that handles this? Any suggestions are appreciated. Thanks.
  6. gard0128

    Assign Macro Command Button in Excel 2003

    I am attempting to create a command button and assign a macro to it in Excel 2003. I thought it was simply a matter of right clicking on the button and clicking Assign Macro from the pop up menu. However, this option is not included on the pop-up. What is the best way to do this? Any help is...
  7. gard0128

    Field Tree Won't Dock

    I've had this problem a number of times now. While I was working in my formula editor, my field tree became un-docked. No matter what I do, I cannot get it to re-dock. I've tried right clicking and clicking "allow docking", but it does nothing. And when I try to do this again, the "allow...
  8. gard0128

    Customizing Opportunity Drop list - Please Help!

    I am making customizations to the opportunities section of CRM. I have no problem making changes to the two main tabs ("general" and "administration"). The problem is when I attempt to make an addition to the "status reasons" drop list, that pertain to the "won" and "lost" radio buttons...
  9. gard0128

    Crystal Parameters

    I am creating a report that will allow the user to run the report based on five different criteria using parameters. The trick is that I want all five criteria to default to "all" so that the user only needs to designate values in the field he/she wants to filter on. Is there a way to set up...
  10. gard0128

    PLEASE HELP

    I am using Crystal 10 to create a report that gives me only the values that don't match, when linking two business views. One view has account information. The other has email information for contacts. Not all accounts have a corresponding record in the email view, and I'd like to generate a...
  11. gard0128

    Macro to paste query into Excel

    We are currently updating an Excel file from two queries in Access by cutting and pasting the data. Is there a way to create a macro that would run the query, open the excel file and paste the data into a "data" worksheet?...or is there a better way? Thanks for any help!!!!
  12. gard0128

    Macro to paste query into Excel

    We are currently updating an Excel file from two queries in Access by cutting and pasting the data. Is there a way to create a macro that would run the query, open the excel file and paste the data into a "data" worksheet?...or is there a better way? Thanks for any help!!!!
  13. gard0128

    Losing Print Setting in Copy

    When I copy a worksheet from one file to another, I lose my print settings (including my print area, margins, page breaks, etc) Is there a way to preserve these settings when copying a worksheet from one Excel file to another? Thanks.
  14. gard0128

    Excel - Copy Paste Values into Merged

    I have forecast spreadsheets which have multiple sheets and a ton of formulas. Because executive mgmt needs to ocassionaly look at old fc's, I need to keep previous versions. To save space, I want to copy and paste my formulas as values back into their existing cells in each worksheet. My...
  15. gard0128

    Excel - Not enough resources to display completely

    I've got an Excel file that is about 2,800 kb. It contains about 8 worksheets and a fair amount of formulas. Lately, whenever I attempt to open the file, I get the message "Not enough resources to display completely". What is causing this error? How can I address this? What impact...
  16. gard0128

    Excel Size limitations

    I am currently managing sales forecast information in an Excel (XP) environment. I am concerned that, as our product line expands, I may run into file size issues. Currently, my file size is 2,229 KB, but is expanding. This is a multi-tab workbook and I have intentions on adding additional...
  17. gard0128

    Parameter in Cross tab query???

    Is there a way to use a parameter in a cross tab query? I'd like to simply include the following criteria in the Accounting Month field in my crosstab: [Enter Current Month] This works fine in a select query but when I try it in a crosstab, I get the following error: "The microsoft jet...
  18. gard0128

    This operation requires merged cells to be identically sized??

    I am attempting to bring data from one spreadsheet that has forecast data into another on a monthly basis so I can calculate the monthly change in forecast for each product. Both spreadsheets are identically formatted but when I attempt to copy from my original forecast document into the...
  19. gard0128

    Microsoft Map - Gone in Office XP???

    I've heard that Microsoft Map will not be included as an add-in for Excel in Office XP. Is this true? Is there any replacement?
  20. gard0128

    summing result of a count - HELP!?

    I need to track sales rep visits to customers throughout the month. The problem is, in some cases, there may be multiple records for each visit to track different reasons for the visit, and simply counting the records would inflate the number. I want to assume that all activity records to the...

Part and Inventory Search

Back
Top