Generating Multiple Choice Tests
I currently use Access 2003 to create tests. I am looking to use a grouping
and random sampling method to improve efficiency. In as much that I use
access to create tests now, is VBA an appropriate platform for randomizing
and group sampling or should I go to an independent language. Any advice
will be greatly appreciated.
SELECT TOP 1 Rnd([TestID]) AS Expr1, TestText
ORDER BY Rnd([TestID])
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, inform...XmlSchema classes help needed
I am having hard time figuring out how to programmatically construct a
schema with following comple type:
<xs:element minOccurs="1" maxOccurs="1" name="B" type="B" />
<xs:element minOccurs="1" maxOccurs="1" name="C" type="C" />
Specifically I can not find any way to insert the
"XmlSchemaAnyAttribute" instance into the complex type I have. A...random number generator
hi there i don't know if this is the right section, however I was
wondering is there some vba or formulae to generate random numbers in a
I would be very greatful if you can help me
manclad's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30016
View this thread: http://www.excelforum.com/showthread.php?threadid=497074
I like J.E. McGimpsey's =RandInt().
> hi there ...Receipt
Does anyone know whether it's possible to use a string as part of the
conditional expression ? The code I'm trying to use is :
<CONDITION> Entry.Item.ItemLookupCode = "GV" </CONDITION>
It's working fine if I replace the "GV" with a number, but always hits the
ELSE expression when it's a string. I've also tried using a string variable
here, which also fails.
Nope, no string comparisons.
Tiber Creek Cons...Saving/Loading Xml to/from an Xml file
I have a function called GetXml that returns Xml as expected.
I then use:
Dim saveFile As New SaveFileDialog
and the configure saveFile.
Having got the file and the Xml, how can I then write the Xml to the file?
Also, how could I load the Xml back in to a string using an OpenFileDialog
(openFile) or similar?
Regards, Carl Gilbert
"Carl Gilbert" <email@example.com> wrote in message news:OHk4WC5qEHA.628@TK2MSFTNGP09.phx.gbl...
> Having got the file and the Xml, how can I then write the Xml to the file?
Dim writer As System.IO.StreamWriter
writer = ...XML Security
I have posted this on ASP security to no avail. I have a web app written in
c#. This app dynamically creates an Xsl doc from user defined info in the
database. It also creates an instance of another c# class. This object gets
passed into the Xsl doc as a parameter, and it is called from within the
stylesheet to perform various functions during transformation. This object
also uses some gdi32 and other unmanaged code. The I am seeing is that
various exceptions (SecurityException, namely) are thrown from the component
any time these methods are called. I have tried granting FullTru...Generate URL and trigger
Let's see if I even phrase this question correctly. We use an Access DB to
enter appointments for our company. There are hundreds of querys, but in
reality all the information is stored in one Table. (There are other tables
used for drop down info, etc.)
We are going to start using a web based software that will do additional
things for us. We will continue to use the Access DB. The Web software guys
are telling me to have our Access DB generate a URL for each appointment
entered and have it automiatically uploaded to their software using the auto
They acted...Retrieving default values specified from XML Schema file
I have an VS.NET 2003 app which will be processing XML files, some of which
will have empty elements (for example, <Item />). I have an XSD file which
should supply default values, but I am not able to read these plugged in
value using an XMLDocument object. The validation is working fine--it's just
not providing any default values.
Has anybody tried this? Am I must be missing something? This is one of
those that "should be simple..."
Here's a simplifed version of the code and XML files:
XmlDocument xmldoc = new XmlDocument();
XmlSchemaCollection my...How fill Dataset from XML file?
How do I use an XML file to fill a dataset? Any code examples?
The XML file has 10 of these records.
I found it!
"VB Programmer" <growN0SPAM@go-intechN0SPAM.com> wrote in message
> How do I use an XML file to fill a dataset? Any code examples?
> XML f...Identifying all Namespace / Prefixes when reading an XML
How do I identify all of the namespace / prefix pairs associated with an XML
document I am reading?
Thanks for any help.
> How do I identify all of the namespace / prefix pairs associated with an XML
> document I am reading?
XPath has a namespace axis you could have your code walk. It depends on
how you read your XML document, with Xml(Text)Reader you do not have
XPath support. With XPathDocument or XmlDocument you do.
XPath expression is
or (with duplicates removed)
//namespace::*[not(. = ../../namespace::*]
Note that the prefix xml is a...ASP.NET Caching XML
In the world of MSXML 4.0 - one of the techniques used was caching the
DomDocument in the application cache with ASP.
Updates made to individual nodes could occur concurrently.
Is this still possible in .NET? Or is the a better design to use.
Paul Jansz wrote:
> In the world of MSXML 4.0 - one of the techniques used was caching the
> DomDocument in the application cache with ASP.
> Updates made to individual nodes could occur concurrently.
> Is this still possible in .NET? Or is the a better design to use.
I believe the same goes for System.Xml.XmlDocument class of .NE...XML
I can not locate XML on my Data menu for Excel. I checked to see if it was
an add-on but it's not.
You don't say which version and edition of Excel you are running.
From Excel 2003 help.
Note XML features, except for saving files in the XML Spreadsheet format, are
available only in Microsoft Office Professional Edition 2003 and Microsoft
Office Excel 2003.
Excel 2007 has XML support also.
Gord Dibben MS Excel MVP
On Tue, 24 Jul 2007 10:08:03 -0700, emi <firstname.lastname@example.org> wrote:
>I can not locate XML on my Data menu for Excel. I checked to see if it wa...Error message: c:\windows\system32\avgxch32.dll
I am running Cloudmark's Spamnet within Outlook 2002.
When I try to delete a large number of emails from the Spam folder (choosing
Edit/Select All/Delete) I get the following error message:
"c:\windows\system32\avgxch32.dll could not be installed or loaded. This
problem may be resolved by using Detect and Repair on the Help menu. Out of
memory or system resources. Close some windows or programs and try again."
a. Even if no other programs are open, the problem still occurs.
b. Running Detect and Repair makes no difference.
c. Worst of all, I cannot close the error window. Wh...Generate current month
is what I was given to get referrals in a current month.
I'm setting up a general program so that it is easy to use
for my co-workers and supervisors.
Is there a way to insert something for "jul" that will
enter the current month on its own?
Though I would use:
> =SUMPRODUCT((TEXT(A6:...How to generate different series of document nos for different users..
We would like GP 8.0 to auto-generate different document numbers for each
User A will be assigned INV document numbers 1-100 and User B will assigned
INV document numbers 101-200 and so on.
Is that possible in GP 8.0? If so, how do I go about it? Any ideas?
Thanks very much in advance for you help.
It would have to be a customized solution. VBA or Dexterity are your best
bets, for now. With GP 9 you will be able to use Visual Studio 2005 to create
> We would like GP 8.0 to auto-generate different do...generate .NET code from visio 2003
How can i Generate .NET code from a UML made in visio 2003 ?
I did searh the net and found this link but it says 404 ?
the article title is
Generating .NET Code Using Visio Enterprise Architect's UML
So any one know how do that or any one have back up copy of this article
which version of v2003 are you using. The EA version which comes with vs.net
I believe has the process in the help facility. v2003 pro does not support
forward engineering of uml...
"Suhail Kaleem" <email@example.com>...How to view a complete schema when using schema includes/imports?
I've got a parent schema file that references complex element types
that are defined in several "child" schema files and I used the schema
imports statement to include them into the parent schema's default
namespace. I would like to generate a complete/single-file instance of
the schema to simplify things but I can't figure out how to do it.
Each schema seems to live in it's respective memory space inside the
SchemaIncludesCollection. Any idea how I could traverse all of the
"virtual" nodes in the parent schema to create a physical
representation of what t...EFT Generation Locking Up
We occasionally are having problems with our EFT File Generation locking up.
It basically generates part of the file and then dies. The problem is that
Great Plains thinks the file was successfully generated and won't allow us to
create it again. The batch does not show up in the File Generation List.
We have been testing on our development server with changing the ME234602
and ME234603 tables to try and allow us to rerun the EFT File Generation but
nothing seems to work. Does anyone know what table we need to modify to be
able to rerun an EFT File Generation?
I found a Knowl...schema-root public folder
I am looking at dismounting and at some time removing Public Folder stores
from my front end Exchange servers, as from what I've read public folder
stores should never have been created on my Front End server.
We don't have any user public folders on the front end servers, I'm not
entirely sure why public folders were ever created on them.
What I do have is 2 copies of schema-root one on each of 2 front end servers
(not replicas of each other) There are no replicas of this folder on any Back
There are however replicas of subfolders to schema-root such as
'M...How to set custom class name for MFC frame window?
When you create a frame window in MFC using following code:
BOOL CMainFrame::PreCreateWindow(CREATESTRUCT& cs)
if( !CMDIFrameWnd::PreCreateWindow(cs) )
// TODO: Modify the Window class or styles here by modifying
// the CREATESTRUCT cs
cs.lpszClass = AfxRegisterWndClass(0);
In Spy++, the default frame name is Afx:00400000:0. How can I set custom
name instead of the default name?
On Wed, 16 Nov 2005 14:49:47 -0800, "Michael"
>When you create a frame window in MFC usi...Extending XmlDocument and associated classes to provide character positions.
OK here's is what I wish to do. I have an XML file that I want to read
into an XmlDocument. I then want to be able to interrogate the
XmlNodes to find both their start AND end character positions within
the original file.
^ ^ ^ ^ ^ ^
0 6 12 19 26 33
tagA: start=0, end=33
tagB: start=6, end=26
sometext: start=12, end=19
I have seen the LineInfo example within the .net docs, see:
"Extending the DOM"
and ...How can I show some of the attributes of a UML Class Diagram?
I have a huge class with a lot of attributes and operations. I plan on using
multiple drawings to illustrate different parts of each class, but I do not
know how to show some, but not all, of the attributes ( and operations).
"noodle-head" <firstname.lastname@example.org> wrote in message
>I have a huge class with a lot of attributes and operations. I plan on
> multiple drawings to illustrate different parts of each class, but I do
> know how to show some, but not all, of the...xml within xml?
Hi all, I wish to embed an xml document within an element of another xml
document. If I enclose the child xml within a CDATA section will the DOM not
parse the child xml? What is the best way to do this? Additionally what
should the parent element be defined as in the xsd? I noticed xs:anytype
throws an error when validating the final xml doc.
> Hi all, I wish to embed an xml document within an element of another xml
> document. If I enclose the child xml within a CDATA section will the DOM not
> parse the child xml? What is the best way to do this? Additionally...Has ANYONE found a cure for the C++ Runtime Error?
It is very apparent that many of us our having this problem. Has anyone
found a solution?
maybe here http://home.arcor.de/andreas.roeder-privat/English%20Help.htm#55
Ich habe nichts gemacht, gestern gings noch
Join me in my Forum @
"Brian Harclerode" <BrianHarclerode@discussions.microsoft.com> schrieb im
> It is very apparent that many of us our having this problem. Has anyone
> found a solution?
...Do I have to extend the schema?
We have windows 2003 forest functional level and exchange 2003 servers.
I need to install exchange 2007 management tools. Do I have to extend the
schema in the current windows 2003 & exchange 2003 envir.?
On Wed, 23 Jun 2010 12:51:54 -0700, ed <email@example.com>
>We have windows 2003 forest functional level and exchange 2003 servers.
>I need to install exchange 2007 management tools. Do I have to extend the
>schema in the current windows 2003 & exchange 2003 envir.?