Form design to add data to 3 tables in "Order Entry" style db
Sorry if this is a duplicate. I thought I posted it yesterday but couldn't
find it today...
I need help figuring out the best way to design a form for data entry in the
"Order Entry" style, adding data to three related tables. For clarity I have
eliminated several fields. Here are the three tables, plus the fourth that is
a reference table:
tblCustomers: CustID (pk), CustName
tblOrders: OrderID (pk), OrderDate, CustID (fk)
tblOrderProd: OrderProdID (pk), OrderID (fk), ProdID (fk)
tblProducts: ProdID (pk), ProdName
Each Customer is associated with one or mo...Add the contents of two sheets together
I am looking for a way to add the content of two sheets or even 1 shee
together. I have a large list of part numbers with quantities. Som
of the part numbers are repeated. I would like to add the duplicat
part number quantities together and have just 1 line with the par
number and the total quantity.
Does anyone have any insight?
Message posted from http://www.ExcelForum.com
Sounds like a job for a pivot table. See here for an intro:
"mwiggins367 >" <<email@example.com> wrote...Why can't I use an event sink to add a header entry
The msdn site says the property is read only. Anyone know of a way to do
...Add-in or Reference
I've created a customized LinkedTableManager which allows me to perform most
of the LTM functions, within my environment, while using DSN-less
I've developed this to be an add-in (or at least I thought I had), but I'm
having difficulty with the USysRegInfo table and getting it to actually
register as an add-in. I currently have added the mda file as a reference
my main application, and that seems to be working fine.
What are the pros and cons of these two methods?
email address is invalid
Please reply to newsgroup only.
...Newbie Xpath Question #2
Hi everyone, i have a quesiton regarding XML/Xpath
i have a XML document that has let say the following structure
I want to know, what would be the most "by the ...Inserted Pictures keep disappearing replaced w/ white box with a r
I have never had this problem in power point before. I opened an old
presentation to update it (Professional Edition 2003). Photos I had inserted
were gone and replaced with white squares with red Xs. I tried to replace
the photos and saved it. When I went to reopen today, the photos are gone
again. HELP! Also, when I open the folder and point to the file I want to
open, the small "Details" icon still shows my photos as being there, but
they're not there; when I try to print, it's the white square with the red x.
Thanks for any support anyone can give me!
This is my situation - the data that I am attempting to chart is a
combination of numbers and y/n which are answers to questions about usage:
Task To Be Done (Y/N): Y
Task Should Be Done(Y/N): Y
Quantity Done (#): 12
Quantity Not Done (#): 4
There are 13 locations
Each location has 2 resources
Ultimately, I am trying to show value added using current resources.
However, I am stuck. Can anyone help?
You have left out more than you've supplied. How are you defining,
measuring, and calculating "value"? What parameters do you want ...After Add Record, Put Cursor in specific Text Box
Hi, I had the wizard set up a button to add record (it puts in the code
below in the On Click property of the button). I'd then like to have the
focus go to text box [ProjectType]. I don't know how to do that. TIA :)
Private Sub cmdAddRecord_Click()
On Error GoTo Err_cmdAddRecord_Click
DoCmd.GoToRecord , , acNewRec
Private Sub cmdAddRecord_Click()
On Error GoTo Err_cmdAddRecord_Click
If Me.Dirty Then Me.Dirty = False
If ...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" <firstname.lastname@example.org> 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 = ...add-ins without install disc
My students need to install and use some of the standard Excel add-ins,
but some cannot find the required install disc. Is there a way to do
this without the install disc?
The experience of my students has been limited to Solver and Analysis
ToolPak, and , as I recall, you definitely need the Office/Excel
installation CD. However, as I recall, you can use any Office/Excel CD, as
long as it's for the identical version of Office/Excel that is currently
installed on the hard drive.
"carbon_noodle" <QuantumKinetics@gmail.com&...Pressing Tab to add a new record at the end of one record in a for
Back in Access 97 and 2003, I noticed that when you reach the end of a record
in a form and press tab, it used to take you to a new record. But, in Access
2007, it's not doing that. Please let me know what I need to check for to
enable this function.
There's a form property (Cycle) that affects how a <Tab> affects the screen.
You can set it to (re-)cycle back through the fields of the record you're
on, or move to the next record.
Microsoft Office/Access MVP
"briangw" <email@example.com> wrote in message
news:329198...how do I add information from many worksheets to one main workshee
Without knowing how your data structure is setup, it's fairly difficult to
know what you are dealing with and provide you with a specific answer. But
you can use formulas to bring in data from other sheets ...
Zack Barresse, aka firefytr
"sillygurl" <firstname.lastname@example.org> wrote in message
In whatever cell in the main sheet you want to start listing the dat
type =, then go to the first cell in the work...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 <email@example.com> wrote:
>I can not locate XML on my Data menu for Excel. I checked to see if it wa...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...Search and replace problem
I have an Excel worksheets where in several cell's a symbol was added to
mark the cell's "to review".
The symbol used was "(*)".
I have tried now to delete all the entries with a "search and replace", but
Excel interpretes the asterisk as a DOS-symbol and deletes everythng between
Is there a way to avoid that or to let Excel know that I only want to delete
the specific characters.
It's because it is a wildcard, you can replace it by preceding it with a
tilde ~ which tell Excel to find an asterisk
in find what p...WPF xml
I'm using WPF with net 3.5 to load the ItemsSource of a combo box from an
The xml is setup like this:
... other profile nodes
In the Windows.Resources node of the xaml I have:
<XmlDataProvider x:Key="xmldata" Source="c:/temp/xmlData.xml"
and in the combobox I have:
<ComboBox Margin="5" Name="cbProfiles" Width="240" IsE...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...Word document creation in XML
I'm pretty new to .Net, not to mention XML, so I truly appreciate any advice!
I have user data that I want to selectively insert into a MS Word document
in XML. Given the various content, I want to create a new instance of an XML
document and write the data to the XML doc using the Word ML schema. The key
item is that I want to be able to add content line-by-line or
section-by-section, to the word document using the XML schema. The reason
behind this is that the content will change dramatically.
The question comes down to this -- are there already-defined components that...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...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...How do I add Yahoo email to Outlook
I have the free version of the Yahoo email account. How do I put it in
Outlook like my hotmail account.
Work is victory. - Ralph Waldo Emerson
You have to subscribe to Yahoo! Plus mail servce. Then it will give you a
POP3 access, which you can add to your outlook.
"Jeff Mu�iz" <firstname.lastname@example.org> wrote in message
>I have the free version of the Yahoo email account. How do I put it in
>Outlook like my hotmail account.
> Jeff Mu�iz
> Work is victory. - Ralph Waldo Emers...character attributes lost (eg font, italics, bold) when cutting/pasting from excel to quark
I can cut/paste from excel to quark, but I lose the character attributes
(eg font, italics/bold) in the cut/paste, though the text is pasted. I'm
new to this so I don't know whether this is a quark limitation, or
limitation of windows cut amd paste, or my inexperience.
thanks in advance.
What is a QUARK???
Isn't that a star that exploded in space 1 billion years
>I can cut/paste from excel to quark, but I lose the
>(eg font, italics/bold) in the cut/paste, though the text
is pasted. ...Security, automation events and add-ons
Visio 2003/XP Pro SP2
I'm using the automation in the timeline so I can slide the milestones
back and forth and the dates change automatically.
But, I have this problem on two computers where if I lower my security
to high and disable 'enable automation events' in options > security,
when I start Visio, it tries to run/install all the add-ins I have,
which is about 30 (and I don't know where they all came from; only a
few) - everytime I start Visio. This is no good.
If I increase the security to high, then the automation doesn't work.
Does anyone know how I can...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...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();