Creating a table
There's probably an easier way to do it but...
I have a series of numbers in column A (150 in all) and a series of letters
in column B (22 in all). In total there are 4800 rows.
What I am trying to do is create a table with the number down the left hand
side and the letters across the top. In each cell within the table I need
to count how many times the combination of number/letter appears. Eg:
A B C
201 0 2 2
202 3 0 1
203 3 6 4
I tried combining the number/letter into a single text field using the
CONCATENATE function then filtering ...Creating a print-macro that'll only print page 1?
I have a spreadsheet that contains multiple sheets. I want to add a
button that runs a macro, which only prints page 1 on the first sheet
The "Scorekort" sheet contains 13 pages in total, but I only want to
print the first page.
Any ideas for this macro?
Sheets("Scorekort").PrintOut From:=1, To:=1, Copies:=1, Preview:=True, Collate:=True
if you don't want a print preview, Preview:=False
Le 2011-05-21 04:16, Anders M a �crit :
> I have a spreadsheet that contains multiple ...Problem with View Source / Outlook 2000
I searched some more, found that the problem is caused when the
Temporary Internet files cache is too big. Deleted the cache and the
problem is solved. Changed the settings to a more reasonable 100 MB
and it shouldn't happen again
I'm using Outlook 2000 and Win 2000, no problems now (had to reinstall
Windows last week for unrelated reasons).
I also use ZoneAlarm and Outlook has permission only to access the
Trusted zone, not the Internet in general.
Something has happened in the past couple of days. I got an email
that looked blank ...custom entity + linking contact
I am new to the CRM product. And have a few questions......
I know that in 3.0 you can create custom entity, but can you link your
custom entity to other entity such as contact/account?
In defining the custom entity, there's a relationship field and mapping
field. What are they exactly? When/How do you define a
You can create relationships to other entities when you create a new custom
entity in 3.0. I believe that you can also establish if the new custom entity
maps up to an existing entity, or receives mapped info from an existing
-...save accounts similar outlook express
How I save account POP mails configurations in Outlook 2003 similar ao
Using the office save my settings wizard or a 3rd party program.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-ti...problems in creating file dialog in tab control
Hi,I am creating a tab control and want to pop up a file dialog when
clicking one tab page. but now, the file dialog was shown up at the
same time with tab control, not after selecting one page. Could some
guys help me? Thanks
AfxMessageBox("can't create tab control window");
m_tcitem.iIma...HELP Error: Trying to populate userform fields from access databas
Hi All, I have been struggling with this since long, I would appreciate if
anyone can help me with getting this done. Basically I want to pull
information from access database and populate my excel userform fields.
For eg: If I input a Student Id field I want to populate the Name and Phone
number for that student from access database, Here is the code that I have so
far, But it gives me errors.. Please guide me through this
Private Sub StudentId_AfterUpdate()
Dim cnt As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strSQL As String
strSQL = "SELECT Name, Phone FROM...New Views are not displaying Customized calculated fields value
I created a new view based on some native fields along with some custom
fields. None of the custom field values are calculating and showing up in the
The custom fields do not seem to be complicated. here they are
Earned Work hours = INT([Work]/60)*([Physical % Complete]/100)
Productivity = IIf([Actual Work]=0,0,([Earned Work Hours]/([Actual
WorkHours Forecast = IIf([Actual
The view is set at the Security Category of "My Projects"
I am assuming that you have this problem in P...Asset account question:
My newest question is how to deal with asset accounts. I added my car, and
added the initial value (price tag). This month, I went to adjust the value
by looking up my vehicle in the Blue Book. Once I entered the newest value,
my car devaluing by $4k shows up in ALL of my spending charts. Obviously
this wasn't an "expenditure," and it happened gradually since I bought the
car - not all this month!
You lost $4k of net worth. The transaction that did it was entered this
month. That's about all Money knows. What else can it say?
"drokkon" <firstname.lastname@example.org...Problem creating new mailbox
I'm trying to create a new mailbox, I've done this tons of times but this
time I'm getting a problem.
I created the user and then the respective mailbox with no problems.
I then went to the users properties to create e email address, choose SMTP
and inserted the address with no problems.
The other times after some seconds exchange would automatically create de
X400 Address but this time it doesn't, the user won't appear in the global
address list and when I configure Outlook 2003 and click "check name" it
says it cannot find the user.
Last friday I cr...Total by Name
I am new to using Excel and need help with totalling by name.
I am using VB6 to create a spreadsheet. I am sending 3 columns out
that I need to total the different names of the people submitting
The program will fille the sheet but I need to break the sheet where
the names stop. ( If this is making sense )
The sheet will start as this
Jeff 8258 01/10/2004
Jeff 9587 01/11/2004
Jeff 9956 01/12/2004
Bill 5478 01/10/2004
Bill 6458 01/11/2004
Bill 7520 01/12/2004
Bill 7912 01/13/2004
Bill 8109 01/14/2004
I would...Outlook 2002 locked up when deleting contacts
While cleaning out duplicates and obsolete email
addresses, Outlook locked up on me. I used the task
manager to end the program and then shut the machine
down. I rebooted and Outlook asked if I wanted to start
up in safe mode. Did that, Outlook just sat there. Used
the task manager again to quit outlook. Tried rebooting
again. Outlook comes up, but the cursor is constantly the
hour-glass and I can't do anything with in the program.
Any ideas for fixing this?
Close Outlook. Find and rename outcmd.dat to .old. (If using Windows 2000
or XP, you will need to e...Project Accounting Inventory Transfer
This is GP 10 PA. I inadvertently went past the project number field on the
Inventory Transfer screen and it let me do that. It even puts the word <NONE>
in that field. Why is that allowed and why would you do that? It appears that
with this all you a doing is a ledger entry. You appeat to be doing a
transfer but not transferring anything to any job.
...Migrating contacts from thunderbird back to outlook
After trying Thunderbird for a year I decided that Outlook has options I need. I need to transfer my contacts back to Outlook, but I don't know how.
EggHeadCafe.com - .NET Developer Portal of Choice
Check out this utility:
Dawn, the Address Converter and Manager
Hal Hostetler, CPBE -- email@example.com
Senior Engineer/MIS -- MS MVP- Print /Imaging -- WA7BGX
http://www.kvoa.com -- "When News breaks, we fix it!"
KVOA Television, Tucson, AZ. NBC Channel 4
Still Cadillacin' - www.badnewsbluesband.com
&l...Additional fields in the Activity Table / Case Timer
I have a client who needs accurate billing from the the Activities performed
towards the resolution of a case. The ideal solution would be a timer on the
Activity Form. However, this is not possible in v1.2
However, in the ActivityBase table there are fields called ActualStart,
ActualEnd and ActualDuration. I am planning on writing a report which uses
these fields. I would like to know how the application uses these fields, as
it would seem to be counterintuitive. I say counterintutitive because when I
created a calculated field and subtracted the ActualStart from the Actualend
I ...Lost accounts
After a brief trip, I opened money 2002 and my accounts
were missing. I got the default money startup page. I
inadventently exited the program, thereby saving the bogus
page in my backup file. Why did it dump my accounts, and
is there any recovery? I can rebuild, but what an effort
that will be (computers are supposed to save time!). I
could in the future set up a password for backups, but
until I find the reason for this program behaviore, I
consider Money unreliable and cannot use it. jmp
Try searching for files named *.mny in your hard drive and look at the
dates. Obviously the one ...Combining Account Activities
We had a customer (Acme) buy another customer (Widco). Now the sales
rep wants all the activity history information from Widco to move over
to Acme so it all shows together. Then we'll delete Widco.
Is this possible?
it is possible but you need to know the data source for widco. what are they
running for a CRM tool if any?
Microsoft CRM MVP
<firstname.lastname@example.org> wrote in message
> We had a customer (Acme) buy another customer (Widco). Now the sales
> rep wants all t...Outlook should be able to print an envelope for a given contact.
From a contact view, outlook should be able to print an envelope or even
start a business letter to that contact, especially if you have MS Word also.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx...How do I download earlier transactions of an account?
I am having a terrible time getting earlier transactions
to show up on an account. How do I change the beginning
date so they will download from my bank online with my
Any help would be greatly appreciated!!!
...Link between Contact and journal entries
Does anyone know the underlying database field that links
Journal entries to a specific contact. If you have ever
tested you can have two contacts with the same name and
put journal entries in for each contact and only see the
journal entries that were recorded when that particular
contact was opened.
Any help would be greatly appreciated.
...401k Account Missing
In Money 2005,I have a 401k account that shows up in my portfolo but on the
Account List under Investment Accounts, just the name shows up and no
balance. I can't print a report for this account (it will not show up on the
list) or include this account in my lifetime planner.
When I go into Change account settings, the retirement box is checked, under
budget the "Include this account in the budget planner" is checked. The "use
this account for budgeted savings goals" is not checked and the system will
not let me check it.
I have repaired the file just to make ...Named Printers for Manufacturing
Is there not any named printers for manufacturing? There is a drop down for
manufacturing but I do not see any named printer items you can configure
under it? Does it exist?
...view email maximised
I've just upgraded to OE v6. When I double-click on an
email to read it, the window returned is too small to be
useful. How do I get maximised windows automatically when
reading emails ?
...pre-windows 2000 logon name __ is already in use
We are trying to roll out Exchange Server 2000 at our office but we are
having a problem creating a very important account we have on our old
mail server (service@) When we try to create the user "service" we get
the following error msg:
"windows cannot create the new user object becuase the pre-windows 2000
logon name service is already in use. select another name, and then try
I assume that this is reserved word or something for AD user accounts.
We need to be able to send and receive emails w/ "service@", how can we
get this to work on exhange...Search for Contacts Created by or Modified by a certain individual
When I open a contact I can see at the bottom a "Last Modified by" with the
name of the individual who modified the contact.
I would like to be able to search and find all of the contacts modified by a
certain individual. I cannot find a "Last Modified by" field. I can find
"Created" and "Modified" but those appear to be date fields.