double clicking and draging a column in a chart to chg data
in Excel 2003, double clicking on a column in a chart and then dragging the
column up or down would change the data in a table upon which the chart
How does one do this in excel 2007?
That feature has been removed in 2007, there is no way to do it.
If this helps, click the Yes button.
"Tom of inns" wrote:
> in Excel 2003, double clicking on a column in a chart and then dragging the
> column up or down would change the data in a table upon which the chart
> How does one do this in excel 2007?
&g...Changing SQL Server for CRM 1.2
As my SQL server is currently on its last breath I am in the process of
moving our CRM 1.2 databases to a new dedicated serever. I have detatched the
databases from the old server, copied the files to the server and attached
I have then gone into CRM deployment manager and changed to the SQL server
to the new server.
That all appears to work fine, no error messages. But when users try to
access the CRM system they get an error and the CRM server event log fills
with error messages. A few are listed below:
dmLog: Failed to execute the SQL batch in the file sqlbatch.sql.
MSCRM P...What's happened to the findfirst function in Access 2010?
I have a working Access 2007 Application which is now failing miserably in
2010. It hinges on location the first available working document in a table
runing the following VBA code:
.FindFirst "([fld1] + [fld2]) = 0"
If .NoMatch Then
.FindLast "([fdl1] + [fld2]) <> 0"
.... FURTHER PROCESSING ...
What must I do to correct this? Go through a record by record search?
In 2007, this works correctly, stopping at the appropriate record (approc.
rec 1385 in the recordset...Can't insert Char(1) into SQL Server from Stored Procedure
I am trying to insert a char(1) field into a table from an ASP.Net/C#
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y...How do you turn off/on the "1" or "2" or "+" or "-" view hide/unh.
What is or how do you control, turn on/off the small "1" "2" or "+" "-"
hide/unhide view buttons right above the "A" cell? Sometimes shows when I
'Data - Goup/Outline'
> What is or how do you control, turn on/off the small "1" "2" or "+"
> "-" hide/unhide view buttons right above the "A" cell? Sometimes
> shows when I hide columns.
You can toggle them to hide or display with
Usi...transfer data from multiple columns to singlr column
I have data in form a d g
b e h
c f i (but larger scale)
and I need it in a single column going a to z.
highlight you data, copy, go to the column where you want to see the data,
paste special, transpose
> I have data in form a d g
> b e h
> c f i (but larger scale)
> and I need it in a single column going a to z.
You up for using a macro?
'dantuck Mar 7, 2007
&...Register & Favorites Don't Match
I have Money 2004. My checking account register shows the correct balance.
But in the "Favorites" list on my home page, my checking account balance is
many thousands of dollars lower than the actual balance. How did these get
out of sync? Thanks for any help.
In microsoft.public.money, Larry E. wrote:
>I have Money 2004. My checking account register shows the correct balance.
>But in the "Favorites" list on my home page, my checking account balance is
>many thousands of dollars lower than the actual balance. How did these get
>out of sync? Thanks for ...update column
How would I update a column with numeric values so that there are 3 leading
zeros for each row?
it is not possible to add leading zeros to a numeric value. Mathematically,
this is redundent and unnecessary.
> How would I update a column with numeric values so that there are 3 leading
> zeros for each row?
hit the post button too quick.
option 1. custom format
if your numeric value is 12345 then see the custom format to 00000000.
note. format do not change data - it just changes the way it looks in the
option2. format to text
then use the c...Using mouse wheel in VB editor
Just tried using the mouse wheel to scroll within visual basic editor in
excel but it wont let me. How can I turn this feature on. I am using Excel
Thanks in advance.
This is a known problem with the latest MS mouse drivers. You
can either install version 4 of the drivers (current version is
5), or use FreeWheel, and freeware program at
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"fullers" <firstname.lastname@example.org> wrote in message
ne...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
d...Global Column Row Preview Font Size
I know I can change the column, row and preview font size for the current
email folder's view, but how do I do it for all of the email folders? I have
loads of email addresses each with lots of folders. I don't want to have to
do each one at a time. Surely there must be a default font setting (even if
it's only in the registry)?
Thanks in advance,
I too would love an answer to this.
"Timie Milie" <email@example.com> wrote in message
>I know I can change the column, row and preview font ...how to match the color of a button with its background?
I have a owner draw push button. I associate it with two bitmaps, one
is down and the other is up. Is there a way to make the bitmaps's
background color match the color of the window where the button is
located. I manually choose the best matched color but still the result
is not good. I can even see a white border line (not drawn by me) when
the button is pushed. Please help. Thanks.
May Young <firstname.lastname@example.org> wrote in message news:<408473...Outlook 2007 Search always returns no matches
Any search I do in Outlook 2007's new search box returns no matches.
I watched the Indexing Status as it progressed, and now it says "Outlook has
finished indexing all of your items"
But, searching on anything, even the word "The" or "a" returns no results.
I'm searching all Outlook items. I'm on an Exchange Server via VPN.
Anyone have any suggestions?
I uninstalled Office and re-installed and the problem went away...
"Tom" <email@example.com> wrote in message
> Any search I do i...Use exchange from a trusted domain
I have domain a and domain b. Domain a is all set upp with exchange etc.
Domain b was bought, and they don't have exchange. I have trust between the
domains and file sharing and authentication are ok.
What we want to do is, make users on domain b and let them use the exchange
(on a seperate storage) on domain a.
The users on domain b must logon to domain b, but need to have mailbox on
Domain a are running on win2003 and exchange 2003. Domain are running on
win2003 with forest and domain ready for exchange.
thanks in advance,
Thi...Qrp Date functions
Where do I find the various functions to modify the Reports
like cast(DatePart(Dd,[Transaction].Time) as nvarchar) and others
and what they mean????
Found the information at MSDN Transact-SQL Reference
"Barry L" <firstname.lastname@example.org> wrote in message
> Where do I find the various functions to modify the Reports
> like cast(DatePart(Dd,[Transaction].Time) as nvarchar) and others
> and what they mean????
...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...Non-VBA way of making custom menus.
Sorry for the new thread but even on Google, the thread isn't showing up.
Well, it was SOOO easy, as I knew it would be. The webpage I quoted in my
message this morning didn't mention the "New Menu" at all!
So, here is the non-VBA way to create a custom menu:
- TOOLS > CUSTOMIZE
- under the categories available choose NEW MENU and then drag the NEW MENU
option under the Commands window up to the menu bar (like D'UH!! <lol>
Wish all those hours spent searching yielded webpages that gave this! <g>)
- THEN one can go back to the MACROS category a few line...Some Excel formatting functions taking a long time to work #2
Excel 2000 SP3
When I use some formatting functions for the first time in a
session, such as bold, increasing font size etc, it takes up to 30
seconds to work. Meantime Excel is locked up until it completes that
formatting call. I suspect faulty DLL?
Has anyone experienced this? How to fix (other than a complete re-
Any advice appreciated.
On Nov 5, 8:39=A0am, Piri <wiremu.pare...@hotmail.com> wrote:
> Excel 2000 SP3
> When I use some formatting functions for the first time in a
> session, such as bold, increasing font size etc, it takes =A0up to 30
> secon...2 Domains, 1 Exchange Server
We're trying to go with 2 seperate 2003 domains, but with only one
Exchange 2003 Server. What would be needed for the domain that the Exchange
server is not in to access e-mail? We've contemplated having those users use
OWA, but would really like them to be able to use Outlook 2003. We're a
school district and want to segregate the kids domain from the administration
domain, but only have funding for one Exchnage server. Any ideas\help will
be appreciated. TIA.
This should explain what it requires:
"tj woo...RMS 1.2 vs 1.3, plus integrate with Great Plains
1.) I am working on an assessment for upgrading our current RMS software from
1.2 to 1.3. My assessment will take in account the benefits, broken down by
store operations (Retail) and the benefits to IT. Also, list risks and
potential problems that might be experienced. We currently have 28 stores
with 3+ registers per location with another 22 new stores on the schedule
over the next 2 years. Are their other in this group of similiar size that
have done this upgrade to the new version?
2.) If we do not upgrade the software, can we still integrate the RMS to
Great Plains? Would we...How do I insert space between 2 consecutive columns of an XL Shee.
I want to have space between two consecutive columns of a worksheet (of
course, without having inserted another column between the two) in order to
have separated the Border Lines of the adjacent cells/columns. Please guide
me if it can be done in XL.
Can you achieve the effect that you're looking for by using a double
vertical border down the right side of the left column and having no
border down the left side of the right column?
"Shamshad Butt" <Shamshad Butt@discussions.microsoft.com> wrote in
message news:1222EE13-11A9-4354-9F12-D1F1155D3902@microsof...Adding a Macro to a VLookup Function
In Excel 2000 -- I would like to create a summary spreadsheet (sheet2).
For each time that "Name" appears in sheet 1, row *, take information from
the same row, but columns 2 and 6 and bring it over to sheet 2 in the
I know that you need to do a "VLookup" function and I got that to work. I
know that you also need a "Loop" statement, so that it will continue to
perform the Vlookup and bring over the information for each time that the
name appears. I don't know how to write the formula so that the VLookup and
the Loop are combined.
Examp...How Use ShellExecute with a CMemFile
I need to store files of various types (such as .doc, .xls, .jpg, .pdf,
..wmv, ...) in a database. Upon retrieval of such a file I have the file as
data in memory in a CMemFile. I need to then "display" the file in the
aproriate application. If I were to write the CMemFile to disk and create
an actual file I could then, of course, use ShellExecute() to launch , say
Word to display a .doc file.
However, I would much prefer to avoid the overhead of writing the data to an
actual file and then dealing with having to detect when the User is done and
cleaning up the file I had ...Using INDIRECT within functions
I learned a bit from JLathman in a previous post but tried to use the same
methodology with this formula (also learned from this Group to get the last
entered value in a column) without much luck.
The original formula was this with 2009 sheet being static:
Trying to make it dynamic I tried the following without success:
=LOOKUP(INDIRECT("2,1/(" & O1 & "!$H$3:$H$65536<>"")," & O1 &
Did I miss something or are...Date function quit working
I have an Access 2002 application that I have been running on Windows XP SP2
I just installed the application (running in Access Runtime) on a Windows
Vista Home Premium machine. Now, anywhere I used the =Date() function, it
fails and just shows #Name?
I also have a subform on one of my forms that has now gone blank. It also
uses the date function.
I had this problem when I converted to Windows XP several years ago and
updating the OWC10.dll to version 6619 fixed both issues.
However, everything I have read says that reference file makes no difference
to the Access...