Reported Positions don't match Money Account
I've been downloading my stock portfolio details for years with no problem.
For some reason one of my brokerage accounts has gotten out of whack - Money
is reporting "Positions reported....don't match those in your money account".
If I don't update and manually compare the account summary with my online
statement, every quantity for every symbol matches exactly. Yet for some
reason, Money thinks it can only fix this problem by creating an empty symbol
and inserting some shares. I think that somehow money is trying to map a few
new transactions into the wrong ac...Export data fro access to excel
I'm working on a site for on-line registration for Special Olympics.The state office has gone to a excel form for the information to besent to them. I am able to print the exact form, but am wondering ifit is possible to export the information into their excel form. To bemore specific - the information in my access field name email wouldhave to go to F48 thru K48, DaytimePhone to F50 thru K50 and so on. Iknow how to export the info as an excel sheet, I do that to get theregistration into their games management software, but am curious if Ican export into excel being specific with where ...Linking to photos for download
I'd like to be able to post text or photos for download by customers--the
photos would be the product. Eventually, I want to be able to track, for
billing purposes, who downloads a 'product.' How do I do that?
On Sat, 6 May 2006 10:00:01 +0100, Chris wrote
(in article <F8AA4510-2AE7-4333-ADBD-EBDE3008B1BC@microsoft.com>):
> I'd like to be able to post text or photos for download by customers--the
> photos would be the product. Eventually, I want to be able to track, for
> billing purposes, who downloads a 'product.' How do I do that?
You must REALL...download Microsoft Office 2007
Have Dell Latitude D610 notebook with more than 70% free space. currently
have Microsoft 2003. was given CD with Office 2007 [with authorization
codes, etc.] and every time I try to download it, I get a dialog box which
says "D:\ProPlus.WW\OSETUP.DLL digetal signature does not validate or is not
present"....[the disc was tested and could be read by another, though newer,
can someone tell me how to diagnose, but more importantly, how to fix, the
...Diable account but still have active mailbox
I'm new to AD & Exchange 2003 and ran into my first problem:
I disabled an account in AD and then the user's mailbox could no longer
accept mail and other users could not access the mailbox either. I ended up
changeing the user's password & reenabling the account to get it working
again. What should I have done?
Scenario: when a user leaves, we like to leave the mailbox active and have a
manager review incoming messages for a week or so. However, we want to
disable the logon priviledges. What needs to be done to allow this?
Disable the user account and assign &q...Accounts & Contacts Company Name CRM & GP
Our company is in the process of implementing a crm3 to great plains 9.
We were told that we need to convert Leads to Accounts & Contacts for the
way Great Plains & Crm Integrates using the Scribe solution we purchased.
The problem is that when we have multiple accounts with the same company
name that they do not import correctly. These ARE NOT the same company even
though they have the same company name. We are trying to figure out how this
will work in CRM and Great Plains.
For example we could have RE/MAX Northwest in Chicago area and a RE/MAX
Northwest in Texas that are n...Printing Customer Name on Credit Card Receipts
This is another suggestion to MS to add into RMS the following feature:
Pull the customer name from a credit card that is swiped and print it on the
If the "dumb" terminals most processing companies rent out can do this,
certainly a sophisticated program like RMS should be able to do this as well.
I'm no programming genius but I'd imagine that since RMS is already
filtering out the account number and exp date from the rest of the data on a
cc mag stripe that pulling the name would only add a few lines of code.
In a similar post someone mentioned that there wa...User account locked out
Bonjour! One of our user receive an error message "This User account has been
lock out. Contact your Sys Admin." when trying to login into GP yesterday and
she is still Locked out this morning.
Try the following
1. Go to Tools=>Utilities=>System=>User Activity and then Delete the User
who is locked out. If this doesn't work out
2. Go to SQL, Run the script below in DYNAMICS Database
DELETE FROM SY00800 WHERE USERID = 'XXX'
---Replace XXX with the User ID
> Bonjour! One of our user re...Excel 97-remove link but keep data
I have a pre-existing excel 97 s/s which has links to other s/s's. I would
like to keep the data only (like paste-special, values) and remove the linked
reference from showing in the current s/s. Any ideas how to do this instead
of me changing each linked reference?
Thanks in advance!
search for .xls or [ or ] to see if you can find the formulas that contain links
to other workbooks.
> Hi guys,
> I have a pre-existing excel 97 s/s which has links to other s/s's. I would
> like to keep the data only (like paste-special, values) and rem...Auto config of exchange account in outlook 2003
I am looking for a way for users to log onto any computer with their account
and have outlook launch without prompting for exchange account settings. Is
there an easy way to accomplish this?
It can be done with the resource kit for outlook. I seem to remember that
you can create an MST file to install office/outlook with and that gives the
information about outlook settings. I am sure that one of the smarter guys
will give you a link about how to go about this. But it is possible and
"MarkatMarios" <MarkatMarios@discussions.mic...How to retrieve data which contain "/" in it
I try to pull a data from access with contain a speacial character "/" in it
but what i get is it not return a single data, so how do i wanna retrieve it?
below is statement I use it but it return nothing.
SELECT LDDATA.COR, LDDATA.CON, LDDATA.PCODE, LDDATA.QTY, LDDATA.BOXNO,
LDDATA.CASENO, LDDATA.RSNOS, LDDATA.RSNOE, LDDATA.NOFRS
FROM LDDATA WHERE (((LDDATA.COR)="A11/LC/000002/11/06")) ORDER BY
On Tue, 22 May 2007 21:53:02 -0700, osmanar
>I try to pull a data from access with...Importing Data into Word Drop Down Form Feild
How do I import excel data into a drop down form feild in Word?
Thank you for your assistance! :
Barnch's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1467
View this thread: http://www.excelforum.com/showthread.php?threadid=26305
What kind of dropdown? Is it data validation or a combobox or what?
Where are you importing from? Normally it comes from a range on th
worksheet. Is this what you intend?
---------------------------------------------------------------...HELP: Cannot retrieve my Outlook/Outlook Express messages from my Yahoo email account
In the past, I have always been able to use my Yahoo email account to
download my emails from my Outlook/Outlook Express POP server.
In other words, I could always use Yahoo to access my Outlook email without
Outlook at all. Just go into an Internet cafe anywhere in the world and I
can access my Outlook emails from the Yahoo email site.
But lately, the Yahoo email kept giving an error message:
"POP server does not support LAST command. You may only retrieve POP mail
from this server using "get all messages".
The Yahoo email webpage doesn't seem to allow me to input this ...Need to re-download and get product key
My computer was reformatted and I no longer have my copy of Money Plus Deluxe
or the product key. I purchased it directly from the Microsoft site. How do
I go about getting a new copy and my product key? Thanks in advance for any
...Default Email Account
I am using MS Outlook 2003 on a Windows SBS 2003 network. I do not want to
use the Exchange server to send my email to my ISP. I want to send to the
ISP directly from my computer. So, I open Tools/Email Accounts.... select
E-mail View or change existing e-mail accounts and click Next>. I then
highlight my ISP account Name and click Set as Default. It is now set as the
default instead of the Microsoft Exchange Server. However, when I restart
the next morning, I have to go through the same procedure since the default
has reset to the MS Exchange Server. How can I make the ISP account t...Contact fields don't show data on Task View.
I have task that are linked back to contacts by the contact field at
the bottom right corner of the task entry form. The problem is when I
am in the task view screen and try to add any field from the contact
screen like company name,contact phone number using the field chooser.
It drops the field on the view but never has any data in it. Is there a
way to do this?
Windows XP Pro
Those fields aren't available on Tasks. Just because you link a contact to a
task, it doesn't mean the rest of the contact fields are linked to the task
or visib...Help with selecting data
Can someone correct the following expression so that my database comes up
with a list of forms issued and the highest number issued for each?
SELECT [ID], [Form_Number] & " " & [Ending_Number] FROM DocumentsIssued
ORDER BY [Form_Number] & ", " & [Ending_Number];
Currently, the above is generating all the forms and all the ending numbers.
It also includes forms that have not been issued with the Ending Number of 0.
To be clear, here's a sample of what I get, followed by what I need:
Form A 15
Form A 30
Form A 90
Form B 10
Form C 30
Form C 6...Recover mailbox from deleted account
I had a request to recover data from a former employee's mailbox. The
employee in question has been gone for about a year. I was able to
resorte the Private store to the RSG, and I can see the mail-box
listed, but I can't seem to get to the mail data. I have tried
recreating an account with the same name, that has not worked. I have
tried exmerge, and that also has not worked. I am sure the issue has to
do with the SID of the original account missing, but is there any way
to get around this? Using Exchange 2003 native mode. BE offers during
recovery to recreate accounts, and if I have ...Different ways to extract data from Access to Excel
I have been using Access 2003 and 2007 to read and do simple data (not
design) repairs to old Jet databases that underlie a legacy proprietary data
collection program my company uses. My latest challenge is to automate the
extraction of certain data from the tables and put it in an Excel
spreadsheet. Each time the extraction is done it would involve finding a
certain table, searching for a record that meets the new criteria in a
certain field, then moving over to another certain field and extracting the
text, number, or date therein.
I would really appreciate if anyone could point out ...trying to combine 2 columns of data to create one x axis in graph
I am trying to combine 2 columns of data to create on x axis (I have to
create an Asthma peak flow chart and have 4 different times per day with
figures - before & after), so each day has 4 lines. I need to show data and
graph (if possible) on one sheet to take to the hospital. At the moment the
column is too long to be readable in landscape (with graph) and I can't find
a way to change orientation of graph to make it readable in portrait. Is
anything possible (my dates are like 01 8, 01 12, 01 16, 01 20 etc. for
every day in the month).
Send me the file and I will fix ...setting up mutiple email accounts
I have 4 different mailboxes and I need them to go into 4 different inboxs. I
dont need them to got into a community inbox. How do I do that? The help
assist tells me to setup different profiles but doesnt tell you how to do it.
With a single profile;
Create mailbox specific Folders, as subfolders of Inbox
Create rules to move received mail to specific folder
"thephoneplace" <firstname.lastname@example.org> wrote in message
> I have 4 different mailboxes and I need them to go into 4 differen...Pivot Table - Group by Month
My data is in financial year, July to June. The date field is in the format
DD/MM/YYYY which is in the column area of the pivot table. I have this
grouped by month and year, so it displays Jul-Dec 2003, followed by Jan-Jun
Some items in the "Row" area of the table do not have entries for all 12
months, but I still want to display the month for that item (with no data).
In the "field settings" of month I have selected "show items with no data".
Unfortunately this then displays Jan-Jun for 2003 and Jul-Dec for 2004, all
blank because those d...how to collect the data and log file growth trend in past in sql 2
Do you know any way to collect the data and log file growth trend in past in
sql 2005? Any DMV records this? Thanks
The default trace files track this but they only track so many events before
the trace file is over written with a new one. You can usually find the
trace files in the instance folder under the LOG folder. Use
fn_trace_gettable() to view them and look for autogrow events.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Iter" <Iter@discussions.microsoft.com> wrote in message
news:B310150D-AD9C-42AF-82C7-051E8F6D13B7@microsoft.co...Sort on last two digits of data
A sorting question.
I have a sheet of data A12:BC77. I would like to sort this on items in
column A. The problem is I need to order it by the last two digits of the
data in Column A. So say ZWE11 will come before AA77 and QW22 will come
before BB55 and so on. There is probably a simple answer but it is missing
me at the moment.
All I can think of is splitting out the last two digits into a new column
and sorting on that, then deleting that column once sorted but seems very
Any advice will be very gratefully received
with kind regards
Hi Spi...Storing products information in contacts or accounts ?
I am relatively new on this, so please excuse this possible stupid question...
I can create databases with products in MS CRM and I can link them to cases,
but is there a way to add an existing product to a contact or an account ?
E.g. could I add sold software to an account and add the serial number of
the software to it ?
Many thanks in advance !
You can link products to accounts/contacts by creating custom entities -
Account-Products, for instance. This entity shall have a relationship with
Account and Product entities and will appear in the left navig...