Drop down lists
Thanks for the info on the drop down lists - has worked perfectly
The other thing I want to do is assign a value to the items in the list
If the item selected is "Gold" then I need to assign a value (in a separate
of 100 - if the item is "British Pound" the value assigned need to be 625
I was going to use �f" statements for this but I have way too many items in
On another sheet, make a list with Gold, British Pound etc in column A,
and their respective values in column B.
Insert>...Year end payroll tax update
I see that Microsoft recommends updating to service pack 6
before installing the year end payroll tax update. We are
on SP5 and wonder how critical this latest service pack
really is. Does anyone know what will happen if we just
install the tax update, without installing SP6? Thanks!
I was in the same situation and decided to install
Service Pack 6 because we do 1099's from Payables and
there was a fix in SP6 for them. The install of Service
Pack 6 and the Year-End update went well and we haven't
had any problems since.
>I see that Micro...Query parent elements (newbe question)
I have a XML file where I want to query elements but id of the element is
buried deep inside child elements for example:
<PositionDescription>Some sample text here</PositionDescription>
...truncated return message http content from webservice #2
We have started experiencing a fatal problem from two of our servers in the
last week. Large return messages from a webservice are getting truncated in
the http message content. I have set up a trace extension to log the
post-serialization xml on the server, and it is complete (usually a little
under 200k). But the SoapScope http traffic sniffer running on the server
shows the same message going over the wire with a content-length header
showing the intended length of the full message but the actual content of the
http being truncated to 94283 bytes. This is always the size it truncates...Update
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
As you may know, newsgroups have existed for many years now; however, the
traffic in the Microsoft newsgroups has been steadily decreasing for the
past several years while customers and participants are increasingly finding
solutions in the forums on Microsoft properties and third party sites. This
move will unify the customer experience, centralize content, make it easier
for active contributors to retain their influence, miti...XsltContext is needed for this query because of an unknown function
This is a multi-part message in MIME format.
The Following is an Error I am getting using VS.NET 2003. When I bind =
the XML and XSLT Document together in Internet Explorer it works fine. =
However when I attempt to Load the File with the XSLTTransform.Load it =
raises this error. I have attempted to use a DNS Resolver hoping that I =
could get it to request a URI or URN that i could return a Custom XSLT =
Context to (or something - grasping at str...Control if a form updates table
I would like to know how best to accomplish this data entry form requirement.
I have a form with a number of fields which is linked to a table. When the
operator opens the form i would like all the fields to be blank and the user
can tab through the fields as necessary. I have two command buttons. One
allows to exit the form (all set with that one) with no saving of the form
data, while the second button opens a message box which asks the operator if
they wish to submit the information on the form (within the fields) Y/N and
the message box has all the data from the fields li...Using an update query to update amount in stock automatically
I have created a database to keep a track of orders.
In the stock table I have a field called amount in stock.
In order table I have a field called order quantity.
I have created an update query to update amount in stock to [amount in
I wish to create a macro to run the update query on my order form once the
sale is confirmed.
My problem is that I want to just update the single record on the order
form, and not all items of stock from all existing orders.
I know I can add a parameter criteria to my update query (i.e. enter order
number) so that only stock relating ...Updating a CStatic text
I found posts similiar to this question but not the answer. I have a
CStatic with say 3 lines of text
bla bla bla bla bla bla
bla bla bla bla bla bla
bla bla bla bla bla bla
The when something happens this is replaced by a single line:
The problem is that when I call SetDlgitemText it displays the new text
ontop of the old one for a short while. I guess it is until the
OnEraseBkgnd is called. What is the correct way to solve this so that
the new message is displayed alone directly and not ontop of the old
Seemed to solved thi...After update Not update Text Field
I have created a subform based on a table. Within that table there is a
product name field which retrives a list of product names and prices from the
Products table. I to use the subform to enter product and then get it to
automatically update the price field.
I have read many entries about using after update to do this, but I just can
not get it to work. I select the product in the drop down and nothing
happens. I am pulling my hair out. The code I used was
Me.Product_Price = Me.Product_Name.Column(2)
Can any one help me
>I have created a subform based on a t...How to disable the pop up for enable auto update?
I have imported an external link in to excel, and set it auto update when it
opens, but whenever I open this file, it pops up a window to confirm whether
you like to enable auto update or not.
Does anyone have any suggestions on how to disable the pop up window for
enable auto updating links?
Thanks in advance for any suggestions
on the menu bar>edit>links>startup prompt
pick you choise.
> I have imported an external link in to excel, and set it auto update when it
> opens, but whenever I open this file, it ...2007 Deluxe update...CRASH
Money Deluxe 2007 just told me it needed to update. I allowed this
thing to happen (silly me), and now when I try to start it, I get an
error message that tells me it cannot find checksum.exe, and that I
must reinstall from the original disks.
Silly me also purchased it as a download, and didn't pay an extra 6
bucks to get multiple downloads, or an extra $10 bucks to get a CD
(cheap silly me).
Am I screwed?
Thanks in advance...
In microsoft.public.money, villagedweller wrote:
>Money Deluxe 2007 just told me it needed to update. I allowed this
>thing to happen (silly me), and n...The on the server published free/booked-information could not be updated. The task could not be executed OL 2000
outlook 2000 (german) running with windows xp (german) gives the following
error message window when quitting after adding a date in my personal folder
calender from a other user:
"The on the server published free/booked-information could not be updated.
The task could not be executed"
Please help me fix this message. Thank you.
Well, the short version is that for whatever reason, your outlook can't
connect to your free/busy server to update the information. What causes the
error depends on your network configuration.
Diane Poremsky ...Routing List for Email Message
Am I missing something? There used to be a routing "slip" you could attach
to an email message so that it would proceed through various people in a list
rather than sending it to all of them at once. Where is that in Outlook
> Am I missing something? There used to be a routing "slip" you could
> to an email message so that it would proceed through various people in
> a list
> rather than sending it to all of them at once. Where is that in
I don't recall that feature...Recall messages:when do you get a confirmation ?
Exch2003 Sp1, Outlook 2002.
CIO sends a message to UserA (all inside my organization). A couple of hours
later CIO recalls message.
I checked on UserA inbox and I don't see any messages from CIO there.
Nothing on Deleted Items either.
CIO hasn't got any confirmation of successful message recall. How long it
takes to get a confirmation whether recall was successful or not ?
Is the recall function more reliable on Exch2003Sp1 ?
I remembered this never worked right for me on Exch2000.
Recall is a client-side function (Outlook) and it's not very reliable no.
...Formula update automatically
Please look into the formula & suggest.
The excel sheet is fille-in as below:
Column A B C D
Row 1 2 6 5
Row 2 20 30 90 D2=A$1*A2+B$1*B2+C$1*C2
Row 3 2 4 8 D3=A$1*A3+B$1*B3+C$1*C3
& so on for further rows.
What I need is, if a column is added between, say, B & C, then th
formula in D column should update for the added column & similarly fo
Is there a way?
I would prefer excel formula solution. If code is the only solution
please write the complete code. The undo button should not beco...How to force rebuild and update data from msproject to project server database
(I use MS Project Pro 2003 connect to Project Server)
I have a ms project file (ABC.Published), in this file I have 800 task. In
the project server database, table MSP_TASKS, this project has 800 rows, but
there are 600 rows in the MSP_VIEW_PROJ_TASKS_STD. I forced rebuild data
with this help:
but data in MSP_VIEW_PROJ_TASKS_STD remain 600 rows.
Is there another way to force rebuild MS Project Server Database? I need to
see the log for project server error, where can I see?
...Unable to bring back all results from table with query
For a uni assignment we have a designated query that we have to create.
But when I run the query, I get one result returned to me. I should have two
returned to me, as I have two records in the Problem table.
The SQL is:- SELECT Problem.[Problem Number], User.[User ID], User.[User
Name], User.[Job Title], User.Email, User.[Telephone No], Asset.[Asset Code
No], Problem.[Problem Description], Problem.[Current Activity Log],
FROM [User] INNER JOIN ((Asset INNER JOIN Problem ON Asset.[Asset Code No] =
Problem.[Asset Code No]) INNER JOIN [Contact Log]...Money 2005
I just installed MS Money 2005 and am using a regional bank named Central
Carolina Bank (CCB Online). The bank is in the list when creating a new
account and it's a simple checking account. I've configured Money for online
updates, providing my user id/password, etc. (I'm also using MSN Billpay)
The automatic updates "seem" to work in that the bank balance is updated and
the status shows that the call was successful. However, I don't see the
transations in Money's account register. If I manually connect to the bank
via a browser and download an OFX file, th...query a table and subform
I have 3 tables
1. Printer table: printerID, ModelID, SerialNum, MACAdd
2. Toner table: TonerID, ModelID, PartName
3. Invoice table: InvoiceID, Date, Qty, PrinterID, TonerID
How can I pull up toners based on the printerID in Invoice table? I set the
TonerID as a combo box, Could anyone help me with the query that i need. The
inovoice table actual is a subform under printer in the Form. so when I
choose the printer from the main form the subform printerID changes
accordingly, I just don't know how to generate a list of toner for user to
choose based on the printer or m...Outlook 2007 Message Flags Keep Appearing
This is a multi-part message in MIME format.
I'm finding that I constantly have email messages showing up that are
flagged but I have never set the flag for the message. Does anyone know
what would be setting the flags and how I can stop them from being set?
<html xmlns:v=3D"urn:schemas-microsoft-com:vml&q...Update formulae
Financial planning spreadsheet containing many long interdependent formula
needs to be updated from 04 to 05. Is there some quick way of editing this
The answer is "Probably yes", but will you please provide an example of
a formula? If it was a simple search and replace you probably would
have done it already. Is it a matter of changing a cell reference from
'SheetName'!A1 to 'SheetName'!B1, where A1 is a 2004 total and B1 is a
...View the source of a message (Outlook 2000)
Hi to all!
Since some months I search for a possibility to view the entire source of a
message in Outlook 2000 SP-3 (background: by some means or other there is
sometimes a message slipping through my filters - and then I DO NOT want to
see it in Outlook's state-of-the-art multimedia viewer).
In case you have questions:
Yes, I know that I can view the header of the message by right-clicking on
it in the overview and selecting "Options".
Yes, I know that I can view the source of just the body by right-clicking on
it in the message view and selecting "View source".
B...updating with now()
Using 2003. I have a work sheet, at the bottom I have "Updated" and in the
next cell I simply put in =Now(). This brings up the date and time each time
I open. Now what I want to do is see when I last opened and updated. How
can I do this
Le t's say you want cell B9 in Sheet1 to contain the date the last time the
workbook was saved. Put the following event macro in the workbook code area:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("B9").Value = Date
Because it is workbook ...KB972270 update won't install on XP SP3
Security Update for Windows XP (KB972270) will not install manually or
automaticly via windows update. I get the response "Some updates could not
Other updates installed OK. This seems to be the only one not working.
When I manually installed I attempted to use the following approach:
WindowsXP-KB972270-x86-ENU.exe /log:c:. /verbose
It fails with two Setup error messages in a graphical text box:
the system cannot find the file specified"
installation did not complete"