How can I generate a user friendly error message when validating XML against a schema?
When validating xml against a schema, the most frequent error I get is
something like "The 'FOO' attribute has an invalid value according to its
data type. An
error occurred at , (25, 913)". That error message is not very user
friendly, so I'd like to extract the data in the failing node along with its
parent node data, and show that to the user.
Do you know a way to do this? I don't think there's any other information
about the error position than the line number and position.
Yes, line number and position is the only information that you have to...Duplicating a GP Smartlist for use in Smartlist Builder
Since I can't edit default Smartlist objects in Smartlist Builder, I want to
take an existing GP Smartlist and make a copy in Smartlist Builder so that I
can edit THAT.
Is there any way to accomplish this?
As far as I know there is no way to copy an existing SmartList for use in
Dynamics GP MVP
Flexible Solutions, Inc.
"FatRichie" <FatRichie@discussions.microsoft.com> wrote in message
> Since I can't edit default Smartlist objects in Smartlist Builder, I want
...How can I read CSV file using VBA?
I have to read CSV file using VBA. I don't want to use macros or queries like
transfer spreadsheet etc. because I want to apply certain rules in a module
after reading the file.
Message posted via AccessMonster.com
I am using the following code but one of my field which has both characters
and numbers is not importing at all.. How do I handle this?
DoCmd.TransferText acImportDelim, "", "Test_CSV", "c:\csv_files\12-31-2009
Test.csv", ...Using Data Stored on External Drives in 64 bit computer
I have a 32-bit computer using Windows XP Pro and I have two externaol hard
drives with a lot of important information. When I get a new computer, 64-bit
with Windows 7, will I be able to use the data currently stored on my
external hard drives with the new 64 bit computer using Windows 7?
On 7 Apr., 18:38, moon <m...@discussions.microsoft.com> wrote:
> I have a 32-bit computer using Windows XP Pro and I have two externaol hard
> drives with a lot of important information. When I get a new computer, 64-bit
> with Windows 7, will I be able to use t...Information on assets that are used for bussiness and personal
How can I use your program to designate a porcentage of these type of assets?
Exaple office space at home, car for personal use and work?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=88fddc9b...How can I add transaction while using the online version of money
Ok... when I first bought Money several years ago and installed it on my home
computer, I could then login while at work via the passport and see the
information that I had entered on my home computer. If I purchased something
during the day I could go online and add the transaction which was great way
to know at any given moment what my TRUE balance was in my account.
Now when I check my Money account online from work I can see all the
information I've entered at home but now there is no way to add a new
transaction other then from my home computer where I have Money installed.
...importing text file into excel file using macro
How to import text file into excel file using Macro? Can this proces
run on form menu button? Please help and give me some ideas of doin
it. I have attached a text file for your reference.
Attachment filename: rdata.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=66130
Message posted from http://www.ExcelForum.com
>How to import text file into excel file using Macro? Can
>run on form menu button? Please help and give me some
ideas of doing
>it. I have attached a text file for your r...Need to remove data in table due to input mask; cannot close.
ACCESS Table open, unable to close or modify telephone field. Had tried i/p
mask of 0 due to "Unlisted" numbers appearing right-justified when doing a
report. I sure thought I changed it back to a NO MASK prior saving the table.
Now, table is open and I am unable to do anything with that field, even
deleting the content, to satisfy the mask problem. Hands seems to be tied in
'catch 22'; I would have thought (!!??) that the table would not have saved
properly if the input mask did not match the field contents. I'm stuck!
Thank you so much.
....I have a large amount of amount to produce multiple charts from, so using
Autofilter is a bit of a necessity. Using the Chart Wizard, I can easily
select the filtered data range but it doesn't seem possible to select the
(filtered) headings as the X-axis (time period). Any ideas or workrounds?
Thanks in advance,
when you set up your autofilter range leave the row you want to use for your
axis out of the range.
> ...I have a large amount of amount to produce multiple charts from, so using
> Autofilter is a bit of a necessity. Using the...This action is only valid for products that are currently installed
I have Outlook 2003 in Corporate mode. When ever I try to open a JPG
attachment, I get the error "This action is only valid for products that are
currently installed". I have tried "repairing" Office, and tried
reinstalling the various filters and file formats, to no avail. Any ideas?
Tim Munro <Excelsior@Liamtoh.moc> wrote:
> I have Outlook 2003 in Corporate mode.
Outlook 2003 doesn't have modes.
> When ever I try to open a JPG
> attachment, I get the error "This action is only valid for products
> that are currently installed&...Using VBA to change default color palette
We currently have an add-in for Excel Xp which changes the default excel
color palette so that it displays our companies corporate color scheme. We
are wanting to use this in Excel 2007 as well but cannot get it to work.
Included is some of the code used for Excel XP
On Error Resume Next
'Modify the first row to compnay Primary color Palette
ActiveWorkbook.Colors(11) = RGB(160, 0, 80)
ActiveWorkbook.Colors(55) = RGB(225, 110, 0)
ActiveWorkbook.Colors(52) = RGB(235, 175, 0)
ActiveWorkbook.Colors(51) = RGB(180, 190, 0) ...Best Practices for Development in GP's using Custom Tables
Is there any such document/direction?
We write custom solutions for our clients using everything from eConnect, to
..NET etc. Is there a guideline for creating or not creating, custom database
tables in GP's productions databases?
...Order of Events when using the Control Box Close Button
I would like to intercept the built in messages that are generated by Access
about required data when a user clicks on the Close Button. The Close Button
is enabled by setting the Control Box and Close Button form properties to
"Yes". Does anyone know what the order of events is when using the Close
Answered in later post.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"accesswanabe" <firstname.lastname@example.org> wrote in message
>I...How to use two parameters in input of popup Variables
Gary's Student kindly made some to code to allow input of variables via
Dim colstring As String
Dim findit As Double, replacewith As Double
colstring = Application.InputBox("Select Column ....", "Stage 1 of 3",
findit = Application.InputBox("Column Selected : " & colstring & vbCr &
vbCr & "Select Value To Replace?", "Stage 2 of 3", Type:=1)
replacewith = Application.InputBox("Column Selected : " & colstring &
vbCr & vbCr & "Value Selected : " &am...Open Subform in a New Window using a command button
I have a form with a subform which does exactly what I need. However, I want
to someway change the subform to a command button so when you click the
command button, it will open the subform using the same filter.
My form is frmPatent and the subform is sfRelated. The Link Child Field is
RelatedMtr and the Link Master Fields is Matter.
Can anyone assist me.
Place a button on the form and try this in VBA:
docmd.openform "subformname", acnormal,,"RelatedMtr= '" & me.matter & "'"
replace the subformname with your own subfo...Want to use Excel as a database for small school, how to print out specific fields??
I am a volunteer parent for a small school and have been asked to help
setup a database of the students (160) and need to figure out how to
create a file and print just specific fields for different purposes.
I tried the mail merge but didn't get the result I needed, which is
just a page of information to pass out amongst the different families.
I've looked around but can't find anything that looks like it would do
what I need, but I seem to remember that it is possible. so far I've
got my column headers and the data entered, but can't do anything with
The ...Using get_documentElement cause exception in Application exit
I am trying to read an XML file using get_documentElement method and I get
exception when the application exits in comip.h file (in _Release() method).
I am just Loading the XML file and use get_documentElement method:
bool CProfileTranslationToolDlg::TranslateFile(const _bstr_t& TrnURI)
// Load XML file.
HRESULT hr = pDoc.CreateInstance(__uuidof(MSXML2::XML_DOMDOCUMENT));
VARIANT_BOOL vb = pDoc->load(TrnURI);
hr = pDoc->get_documentElement(&mDocElem);
when &...Using Outlook with Hotmail
I've just started using Outlook 2003, after having owned the disc for a
while (I only used office for Word prior to this).
I use two hotmail accounts, both of which are installed fine.
1) How can I get an audio alert when new hotmail arrives? Surely if Outlook
Express provides one, then the more advanced program should too??? This is a
mjor thing for me, as I don't want to have to keep checking constantly to see
if I have mail.
2) How do I configure my sent items to stay in the right place - e.g. the
hotmail sent items with their relevant accounts, rather than in the un...Address books using nicknames E2K3
How do I force outlook to look at the nicknames of my address book?
...validation list became not working.
i have an excel with lot of validation lists in severals sheets.
while working with the excel i all the validation list in specific sheet
became not working.the list are still defined in other sheet. but there is no
option to select from the list...
thanks in advance....
Do you mean that you have lost the drop-down arrow when you select the cell?
If so, does typing an invalid value in still throw an error?
(change the xxxx to gmail if mailing direct)
"Miri" <email@example.com> wrote in message
news:FABA720A-1F25-42...Accessing Custom entities using webservice
Can anyone tell me if it is possible to access custom entities using a
webservice. I am trying to create an instance of a custom entity that has
already been established in the CRM. Thanks.
...Filter by form using a multiselect listbox
I have been able to build a query that is filtered by a selection in a
Listbox, but now i want to use a multi select list box so that two or more
items can be included in the query. I constructed the query pointing to the
Listbox but all I get is an empty dataset. How can this be accomplished?
As always your help is appreciated.
For a multiselect listbox to work as a filter you need to create another
query based on the listbox.
Put this code for execution between the selection of the listbox and running
your main query
****Start of code*****
...Using COUNTIF for a word that is joined by another word in same ce
To make it easy, I am trying to count the number of times the name "Bob"
appears in a range of cells. Most of the time, "Bob" is the only name in the
cell, so COUNTIF would work. However, sometimes there will be 2 names in the
same cell, like this: "Joe/Bob." What kind of formula can I use to count the
number of times "Bob" appears in a range of cells, including the times there
are 2 names in the same cell? With the COUNTIF function, it is only counting
the number of times "Bob" appears alone in a cell within the range of cells.
u...Using Outlook on multiple computers
I'm going to college soon. I have a desktop computer and a laptop. It is
very important that both have access to my Outlook inbox.
I would love to be on campus somewhere on my laptop with Wi-Fi, download my
e-mail, come back to the dorm and automatically have it synch up with my
Also, I would love for my desktop to have it's own .pst file. That means I
don't simply want to read off the laptop's .pst file when I'm on my desktop.
I would a program that automatically (or w/ the click of a button) synchs
Outlook between my laptop and desktop.
Do you guys know of suc...question on "include" in schema files (.xsd). Trouble validating schema in .NET
I hope someone can please help me. I'm having a lot of trouble with
schema files in .NET. I have produced a very simple example that uses
"include" to include other schema files. It all works with SPY, but
when I pick "Validate Schema" from the .NET 2003 menu, it fails with
"Type XType is not declared." As I hinted at in my subject line, I
suspect that it has to do with including another schema multiple times.
Can someone tell me how this should be done? Possibly, SPY or .NET do
not conform to the standard. Is there a reference somewhere t...