Please Help! #2Hi Folks!
I need to create a macro for my work and I have been trying all day t
do it without success. None of my workmates can offer a bette
solution.
The problem: I have been asked to write a macro which will filter ou
approximately 160 reference numbers from a list of approximately 500.
It takes the following structure:
Scheme No Area Dept Person
9876gf34 A G.P.P D Smith
9898gf54 B M.P.U T Jones
I receive a different spreadsheet every week with 500 numbers. I need
macro that when activated will filter out the 160 relevent numbers an
paste ...
Exchange DR woes, please help.Gah, it happened, the Exchange 2003 server died, weeks before we were due to
start developing/testing our DR plan.
OK, the server was DC and I had to chop it out of the AD as I was not able
to do a happy restore.
So I rebuilting it as a member server, applied patches and installed Ex2003
in recover mode. (/disaster recovery)
There were a few problems with security for certain objects but I figured
them out with the help of google.
Applied sp1.
I have a full backup from a week ago and the logs from sunday. (veritas)
I restored both the stores, but they do not mount.
A rather generic erro...
help attaching filesHi...
Using XP Pro and Outlook 2003.
For some odd reason, I am unable to attach files when sending emails.
Click on the 'paperclip', window opens to the My Doc folder. then when I
click on a sub folder to open, nothing happens... finally, a Microsoft Word
window opens that it is unable to open....
It is almost as if it is trying to launch Word to open the folder...
Help?
Thanks!
--
B'rgds,
Vinnie
FWIW, from the Microsoft side a new Knowledge Base Article (KBA) was
released on Apr 15th.
http://support.microsoft.com/?kbid=918165
It lists two known conflicts so far....
Publisher 95 Help!Just got my computer redone and we wiped out everything from Windows ME and
went to Windows XP Professional. Had an old version of Publisher that was
working fine with the ME. Now that we got the xp i installed the Publisher 95
and tryed to retrieve the old files i created (copied on cd-disk before the
switch) from the CD and it is telling me "Publisher can not load files from a
different version" Can anyone help?
How many files are you talking about?
--
JoAnn Paules
MVP Microsoft [Publisher]
"Deb" <Deb@discussions.microsoft.com> wrote in message
news:C67E...
CRM Customization Help!!!There are a few things in CRM that we would like to customize.
I noticed that you can create and modify views however where can you modify
the views for activities and notes?
Can you add a start time and end time to a case and automatically calculate
the duration?
Any help with these questions is greatly appreciated.
If there are examples or cusomization documents we could look at that would
also be great.
I figured out how to modify some of the hidden views that are not
customizable through the interface. I was able to add the File Name column
to the note view. However can you make the ...
Help with clickonce deployment over VPNWe have an office in a different location where two employees need to
use my program.
We are using Small Business Server 2003 R2 with ISA Server 2004 as our
firewall, which is set up to receive VPN connections. I am using a
self-made certificate for Exchange webmail.
I currently publish to a folder on the server and all the office
computers can install and receive updates from that location.
I need the VPN clients to be able to install from the same location.
Heck, I'd be happy if they installed from ANY location at this point!
I've tried to FTP, I've tried to acce...
Help needed with date functionHi all
I am making a 3 page spread sheet which will have a column with
different dates. The idea is that something needs to be done at that
particular date and I need to program excel to warn me when the date is
approaching. It is almost like I need it to be an electronic calendar
with alarm.
Very simply: one sheet has the dates in a column. Each cell has a
different date (not necessarily in cronological order). I am using the
dd/mm/yy format (Europe) and I want to have another sheet which,
amongst other data, will have a space / cell reserved for this warning.
I hope I have been clear e...
Help an Excel novice with a graph formula?I have worked some with MS Access, much less in Excel and really am not very
math oriented but I need help. Not much on graphing in the Access Forum but
several suggestions to use Excel because it is much more powerful in this
area. I have numerical test values on the Y axis matched with numerical
values representing age in hours on the X axis, plotting a line graph in
Access which represent a limit.
I need to compare new data sets on a daily basis with this line graph
identifying each set as either above or below, Less Than or Greater Than the
limit set my this graph. Is there a f...
forecast function help
This might seem a bit newbie but im having trouble with the forecas
function.
Say for example i have a collection of data for sales of each item ove
a number of years:
item 2000 2001 2002 2003
1 3 4 5
2 4 3 2
3 2 2 4
4 3 1 5
5 4 1 6
6 2 2 4
i am asked to forcast the values for the year 2003. I have read an
looked at many examples on how to do this and still can't work ou
where to start?
Any help would ...
unable to enter data on form. help?I have created a form using a relationship between two tables. This was to be
a data entry form but when I try to enter data nothing happens. The cursor
moves to the first field but typing doesn't result in data appearing on the
screen. I could do with some help
It sounds like you have based the form on a non-updatable query.
For a list of why this might be so, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
There are other possible explanations, e.g.:
- you set the form's AllowEdits property to No
- you set the form's Recordset Type property to...
Formula Help #40I want to use excel to subtract two times and then divide a specified cell by
the sum and return the value. Example: I get to point A @ 7:00am depart @
9:00am and deliver 864 boxes. How many boxes per hour did I deliver? When I
sum 9:00am - 7:00am I get 2:00 then if I divide 864 by that I get 0:00 if I
leave it formatted as time. And if I change the format to general I get
10368?? I should get 432
9am-7am gives 0.00 in time. if you format as number it will give you
0.08333333... that means 0.083333333.... day. so 864/.0833333......./24 will
give your per hour i.e. 432
A1 ------7:00am
A...
tiny letters helpAll of a sudden, my letters in word are teeny, tiny. I have looked at
everything that was suggested in prior posts and nothing has worked. Old
documents are fine, and it prints fine but I can't read the screen.
Have you tried changing the zoom?
--
Stefan Blom
Microsoft Word MVP
"judi" <judi@discussions.microsoft.com> wrote in message news:9E610266-4597-41F5-8C40-61BB455ED834@microsoft.com...
> All of a sudden, my letters in word are teeny, tiny. I have looked at
> everything that was suggested in prior posts and nothing has worked. Old
> doc...
help with correlated query and TOPam using sql server 2000 and i need to do the following.
i have a table like this (pseudo coded)
CREATE TABLE TEST1 (ID INT, STATUS VARCHAR(15))
INSERT INTO TEST1 (ID) SELECT 1
INSERT INTO TEST1 (ID) SELECT 2
CREATE TABLE TEST2 (ID INT, STATUS VARCHAR(15), CREATE_DATE DATETIME)
INSERT INTO TEST2 (ID, STATUS, CREATE_DATE) SELECT 1, 'A',
'2007-01-01'
INSERT INTO TEST2 (ID, STATUS, CREATE_DATE) SELECT 1, 'B',
'2008-01-01'
INSERT INTO TEST2 (ID, STATUS, CREATE_DATE) SELECT 1, 'C',
'2009-01-01'
INSERT INTO TEST2 (ID, STATUS, CREA...
Number to text conversion ......HELPDear Friend..
I need help in converting formula calculation ( Number or Currency ) into
Text
EQ. Result = 2,500.00 converting to .....two thousand five hundred..
Thanks
Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Eko Hery" <eko@megaenterprise.com> wrote in message
news:BCD8B0CE.1D8%eko@megaenterprise.com...
> Dear Friend..
> I need help in converting formula calculation ( Number or Currency ) into
> Text
>
> EQ. Result = 2,500.00 con...
How to create and use xlw file? Help!Hi,
I had a huge file with numerous links. It can not even auto-calculat
the formulas once I made a change. I guess it is just too large.
Anyway, I posted a message on another forum and someone suggested t
use xlw file so that when I open the xlw file I will open several file
linked to xlw file at the same time. And that may do help.
I don't have any idea about creating and using xlw file. Anyone know
details about it? Pls. help
--
Message posted from http://www.ExcelForum.com
Start by looking at
Save a group of workbooks in a customized workspace
in XL Help.
In arti...
Help with SQL Table/FieldI am trying to run a purchasing report that includes item #, qty ordered, qty
shipped and qty canceled as well as promised date and PO#. I have all the
data I need except for the qty shipped on each line. I've found all the data
I need in tables POP10100 and POP10110. Can anyone help?
Thanks.
The QTYSHPPD values are in the POP10500 table...
--
Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Financials
Currently supporting: GP 9.0, SP2
"Grieves" wrote:
> I am trying to run a purchasing report that includes item #, qty ordered, qty
&g...
Fixed Asset Error, please help!I did a mass retirement of assets but one of the assets did not create a
gain/loss account. When I did an Asset Inquiry, it showed that the status of
the asset was 'Retired'. But when I did a retirement inquiry, the retired
asset information did not show on the list.
I tried to Undo the Retirement process and the system displayed the
following error:
"Return code 2 on script FA_Get_Period_Infp. Date: 0/0/0000"
Situation: The specified script aborted with the given return code.
Solution: Contact Systems support with the text of this message
tray in a test inveroment t...
Clearing Entries-HELP
I am using GP 7.5 and entered clearing entries by trx period and it worked
fine for months Mar, Apr and June but May did not work for some reason. When
I do an inquiry by account summary, the balance for May is still there.
However, when I try to reenter another clearing entry - its state there is no
balance to transfer.
Does anyone have any ideas on what I can do to correct??
Any input is appreciated.
thanks
Barb
BK,
Was the clearing entry posted? Also when posting, it might not updated the
GL summary tables. Please do a Utilities>>Financial>>Reconcile for the year
...
Help!!! Outlook 2003 RulesHi There,
I need your help to create a outlook 2003 rule
I get approx. 200 emails with attachment every day
I have to print each one of them, so i created a rule, that every new
email, if it contain an attachment = print it
The problem is that the rule print not only the attachment, also the
message itself.
i lose tons of paper for nothing?
any suggestion how to prevent it?
let me know
thanks very much
Assaf M
you'll need a 3rd party tool.
http://www.slipstick.com/addins/auto.htm#special - both mapilab and Sperry
software have addins that can do this, as do others.
--
Diane Poremsky...
Need help pleaseLet me start from the beginning. I am trying to create a cumulativ
value that would show only when that month is included (i.e.
cumulative number would show up in Nov. once a monthly number i
entered in Nov.). That value, when present, is then linked to a char
on another worksheet. To do this, I have created a formula that look
at a cell and either returns a value or "". By "", I wanted t
return a null value. So, what's in the cell that the chart is lookin
at is a reference to the formula result which I thought was a nul
value, but the chart is reading it as a z...
Help required with Violent Incidents DataBaseX-No-Archive: yes
Dear Group,
I need to create a form for entering information from the original paper
version submitted by staff following an incident.
The information will be
Was the patient Male
Was the patient Female
Was the pateint Informal
Was the patient Formal
Was control and restraint used
etc etc...
The information needs to be submitted into an ongoing database.
So if the patient is Male then +1 is added to the male total
etc
I would then like to be able to include on the database (but not the
form)...
How many incidents occurred where the patient was female and informal.....
HELP, Navigation bar works in Firefox, not ExplorerI have recently uploaded a website created on FrontPage 2003 to GoDaddy. The
home page navigation bar works well when viewed with Firefox, but not at all
with Explorer 7. What's wrong???? Thanks,
No idea. But your question seems to have nothing to do with Access, the
Microsoft database application that this newsgroup is concerned with.
Rob
captain" <captain@discussions.microsoft.com> wrote in message
news:1EAD2E1E-6F46-49F6-AB38-3F26A3B764ED@microsoft.com...
>I have recently uploaded a website created on FrontPage 2003 to GoDaddy.
>The
> home page navigati...
Cannot Use 2007 Office Resource Kit Technical Library in Compiled Help formatI downloaded the 2007 Office Resource Kit Technical Library in Compiled Help format, double clicked
on it, cleared the Always ask before opening this file check box and clicked Open.
All I got was a window with a little icon in the top left. How do I get this to display properly?
Thanks for reporting. It appears something is wrong with the latest
published version (version 5 published on 6/12/2009). I've passed it on to
the Office Resource Kit writer team at Microsoft. In the mean time, you can
still access the content on-line via;
http://go.microsoft.com/fwlink/?LinkId=127122
The c...
Publisher 2007 helpI am having problems printing out business cards.
I have tried putting in different dimensions for the Margins and Gaps and
still does not print out inside the card stock.
Can anyone give me the proper dimensions to put in?????
macphade wrote:
> I am having problems printing out business cards.
> I have tried putting in different dimensions for the Margins and Gaps
> and still does not print out inside the card stock.
> Can anyone give me the proper dimensions to put in?????
=====================================
Maybe the following article would be worth a look:
Create your own ...
Formula BarIn my previous copy of Excel, when I typed in an equation in the Formula Bar, it would give me a little message window that showed where I was in a particular equation. Now that I have a another copy, I don't know what the "on" switch is for this function.
Please help, it's driving me crazy when I create very long equations.
Thanks,
AK
AK
it was introduced with excel 2002, you turn it on/off under
tools>options>general>function tooltips
--
Regards,
Peo Sjoblom
"ak" <anonymous@discussions.microsoft.com> wrote in message
news:BB2440A2-2883-4...