Report Manager #3
How can I create reports using predefined views in excel 2003
How to install the Excel 2002 Report Manager add-in in Excel 2003
How to create multiple views, create a report, and print a report in Excel
2002 and Excel 2003
Gord Dibben Excel MVP
On Wed, 16 Feb 2005 12:35:02 -0800, "Kish Patel" <Kish
>How can I create reports using predefined views in excel 2003
...How can I set up the random selection of a cell from within a ran.
I want Excel to randomly select one cell from a range of cells, but is it
possible? This would be the equivalent of drawing one slip of paper from
An uncomplicated way to do this is to simply add a column filled with the
RAND() function next to your column of choices.
Select both columns, and sort on the Rand() column.
Pick the one at the top, or bottom, as your random selection.
A little more complicated procedure would be to use a formula, referring to
this combination of Rand() and your list, and let this formula randomly pick
Place your list in an "out o...Can you program Excel to draw an asymptote?
I want to know if there is a way to get excel to put an asymptote on a chart
if you already have a parabolic data set on the chart. My goal is to find to
value of the asymptote for further analysis. I know I can fudge a straight
line graph onto the chart but it is not meaningful without the true value.
"csusbgirl07" <firstname.lastname@example.org> schrieb im
> I want to know if there is a way to get excel to put an asymptote on
> if you already have a parabolic data set ...Create Window at Runtime from function
I'm trying to create a window at run-time where all I have to do is pass
the Caption and Label, and then the function will display a window. It's
intended to be a small window used for quick user input.
The code below compiles, but on calling it, no window is displayed. A
button in the task bar is created, however, so the window class seems be
running -- I just can't see it or interact with it.
My guess is that the problem is I haven't given it an instance -- all the
examples I have seen start from the WinMain procedure, and they just use
that instance. I'm not...Need to sum up numerous columns in different worksheet into 1
I generate 100-200s .csv files end of each month for my company.
Each of these .csv files have numerous data that I need to sum up for a
(Example: 1.csv have 3 columns with things like, item A, item C, item D etc
and 2.csv have columns with item B, item C and item E... and so on and so on)
I am required to sum up all these 100-200s .csv files and have a total sum
of how many of each items appeared and used by the users.
(Example: item A - total count 100, item B - total count 20.. .etc etc)
Is there a way I could do it without going through each of the .csv files
and counti...outlook can't receive exe files
A guy here at work can't get exe files through his outlook. Is there a check
to uncheck somewhere to allow it to do this? He can receive normal
...Adding columns to "Look Up Records" window #4
In certain places in CRM (specifically highlight a Lead, click New Email, and
press the looking glass lookup button to the right of the To field) when I do
a Lookup for contacts or accounts, the window "Look Up Records" appears with
a list of entities at the top, a search field, and two lists below. The left
list is available records and the right is selected records.
The Available Records list only displays a single column, the name of the
account or contact. I want to display more columns, and scollbars are OK.
My specific issue is that I have 4 "Rick Johnson" c...Convert Text to Date Month and Year
I have a cell for example that displays 03/07 as a text field for month and
year. I want it converted to date field to display as = mar-07 or march 2007.
when I use format or text function it converts to 03/07/2010. I dont want to
have the current year display instead it should display 2007.
and format as: mmm-yy or mmmm yyyy
"Excellency" <Excellency@discussions.microsoft.com> wrote in message
> I have a cell for example that ...how can i do this
i am using office 2007
i have a table called titles that has title of the movie and the another
field called year of movie also another table called actor that has actor
name of the actos and another infos
and third table called title-actor which is junction table of the two
previous tables and has the fields of title,year,actor name year
the title and the year is conectted to titles table and the actor name to
the actor name in actor table
now i have form based on each of the two tables and each one has sub form
whichs based one the junction table
the title form has su...Outlook 2003
I would really appreciate some help on this. I run Norton AntiVirus and it
has this really aggravating behavior .. all virus infected attachments are
deleted, but the emails they rode in on end up in my inbox. There is no NAV
option to not only delete a virus infected attachment but also its email.
Since all of the virus infected email I get is spam, I end up with lots of
extra junk in my inbox. The Outlook 2003 junk filtering does a pretty good
job on everything else.
So .. I want to create a rule to move all emails with a file attachment
called "Norton AntiVirus Deleted1...Can't group pivot table items by month in Excel
i use excel 2004 for mac but have the same problem using 2003 for windows. i
have a pivot table with dates in the rows, names in the columns and count of
quantity in the data section. i want to group the date entries by month. i
follow microsoft's help directions listed below but i am never prompted with
a starting at box, ending at box or by box. the pivot table just groups
whatever i have highlighted and gives me no other options. i would like to
use this smart grouping option. please help.
1. Hold down CONTROL and click the selected date or time items, point to
Group and Outline...Saving and Restoring a Child Window to its Former Position and Size
I want to save a child window's position and size in the Main Window of an
MDI application, and restore it at any time later. I want to do this after
the user may have reposition and resized it. The parent of this child window
is the Main Window. Below is the code I am using to save the position and
pView->GetWindowRect( &m_WndRect );
AfxGetMainWnd()->ScreenToClient( &m_WndRect );
where pView is a pointer to the child window and m_WndRect is used for the
storage. Below is the code I am using in an attempt to restore the position
and size stored in m_WndRect:
In Outlook Express (Microsoft Office XP version),when I
receive pictures in an email and the file is attached I
don't have any problems. However some emails come in
with pictures that don't include the file. All I get is
a picture box with a little red "X" in the upper left
corner. Can anyone tell me why this happens and how to
correct it? If by chance an email comes through with a
picture and I want to forward it, I go to the 'format'
menu and select send picture, but most of the time the
forwarded amails come back stating that the picture
didn't co...Can field names be changed with a query?
I've got a sequence of queries that culminates in a final make-table query.
I would like to change the fieldnames with the final query, producing the
table with new fieldnames. Is there a way to do this?
Sure. In the field name put what you want to see in the new table like so:
What is before the colon ( : ) should be the new field name.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I've got a sequence of queries that culminates in a final make-tab...How can I get Outlook (2002) from deleting emails older than 6 day
I have auto-archiving turned off, ansd I am doing backups manually thru the
Science-based nutrition! See TIOEnterprises.net
Change your view settings - enable the advanced toolbar and use the dropdown
to enable all messages, not just messages from the last seven days.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
"Mark Hilbrink" <MarkHilbrink@discussions.microsoft.com> wrote in message
news:639E637B-C8B...Someone who can provide TRaining in NJ
I just openned a retail store in NJ. I need some help with some features
and am looking for some in store training formyself and my partner. We are
looking for informal, mostly question and answer training and demonstration
and maybe some assistance in setting up some features we are unsure about.
We have been using the system for several months now.
We have installed over 100 stores across North America remotely. Are
services are a $100/hr and we can spread out training sessions over serveral
days to allow you to digest the information.
If interested you can contact me a...Window Mail
Please help me to set up Windows Mail to retrive my gmail account
I got lost...
This newsgroup is for technical discussion of, and questions and answers
about, Microsoft Access database software. More than likely, if you lost
your account or password, you'll need to contact gmail directly. If your
question deals with how to enter account and password information into
Windows Mail, you should seek a newsgroup or online forum that deals with
Windows Vista or Windows 2010.
Microsoft Office Access MVP
"Jabez" <email@example.com> ...Allen Browne - Find as you type
Hello Allen (or others)
I am using Allen Browne's great utility 'Find as you type' on a form, but
now want to print the results of the forms output. Can it be done?
"efandango" <firstname.lastname@example.org> wrote in message
> I am using Allen Browne's great utility 'Find as you type' on a form, but
> now want to print the results of the forms output. Can it be done?
You may be able to apply the form's filter as the WhereCondition for
OpenReport, like this:
Hi I am doing a spreadsheet which covers a one week "snapshot of a
bowling leage" all the data is imported into a data sheet which
includes scratch games (totalling to series), Handicap games (totalling
the first colum is the bowlers name followed by fixed (non formlated)
stats such as starting average, no of games, etc which are used for
the next colums are the scratch scores followed by the hadicap scores
I then have another worksheet which is a presentation sheet this is the
sheet I print. it contains the top 5 male and female scores, the
bottom 5 male ...I have a column of many many numbers how can i split them up auto
I have a group of numbered data that I can split into different columns using
text to column. I now need to place a blank row in between each row of
diffeerent data. Can this be done
Give a few examples of what your data looks like and what you are
trying to achieve. What do you mean by "different data".
On Dec 3, 8:23=A0pm, Kevin <Ke...@discussions.microsoft.com> wrote:
> I have a group of numbered data that I can split into different columns u=
> text to column. =A0I now need to place a blank row in between each row of
> diffeerent data. ...Can I do Labels from out look and also How do I
I really need to print some adress labels and put them on another computer
how can I do this? I can either use mord or out look
Check OfficeOnline's template section to see if something there suits your
"Capggal" <Capggal@discussions.microsoft.com> wrote in message
>I really need to print some adress labels and put them on another computer
> how can I do this? I can either use mord or out look
...Installation of Project server 2007 on Windows Server 2008 R2
I am attempting to install and configure Project Server 2007 on Windows
Server 2008 R2. After successful installation, Sharepoint configuration, and
PWA setup, I try to access the PWA site and get the error message "An
unexpected error has occurred". If I follow the same installation /
configuration procedure with the only difference being Windows Server 2003 I
can open the PWA website successfully.
I am creating a clean install of Windows Server 2008 R2 x64 and applying all
available updates (I have also tried with out any updates).
I add the Application Server &...Can (or how can) I do this
My Access application tracks an employee's progress through a process
similar to hiring. There are 5 steps in the process. I track 4 of the steps
by counting the number of times a value appears in a date field for that
step. The count is then displayed and used in a calculation. The 5th step
is more complicated. The 5th step needs to determine if the employee has
verified that he can access all the applications that he should have access
My process tracking table has the first 4 dates. The application access
info comes from a different table. This process trackin...My Outlook 2003 is running very slow, why?
slow start up, program not responding, slow when changing views. Freezes when
scrolling in month view, ect ect
"com" <email@example.com> wrote in message
> slow start up, program not responding, slow when changing views. Freezes
> scrolling in month view, ect ect
Mailbox big? Try some archiving. Tools, Mailbox cleanup.Have you ran disk
checking tools like chkdsk/scandisk/defragmenting? Other than that you
haven't really given very much to work on .....
"Alan" <al...Can I create a one page Twelve Month Calendar
I am trying to create a One Page Twelve Month (2006) Calendar, using either
Publisher or Power Point, that gives me room for Logo and/or address to
distribute among my customers.
New, Publications for print, calendars, when the wizard opens and you select your
design choice, there are options for date range and so on.
Mary Sauer MSFT MVP
"Chezerim" <Chezerim@discussions.microsoft.com> wrote in message
>I am t...