Linking Access 2007 to Microsoft Project 2007
I have an application that tracks various projects with milestones and other
dates. My client is interested in visually depicting some of this
information, and would like to try using Microsoft Project.
They have created a small Project file with data they extracted and manually
entered into project. What we now want to do is figure out how to either
link Project to Access to use the Access tables directly, or to use Access to
identify "differences" between their data and what exists in the application.
Does anyone have any experience in this area?
What is th...Write-Back Cache
Is anyone ot there using write-back cache on there ARRAY controllers.? Right
now I have an Exchange system using a HP MSA 1000 SAN to house Exchange
Databases, stores, etc.
I have read in some books and some blogs that you should put write-back
cache at 100% on the array controller and there is a great perfromance gain?
Does anybody have anything to add? i.e. good idea, how much perfromance
Write-back cache should only be enabled if the array controller is battery-backed. It should be a decent performance gain. As I understand it, enabling write-back cach...Where Do Messages Go??
If there isn't a kink in my program and it's behaving as it should, I hope
someone can answer my questions.
Messages disappear. Example: I e-mailed a friend, who e-mailed me back. When
I answered that response, I could find no trace of it in "sent mail" or
anywhere else, and the item in my inbox maintained its appearance as unread
mail. If I click "mark read" it disappears altogether. I've lost several
messages this way.
Also I seem to be unable to drag a message from one folder to another. It
gets lost in the transporter, never to be seen agai...exclusive access to the database error. Office 2003 upgrade.
This access dtaabase was on a shared folder used by upto 40 simultaeous
users. There were no issues. In January they upgraded from office 2000 to
office 2003 and started getting this error. "You do not have exclusive access
to the database at this time. If you proceed to make changes, you may not be
able to save them later"
I checked teh article http://support.microsoft.com/default.aspx/kb/839782
but we don't have the same situation. There is only one .ldb file and there
is no .mdw file with the same name as ldb file. Is this related to office
2003 upgrade. The firs...Fowarding a message without including original text received.
How do I forward a message without including the original
text in the mail received?
...Where do the Archives Go?
I cannot find the information Outlook claims to have archived for me. Yes I
know how to display the archived calendar, but it's blank. Any ideas? Thanks!
I use XP, and Office 2007.
"6Sigma 5s No Clue" <6Sigma5sNoClue@discussions.microsoft.com> wrote in
>I cannot find the information Outlook claims to have archived for me. Yes I
> know how to display the archived calendar, but it's blank. Any ideas?
> I use XP, and Office 2007.
Why do you think Outook is arch...Simple Access Query
I would like to allow the user to click on a button and then call a query
and assign the returned value to a textBox control
How can I do that?
Realistically, you don't need to call a query. Using the DLookup function
should be sufficient to return the required value from the query.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"Samuel" <firstname.lastname@example.org> wrote in message
> I would like to allow the user to click on a button ...transactions without saved payee missing from report
I am a treasurer for a charity and have been using money to track the
accounts (because I foolishly believed that it was better than paper)
I have a customised money cashflow report that I need to show all
transactions, so I do the following:
1. select all categories (click on select all button) - this is on the
2. select all payees (click on select all button) on the payee tab
But I have just discovered that for a transaction where I chose not to
add the payee to my list of payees that it is missing from the report.
In otherwords I can only report on transactions for which I c...Price/cost fields need to be able to go beyond 5 decimals.
When we receive product it comes in $ per metric ton, which we convert to $
We sometimes receive product in millions of lbs. in one line item, when we
convert from $/MT to lb./MT the limit of 5 decimal places in a currency field
causes pretty lare rounding errors to occur in our extended cost.
This causes our posted cost in GP to be different than what we actually pay
The ability to extend beyond 5 decimals in the currency field would solve
the problem, but for now it is not possible in GP.
This post is a suggestion for Microsoft, and Microsof...storing historical data in Access
Hi. I am creating an Access database to store information about
employees, such as their job title and address info. However, I also
need to store their historical job title and address info as it
changes. I have other tables in the database to store info on their
different benefit plans. In the employee info table, I have their
Employee ID (the number that the company assigns to each employee) as
the primary field. So, it will not let me add duplicate entries for
each employee. I thought about making the primary key an autonumber
field but I need the primary key to be the employee ID so...Filtering in Access 97
HiI was wondering if some kind person could answer this question for me orgive me a leader in help for it.I have to filter out from a database all the Client codes from a field thatlooks like thisCodes for ClientsANCD #AMRU ANRD ADNIACRI *EVER #ASTI*AMRI ASST *FROT ASSUADDU -ADCB -MNOP ACRUThis is just to give you the idea.I need to filter out all the codes that do not have-*#in them, leaving me with the plain codes on their own. I have tried a ...Multiple calendars, how to choose which one meetings go into
I have 3 calendars setup in outlook XP , when someone sends me a meeting
request how can i change which calendar the meeting goes into, at the moment
they all go into what i guess is the default calendar which i want to change
to a different one
You really can't change it. Outlook treats certain folders special.
"Chris S" <email@example.com> wrote in message
> I have 3 calendars setup in outlook XP , when someone sends me a meeting
> request how can i change which calend...Export MS-Access report output
I would like to export some MS-Access reports output to pdf.
However, the only possibility offered by Access (afaik) for me to export
formatted output is snp (snapshot) (I use MS-Office XP Prof. 2002 version).
With formatted output I mean the *exactly* output I produce from executing
my report (information is gathered from an ODBC database).
1) Is there a way (e.g. using VBA) for me to export directly in pdf?
2) If not, where can I find a tool for me to convert snp to pdf (or other,
that could be converted to pdf (e.g. MS-Word .doc))?
Thanks in advance,
Access won't make PD...Go to page
I have a long document and need to go the certain pages without having
to scroll down. How do I go to a particular page?
This is a multi-part message in MIME format.
Press Ctrl+G to open the GoTo dialog, and enter the page number.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"richard" <rmk@wo...Opening Hyperlinks in IE7 With MS Access 2002
Have a really simple and perhaps dumb question so here goes:
Using MS Access 2002 with hyperlinks to photos stored on network. All
hyperlinks currently open in a new tabbed window. I can understand
hyperlinks for new websites opening in a tabbed window but shouldn't photos
open with picture viewer?
...Accessing Cubes -- Pivot Tables vs. Cube Analysis Add-In?
This is a multi-part message in MIME format.
I am accessing some cubes created with Analysis Services on SQL 2005.=20
Wondering if anyone has a link to a website or document that can detail =
the advantages (if any) of using the Cube Analysis add-in to Excel 2003 =
to access these cubes versus creating an external data connection to the =
OLAP cubes through the standard Pivot Tables functionality.
So far I am not seeing the value of this Cub...Connect via modem when Outlook is offline does not work Outlook 2002
I have recently discovered a problem with Outlook 2002. When I am connected
to a network I would like to be able to send and receive automatically. When
I am not connected to the network I would like the Dial-up dialog to pop up
when I click send/receive. This worked in Outlook 2000 but when I upgraded
to Outlook 2002. All my settings appear correct. This was the same in the
original installation and after updating to SP3. I have also made sure that
IE6 is not in offline mode.
I have each email account set to Connect via modem when Outlook is offline -
as I have for IE6.
When I click Sen...object access
Event Type: Success Audit
Event Source: Security
Event Category: Object Access
Event ID: 562
Time: 6:10:40 PM
User: NT AUTHORITY\SYSTEM
Object Server: Microsoft Exchange
Handle ID: 264426648
Process ID: 3556
Image File Name: C:\Program Files\Exchsrvr\BIN\store.exe
For more information, see Help and Support Center at
what do these messages mean?
"tony" <firstname.lastname@example.org> wrote in message
news:OEpY8dn4FHA.3976@TK...Here we go again
Well, once again CashEdge is not connecting/syncing with Money and MSN
Money. I guess I won't run right out to buy Money 2007. Even if the software
were an improvement over M06, it cannot be any better than the weakest link
in the sync chain.
A known problem, David -- and not unique to the version of Money. Look at
"David Haynes" <email@example.com> wrote in message
> Well, once again CashEdge is not connecting/syncing with Money and MSN ...Word 2007 crashes when accessing address book
I've reinstalled Office 2007 several times. I have even done a complete clean
reinstall of my Windows 7 Home Premium and all that goes along with that. If
Outlook is open all is fine, if not word will crash as soon as I click on a
name to fill in an envelope or a label. As others have had this issue I
still haven't found anyone with the solution. I have done all the usual like
turning off all add-ins. Outlook IS the default mail handler, I've done the
whole -- HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Data and
Rename the "Data" Key to "Da...Not all emails going out??
For the last week or so, send few, my emails have not been going out, or not
going out to all parties I access from my address book. Just tested by
sending one to myself...went fine. Sent second to a single party and cc
myself. Did not receive my cc in outlook, but it did show up in my iphone.
Tried a third to a group of people...through a single address book contact,
and nothing happened. I am strictkly novice, but have not had this problem
before. Any ideas???
Wilson Kobel;110315 Wrote:
> For the last week or so, send few, my emails have not been going...Run an excel file in other PC without Office installed
Can I run an excel file in other PC that doesn=B4t have office installed
like in Access where you can create an autoexec.
You can download a free Excel Viewer from the MS site
Microsoft Excel MVP
email address: remove uppercase characters
"1234" <firstname.lastname@example.org> wrote in message
> Can I run an excel file in other PC that doesn�t have office installed
> like in Access where you can c...Offline Sync
Outlook 2002 is setup with offline mailbox but now when
the user connects to the network, the offline mailbox will
not ync automatically ?
Client: Outlook 2002 sp2
Server: Exchange 2000 (Not integrated with ADS.)
...What are the advantages of using Access over Excel?
(remove nothere from the email address if mailing direct)
"dems" <email@example.com> wrote in message
What are the advantages of using a car over a telephone ?
HTH. best wishes Harald
"dems" <firstname.lastname@example.org> skrev i melding
They ask meaningless things like this in schools ? Disturbing.
Best wishes Harald
"Bob Phillips" <email@example.com> ...If Public Folders are going away..
What would be the best/simplest solution for a user requesting a group
calendar to be used within Outlook. Ordinarily i would advise them to
create a calendar within the Public Folders hierarchy and then assign access
rights to anyone who needs it. I understand though that Public Folders will
be history with the next release of Exchange. The only thing i can think of
is to create a new mailbox, share the calendar, and then walk users through
adding it to their Outlook folder list. I suspect this isn't the best way
though. Any recommendations out there?
All clients are running ...