New to excel
I'm new to Excel ( and to this forum :) ) and so I hope somebody may b
able to help me.
I've got 2 questions....
I've got a spreadsheet which takes data from one worksheet and uses i
to calculate data in a second worksheet using the following code
=IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe
2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t
The problem is, when I create a new worksheet I have...Attaching Contacts to new email
Creating a new email. When contacts folder has "shared" contacts and
"personal" contacts how can you set your personal contacts as the default?
Example: creating a new email having never addressed the "send to" contact
before, you hit the "To" button. Currently my "shared" contacts opens up but
I would like my "personal" contacts page to open instead of having to drop
down to "contacts" to bring up that list.
Is there a solution to this?
On 2/26/2010 10:21 AM, assistantneedshelp wrote:
>...how to convert lookup values to the "display text"
I'm using an sql code (below) which uses a few lookup fields. Unfortunately
in the datasheet view, I get the "bound values" instead of the "display
values". How can I change the properties for the these lookup fields so I
can see the "display values" from the datasheet view?
UNION ALL SELECT
UNION ALL SELECT
I have following queries regarding new implementation:
If I ask that I have 8 outlets at remote locations & these are all garments
stores, which will communicate with HQ Server. Each store is having around
1500 items. Now the question is how much time/days will it required to
implement? Can anyone tell me an approximate time period? Just have an idea.
Which connection/line is fast/speedy for communication with HQ server from
remote stores? Like DSL, Dial ap. IS VPN necessary?If NOT Y and if YES Y??
•Will start from Store Operation Template Database.
•Af...How to automate increasing the form cache registry/file etc...
I want to roll out a batch file to make a number of tweaks to CRM
The body of it would go
REGEDIT /S Kerberosefix.reg
REGEDIT /S ForceFormreload.reg
REGEDIT /S OutlookFix.reg
It would also rename OSA.exe to OSA.bad
Remove OSA.exe From the startup menu
I need help finding a way to use my batch file to increase the Outlook
Form cache from the default 4MB to 50 MB.. This makes CRm more stable
and faster for communications. I dont want to manually do this, as it
time consuming, are my end users would not be reliable in doing it
I also want to make another batch file or button that...Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account?
Assuming you are using the outlook connector, you need to set the msn
account to be the default message store then outlook will use the msn
calendar as the default.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this...explanation of codes in Visual Basic when creating User form
I am trying to create a user form in Visual Basic however I'm trying to
teach myself by reading/watching tutorials. (www.contectures.o.ca, etc)
A lot of the instructions I am seeing simply give the code rather than
explain how to actually write one from scratch.
I need to know what each 'term' means so I can understand how the codes work.
Any help is much appreciated :)
One of the first codes is for the Add button
Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("PartsData")
What d...New Record
I'm using the following in the On Click of a command button.
DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec
Anyway I can do this without referenceing the Object (Form) name??
DoCmd.GoToRecord , , acNewRec
Mark A. Sam
"JamesJ" <jjy@adelphia_darwin.net> wrote in message
> I'm using the following in the On Click of a command button.
> DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec
> Anyway I can do this without referenceing the Object (Form)...How do I see when new messages without outlook running?
Without Outlook 2003 constantly running, how do I send mail or know when I
have new mail?
two possible answers...
1) you don't or
2) you acquired a 3rd party app to occasionally poll your pop3/imap account
"Leslie Adams" <Leslie Adams@discussions.microsoft.com> wrote in message
> Without Outlook 2003 constantly running, how do I send mail or know when I
> have new mail?
...Pivot Table Question #5
How do I make the row headers show up in front of each row
on pivot table instead of just once on the first row of a
Copy the pivot table
Do a Paste Special > Values into another sheet
Ensure that the top left cell is A1
Run the Sub FillBlanks() below
(from MVP Debra D)
'by Debra Dalgleish 7-Dec-2001
'fill blanks cells with data from above
.FormulaR1C1 = "=R[-1]C"
Range("A1").PasteS...Status in table PurchaseOrderEntryDetail
We're trying to populate serial # into the PurchaseOrderEntryDetail table
and run across the column 'Status'. What are the possible values for Status
column in this table? Most of the time we see status of '2'. What does that
mean? Please help.
Many Thanks & Best Regards,
...Call & Place Graphic Based on Cell Value?
Is there any way to call & place a graphic image based upon a cell value?
Maybe you can look at J.E. McGimpsey's page:
> Is there any way to call & place a graphic image based upon a cell value?
...Table of Contents for each section
I have tried several times to create a TOC for each section of my document.
They way it is now I can simply go to the Insert a TOC and it will insert e
perfect TOC. All my text has been changed to the appropriate Level and I have
no problem there. But I need to seperate the chapters to the start of their
respective sections (I have next page breaks inserted at the start of every
chapter). I have tried the bookmark method, no luck. I have tried other
methods but I think my problem is that I have selected the appropriate fields
and changed their levels appropriately. I have not mes...Money End of Support
I may be asking something that's already been asked 1000 times (apologies in
advance), but I'm just not 100% clear on something re: Microsoft's decision
to end their support of Money.
I'm a current Money Plus customer who uses the online features for stock
updates, credit card downloads, bank statement downloads, and investment
downloads (no Bill Pay). Reading their FAQ page, it seems that service should
continue until 1/31/2011. However, when I shutdown money, I get a message
that says "online services will expire in 21 days (that's what I got today).
After ...wprintf() could not display unicode chars which is > 255 to console?
I encountered a problem about wprintf() to display unicode chars which is >
255 in my console app. I am sure I have defined _UNICODE in my VC6 Project
I had a search with google and found that my question was some like the
Is it true that there is some bugs in wprintf()?
Thanks for your help.
I assume you are writting a c++ program. Can you give preference for
ostream cout, wcout on printf/wprintf?
use wcout like this:-
wcout << L"How are you?"
"David" <David_Wa...form fields not saving to table
I have created a database with a form and three of the fields are not saving
the information to the table. I have checked the row and control sources and
now at a loss and thoughts?
As you scroll through existing records is the data of the table displayed?
Post the SQL of the query or form source.
Build a little, test a little.
> I have created a database with a form and three of the fields are not saving
> the information to the table. I have checked the row and control sources and
> now at a loss and thoughts?
...Cannot Delete Any Records
We're running CRM 3 Rollup v3 and we have recently found that we cannot
delete any records in CRM. We recently migrated over to a Windows 2003
Enterprise install running SQL 2000 Enterprise. Everything else is working
without issue for us. For example I am a Sys Admin, and I receive a generic
SQL Server error when going to delete an activity? I know that in the past
this was possible, any thoughts?
Sean; sounds like something went wrong with your migration. you can run a
CRM trace or a SQL Profiler trace while performing the deletion to see if
you can pin-point the error.
Dave Ire...Can I share entities in migration process?
The entities in CRM have only one owning user. If I want=20
who a user see a entity of another user, the entity must=20
be shared with this user.=20
Well, I want migrate entities who must be shared with some=20
users. Exists a way to do it?
Thank you for pay attention and sorry my bad english.
Vin=EDcius Pitta Lima de Ara=FAjo
...Control End After the Sheet is Modified
I use control end a lot to go to the bottom right corner of my big sheets.
If you delete rows & columns of data it no longer goes to the right hand of
the data. Is there any easy way to navigate to the end of the current data?
End and down arrow doesn't work if there are gaps in the data.
Thanks for looking.
You should use <Home> <End>
> I use control end a lot to go to the bottom right corner of my big sheets.
> If you delete rows & columns of data it no longer goes to the right hand of
> the data. Is...Can't do adjustment in analytical accounting
I am trying to change an analytical assignmnet through the Edit
Analysis. When I try and change it, I receive an error stating "The
Code of this Transaction Dimension cannot be adjusted". Has anyone
seen this before? I have done similar changes many times, but I don't
know why I can't now. Any insight would be helpful.
What version of Gp are you running? I haveseen this happen in 8 but one of
the service packs fixed it. (I think it was SP 4 or 5)
> I am trying to change an analytical assignmnet through the Edit
>...Outlook: default new mail location
We seem to have a problem with users that log into a
workstation that they have never logged into before.
Basically, the default NEW MAIL location is set to a PST
local to their c: drive. So, when they open up Outlook to
check thier mail. All MAILBOX, INBOX mail slowly
dissapears and is moved to the local pst file. Once, we
configure the users Outlook profile on that machine and
change the default NEW MAIL location to the
Exhange/Mailbox/Inbox it works fine. I've heard about PRF
files, but I am unfamiliar with configuring them. All I
want is for the default NEW MAIL locatio...How can I create Schedule Chart?
I have simply an activity list which shows START and FINISH date of
related activity. I need to put this information into a Chart, so
i will get a bar chart highligting the line between the START and
FINISH date of the activity.
It is very similar to what we can create in Microsoft Project.
Do you know a specific chart type for this?
It's called a Gantt chart:
"mezzanine1974" <email@example.com>...GPS 8 service pack 2 and add new company
After installing service pack 2 for GP 8, I am not able to add or log on to
the new company. Error during upgrade is “Entries haven't made to all
required fields. Would you like to show the required fields on all windows in
When I try to log on to GP getting another error “file for this company have
not been updated”
...How can I change text to proper text in multiple cells.
I need to change names that are all in caps to proper case in 100 cells.
If I click each one individually, it works, but I need to be able to perfomr
this funcion automatically on all the cells. One other post said to be sure
calc is set to automatic and mine is. Any instruction is most appreciated.
Insert a helper column to the right of the column with the names.
Then use a formula like:
and drag down that column
Then select that column
select the original range
And then delete the helper column.
> I...can't open new worksheets in a separate window
I've been trying to open multiple wookbooks in Excel, but they won't open in
a new window. Instead they continue to open in the same window - one on top
of the other. I've tried playing around with the maximize and restore, but
to no avail. I tried right clicking on the Excel button in the taskbar to
cascade the windows, but the pop-up menu is inactive. any advice would be
Running Excel 2003, Windows XP.
This might be it:
Tools - Options - View tab - Show: Windows in taskbar.