Has anyone converted an MS Access VBA project to .Net?
I am looking for any information regarding the conversion
of an MS Access VBA project with backend of Oracle to
either Visual Basic or VB.Net. Has anyone done any
conversion like this and if so, do they have any
recommendations, issues to share?
...Pocket Money 2005 Is Available Now
For those of you who have been asking about the latest version of Pocket
Money, the 2005 version is available for download now at:
It is fully compatable with Microsoft Money 2005 Standard, Deluxe, Premium,
and Small Business Edition.
This is what I got when I went to the site this afternoon. Has it been
Microsoft Money for Windows Mobile-based Pocket PCs is coming soon!
"Ken Mattson" <firstname.lastname@example.org> wrote in message
news:dttld.41461$QJ3.2947@newssvr21....Merging XML Documents (with ADO.NET?)
I have got 2 XML documents, both of which conform to the same XSD Schema,
which define possible optional elements. The 2 XML documents contain 2
disjoint set of XML elements.
What is the best, easiest, most efficient way of merging the 2 XML
Documents? Can I use DataSet.Merge() facility in ADO.NET?? Any
Any other suggestions?
Can you provide an example of each XML document? Its not clear to me how
the schema can be the same if each XML document has different sets of XML
Also, you didn't indicate what you wanted to do after merging the XML
....NET access not working
I can get into hotmail and my MSN account information but
not money using my .NET name and password! This is VERY
wierd. Has this happened to anyone?! I am using Money
2003. Any help is very appreciated!
I have exactly the same experience with money 2004. It
started last week and I'm pretty tired of it.
>I can get into hotmail and my MSN account information
>not money using my .NET name and password! This is VERY
>wierd. Has this happened to anyone?! I am using Money
>2003. A...Columns on wrong side
When I open a book in excel, why is column A in Excel on the right side of the sheets, meaning it looks like this:
How do I change it to look the normal way from left to right when I open a new book in excel?
Seems you have set Excel to read from Right to Left - as is done in Arabic language.
To set it right
Go to menu Tools->Options
Choose the International Tab
In Right-to-Left Default direction choose Left-to-Right
The order of column will be A-B ...
> When I open a book in excel, why is column A in Exce...Money 2005
In Money 2004 there was a lot of flexability in the information displayed for
individual stocks in a portfolio. I have been unable to find much
flexability in the display of stock info in Money 2005. For example in Money
2004 I had the number of shares of a particular stock multiplied by the
change in the stocks value for that day to arrive at the dollar amount of
change in a particular stock. I can't seem to find this ability in Money
2005. Can you help?
In microsoft.public.money, jwd wrote:
>In Money 2004 there was a lot of flexability in the information displayed for
>i...What am I doing wrong? (Protecting forms)
I'm doing something wrong and I can't figure out what. I created a
form (like I've done many times before) and I'm trying to protect it
but when the Protect Form pane comes up, I check the box that says
"Allow only this type of editing in document:" and I select "Filling in
forms" from the drop down list.
Normally, the "Yes, Start Enforcing Protection" button becomes active
and I would then select it but it's grayed out as is the the lock on
the Forms toolbar.
This has happened to me once before and I had to start over wi...Error: Value in Formula of wrong data type
I have a worksheet that uses custom formulas on several inputs from that
page. I've used it for a while and never had a problem, but made some
changes elsewhere in the worksheet (not linked to this part) and now on many
of the cells using these formulas, I get a '#VALUE!' error, stating 'Value in
Formula of wrong data type.' The data type is the same it has always been,
so I don't know why it's not working now (formula just uses if thens to
compare different numbers and return values like 0, 1, or 2).
What's even more perplexing is that several ...Default Printer-Wrong Printer
Is there a way to change the printer automatically on a per application basis.
Our default printer is a HP LJ 6, However 2 users also need to have access
to another printer (check printer). When they are in Great Plains they will
only be printing to check printer. They keep forgetting to change it from
file/print and printing on the wrong printer. Also I do not need to change
the default printer(hplj6)
this most stay as is. Is there a regkey i can invoke or script to launch
when they start GreatPlains they will change the printer to checkprinter.
Now when ever they reboot and sta...2003 Imports to wrong fields
When I import a QIF statement from my bank(s), money
imports the narrative field into the 'Memo' field. That
may sound correct, but both of my banks use the Narrative
to store the name of the Payee and as such I would like
to change the way money imports the file.
Does anyone have any ideas that would enable me to import
the Narrative field from my banks into the Payee field in
In microsoft.public.money, Tim wrote:
>When I import a QIF statement from my bank(s), money
>imports the narrative field into the 'Memo' field. That
>may sound correct, ...richcopy vs robcopy
any one has experience using both richcopy and robocopy
is the richcopy really that much better than robocopy gui on vista or win7?
On 26 May 2010, "GS" <gsmsnews.microsoft.comGS@msnews.Nomail.com>
wrote in microsoft.public.windows.vista.general:
> any one has experience using both richcopy and robocopy
> t.aspx is the richcopy really that much better than robocopy gui
> on vista or win7?
Richcopy is to...oups wrong email
I use my address book a lot. Seeing that a few of my
contacts have 3 or 4 cards (differents company, fonction,
category...) The only thing that doesn't change is the
address, fax number or phone (same on every card)
So when I get a change I have to modifie all the cards.
Do you know how to "link" the cards so the change is done
Thank in advance
...Discount vs Sale Pricing
Need option for displayed price to be based on lower of customer discount or
sale price, but not both. For example, currently I have item XYZ on sale for
$70 (reg. price = $100). I have customer 'Jim' who has 30% discount
automatically set-up in the customer database. When Jim buys XYZ, the price
that gets rung-up is $49. I was expecting $70 (i.e. the lowest price
considering either the sale price or customer discount, but not customer
discount on top of sale price). I've tried all kinds of options using the
'Discount' tab, but it appears the software doesn't...making changes using VB.NET
Thanks very mach for your help :)
Now I have another problem , I have xml database, and need to make changes in
I can successfuly find the wanted node using XmlNodeReader but then I have
problem : How can I convert it to the type (xmlWriter or something else) to
make the change in the data (for example to change the price of product).
Thanks in advance :)
Message posted via http://www.dotnetmonster.com
...calculate net income i.e. revenues (-) expenses in a pivot table
I need to calculate net income i.e. revenues (-) expenses in a pivot
table. My source data is all positive amounts. I do have a field that
identifies the amount as a Revenue or Expense.
Source fields are:
4.GL Line item description
6 Rev_Exp _ID
Once the pivot table is setup how can I get a TOTAL calculation that is
revenues (-) expenses by Section by month/Yr?
Column fields are: Month/Yr
Row fields are: Section, GL Number, GL line item description,
Data is Sum of $_amount.
Try creating a ...mfc class wizard problem on visual studio 2005
I found a problem of mfc class wizards (VS2005 with SP1). If a class
doesn't inherit a MFC class *directly*, e.g. it inherit a class which
inherit a well-known MFC class directly, you can only add message
handlers by hand. And when you open the properties window of the class,
you see the "Events", "Messages" and "Overrides" window are empty.
1. create a new MFC class CMyDoc based on CDocument firstly.
2. create a second MFC class CMyDocEx based on CDocument. Because the
wizards limit the base class to the well-known MFC class.
3...SQL Server 2005: SELECT INTO & pass-through query
I often use pass-throgh queries to get data from external sources -
something like following example:
-- Declaring variables
DECLARE @SQLString varchar(max)
DECLARE @OpenQuery varchar(max)
DECLARE @LinkedServer varchar(max)
-- Declaring table variables
DECLARE @Q1 TABLE(
-- Setting variables
SET @LinkedServer = 'MyLinkedServer'
SET @OpenQuery = 'SELECT * FROM OPENQUERY(' + @LinkedServer +','''
-- Co...Publisher just started printing wrong colors
This problem just started today, and only when using Publisher
A deep blues sky is printing orange, and pink skin is printing light blue. I
tried printing the jpg outside of Publisher, and it looks fine. I've changed
the color scheme in Publisher to black, and black/grey, but that did
nothing. I changed ink cartridges (both the black and the tri-color) and ran
the HP utility to clean the print heads, all to no avail.
What version Publisher?
Publisher is more critical about printer drivers. Check with HP for an updated
driver. They also have good support doc...Outlook Express vs. Yahoo e-Mails?
Can anyone please tell me if it is possible to setup Outlook Express to
send/receive from Yahoo webmail?
This newsgroup is for support of Outlook 97-2003 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.windows.inetexplorer.ie5.outlookexpress&SLCID=US&sd=GN&id=fh;en-us;newsgroupsmicro...money 2005 error
looks like money zapped out on me...when i go to setup an account for online
access i get a message "to set up your accounts, you must be online. Please
close money, and then sighn in to your file. When you sign in, make sure the
work offline box is cleared." I AM online and no the box is not checked...I
don't get it. I've reinstalled money to no avail...anyone have any ideas?
I have a main page 'MyMainForm' containing a button. When this button is
clicked; another form 'MySubForm' opens up which contains two buttons (OK &
When OK button is clicked; the code behind this button processes some data
and displays an alert and then goes back to 'MySubForm'.
What do I need to do so 'MySubForm' is closed automatically when processing
is done and OK is clicked on alert box?
> I have a main page 'MyMainForm' containing a button. When this button is
> clicked; another form 'MySubForm'...Integration Manager vs eConnect
We have two data integration requirements the first is to import data from
another accounting solution the data residing in MS SQL2000, the second
requirement will be recurring and that is to import AP invoices from a
vendor's provided SQL table. Is eConnect or the Integration Manager a better
For simple data integrations, I prefer to use Integration Manager since it
does not require complex coding and it is a pretty straight forward process.
For complaex data integrations, like invoices, orders etc, eConnect is the
right tool but it requires tedious coding (I use VB.Net).
&....NET Framework 1.1 Service Pack 1 fails to Install
Using Windows XP Home SP3
..NET Framework 1.1 Service Pack 1 always fails to Install. I have tried
everything in KB 953297 and 922377 including the cleaner that removes all
versions for .NET Framework.
I have emptied the Software Distribution folder and it still fails. Anti
Virus is off as is the firewall.
I'm looking for something else to try
OK try to download a fullfile version from here and then install it when you
I seriously think that you may not need this update but you haven't told us
what applications you are using that requires version 1...VS IDE
I'm trying to work with XML/XSLT in the Visual Studio IDE (VS 2005) and when
I select the menu option XML/Show XSLT Output I get a tab with the output
showing the text HTML code. I'd like to have it display like it would in a
browser instead. I'm working around it by coding the path to the XSLT into
the XML file, keeping a browser open and hitting the refresh button which
isn't a huge deal, but I was wondering if there's a configuration option or
some way to have it display the way it would look in a browser in the IDE.
Any links to documentation about this would be ...serring sheet size vs paper size
is there an easy way to set sheet size so that it doens't auto maticcally
default to 8.5x11. this cause me to creat a new paper size anytime i try to
I've read all the help, there is no reference to sheet size I can find
It is possible to create custom page sizes in your printer.
Your page size will always default to letter unless you create a new page size
for all your publications. This would be something you would do in the print
folder in the control panel.
I would advise you not to do this however. Publisher is setup for the letter
default. Create c...