Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
"JCC" <JCC@discussions.microsoft.com> wrote in message
I'm currently having the following problem with CRM: On accessing CRM via ie
- I get the following error "An error has occurred. For more information,
contact your system administrator. " Event logs display :"MSCRM Platform
------------------------------------------------------------------------------------------------Error: An operations error occurred.
Error Message: An operations error occurred.
Error Details: Details on this error have not been provided by the platform.
Source File: Not available
Line Number: Not available
Stack Trace Info: at...how do I subtract several cells from one total
If A1 is 3500 and cells A2 is 500 and A3 is 100 A4 100 A5 is 100 then how do
I substract A2 thu A5 from A1 without doing each one seperately
in A6 type
"highway" <firstname.lastname@example.org> wrote in message
> If A1 is 3500 and cells A2 is 500 and A3 is 100 A4 100 A5 is 100 then how
> I substract A2 thu A5 from A1 without doing each one seperately
should do it
----------------------------------------------------------------...Cant get any mail in my inbox using Microsoft outlook web access
I can log on to Micorosoft Outlook Webacess but the
problem is that I dont see any mail in my inbox using the
inbox, some times I can get the new unread messages but
after I have opened and read them, they disapper too. Does
any one have a solution to this problem?
are you using a "hide read messages" view?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Search for answers: h...Accesssing Access data-base without Access -- How?
I have been sent an Access data-base (.mdb filetype). I do not have any
MicroSoft Office programs installed on my computer. Is there anyway to look at,
and extract data from this file? I do have Paradox installed, but it seems to
require some sort of modules from Access (DAOs - "Data Access Objects"). Is
there a source for these.
I know that Paradox provides a free database engine to allow non-users to use
..db files. Does Access have such a thing?
In many instances, an Access database is actually an Access-based
application. Are you interested in the data...Office Document Connection wont connect and locks my AD account
Operating System: Mac OS X 10.6 (Snow Leopard)
Hello <br><br>I have been using Document Connection (DC) happily with my company's SharePoint for some weeks now. Today I had some hiccup with my AD account password, which is now sorted and I can now log onto the SharePoint site through Safari and authenticate to access the WebDAV through Finder. <br><br>However when I accessed the same WebDAV using Document Connection I was told that I didn't have permission and my AD account got locked. It looks like DC hammered my AD account...entering date in access records
I have this following problem. I have a access database with thousands
of records. The problem now is I want to enter the same date into all those
records, how can I do it in one shot?
Create a new query using the table that needs to be updated. From the query
grid, click QUERY in the menu and select UPDATE QUERY
In the query grid, select the date field as the field to update as the first
colum and in teh UPDATE TO row in the current column set the update value to
Since you're updating all records, no criteria is necessary. Clic...Deny file access if user declines macros?
I periodically issue a file that contains macros to users. For ease of
functionality, the users should accept the macros (as when their
security level is set to medium).
Is it possible to deny a user access to the file if he answers "no, do
not allow macros" to the security question?
Before closing the workbook, you can set the visible property of all the
worksheets to very hidden and then protect the workbook with a password.
Then have an auto exec macro that makes all the sheets visible when the
workbook is opened. The auto exec macro won't execute unless the us...The best Exchange setup in a small hosting setup
I need to set up at small hosting setup where the users can access their
email through RPC-HTTPS and webmail.
But what do I need?
One ISA server?
One front-end server?
One back-end server?
Some clustering or is it overkill?
- You can do it with as little as a single Exchange server and a firewall.
- In a single server environment, FE/BE topology doesn't really buy you
- Clustering can be an overkill or not, depending on what your goals are. If
high-availability is a valued goal, you could look at clustering (and the
investments that go with a clustered ...Page Setup
I have a problem with Excel XP in that when I preview a page which is in
Landscape, it automatically displays as portrait. When I resize it, it goes
back to landscape but then back to portarit again ! Any ideas ?
If you change printer drivers, does it happen? If no, then I'd download a
newer/fresh printer driver for that troublesome printer.
Any chance you have some helpful macro jumping in to fix the page setup for
you? If you open the workbook with macros disabled, does it still happen?
> I have a problem with Excel X...Moving multiple profiles from outlook 2000 on win98 to outlook 2002 on XP pro machines
We are in the process of upgrading our computers from win98 with
outlook 2000 to XP pro with outlook 2002. We are changing out all of
the workstation hardware. I have all of the workstations set up with
outlook 2000 with as many as 20 profiles, for different users, on each
machine. All of the profiles are pop3 accounts, and the .pst files are
located on a central file server (not on the workstations). Is there a
way to export the user profiles and import them onto the new machines.
When the original accounts were set up the users changed thier
passwords, so I would have to hunt down and si...Adding multiple intances from several sheets?
I use a timesheet in my job & I want to total project times over the course
of the year.
There are 52 sheets, one for each work week, plus a totals sheet. I want
excel to look in column c for of each sheet a given project number and add
the time in column f. I can do it for one sheet but I get value! when I try
to specify a range of sheets.
The sheets are set up like this:
Date Acronym Project No. Phase Description Hours
11-20-09 CHLFD 091102 V Plans 7.5
11-20-09 JDSF 091021 ...Addnew to both sides of a One-to-Many (find autonumber)
I am having problems here and I know it's something simple and stupid that
I'm missing but here goes. I have a form that creates a new record into the
table "ASSET". The table "ASSET" has a one-to-many relationship with
"INTERVAL". I am able to add the record to "ASSET" no problem, but I need to
add a record into "INTERVAL". My "INTERVAL" table uses the ASSET_ID as a
foriegn key from "ASSET". The follow is my code:
Private Sub cmdSAVE_Click()
Dim MYDB As DATABASE
Dim rstINTERVAL As Recordset
Di...excel page setup
I have a spreadsheet and I am using cells a:k50, but when
I go to see the end of my spreadsheet it tells me I have
used cells a:ak 295. I have 35 sheets like this and is is
making the file bigger than it has to be. I have tried
deleting, clear, page preview setup but nothing seems to
clear and make my page a1: k53. Any suggestions. Thank You
Select the row following the end of your data. Ctrl+Shift+Down Arrow to
select all rows beyond your data and Edit>Delete.
Select the column following the end of your data. Ctrl+Shift+Right Arrow
(US) to select all columns beyond your data...Deleting multiple rows through a formula
So does anyone know a formula that will allow me to delete multiple rows of
re-occuring data in a spreadsheet.
For example, I have a spreadsheet of 10,000 lines, with multiple mobile
numbers on it. I need to only have one of each mobile number and delete the
remaining rows where the mobile has been repeated?
you may be able to use the advance filter where can select unique records
select data filter advanced filter select copy to another location then in
list range box enter range to filter in the copy to box enter a free column
select unique records only then ok
then just ...Account setup is temporarily unavailable. Please try again later.
I just upgraded to money '05 because my bank no longer allows acess using
money '02. I have been getting this message for TWO WEEKS now. I set up three
accounts with no problem, then this message over and over every day. I have
tried starting a new account and I still get the same message. Surely MS's
server has not been down this whole time, so I guess the problem is on my
end. Please Help!
In microsoft.public.money, lostmymirth wrote:
>I just upgraded to money '05 because my bank no longer allows acess using
>money '02. I have been getting this message for T...[ANN] The Entourage Help Blog: "Updated Exchange setup script supports Entourage 2008"
I've posted version 2.0 of my EntourageExchangeSetup AppleScript on The
Entourage Help Page that includes support for Microsoft Entourage 2008's
Kerberos feature as well as some minor additions and bug fixes.
This AppleScript is intended to be modified by an administrator to
assist his Entourage users with the setups of their Exchange server
accounts. It has been tested specifically with Entourage 2004 11.2.6,
11.3.3, 11.3.7 and Entourage 12.00, 12.0.1 and 12.1.0 but should work
with any version of Entourage 2004 SP2 (11.2.0) and higher. Every
company's network is different...How can you convert a Microsoft database to a Microsoft Access 03
I would like to convert a database made in Microsoft Works to Microsoft Office Access 2003. On Wed, 21 Mar 2007 13:54:05 -0700, greenbentley<email@example.com> wrote:>I would like to convert a database made in Microsoft Works to Microsoft >Office Access 2003.Oddly enough for two Microsoft products, there is no direct path.You can save the *data* from Works into Excel, or into acomma-separated-values Text file, and then use File.... Get External Data....Import to import it into an Access table.Any reports or layout you've defined in Works will need to be com...ODBC and Access
Environment is XP, VC7 and Access2000
I get these messages
Warning: Driver does not support requested concurrency.
Warning: Setting recordset read only.
Optional feature not implemented
State:S1C00,Native:106,Origin:[Microsoft][ODBC Microsoft Access Driver]
Does anyone know what I might be doing wrong ? I am working in a very gray=
i would guess you are trying to open a database that is already open in some
combination of reading and writing that the odbc driver can't handle. just
what are you trying to do, besides working in a gray area??
"Ian Semmel" <is...CLock same-thread double-access problem.
This is my scenario:
My application has one instance of:
class CMapDevices : public CMap <long, long&, CDevice*, CDevice*&>
Several threads can access this CMap; but they must not access it at the
So I added these member variables to CMapDevices:
CMapDevices ::CMapDevices ()
sSemaphoreName.Format("devs-%f",(double)(DATE)COleDateTime::GetCurrentTime()); m_sem = new CSemaphore (1, 1, sSemaphoreName); m_lock = new CSingleLock(m_sem);}So that wherever my code a...move down one row
I'm trying to write a macro that goes to the first blank cell at the end of
I found Selection.End(xlDown).select this gets me to the end of the list
but I can't figure out what to add to move down 1 row.
If there is another way to do the same thing please tell me.
Thanks in advance for the help
Will move down 1 cell.
"Truseeker" <firstname.lastname@example.org> wrote in message
> I'm trying to write a macro that goes to the first blank cell at the end...Multiple domains displayed from within outlook
Does anyone know if there is a way to display 2 different domains from within
the same outlook mailbox?
You can only have one Exchange account but you can certainly open multiple
inboxes and Exchange certainly supports more than one mail domain. You'll
need to clarify your question if you want more specifics.
"KJK" <KJK@discussions.microsoft.com> wrote in message
> Does anyone know if there is a way to display 2 different domains from
> the same outlook mailbox?
HOW DO I SET IT UP.
Windows Mail: Setting up an account from start to finish
Imperial Beach, CA
"home" <email@example.com> wrote in message
> HOW DO I SET IT UP.
"home" <firstname.lastname@example.org> wrote in message
> HOW DO I SET IT UP.
Start here and look for mail settings.
ht...Sent Messages from Web Access
If I send a message from a remote computer using Web Access with Outlook,
will the sent message appear in my sent file on my office computer? Or, will
it not be there due to my using a remote location.
OWA stores sent messages in the Sent Items folder on your Exchange =
mailbox -- the same folder you see in your mailbox with Outlook.=20
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Sabrinagb" <Sabrinagb@discussions...Access 2003 to Access 2007
I am cloning a database we use in our business for a sister company. Main
changes are report headers, form header changes and some minor coding changes
due to slight process differences between the two companies. I just
discovered the new company has Access 2007. The original database is Access
2003. Looking at the Microsoft Office website it seems the changes between
the two are mainly in the interface. Is this correct? I need the data tables
to remain unchanged if at all possible as there may be a chance the two
companies will share certain data.
On Wed, 19 Mar 2008 21:46:00 ...