FancyPrairie & TheAceMan1
Hope you have not lost me. I still need some direction with this.
FancyPrairie wrote:
"...the 1st command bar does not need to represent January. Rather, the 1st command bar represents the 1st bar. Your query will tell you which product is 1st, 2nd, and so on"...
FancyPrairie -
My graph is based on a query that basically groups sales volumn by month and another graph with a query that groups sales volume for entire year by product.
The product graph could pull just the top 10 products for the year at any given time.
For example, these 10 product bars...
I see where you are headed. However, my question from that is how do I refer to the particular bar on the graph withouth hard coding it to for example actual name of product or month name "January"?
Thanks.
Thanks so much for your ideas.
In this case, the months will always be aligned in order each time. That is the Bars will always be in this order - Jan Feb Mar...Dec
Next Question: What if the bars are not always in the same order. For example if you have a graph with bars for Producs in...
I have a gragh on a form that shows data for each month of the year so the grapgh has 12 bars.
I would like to be able to click on each bar and have it open up a report or table that shows the detail record for that month.
Thank you very much.
I have a graph that plots data for product sales for each month.
I need to update the graph with the data for each month as a selection of month name is made from the combo box
How do I go about getting this to work?
Thanks
Need help with my graph on a form. The graph is based on a query that is sorted by the Month Num, which therefore sorted the Month Name column -Jan, Feb, Mar, etc.
However, the graph is based on the month name column so it got sorted by month alphabetically.
How do I go about getting it...
You won't belive this but I am still getting an error with the code below.
-------------------------
Private Sub IssueDetail_Click()
On Error GoTo Err_IssueDetail_Click
Dim strDocName As String, strLinkCriteria As String
strDocName = "frm_IssueDetail"
strLinkCriteria = "[IssueCount]="...
TheAceMan1 - Thanks for the help. [IssueCount] is a number field (AutoNumber).
I used the syntax you suggested and I got an error that says
"Microsoft Office Access can't find the field '|' referred to in your expression"
Thanks
Question: I am trying to open a form from a subform.
Dim strDocName As String, strLinkCriteria As String
strLinkCriteria = "[IssueCount]= '" & Me![tblIssues_subform]![IssueCount] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
The result did not apply the filter.
Pls help.
Thanks
Question: I was reading the post and I has a problem similar. The diffrence is that I am trying to open a form from a subform.
Dim strDocName As String, strLinkCriteria As String
strLinkCriteria = "[IssueCount]= '" & Me![tblIssues_subform]![IssueCount] & "'"
DoCmd.OpenForm stDocName, ...
The foxpro table will be replaced monthly, which is why I need to import the table first before loading it into the master /cummulative table.
If I do a link, I will loose the old data when the table gets replaced.
Thanks
I am trying to import a FoxPro table into Access 2003 with a macro using TransferDatabase.
Here are my settings:
Transfer Type: "Import"
Database Type: "ODBC Database"
Database Name: Path where the file reside
Object Type: I left this field blank
Source: Name of the file.DBF
Destination: Name...
Is it possible to pull data into access from Oracle by linking to Oracle tables?
If yes, how do I go about doing that?
Thanks for anticapated response.
I understad it is possible to automate SSAS backups. How could I edit the backup script below to have it ready for automation?
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Project_Test</DatabaseID>
</Object>...
How could I automate the following back-up script below:
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Project_Test</DatabaseID>
</Object>
<File>Project_Test.abf</File>
<AllowOverwrite>true</AllowOverwrite>...
Automation has been mentioned in this thread.
My question is - How do you automate SSAS project deployment from the dev server to the prod server - strategy, tips etc.
Thanks in advance for your help.
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.