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...
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...
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...
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...
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...
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...
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...
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...
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!!!!
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!!!!
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.
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.