Simple question #3
Hi Folks -
On my computer I have a folder that contains all my songs and I now want to
catalogue these to ease finding etc. etc.
Simple question - how can I copy the song titles over to an Excel
spreadsheet. I've tried copy/paste etc and paste special but an error
message appears stating the file is a 'SYLK file' . I appreciate that Excel
will see this file as an MP3 etc and can not place it but all I want is the
title ? HELP - I need somebody.
I have a 'few' songs and don't want to have to type out every song title
Anyone know of an easier way to tran...WARNING! Questionable newsgroup performance
This may already be a well-known, well-documented "feature" of newsgroups.
If so, sorry for the duplication ...
I've just learned (trial/error/re-trial/confirmation) that using a
"Subject:" in a new post that is identical to another "Subject:" that's
already been used results in my new post showing up "under" the other, as if
it were a response. For an example, see the thread in this newsgroup
entitled "Access 2007 w/VBA".
Microsoft Access MVP
Disclaimer: This author may have received prod...e-mail address privacy question
I have Outlook 2007 and I want to e-mail all my past customers about a new
I haven't sent out a mass mailing like this before.
If I put all their names in the "To" field, each recipient sees everyone
else's e-mail address. I don't imagine that the recipients won't want their
e-mail addresses to be public like this.
Please what's the best way to send my e-mail out so that all e-mail
addresses are hidden from each other so receipients don't get to see
everyone else's e-mail address?
Would I just put the list of e-mail addresses...Finding a string/using adjacent data question
It's a convuluted question that I hope has an easy answer. I'm rather
new to Excel formulas, so I've been trying to find stuff about this on
the internet but with not much luck. If anyone can help me at all I
would greatly appreciate it.
I have text strings in column A, A2-A335. I have numerical values that
correspond to each text string in columns B-O.
What I'm hoping to do is run a search for a given text string in column
A and then use the numerical values in D, H, and O for further
I want to be able to type in a name in column Q (for example) and have
the f...Complex Query question
I've got a challenging query I need help with!
Here's a snapshot of the tables and relationships. I've put the relevant
tables into this query layout just for illustrative purposes.
click on it to make it bigger (it's still a little hard to read)
Note - the table names start with phrases that are not relevant to this
question (ie I use the word "record" for another use than the normal database
usage of that word).
I'll explain the setup. I want the Table Record-Orders-Sales to lookup
Record-Cur...Exchange Server 2003 OWA Question
Hi There - we are running MS Small Business Server 2003 and using Exchange
Server 2003. In the past when a user logged onto OWA, they were NOT
required to enter the domain name. They would just enter their user name
and password and then when clicking log in or enter, the domain name would
automatically populate into the user name field and log the user on.
Yesterday, I applied Exchange Server 2003 SP-1 and now when a user logs in
using OWA, they are required to enter the domain name, i.e. DOMAIN/USERNAME.
Does anyone know how to change this setting so that it will automatically
...Cost of Goods Sold question thanks! Crossposted to biz.comp.accounting
I use money porfessional 2005 and I have been diligent in entering the
cost of each of my items correctly when i enter new inventory items.
I am disappointed, however, when i see the report i get for my schedule
C, as it seems to be spitting out the *entire amount i have spent on
goods for the year* as my COGS, rather than the exact COST of the GOODS
that i have actually SOLD!!! LOL :D
so what am i doing wrong?
thanks to all!
...5 Questions/Problems encountered with Outlook XP
I posted this on the contacts NG but no one has replied, can anyone here
Running Windows XP and Office XP - Outlook 2002 (10.4219.4219) SP-2
Word version is Word 2002 (10.4219.4219) SP-2. Have Exchange Server.
Have set up a mailbox to which a number of users have access (as a service).
It contains a number of folders, including a Contacts folder and an Inbox.
I'm not sure why they haven't used public folders on the server for this.
(Does anyone know why you would choose to set these up under a mailbox
rather than as shared public folders?)
1. There appe...Trouble with a simple formula
Hi All,I have been trying to get this to work in a form to add 1 3 or 5 yearsfor the choice in the drop down [risk factor] to an entered date field[date of last FSMP] and display it automatically.=IIf([Risk Factor]="High - Annual",DateAdd("yyyy",1,[Date of LastFSMP]), IIf([Risk Factor]="Med - 3 Yearly",DateAdd("yyyy",3,[Date ofLastFSMP]), IIf([Risk Factor]="Low - 5 Yearly",DateAdd("yyyy",5,[Date ofLast FSMP]))))))I am self taught and am using=IIf([Risk factor]="HIGH - annual",[Date of Last FSMP]+365,IIf([Riskfactor]="ME...Global Contact Question
I have many users who would like to go into the Global Contact List and edit
information about other users and themselves, but it doesnt let them, it
shows everything greyed out.
Anyway to give access rights to everyone while trying to edit the Global
Exchange 2003 /
...I need help to customize a specific PowerPoint template
For PowerPoint template called "Beam", how do I change the first bullet on
the master slide to be yellow instead of red and still keep the shade effect,
and bring the bullet that is blue with the shade effect up to be the second
...i've got a simple excel problem that needs solving...
Hello, i'm new to the wonderful world of all thing's Microsoft, I've got
Excel 2004 for the Mac and i'm having to use it as a database for my large
record collection as they don't make Access for the Mac unfortunately.
I need a custom worksheet of just 4 columns long, the reason being that when
i get to the last column in the row (the rows being Artist, Title, Label,
Comment) i want the cursor to jump to the 1st column of the next row when i
press TAB as this would save a lot of time when inputting my record names.
(instead of moving the cursor down with the arrow a...Excel question #14
When using the scroll bar in Excel the screen blanks out - why?
We have installed CRM 1.2 on dev server using existing database(backup of
prod db). While installation we pointed Organisation Unit to "CRMDev"
(created manually under Active directory). but once installation is completed
i dont see any Organisation name and usergroups under "CRMDev" Organisation
Unit. Any reason why it didn't create? Is it using the same OU as prod. Is
there any setting that needs to be changed in DB and point it to new OU.
Where we did it wrong:
As posted in another post suggestion to
-create a OU in AD called devcrm
-backup...How do I copy a screen in Excel for use in Powerpoint?
I need to copy a few Excel screens for training purposes and want to paste
them into a PowerPoint slide show. Can anyone help?
Alt+PrintScreen and the paste into Powerpoiint.
> I need to copy a few Excel screens for training purposes and want to paste
> them into a PowerPoint slide show. Can anyone help?
It shows that i have transferred it to the clipboard but it will not show me
the screen in PowerPoint. Any ideas on what I'm doing wrong?
"David Hepner" wrote:
> Alt+PrintScreen and the paste into Powerpoiint.
> "Bess" ...Simple Visio Questions
Being new to Visio, I have some simple questions.
1) The shapes panel on my computer at the office has the shapes in a
condensed, small icon format. On my home computer, they are larger with
descriptions and larger icons. How do I change the format?
2) How do I change the default font that a drawing is to use after the
drawing has already been started?
3) How do I change the default connector line thickness that a drawing
is to use after the drawing has started?
4) Is it possible to modify the flow chart elements or create a
separate, easily accessible library of elements?
I have Common Dialog loaded on my main form (Form1), which is always
The second form (Form2) is opened ocassionally.
Do I need to load another Common Dialog on Form2 or is it just enough to
make a reference to Common Dialog on Form1?
Is there any advantage (or disadvantage) of one method over another?
Please share your experience,
"Claire" <replyto@fra> wrote in message
>I have Common Dialog loaded on my main form (Form1), which is always
> The second form (Form2) is opened ...Macro Question #15
How do you write a macro that specifices the largest number result in
range of values
Message posted from http://www.ExcelForum.com
do you mean that you want to return the Maximum of a range
with a formula use
with vba use
max_value = application.worksheetfunction.max(Range("A1:A100"))
where range A1:A100 are your numbers
"Beth0202 >" <<Beth0202.firstname.lastname@example.org> wrote in message
> How do you write a macro that specifices the largest number result in a
&g...Report Question Please
How do I print a copy of the check register in date order just as it appears
in the checkbook? I do not want the deposits to be seperated from the
Thanks in advance... Bob
Use an Account Transactions report instead. You can customize it to print
the date range, account, categories, etc. just the way you want.
"Bob Newman" <email@example.com> wrote in message
> How do I print a copy of the check register in date order just as it
> in the checkbook? I do not want the deposi...Another question regarding Dates..
First, thanks to the replies to my previous post.
How can I work out the day & month when I only know the Year and Day Number?
Year = 2004
day number = 302
The answer I'm looking for is 28/10/2004
Again, taking into consideration the leap years
Thanks again in advance
"Anthony Slater" wrote:
> First, thanks to the replies to my previous post.
> How can I work out the day & month when I only know the Year and Day Number?
> Year = 2004
> day number = 302
> The answer I'...AOL address book to Outlook Express 6 Question
Is there any way to export from AOL into OE 6 or import from AOL into
OE 6 my AOL 9.5 address book??
I use OE6 to get my AOL mail so I can read it without having to be
> Is there any way to export from AOL into OE 6 or import from AOL into
> OE 6 my AOL 9.5 address book??
> I use OE6 to get my AOL mail so I can read it without having to be
> online continuous.
&...Checkbook maintenance question
I understand that the cash account balance in the checkbook maintenance
screen is the current balance of the cash account tied to the checkbook. In 2
of our 5 checkbooks, the cash account balance does not match the gl balance.
We are using separate gl cash accounts for each checkbook. I have run
reconcile on the gl and checklinks on Bank rec tables. This is v10.0. How do
we get them to match?
The check book acts as a sub-ledger to the GL and should be manually
reconciled each month. Look for journal entries to cash account as they will
cause differences. There are some third party p...Excel 2007, Basic, Square-1 Opening Question
Clicking on an xls or an xlsx file opens Excel 2007; however, the
file itself does not load/open (no blank sheet either). Only way is to
drag the file from its directory.
What have I done wrong?
Try minimizing and then maximizing Excel to see if that makes the file
appear. If it does, I'll build a small routine that does that automatically
when a file is opened. This appears to be a very frequent problem for some
Excel 2007 users.
<firstname.lastname@example.org> wrote in message
> Clicking on an ...CDaoWorkspace Question
I am writing a MFC Dialog program with MS Access Database support.
My OS is Windows XP SP2.
Previously, I used VC.Net 2003 to these create program without error.
But, Now I am using VC++.Net 2005 to create this program, it has Run-Time
The error code is 3028.
What's wrong of my program???
=== Error Message ===
DAO Call Failed.
V_BSTR(&varUserName), V_BSTR(&varPassword), &m_pDAOWorkspace)
In file f:\rtm\vctools\vc7libs\ship\atlmfc\src\mfc\daocore.cpp on line 577
scode = 800A0BD4
Error Code...NNTP Question for 2K3
If I create an NNTP expiration policy like the one described at
http://www.petri.co.il/configure_newsgroup_expiration_policy.htm does it only
apply to newsgroups that come in as feeds? I have several internal groups
and when I set a policy up like the one in the link it doesn't appear to
actually kill of any content. Is a restart needed? I'm thinking it may only
apply to external feeds but can't be sure.