How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Hard drive crash
I had a hard drive crash. I have recovered the files bt can not open Money
from them. Any ideas?
In microsoft.public.money, Elamt wrote:
>I had a hard drive crash. I have recovered the files bt can not open Money
>from them. Any ideas?
You will need to install Microsoft Money. What you do may be
affected by the version, but in no case will an older version open a
file from a newer version. Save the *.mny and *.mbf files from the
crashed hard drive. Make an extra copy in case your new media fails.
...comdlg32.ocx and Access 2007
I have several Access databases that were originally written using an Access
version prior to Access 2007. I am in the process of converting the
databases and installing them on new machines running Win7 and Access 2007.
Over the years, one of the References I commonly used was comdlg32.ocx. It
does not appear that either Win7 or Access 2007 installs that particular
Active X file. I can copy it from an older machine, but that seems like a
Is comdlg32.ocx a "legacy" Active X file and has it been replaced with a
newer (and differently named) Activ...Why does 62 KB translate into 4.2 MB in Publisher?
When I added a 62 KB jpeg to my page, the overall file size jumped from ~275
KB to 4.2 MB. What gives?
Let me guess - Publisher 2000?
MVP Microsoft [Publisher]
"Publisher induced baldness" <Publisher induced
email@example.com> wrote in message
> When I added a 62 KB jpeg to my page, the overall file size jumped from
> KB to 4.2 MB. What gives?
Publisher 2000 doesn't support compression.
PUB2000: File Size Increases Unexpectedly When You Insert Picture
...Error 2455 Closing Access 2007 database with form open
I have a form with a subform that is requeried when you select a new key for
the main form from a combo box.
Everything works fine - usually. But sometimes if you have the form open
when you close the database down you get the following error message (twice)
in a pop up. You say OK (twice) and the database closes OK
"2455 you entered an expression that has an invalid reference to the
If I close the form before the database I never get the error.
If I do not touch the form before you close the database I don't get the
If I update a field by t...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Expression Too Complex in Access 2000
Consider the following query:
SELECT crTbl.acct_1, crTbl.amount, crTbl.date
WHERE (((crTbl.acct_1)="Supplies") AND ((crTbl.date) Between
The query works fine on my own computer in Access 2002.
When converted to Access 2000 and used on an other computer,
I get the following error:
"This expression is typed incorrectly or is too complex to be evaluated.
Try simplifying the expression by assigning parts of the expression to
The problem is with the "Between...groups detail section totals access 2003
I know this can be done, but haven't figured out how yet. I have what
basically is a summary report that my sql comes up with for the detail
rows. I want to total these rows in the report and display
immediately below the detail section. I don't really want to group
anything, but want to treat the whole detail section as a group.
That being said, how can I get a "group footer" on the designer so I
can add my total columns. If I use "sorting and grouping", it starts
grouping things and that is not what I want.
I don't want to use the "page foo...SK 40175 Tuff-1 1/2-Inch Drive 15-Inch Reversible Ratchet
Best deal: http://thediscounfinder.info/index.php?id=B0009U5RRM
Item #: SKT40175. Features & Benefits:Tuff 1(r) Ratchets 72 tooth head design delivers a short 5" stroke for use in tight areas.17 teeth engage when torque is applied to provide a strong grip without slippage.Thumb falls naturally into position, giving instant control with one hand.Easy to reverse, 4 point cap.SuperKrome plating for long tool life and maximum corrosion resistance.Description: 15" Reversible Tuff Customers also search for:...Prevent users from saving music and pictures to their hard drives without folder redirection?
Hi there. I'm wondering if there is a way via GPO or anything else to
prevent users from saving music and pictures to their local hard
drives without using any type of profile or folder redirection.
...How do I print only odd pages in Publisher and then only even page
I am attempting duplex printing with a printer that is unable to do duplex
printing by printing odd pages first and then flipping the pages over and
printing only even pages.
No option is given that I can find in the print window.
Sarah Wright wrote:
> I am attempting duplex printing with a printer that is unable to do
> duplex printing by printing odd pages first and then flipping the
> pages over and printing only even pages.
> No option is given that I can find in the print window.
The duplex printing add-in can be found here
(http://publisherm...Can I show server name instead of drive letter?
When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?
where ServerName is the name of the server and drive is the appropriate
drive, and then find the file on the drive from that point.
> When using the =Cell("filename") function, I would like to show the actual
> server instead of a drive letter because the letter is dependent on...Remote access to another company's Outlook calendar?
I have one client on Exchange 2003 that wants to access the calendar of an
employee (consultant?) at another company running Exchange (version not
known yet). How can the remote company share this person's calendar with my
client? He would need to access it and add appointments to it.
Thank you for the help!
On Mon, 30 Aug 2004 22:15:24 -0700, "Gregg Hill" <email@example.com>
>I have one client on Exchange 2003 that wants to access the calendar of an
>employee (consultant?) at another company running Exchange (version no...Publisher 2007 #31
If I use Autoflow in text boxes, I cannot get the test to wrap round
pictures, they just sit on top!
What am I doing Wrong?
In Publisher 2000 it would be,
Click on the text box; select Format, check "Wrap text around objects"
Don - Publisher 2000�
"richwoo" <firstname.lastname@example.org> wrote in message
> If I use Autoflow in text boxes, I cannot get the test to wrap round
> pictures, they just sit on top!
> What am I doing Wrong?
...how to insert borders on flyer within Microsoft publisher?
Please help, I'm trying to insert a border around a flyer...I'm using
Is it a clipart border, Borderart or a simple rectangle? What problems are you
having? What version Publisher? Any border you insert should be sent to the back
so it does not interfere with your main design.
Mary Sauer MSFT MVP
"Harriet" <Harriet@discussions.microsoft.com> wrote in message
> Please help, I'm ...Publisher created webpage
I have created a web page in publisher, and am having a
problem uploading it to a hosting site(angelfire). Any
In the future utilize the webdesign forum at
You don't specify your version nor state what the problem is.
I'd have to recommend you start by going over my tutorial at
www.davidbartosik.com/ppt.htm on uploading to identify if you are following
the correct procedures.
If afterwards you are having a specific difficulty post as such in the web
forum for follow-up.
David Bartosik - MS MVP
for Publisher help:
www.davidbar...Can't connect to Exchange server after VPN access
I can connect to my office Exchange server when in the office (LAN) but I
cannot connect outside with Outlook.
I can only use the webmail after entering a web VPN access:
- First portal for VPN : https://xxx.yyy.com --> I enter my
- On the next web page, I have the choice for the webmail and it's a link as
https://xxx.yyy.com/go/webmail.yyy.com~ssl where I can enter my
So I can't enter the url in RPC as every slash is forbidden
In my Outlook, the Exchange server (EXC.yyy.com) is not reachable by ping
(or tracert) and I can't ...How do I set up mixed page orientations in Publisher 2003?
I'm trying to create a duplex publication where one side is in portrait and
the reverse is in landscape. I've tried looking in the halp and through all
the menus but it seems that I can only have one or the other. Can anybody
Publisher (any version) does not support this. The workaround most
frequently offered is to design your landscape page, group the all the
objects, then rotate 90 degrees.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"T. Mitchell"...Access 2007 12-17-09
I am building a contact data base for my church. How do I get the phone field
to automatically format like this (xxx) xxx-xxxx when the numbers are typed
in the cell?
In the form design view select the phone control and open the properties
dialog. Goto the Data tab and use the Input Mask to define the format you
wish to use. If you click on the ... to the right hand side on the property
you will get another dialog where there are predefined input mask or you can
define your own.
For instance, I use
to format my telepho...Cannot publish or export in Deployment Manager
When I click on "Publish Customization" or "Export Customization" I get an
This application has requested the Runtime to terminate it in an unusual
way. Please contact the application's support team for more information.
Has anyone experienced a similar problem? What can be causing this, it was
Thanks in advance,
...in Publisher I want to merge/send email with multiple attachments
Using Publisher 2007 I know how to do a merge and then email out from a list.
Publisher gives the option to attach multiple attachments to the email but
when the send actually goes out it only carries the first of the attachments
and discards the others.
Is there a trick to making multiple attachments stay attached? or is this a
Thanks to anyone who can clear this up..
Since you already know how to do email merges in Publisher 2007, you're
probably the ideal person to answer my question...I have been trying to do an
email merge using an existing publis...Can Entourage be used to access Google Groups
I am in the process of switching from PC to Mac. In Entourage, I see this
news server. Can I get some of my newsgroups in Google Groups to show on
Entourage or Mac Mail?
Responses off group will be welcome if I have asked something everyone
except me knows.
On 1/31/10 3:25 PM, Michael Plog wrote:
> I am in the process of switching from PC to Mac. In Entourage, I see this
> news server. Can I get some of my newsgroups in Google Groups to show on
> Entourage or Mac Mail?
> Responses off group will be welcome if I have asked something e...Publish A Workbook Onto The Web, Then Access Using My Web Browser.
How do I access my spreadsheet, or workbook, on the web once I've saved it as
a webpage from the file menu? I've found that even though I've save my
workbook as a webpage, it does not have an http:// address which I can type
in my web browser to access the workbook from my home computer or from a
Should I have to sign up with an http:// service provider or can this all be
done from using Microsoft Office XP without going through a third-party?
You have to have a website first of all, otherwise, where do you want to host