Why does outlook 2007 create archive2.pst and how do I get it to only use archive.pst
I am wondering why outlook 2007 has suddenly created an archive2.pst.
The problem is that now I have 2 "Archive Folders" in my folder list.
I'd prefer to have the archive as one file. archive.pst is less that
1GB in size, so I can't imagine that would be the issue.
Thanks for your help!!
Perhaps some one has changed the archive options and directed at a new
"Jim" <firstname.lastname@example.org> wrote in message
> I am wondering why outlook 2007 has suddenly created an archi...Which solution to use?
I've no working experience with high availability scenarios but am a
long time SQL Server user.
I need to look at an option for work.
Log shipping? Replication? Mirroring? Other?
This will be SQL 2005.
The DB/application is not hugely busy... maybe 30+ users using it for
customers, invoicing, etc. Some of the procedures are quite complex
though with heavy usage of transactions.
Downtime is not fatal but needs to be limited to as little as possible
should something happen.
The idea would be to switch to server B, switch a config setting in the
application and get back ...Utility to convert Borland to VC++?
I've downloaded source code in Borland C++ 5.02 (MSWLogo) which I
would like to make some small changes to. Is there anything around
that would be able to convert it to VC++ 6?
What could possibly go wrong?
...VC IDE 'go to definition' doesn't work
Hello and thanks for trying ti help,
This problem has been driving me nuts, the 'go to definition' item in the
context menu in .cpp files always says "symbol 'symbol' undefined". It will
find something defined in MFC, but IT WONT FIND ANYTHING DEFINED IN MY
Yes I have deleted the .clw file and have rebuilt and run, what else could
be causing this problem???
I tried posting this in the vc.ide.general newsgroup a few weeks ago.
"Ivan Starr" <email@example.com> wrote in message
news:%23l3ANp9oDHA.2528@TK2MSFTNGP12.phx.g...The data at the root level is invalid. Line 1, position 2. -- using LoadXML
I've discovered I need to use LoadXML instead of Load for an xml
string versus an xml file.
HOWEVER, I get the above message when .net goes to load the string.
The string comes from an xmlDoc.OuterXML save resulting in:
<WorkFlow> etc., etc.
So, when I save this xmlDoc.outerxml to a database field, do I need to
remove that first? If so, wouldn't it not work when I then load the
string as xml again?
Also, I can't figure out how to delete that particular node...
Any clues appreciated...as always.
It works for me:
s...How do I use a Publisher letterhead template that I created
I just created some letterhead using Publisher and have saved it in my C
drive. I now want to use this template to write some letters. How do I do
What version Publisher? Did you save it as a template? In 2000, File, new, when the
catalog opens, click templates on the bottom of the page. In 2003, file, new, expand
templates, click My Templates.
Mary Sauer MS MVP
"GuatemalaPete" <GuatemalaPete@discussions.microsoft.com> wrote in message
news:CCAF09C4-B7E1-4FF9-919C-2E99A40551E9@micr...updating macros and links
How do I get macros and hyperlinks to update when I change the name of a
I am inexperienced with v.b.a. but I have created a workbook that I
want to change each day to log productivity. It has macros and
hyperlinks that stop working when the name's changed. How do I make it
so the macros and hyperlinks work, when given a new name?
Instruct on Installation of modules please. Thanks, Lane
Message posted from http://www.ExcelForum.com/
...Useless identity database? #2
Hi, my "Documents/Microsoft User Data/Office X Identities/Main Identity/Database" has 300KB, the Office 2008 one 22MB. And I didn't even install Entourage! Can that file go in the trash? -- Tobias Weber
...Linking tables with forms
Hi, I'm still a relative beginner with Access, but I've not done too
However, I'm finding one thing very confusing.
Here's the scenario: I am writing a multi table db, and I need to link
them all up via an index, so one form can easily display data from the
For example: I need to display a name, located from one table, and
then in a seperate table, store values from yet other tables.
For some reason, I am finding this a little bit of a pain to do - I
can't seem to get the values loaded correctly. It's no problem if
they are simply from a table, but t...Selective Link to Picture #2
I want to show a linked (not embedded) picture based on entry in a
This way, I can keep the excel spreadsheet light.
and point to your picture file
or use the worksheet =hyperlink() worksheet function:
I think if you use the =hyperlink() worksheet function, your workbook will be
> I want to show a linked (not embedded) picture based on entry in a
> This way, I can keep the excel spreadsheet light.
> Any he...Exchange 2003 run database defragment show [Out of database page buffers]
run eseutil/p command on yesterday,
after less than 24 hours, we found the error
message "Operation terminated with error -1014
(JET_errorOut ofBuffer, Out of database page buffers)
after 847,402.35 seconds" appear.
...What function would I use?
I am making a spreadsheet for my work. In this
spreadsheet I enter data such as the name of a customer,
additional products they may have purchased, and the
price paid for the additional product.
I have to list all customers on this sheet wether or not
they bought any of the additional products. Then I have
to do a second sheet only for those who bought the
additional products. Is there someway to make the spread
sheet go through itself and pick out those who bought the
additional products and then transpose those onto the
Thank you in advance for any help that you ca...using outlook in a network
I would like to set up a peer to peer network using
microsoft XP. I would like the user of computer A to be
able to view Outlook on computer B. How do I go about
setting this up?
> I would like to set up a peer to peer network using
> microsoft XP. I would like the user of computer A to be
> able to view Outlook on computer B. How do I go about
> setting this up?
Move the pst on computer B to a shared folder and just point Outlook on
computer A at it.
One point - only ONE computer will be able to open and use the pst at any
...Cannot Unload Assemblies in XSLT Using Script: patch??
Anyone knows that this problem has been patched? Is this a .NET 1.1 or 1.0 problem
PRB: Cannot Unload Assemblies That You Create and Load by Using Script in XSL
It's impossible in .NET v.1 to unload assembly once it was loaded. And
scripts are always compiled to assemblies.
It's unlikely that this problem will be solved in V.2 as well.
You can keep XslTransform object in separete AppDomain and unload this
AddDomain time to time.
This posting is provided "AS IS" with no warran...Access Database to Track Employee Times
Yesterday I had posted a question to see if anyone had an Access database
that tracks employee times, very similar to a time clock. What I would like
is to have a form that has all of the buttons on (Login, Break 1 Out, Break 1
In, Lunch, etc.) and when the user clicks these buttons, the time will be
logged into a table. I would then like to report ONLY the times a person
does not meet the rules of logging in, break times, etc. For example, if an
employee clicks the login button anytime after 8:05 AM, I would like that
time to first be copied to the master time table, and then...Query using date and time in seperate fields
I am having problems generating a query to find records between a start date
and time and a finish date and time. As the table I am querying stores the
two valuse in seperate fields, using BETWEEN is not working.
The table I am querying, called imt_log, stores the date and time in
The fields are called imt_log.date and imt_log.time
Find records from 7-Jan-2008 08:00:00 to 14-Jan-2008 07:59:59
Do I need to create some Vb code or is it possible to do it with a nested
Thanks in advance.
If your fields are datetime datatype then use a calculated field like ...Filter on subform using unbound text box
Hello Forum Members:
I'd like to have some help on the following codes on the Access 2000:
On the Form Header, I have an unbound text box called FindWord, in which I
type some words to search. The code below works on the main form.
Private Sub cmdFilter_Click()
Dim strWhere As String
Dim lngLen As Long
If Not IsNull(Me.FindWord) Then
strWhere = strWhere & "([English] Like ""*" & Me.FindWord & "*"")
lngLen = Len(strWhere) - 5
If lngLen <= 0 Then
MsgBox "Nothing is speci...Can a Vlookup be used when creating a chart
1. Is it possible?
2. where would it be entered? the values line?
2. Not enough detail to provide even a guess.
Gord Dibben MS Excel MVP
On Tue, 26 Jan 2010 11:23:02 -0800, Confusicous
>1. Is it possible?
>2. where would it be entered? the values line?
Here is my data:
2010 spreadsheet =
Entities = A18:A45
Numbers = N18:N45
Numbers = N18:N41
The reason I would like to have the Vlookup is because new data was entered
in 2010 but if I just enter the ...Where to find AdventureWorks database samples
Does anybody know where I can find the sample Adventureworks database? I
need the most recent one for sql server 2008 sp1.
Try this link
Andy B. wrote:
> Does anybody know where I can find the sample Adventureworks database? I
> need the most recent one for sql server 2008 sp1.
Just what I needed.
"Dave Ballantyne" <symlink@no5p323mmer> wrote in message
> Try this link
This may be better posted in a developer's forum, but I'll put it here
because I'm using it in a script, and I hope to get an answer that doesn't
require 10 years experience in DotNet development...
I've been using the Win32 COM object, Shell, to do FTP transfers, though I
must admit I barely understand enough of it to use it. It seems like a
better solution than an external call to the OS native FTP, but I have hit a
snag with the initiation of the server connection in an environment that
includes a FTP proxy server.
The object is instantiated with:
...Filegroup restore used to refresh database copy
I have TestDB1 comprised of 5 filegroups, which I've completed full/log
backups to restore as TestDB2. When data changes within one filegroup on
TestDB1, I've taken a diff' + tlog backup and tried to use it to restore on
TestDB2 so that same filegroup would be essentially refreshed. My execution
the last full, last diff', and tlog from TestDB1 but this doesn't work?
Why? Is there a way to do this ? Thx. -CqlBoy
What do you mean by doesn't work? Are you getting an error or different
results than you expected. Please provide more detai...What's wrong with using GOTO ?????
As a tool to move within code whats wrong with using goto to - as an example -
3 buttons on a form, 1st button is clicked and the code sets a textbox value
to say 1, then exit sub. Clicking one of the other buttons calls the button 1
code to run and at the start of the is a case to determine wich button was
pressed and then using GOTO go to a portion of the code related to that
action, and so on for each button.
Message posted via AccessMonster.com
"trevorC via AccessMonster.com" <u44860@uwe>...How to send out email blasts using an .html file
I've been setting up email blasts using MS Word and then going Tools /
Letters & mailings / Mail Merge but I am limited to what I can do in MS Word
in terms of formatting.
So, I've just created my first .html page in Dreamweaver that I want to send
out but I don't know how to now merge this into Outlook to send out. Can
someone please tell me how to get this started? I need to know how to get
the greeting line, etc in my .html document - do I just go back into MS Word
and import the .html file and then follow the same steps? Or do I need MS
Word at all?
Than...How to clean one book using data from another?
Hello, I'm an intern and a relative new user of Excel. I've used it before,
but only for simple sorting.
Here's my problem:
I am using Excel '03 to sort e-mail address lists. I have two separate
files, one with names, email addresses, and postal addresses, and a "cleaned"
list with all non-working e-mail addresses removed.
What I want to know is, is there any way to use the second list to clean the
first list of all the people whose e-mail addresses no longer work, without
manually searching through them one row at a time? I have nearly 10,000 names
on one an...Using combo box(s) to create a query
I have a two part question as follows:
I am wanting to create a query that is driven by the user selecting a
value from a combo box on a form.
the combo box on the form is called "TypeofIssueID" and it's control
source is "TypeofIssueID" in a table called"tblEngineering".
it would be nice if when the user selects the value he wants to query
from the combo box the query is automatically generated at that point.
the user wouldn't have to select a "do this now" button.
the second part to this would be adding mor...