I am looking for an option to help track events. I would like a "box to put
up when and inventory item is scanned" That can be updated with curent event
status or the previous list of the "events the clothing item has been sold
This also needs to be done on a HQ level, so that when one location makes
changes to that item it carries over to other locations.
...Tracking item quantities and values
I'm wondering if there is a way to track the quantity of items in a category
or department over a history of time, including the total value of those
categories or departments at that specific time. For example, I tried a
report on Reports > Items > Value List and was able to get extended
quantities and extended cost for the current time, but I am unable to change
the time in the filter. I have also tried Reports > Items > Item Movement
History and changed the range to Year to Date. This includes the change in
quantity, but not the change in extended cost. It seems like ...Tracking users who open my workbook
I am developing a number of templates at work that will be save on the
network using Excel 97. I was wondering is it possible that I can set up the
templates so that when a user opens up the spreadsheet, his/her network
username, date and time can be automatically recorded on a hidden sheet
within the same workbook or a seperate workbook?
Thank you in advance.
...Changing margins on different pages in document templates.
I was wondering how you change the margins for different pages in a template.
Specifically, my firm is using a letterhead for the first page but blank
pages after that so the header and footer margins on the first page ONLY must
be larger than normal, while the following pages are fine with default
settings for the margins. How do you do this and save it as a template?
See http://sbarnhill.mvps.org/WordFAQs/Letterhead.htm, especially the "More
complex letterhead" section.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://wo...Changing formula in multiple cells or range simultaneously
I am trying to change the value in multiple cells in a
large worksheet simultaneuously. I want to identify the
range and then adjust the formula in the entire range. Is
there a way that I can highlight the range and then change
to formula in each, simultaneously? For example, if I
wanted to double the value in the entire range, how would
I do this?
You could put 2 in an empty cell.
Edit|Paste special|click on Multiply under the operation section.
Then clear out that 2.
But it really depends on what kind of change you're making. If you wanted to
ad...changing from outlook 2000 to outlook xp
i just bought a new computer and want to move all my
outlook 2000 personal folders from my old computer--to my
new computer which is running outlook xp. What's the best
way to do this?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
sammy russo <email@example.com> asked:
| i just bought a new computer and want to move all my
| outlook 2000 personal folders from my old computer--to my
| new computer which is runnin...Report Builder 1.0 Filter Prompts
I have created an ad-hoc report and want to add a filter. I understand that
the Report Builder will only pre-populate the 'in this list' for that filter
if the list contains less than a pre-determined number of entries. Fair
enough. However, where can I find out what this magical number is...it would
certainly be handy if I could be allowed to set the pre-determine number
myself, or at least view it. I found an article that said that value is in
the DataSource (or the DataSourceView) but I have found nothing that tells me
what the tag, or the location of that special ...Best way to change style of a table
I have a table I added via VBA like this:
set oTable = ActivePresentation.Slides("mySlide").Shapes.AddTable(...)
I then add some cells to it by:
oTable.Cell(...).Shape.TextFrame.TextRange.Text = "some text"
However, I cannot get a handle on these cells to update the font, fill, etc.
What is the best way to do this?
On Sun, 13 Dec 2009 21:01:01 -0500, Clifton Ivey <clifton ivey
> I have a table I added via VBA like this:
> set oTable = ActivePresentation.Slides("mySlide").Shapes.AddTa...Date Changes to 01/00/00 when i enter any date.
Using XL2003, I have a problem. When i enter a date in cell, such as
08/25/10, or use the shortcut Ctrl ;, XL displays 01/00/00 in the
cell instead. I have formatted the cell as a date. What can I do to
fix this problem?
Thank you so much.
...Change the Default Language Setting
Is it possible to set the language to 'English (Australia)' so it will be
the default across all office applications? I keep having to change it
manually in outlook at the moment.
..."change order form"
Does anyone have a change order template that I can review?
The local power company had a problem last week. The power nearly went off and
came back rapidly several times. I have a spreadsheet with a lot of hyperlinks
to other files. After the power fluctuations the hyperlinks have the wrong path
names to the files. The file names are all correct, but the path to them are
Is there a way to restore the proper path name in mass, or must I correct each
and every one? The wrong path names are all the same. Does anyone know how this
could have happened in the first place?
...why cant i change font
i select all the text in a textbox and try to apply a font. nothing happens.
that's the case with 4/5 fonts, only a few work. the same appears in both
publisher 2003 and 2007.
Are you creating a web page? Publisher will show 11 or so fonts when you are
creating web pages. To use all the fonts, on the toolbar, Format, Font, uncheck
Show only Web fonts.
If above is not the issue, are you getting an error?
Mary Sauer MVP
"ayudameconpublisher" <firstname.lastname@example.org> wrote in
message news:1BE1262A-A70B-4...How to change Marketing list member "All members" to "Active membe
How to change Marketing list member "All members" to "Active members" in CRM
Any help is appreciated.
I have used the following code giving object required error
* Change the default view of the Marketing List Members (Account)
if (crmForm.all.createdfromcode.DataValue == 1)
if (crmForm.FormType != 1 && crmForm.FormType != 5 && crmForm.FormType != 6)
...Showing Duplicate Rows
I have seen the question with that same title however that is not exactly
"showing" duplicates. It is more showing unique (not duplicate) I would
like to truly show the duplicates.
For instance there are several duplicate product numbers that are in my
sheet and I want to display all the duplicates so that I can make corrections.
How can I filter so that excel will only show those rows that have duplicate
Use data>filter>autofilter>filter by column...changing report headings names
I would like to give the user the option of changing the report heading
names, I can do this with the Docmd.openreport, stdocname,
acviewdesign,,,achidden and then grab the current heading and display that
heading and allow the user to change it. I then do a docmd.close acreport,
stdocname, acSaveYes, this works just fine when I test but when I compile the
program into a mde it doesn't like the it. Is there another way of doing
this? Thanks for any help.
you can write the current heading names to a table, making sure the table
holds only one record. add the table to the quer...Change of public IP for fighting spam
If I ask my dns registor to change my ip to another public ip. Is this
going to help us fight spam? Is there's a risk of not getting email?
Example old: www.company.com = 184.108.40.206
Examble new: www.company.com = 220.127.116.11
By the way, I noticed that most big companies cannot be ping anymore. Is
this advisable too?
On Thu, 20 Apr 2006 08:06:02 -0700, RickyVene
>If I ask my dns registor to change my ip to another public ip. Is this
>going to help us fight spam? Is there's a ris...'07 Large Operation Error (Delete / Insert Rows and/or Columns)
Help! I was so excited to have '07 until...
I have a very simple worksheet in a work book -
This very simple worksheet takes up 78 rows and 16 columns. Minimals
formats / formulas etc.
I would like to insert additional rows but I get the error message which
says "Large Operation. The operation you are about to perform affects a
large # of cells and may take a significant amount of time to complete. Are
you sure you want to continue? Note: This operation will be performed in 60
seconds if no response is received".
I have tried to select "OK" as well a...Unloading NDIS IM Filter driver
I am using NDIS Intermidiate filter driver in my application.
My application is successfully installing and uninstalling the driver
Can anyone tell me How to unload NDIS IM filter Driver?
Thanks for any guidance.
> Can anyone tell me How to unload NDIS IM filter Driver?
Via INetCfg API?
Maxim S. Shatskih
Windows DDK MVP
On Aug 6, 11:44=A0am, "Maxim S. Shatskih"
> > Can anyone tell me How to unload NDIS IM filt...Tracking
I'm using Publisher 2003 and working to a client's style guide for preparing
service brochures. In the tracking specification, the guide specificies a
value of -3. Problem is, Publisher uses percentages.
Can anyone advise me on how to work this out.
Also...the specifications state: "57 Univers Condensed, 9/14..." - Does
anyone know what the 9/14 is? Probably dumb questions, but I'm stuck
Thanks in advance...Keir (email@example.com)
Keir Wells - ACW
First guess is a date of the file. Apparently there are several different
Univers Conden...Mail Merge Tracking
I'm currently successfully creating a mail merge using Outlook and am able to
send the form email to several individuals. However, is there a way to track
if the email has been read using the tracking features of Outlook?
No, not via the standard Mail Merge feature.
You can achieve this with several Mail Merge add-ins though such as Send
Individually from Sperry Software;
If you decide to order use BH93RF24 to get a discount.
Other Mail Merge tools are listed here;
Robert...Automatic tracking seemingly too clever in CRM 4.0
We are experiencing an interesting thing with automatic promotion of emails
This did not happen in CRM 3.0, but is happening since the upgrade to CRM
4.0: After an email from a specific email address is tracked once to a
specific client, CRM automatically in future always tracks all emails from
this particular email address to the specific client regardless of the user
in the company who receives the email. This is CRM being almost too clever
and it does not make sense. We don't always want this... An example: Document
scanned in from our scanner and emailed to a user will...Outlooks "Incoming mail (POP3)" keeps changing to "local"
Hi everyone, I have a question on Outlook 2000, every few
days my account setting for the "Incoming mail (POP3)"
change from the mail server I have specified to "local"
and the mailServer then gets added to the "Account
Any ideas on why is it doing this, and can I stop it from
doing this, cause each time it does, I have to manually
change it back to original setting so I can get my mail.
This is your antivirus software, most likely (or antispam software). Outlook
doesn't do this. Check with the mfr. to see if they have an...Simple Filter
I have a datasheet with a list of sales numbers and multiple invoice
dates (stored as text) for each sales number (there are duplicate
sales numbers, and distinct invoice dates). I need to compress the
list so I have only one (any one) invoice date for each sales order.
Can you post a small sample of the data AND what you would like the result
Microsoft MVP (Access)
"c.n.ricker" <firstname.lastname@example.org> wrote in message
>I have a datasheet with a li...Fein FBK-1 Filter Bag Kit for 9-11-55 Turbo I
Best price found: http://bestdeallocator.info/index.php?id=B001342J2E
This is a complete kit for converting the Turbo I vacuum to a two-stage filtration system. Remove the cloth dust bag and mount the 1 Micron filter and the dust bag to clean up smaller particulate material with the Turbo I vacuum. This kit includes everything necessary in one package. Great for work with drywall and sheet rock dust as well as other smaller particulate materials.
Fein 913038K01 3-Pack of Vacuum Bags:htt...