rcollins
Last Activity: Dec 3 '09, 08:36 PM
Joined: Aug 14 '06
Location: Grand Junction, CO
-
Using VB to copy info from one spreadsheet to another
I have two spreadsheets. one of them has some information where one collumn will either be blank or have an "N". If it has an "N" I want certain collumns to copy over to a different spreadsheet. Can this be done in VB? How would I go about this chore? Thanks for any input. -
So when I go into the properties of the graph to set percision, I realized that every time I rerun the report, the settings are not there. The query where the info comes from is a union, and I am not sure how to set precision in sql. Here is the query I am using for this chart
...Code:SELECT OPQuestionAvg1.CountyofSurvey, OPQuestionAvg1.SurveyCode, Avg(([1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[9]+[10]+[11]+[12]+[13]+[14]+[15]+[16])/16) AS Expr1 FROM
-
I really appriciate your help. I have it working to the extent that you did, and set the values to be 2 dec places. I will keep working on this since the only qwuarter that changes color is 2009 quarter 2. I wish I had more data than 3 quarters, but we will get there.Leave a comment:
-
That will be fine. I am focusing on another report in the database so I have something to keep me busy until thenLeave a comment:
-
So would this go in palce of the code in the previous post? It gives me an error that OverallBySite is misspelled or refers to a report that isn't open or doent exist, If I have the report open, it errors Object doesnt support this property or method. If I have the report in design view, it opens but the color doesnt change. Any advice?Leave a comment:
-
So, I got that done, and it always randoms the color, but here is the thing. I think I have you backwards. I need the color set to be random on point nine. "Corp" Does not fall on point 9 every time. It is the point I need to compare, if it is "Corp" no matter where it sits is what I need to vary. Sorry for the confusion.Leave a comment:
-
Corp is one of the data in the series, the series is CountyofSurveyLeave a comment:
-
this isnt changing anything. What am I doing wrong?Code:Private Sub Graph2_Updated(Code As Integer) Me![Graph2].SeriesCollection("Corp").Interior.Color = vbYellow End SubLeave a comment:
-
ok, so my graph is Graph2, my x axis is CountyOfSurvey and Y axis is Expr1. "Corp" is always one of the values in CountyOfSurvey, this is the one I want to be dark blue. I am assuming I put this in the VB editor under graph2? Can you help to make sure I get the code right?Leave a comment:
-
Formatting Charts
I have a union query that I built so that I can include location average along with corporate average. I then sort the info on the graph so it is lowest to highes, so now the corporate average sits amongst the middle of the group. This givs a visual to where the locations compare to corporate. The problem is, I want the corporate one to be a different colo so it stands out. I know how to change it manually, but as the corporate average can move from... -
I trusted the folder and I still cannot use the form. I think that we cannot make selections because the code is not running, but I am not sure. Will this be a big issue because the database is on the network? When I open this form, things like the calendar and dropdown lists show, but when I try to click on an item in the dropdown list it just pings and does nothing.I hope this helps moreLeave a comment:
-
Conversion from 2003 to 2007 not right
None of my boxes, dropdowns or anything work in 2007. I tried converting but yet still the same problem. Any advice -
Perfect!!! Thank you so much. I would have never guessed it was in the way I was formatting the dateLeave a comment:
-
Here is My error-"The expression is typed incorrectly, or it is too complex to be evaluated." Here is what I have
Does it make a difference with this as my format?Code:WHERE ((((tSurvey.SurveyName)="Quality Review Tool")) AND ([SurveyDate] Between DateAdd('m',-3,[Forms]![Criteria]![Combo6]) And [Forms]![Criteria]![Combo6]))
Code:Expr1: (Format([SurveyDate],"mmm"" '""yy"))
Leave a comment:
-
Using criteria to calculate last 4 months
I have a query that runs off a criteria form. What I need to do is fix it so that when I select June from the combo box, it gives me back June, May, April and March. The format in the combo box (Combo6) is mmm 'yy so I get Jun '09. The field that I am using in the query is the "Format SurveyDate as Expr 1" and my form is named Criteria. Please advise me on how I need to do this. Thanks in advance
...Code:SELECT tStaffData_1.staffname
-
ok, I think i am a little confused. I thought I could put something in the query when the report opened that would look at what I selected from the list box. This is how I do my combobox. I have List0 for the list of items (which is already set as multple select) and the frield I am using in the report OPComments is SurveyCode. So my understanding from you is I would put it before:
...Code:stDocName = "OPComments" DoCmd.OpenReportLeave a comment:
-
are you around? I have a question about the forum, maybe you can help. -
list box and parameters
I need my List box to carry over selected items to a report. Here is what I have
but this doesnt work. In fact with this, I get an empty report. Need help pleaseCode:([Forms]![CommentCriteria]![List2])
-
Crosstabs Missing Info
I have a report that I have charts on. What I hae now, is grouped by supervisors, and it gives 4 months of info for each supervisor.
On the X axis I have the months and on the Y axis I have the average scores. I have a legand that shows the different Services for each. What I need is for the graph to show all of the for months even if they are blank, and all of the services for each supervisor even if those are blank.
Example: One supervisor... -
Thanks, did perfect. Your help is apprieciatedLeave a comment:
No activity results to display
Leave a comment: