Report on Serialized items passing through a site
I want to run a report on the history of any serialized transfers to / from a specific site.
...A program is trying to automatically send e-mail on your behalf.
I tried posting this in microsoft.public.outlook.general, but no
Does anybody know how to turn the "A program is trying to
automatically send e-mail on your behalf." prompte off?
It pops when one of my MS Access apps is emailing one of it's reports
It happens on the Citrix server that one of my MS Apps is running on,
but it does not happen when the app is running on my own PC.
Consequently I'm hoping for some user-configurable setting that
controls...End User Recovery Report?
Is there such a thing? I see that DPM 2007 has a Recovery report that only
shows what has been done from the administrative console. However, I would
love to show my management how much time we are getting back from users doing
their own end user recovery. This seems like a great ROI feature.
Is there any way to pull that information from DPM 2007?
No , there is no way to get this data.
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason" <Jason@discussions.microsoft.com> wrote in message
Is there any way to create a template where a contact is
automatically CC in the email. So I dont forget to cc them
every time I send an email.
...Money 2006 constantly faults with automatic updates
Whenever I use the Internet automatic updates, money faults out and wants to
send a report to Microsoft. Also my account list shows most accounts with a
status of 'Update In Progress'
I've done a complete reinstall after removing it and power cycling my
machine. I thought it may have been something with removing 2004 and
installing 2006, but got same problem
Has anyone else been having this problem? I really just want to go back to
What's the error message?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq f...Exporting Contacts
Exporting the address infomration does not record which address is the
mailing address... Any way arround this?
...Queries and Reports in 2000 to convert to 97 Access
1/ I have created queries and reports in Access 2000.
How can I convert them down to 97 Access?
2/ When running forms, I get a message that
says "Insufficient Memory" My PC has 240megs of RAM.
What can be causing this? I have closed all other APPS
and still get the same message.
...Deleting Sheets Based on Name
Ive got a macro which makes a large number of sheets with information in
Ive then got another macro which gets all the information from those
the problem is... im then left with all the sheets.. and I really want to
Is there anyway to make a macro which would let me delete sheets.. based on
all the ones i want to delete are called "cats (104)" or "cats
(105)" etc etc..... there is one called "cats" which i want to keep.... so
basically If it could someonie delete based on the term "cats (&quo...Address Name on Contact and Account Entities
WHat is the purpose of this field on both of the entities? I can't come up
with a good reason why it was deployed the way it is.
you might want to call one addres the contact's "Vacation" address or their
"Home" or "Cottage"
pretty weak, but that the best example I can come up with!
"Chris Treanor" <ChrisTreanor@discussions.microsoft.com> wrote in message
> WHat is the purpose of this field on both of the entities? I can't come up
> wi...merging name tags
After I merged name tags (eight on a page), I saved the file so I could clean
up any names that weren't fitting properly. When I re-opened the file to
print it, it printed out each name eight times on a page instead of eight
different names on each page. Any suggestions on how to fix this? Thanks!!
Reset the merge data.
Are you using a label template? Are you trying to merge with all eight labels on
Mary Sauer MSFT MVP
&qu...Automatic axis format
I'm need to make a automatic axis format within excel.
The number of rows is depending of a imported file.
No problem to get the max. number of rows.
But to put this number into the chart ( category axis) is more problematic.
I try VB but my knowledge is at dummy level !
Waiting for your reply.............
Have a look at Jon's examples of dynamic charts.
> I'm need to make a automatic axis format within excel.
> The number of rows is depending of a imported file.
> No problem to g...msg:"name of imported entity already exists" should contain name
When I import an XML file that includes several modifications like entity
renamings(should be ported back to an older setup status), the following
"The name of the imported entity already exists. Please specify another
It would be more easier to find what entity or attribute can not be
added/renamed if there would be a way to configure the system for getting
more detailed error information (what entity/ what attribute affected).
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To v...How do I get an automatic equal sign to begin the formula bar?
How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
The = icon disappeared in newer versions of excel (xl2002???).
You can add an = icon
Tools|customize|commands tab|Insert category
(Scroll down the list until you find the = icon)
And drag it to your fav...My worksheet automatically adds a fill color when I enter text.
When I type text in a blank cell, the cell automatically is highlightes with
the bright yellow fill. There is no conditional formatting on this workbook.
Check your VBA editor.
You might have an Event Macro which does what, usually, a CF does.
Try to Increase the Macro Security to its maximum level in order to
eliminate the Event Macro from running...
You may, also consider to "rem" all the Macro commands by adding a Preceding
apostrophe to each command.
> When I type text in a blank cell, the cell automatically is highlightes with
> the bright yello...Help with printing one name on a report
On my Form that has No Record Source I have a Combo Box [cmbHorsePlanner]
that has a row source
SELECT qryHorseNameActive.HorseID, qryHorseNameActive.Name FROM
And next to that Combo Box I have a Print control that prints my form that I
only want the one name that I select from my Combo Box
My Report is rptHorsePlanner, I suppose I will need a requery or Dirty so I
can change selections to print a Report!
Thanks for any Help...........Bob
What is the Record Source of the report. Assuming your report is based
on a query, then I think all you will need to do i...Date and Time on Reports
How do I print the current/report date and time on reports as well as on
receipt templates (POs, PORcv etc)?
you can use the formula to translate the time: below is the code for you as
example: (timesold is the datetime field) in RMs all transaction date field
contain also time.
FieldName = "TimeSold"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Time Sold"
VBDataType = vbString
Formula = "replicate('0',2-len(cast(DatePart(Hh,[Transaction].Time) a...How to restrict reports for each salespeople?
I need to give access to a few salespeople to their own Sales Open Order
Report and Total Monthly Sales (through the Sales Document Range Inquiry)
without them seeing each other's reports.
What would be the best way to accomplish this?
...Trouble exporting Report to Excel
How do you increase rows to output size? When exporting a 2000+ page report
to Excel (97-2002 *xls), stops on page 412 with message stating: “There are
too many rows to output, based on limitation specified by the output format
or by Microsoft Access”. Using Access 2000 with Windows 2000 OS
Excel has a hard-and-fast limit of 65536. When you export to Excel from a
report, you usually get extraneous blank lines, so it's conceivable that
you're hitting that limit.
There's no way around it, other than to simply export the data (assuming
less than 65536 rows) rather than the rep...I open the MDB, the form runs automatically
I have an MDB file with 20 files and 7 forms in it.
When I open it up, the form runs immediately an access goes into some
sort of protected mode. I can't view the tables, queries etc. I can
see the code by pressing Alt F11 but not the data.
I created a blank db and imported the mdb so I could see the tables.
But how do I open the original without it running the code?
When I look at the code. I don't see anything that sets properties or
invokes the code automatically.
There are no macros in this, just the forms and associated code with
...Automatic updates, automatically disabling itself
Automatic updates, automatically disabling itself.
2nd day now onecare popped up to tell me the updates turned themselves =
I'm thinking what malware would want to turn the updates off ?
Any idea what's going on here ? Did I AUTOMATICALLY install an update =
caused this ?
<email@example.com> wrote in message
> Automatic updates, automatically disabling itself.
> 2nd day now onecare popped up to tell me the updates turned themselves
Drop OneCare and install Microsoft Sec...Cannot choose "series name" for label
Excel in Office XP offered the choice of "Series Name" "Category Name" or
"Value" in the "Format Data Series" popup. Now I have Office 2007 and it
seems that Excel has lost the ability to choose. It looks like the only
option available is to "Add data labels" which unfortunately labels the
series with the value and not the series name. Is there a way to add the
series name or get around this (without manually tpying it in which I am
To specify the ranges/values for the series data, labels and names you
can use Select Da...Having numbers automatically appear bold
Had such great advise last time, thought I'd try again.
I have a large range of cells where I will be inputing sales figures i
the form of currency revenue. The range is about G-I and 1-400. Th
sales data will be a comparisson of YTD 2001 - 2004 revenue results.
What I hope to do is have any figure that is above $30,000 appea
automatically in bold so as to stand out as a good client. I gues
there is something in the IF function to do this but I'm stumped.
Thanks again in advance.
Message posted from http://www.ExcelForum.com
select the range you wa...Is it possible to automatically move data entered in columns into rows?
Is it possible to automatically move data entered in columns into rows?
It seems like a simple thing to do but I can't find a function anywhere.
If you enter something in ONE cell it is automatically in a row and a
column. So, perhaps a bit more explanation is in order.
"Richard Thorneycroft" <firstname.lastname@example.org> wrote in message
> Is it possible to automatically move data entered in columns into rows?
>...customer summary report
1. I would like to print the customer summary report for all of the customers
at the same time. I can print this report for one customer at a time from
2. I am looking at getting the YTD sales numbers for customers through
smartlist or reports. Is this possible? Also what sql table holds this
Check RM00103 and RM00104.
Have you looked at the Period Sales Analysis report?
> 1. I would like to print the customer summary report for all of the customers
> at the same time. I can print this r...Report Writer #8
How do I add the Report Option Name to a report? I would like to be able to
add the name that is stored in the SY70300 (Report Option Names) table to the
SOP Document Analysis Detail by Item Report and cannot figure out how to do
This won't be possible for several reasons.
1. The table itself does indeed does store report options for some reports,
true, however there isn't anything in that table to link a report name to.
Everything is indexed by number.
2. Assuming there was the rep...