Gantt Chart in Excel. Do I need conditional formatting?
I have created a Gantt chart that shows approx. 15 tasks in each project. I
am using this to show percentage of completion for each task.
It is working just fine and looks great but I need it to insert a date when
a task is at 100% completion to show the client the date that particular task
was completed. How would I do this without ruining my chart I already have
working fine? I know this is probably easy to do but I cannot seem to keep
the rest of the chart intact. Is conditional formatting the answer?
You could use Rob Bovey's XY Chart Labeler to do this:
h...how to active the ribbon Tab automatically when the form opens[Access 2007]
I built a ribbon tab for a form. It works fine and when the form opening,
the ribbon will be loaded fine. But it would be focus (or active)
automatically. It still focus in the tab where I set now. Please
is the callbacks for the ribbon always in Modules? I remember in Access
2003, the callbacks function could be in the form class modules. If all the
callbacks should be in the Modules, does it mean we need distinguish which
form or report is active now?
Thank you very much.
Hi Ribbon is the new command bar system in office 2007...Excel 2003 VB referencing #N/A not working but works in Excel 2007
I have a very simple macro that works in Excel 2007 but hangs up constantly
in Excel 2003. Does anyone have a work around?
When referencing cells that have a #N/A value, Excel 2003 craps out even if
I use the ISNA application function before it. The following 2 statements
will cause Excel 2003 VB to stop regardless of order if the cell that is
referenced comes up with #N/A.
Series = Cells(RowNumStart + X - 1, SeriesCol).Value
If WorksheetFunction.IsNA(Cells(RowNumStart + X - 1, ColNum)) Then
Further background.... I am actually wanting to find #...timeclock report help
We use the timeclock report to print out total hours worked for any given
two-week pay period.
I am trying to modify the timeclock report by adding an additional column
that will tell me whether the date on the report was in week 1 of the pay
period, or week 2. I would like to return the string 'Week1' if the TimeIn
value for that row is less than or equal to the FilterLoLim value + 7, but
this does not work, i can't refer to this in my SQL formula.
here is a simple select statement to demonstrate what i'm trying to accomplish:
select cas...2-D charting with multiple rows
I have a power user who wishes to increase the size of his 2-D graphics but
is limited to using 32000 records. He needs to be able to use 64,000 records.
Any suggestions? I think this might be something that is changed in regedit
but I am not sure. Thanks!
Yep, and you can bypass the 256 column limit with Windows API calls.
Joking aside, how about two series, formatted identically. If you have duplicate
entries in the legend, select the legend, then select the text of one entry, and
press the Delete key.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorial...Link Tables in Report Writer
Im working with Report Writer in GP10 I read David articles and they are
interesting but my question is:
for exemple I want to add the "expiration date" to the "POP Receivings
Posting journal" report let's assume I found the table containing the
how do I get to it when creating table relationships Im new with GP and Im
having difficulties what tables to link to get the final table.
I really tried everything to figure it out but I didn't succeed I hope I was
clear explaning this.
thank you guys in advance
It sounds li...Printing postcards from publisher 2007
I have given up on duplexing my postcards with mail merge. I made two
separate publications and printed the addresses on one side of the cards.
Got that to work.
Now I'm trying to print the four pages to the one sheet 8 1/2 x 11. It now
prints all four copies, minimized into the upper left 1/4 of the paper. How
do I get the program to print my postcards full size?
Look at my answer in your earlier post.
"Judy Gross" <JudyGross@discussions.microsoft.com> wrote in message
news:6A6D1429-44B0-47A8-ABEB-0C84C2F749F4@microsoft....2007 Outlook & Word as editor
Just upgraded to Office 2007 (Outlook, Word, Excel, Power Pt ) Windows XP
Some user was having random trouble with a yellow font on received and sent
e-mails and after a search in outlook general quest answered, tried various
fixes. We are watching now to see if OK.
Some answers mentioned the editor, so this leads to my question: what does
it mean it uses Word as editor? Just Spelling, auto-correct, spacing? What
else does Outlook use Word for?
Thanks for your time
if you use Office 2007, the point is moot for the most part - there is only
one editor available when the...Signature format changes in replies with Outlook 2007
We are using Outlook 2007 and are finding that our signatures will sometimes
change font and spacing in reply messages. Is there a way to fix this?
...File in 2007 form
I was trying the Beta Office 2007 and made the mistake of saving one of
you Excel file in the new 2007 form. I really need it back in the 2003 form.
Problem: due to a variety of issues, I de-installed the Beta version and
went back to 2003 but for got about the one file..
So; are there any utilities that anyone knows of the will convert this
file back two 2003 form?? It is a simple Excel file, meaning that there
are no clever or fancy formula or macros, just a collection of parts and
part numbers gathered over MUCH time surfing various web sites.
Any help or advise (beside the obvious....Help on displaying recession periods in a financial/ stock chart
Using excel version (10.6501.6626)sp3
How do you shade the chart background to show economic recession periods in a financial/ stock chart. I've fiddled with the drawing function-rectangle box, transparency, etc- but it isn't very satisfactory since it corrupts the column/ line colors and usually washes out when printed. So that doesn't appear to be the solution. And after checking thru Microsoft help and the discussion group messages I haven't found a message addressing my problem. Since we see charts all the time with the recession periods shown I know there is a way to acco...One Line of Data Per Page of Report
When viewing/printing reports reports we are only getting one line of data
per page. So instead of having a 5 page report with 60 entires we have a 60
page report with 1 entry per page. Is there an easy way to solve this
We are not very familar with access and need this problem solved.
On Thu, 17 Jan 2008 11:07:03 -0800, Coutu <Coutu@discussions.microsoft.com>
>When viewing/printing reports reports we are only getting one line of data
>per page. So instead of having a 5 page report with 60 entires we have a 60
>page report with 1 entry per pag...create flixible forecast reports?
Is it possible to create flexible forecast reports (global reports, reports
for one country, for one business-line, one account-executive, ...) with
revenue and profit margin, given the following information for the
- global revenue and profit margin (percentage), equal split over several
- global revenue and profit margin (percentage), not equal split over
- hourly revenue and cost price for a consultant (linked at an opportunity),
split over several months based on working days per month
- hourly revenue and cost price for different consultants (lin...Downloading Crystal report 9.2.2
I am trying to download and install Crystal report 9.2.2. I found a link in
one of the postings
ftp://ftp.crystaldecisions.com/outgoing/TS/CC/CRPro922.zip, but it seems like
the link is no longer valid.
Could anyone guide me to where else I can download Crystal Report 9.2.2?
Thanks in advance,
If you have a license for v9 you can get 9.2.2 by contacting
BusinessObjects. They will validate your crystal 9 license then either send
you 9.2.2 or give you a download location. You can download from the
following location but you need login details -
https://businessobj..."Remove access" to certain accounts in CRM 4.0
Is there a way in CRM 4.0 to remove access from specific accounts for
Accounts they would otherwise have access to? I'm only talking about a very
specific subset of the regular accounts in the business unit for which the
Anyone have any experience with that?
The simplest way is to move this accounts "VIP accounts?" into another
business unit and set the access rights accordingly. Or you can use the team
"Adam Pinilla" wrote:
> Is there a way in CRM 4.0 to remove access from specific accounts for...MS Access Table missing
I'm looking at a database (Access2003) someone sent me and I see a Query,
something like SELECT * FROM [Table 1]
The problem is that there is no [Table 1] in table list, query list. In
fact, there is no such object with the structure that I see when I open that
original Query a=in design mode. The query opens and shows data....
Few more observations: looks like this DB was converted before with errors;
thiis DB uses linked tables
Assuming that this isn't a split database (do any forms show up?) with the
tables in a separate...Access 2003 Security Message On Open
I have approximately 15 databases that I am about to migrate to Access 2003
from 2000. I do not want the security message to appear every time one of my
users logs on to the database. Registry changes and digital signatures are
out of the question. If I put Application.AutomationSecurity =
msoAutomationSecurityLow on open of my start up form will this prevent the
warning message? Is there something I can put in the windows shortcut to
turn this off?
I have seen some suggestions were it is mentioned to call a script that
calls the database to open in low security mode. Is this nec...Change column color in chart when column value is over/under goal
No use of VBA or macros expected. It is believed to be Excel chart feature.
Any ideas on how to change column colors (Red/Green) if value exceeds or
meets the preset goal.
Eg. if goal is 4% - anything at or above 4 should show green and under 4
should be red.
Assuming your data is in A2:A20
copy B2:C2 down, add some labels to B1:C1, then chart B1:C20.
This will give you two series, one for the aboves, one for the rest.
Select each data series, right click, choose format, and set the colour as
(there's ...Outlook 2007 and Outlook 2010 crashes when downloading email
I have tried everything to try and figure out why Outlook is crashing. I ran
sfc, I reinstalled XP SP3, IE 8, Outlook 2007 and as a last try installed
Outlook 2010. I tried new email profiles and I ran a full scan with Microsoft
Security Essentials and Malaware but nothing! This thing is driving me crazy!
I don't want to do a reinstall of XP as I would rather spend the time on
Windows 7 in a few months down the road when I spec out some hardware. Is
there anything left to try????
What's logged to the Event Viewer about this?
http://www.msoutlook.info/question/...Creating a table into another Access database
Is there a VBA command or SQL statement for me to run a Make Table Query to
create a table in another Access database? I would like to distribute
several access databases to different groups with tables populated with data
specific to the group. I don't want to create the tables in the main
database and transfer the table, because there's many tables and it would
probalby exceed the 2gb limit of MS Access.
SELECT * FROM INTO [;Database=C:\Folder\File.mdb].Table1 FROM MyTable
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"anon" ...Excel Hyperlink on Chart
Is there a way to "drill down" to data from an Excel chart? For example,
select the series and have it hyerlinked to a table containing the data?
AFAIK not possible (or at least not without a huge amount
of vBA code)
>Is there a way to "drill down" to data from an Excel
chart? For example,
>select the series and have it hyerlinked to a table
containing the data?
...Access 2007 and windows 7 12-25-09
Under windows xp and vista. I was using a batch file to compact a database,
now under windows 7 it does not work I get an error.
"c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact
Now I get a message box saying that was a problem sending the command to the
Thanks for the help
> Under windows xp and vista. I was using a batch file to compact a database,
> now under windows 7 it does not work I get an error.
> "c:\Consulting Tracking Program\Consulting Tra...allow folders in access
It's pretty common to have logical groupings of queries, reports and so on.
It would be great if Access provided a grouping mechanism - via named folders
or something similar - within the object management panes.
For example, if I'm creating a report - MyReport - that has several
subreports - MySubreport1, MySubreport2 and MySharedSubreportA - I could set
things up in the Reports pane like this:
- MyReportFolder [folder]
MyReport [rpt obj]
MySubreport1 [rpt obj]
MySubreport2 [rpt obj]
- MySharedSubreports [folder]
MySharedSubreportA [rpt obj]
Two things to note:
...replicas de access
como puedo quitar las replicas de access
"Por mi raza hablara el espiritu"
If you mean 'removing' the replications features... you can start with
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7 (note that the
site is multilingual).
Vanderghast, Access MVP
"victor kingobol" <firstname.lastname@example.org> wrote in message
> como puedo quitar las replicas de access
> "Por mi raza hablara el espiritu"
...Microsoft Outlook Web access #3
I use this to pull office emails at home. Up until
Tuesday, this worked fine. Wednesday I was unable to get
any new mail(said nothing to view) even though Wednesday
is the one day I know there will be early morning mail as
it it the day I get a newsletter. I had downloaded
something on my office computer on Tuesday, so I
uninstalled. When I got home, same thing . This time
the response was a error symbol in lower left. Since I
have Windows XP, I did a restore to Monday. Still
nothing. I am still getting nothing to view or the error
symbol with no additional information. Any ...