update queryI am trying to update a field but get an error message that some of the
records were not updated due to key violations. However, some records are
updated. The field that I want to update is a text field that is not the
primary key. Any ideas?
Is the field you are trying to update - a foreign key in a relationship
to another table?
Does the field you are trying to update have any validation rule?
Are you attempting to update only one field or several?
Have validation rules for any of the fields changed recently and you are
attempting to update records where the current value in a fiel...
Windows Updates of LateI am posting this thread because of the problems reported in this
Newsgroup about KB977165 and possibly others, released appx 2/10/2010.
Most reported by professionals about "clients" getting the BSoD.
Note the thread...
http://groups.google.com/group/microsoft.public.windowsxp.help_and_support/browse_thread/thread/cc25c907ca9538cc/6b76aef1e5eb087c?hl=en&lnk=gst&q=help+network#6b76aef1e5eb087c
....about NOT being able to "Disable Network Connection," which
occurred after the 2/10/2010 updates.
A quote from one post on KB977165:
"I had a problem ...
Updating RMS database with out crashing systemIs it possible to update records in the RMS database using SQL statements
that are coming from an external source (ie. other programs that are
connected via ODBC) with out crashing POS terminals? We want to add order
records and update fields for records in the customer table using custom
internal software.
RMS is based on MS SQL Server. SQL Server is quite capable of servicing
multiple applications. The only thing that's likely to crash RMS is a
lock on a row or table that RMS is trying to use. As long as your
application is well behaved, you should be fine.
DON'T ALTER a...
Software Changed symbol for stock and now can not fixWhen I turned on Microsoft Money this morning, discovered that the stock
symbol on one of my stocks had been changed and it is now reporting
completely wrong pricing, etc. How do I correct the stock symbol back to the
correct one for the stock? I hope I do not have to delete stock and start
from scratch reentering information for the last 4 years........
In microsoft.public.money, basor wrote:
>When I turned on Microsoft Money this morning, discovered that the stock
>symbol on one of my stocks had been changed and it is now reporting
>completely wrong pricing, etc. How do I...
This workbook contains one or more links that cannot be update #2Please be patient and understand my dilemma:
Master computer "A” uses windows XP and Office XP
Slave computer “B” uses windows 98 and Office 2000
"A” & “B”, are networked through a hub
In computer "A” share documents, we have several excel files including a
master for updates;
Computer “B” is use to work on “A” Hard drive for changing and saving data
everyday
When computer "A” opens any file, automatically updates links and saves
excel files without any problem
But if a file is open in Computer “B”, it prompts “This workbook contains
one or more links that cann...
Backing up Windows Update packages???Hi,
I have Windows xp sp3.
I want to backup the packages which windows update downloads to the
system so that I could be able to install them all in one go whenever
I have to re-install windows xp so that I could save precious time
re-downloading all the updates using Automatic windows update feature.
Regards,
Oc9ine.
oc9ine wrote:
> Hi,
>
> I have Windows xp sp3.
>
> I want to backup the packages which windows update downloads to the
> system so that I could be able to install them all in one go whenever
> I have to re-install windows xp so that I...
Automatic Online Updates, Investments, Money2005, SBI've just upgraded from Money 2003 to 2005 SB. Since then, my investments are
automatically updated everytime I bring up the portfolio page. I prefer to
update them at my request, rather than automatically. In my old version
there was a check box where I could choose not to update portfolio quotes
automatically. I can't find this feature in the new version.
Anyone know where it is?
Thanks,
Max McGovern
Max, it isn't there. You will get automatic uploads everytime you open
Money 2005. No big deal after you get used to it. Good luck. Steve
Thanks for the answer, Steve, b...
UpdateI wanted to share my findings with the group regarding the Time stamp issue,
as it seems to be a rather rare and ambiguous subject.
As it turns out, the time stamp is quite a useful feature and RMS fully
supports it. The main benefit is that it allows the store or a particular
department to remain open and make sales, while the physical inventory is
being taken.
Consider the following scenario:
At 8:00 am you run your new Physical Inventory Count sheet.
At 8:15 you scan item Z with a quantity of 8.
At 8:30 you sell 2 of item Z off the shelf.
At 9:00 you upload the counted items into a fi...
Updating fields for a subform automatically depending on the mainformI am using two tables, one is called tools and the other is called
changes. In the tools table i have the fields: serial (the s/n of a
tool), size (size of the tool), and status (whether it is IN stock or
OUT). In the changes table i have the fields: machine (a machines
number), new tool (serial of the tool that is goin to be used) and old
tool (the serial of the tool that is coming back). For the main form
i have the user select a machine, select a tool from a combo box, and
the old tool is listed automatically from the previous usage, this
form is bound to the "changes" table. ...
Money 2004 On-Line UpdateDownloads from my bank are always marked as Reconciled (R) eveb though I do
not have the option checked to do so.
Yes.
"bill l." <billl@discussions.microsoft.com> wrote in message
news:2CC99D9A-20B4-4C90-BB53-2BBF61D4BFAF@microsoft.com...
> Downloads from my bank are always marked as Reconciled (R) eveb though I
> do
> not have the option checked to do so.
Why? It should not, since the "Reconcile" box is not checked under Options.
"Dick Watson" wrote:
> Yes.
>
> "bill l." <billl@discussions.microsoft.com> wrote ...
Function updating all worksheets in workbookI have a function in VBA as detailed at the end of my text and it is updating
all worksheets in a workbook rather than just the active one. I have 12
worksheets all identical apart from Column 2 which holds consecutive date
data (hence one sheet per month). Cell A2 shows the current date on all
worksheets. My cell formula on each worksheet is =addtimeb(C3:CN3,"H") which
changes for each subsequent row for a number of rows ie
=addtimeb(D3:DN3,"H")
=addtimeb(E3:EN3,"H")
=addtimeb(F3:FN3,"H") etc etc each row is an employee record.
I am extr...
windows update errorsAlso having problems with windows updates. Have Xp Pro, SP3 and Windows 8.
Everytime (within the last week) I go to the start menu and got to windows
update it asks me to install the update software but then my system hangs and
I get an error saying explorer closed my webpage to protect my computer. Can
someone help me with this, or how it can be fixed.?
I also have this on the page "Windows Data Execution Prevention detected an
add-on trying to use system memory incorrectly. This can be caused by a
malfunction or a malicious add-on."
I have not added anything or done an...
Word 2007: automatic numbering has disappearedHI
I am working on a Word document created by someone else where the automatic
numbering, which was there originally when I first opened it several weeks
ago while I was using Word 2000, has now disappeared: I am now using Word
2007 if that makes any difference.
As the paragraph numbers are referred to throughout the document and linked
by field, when I am track changing the document, where the paragraph is
referred to in the document, for example " ... in paragraph 2.1 ...", this
now appears as "0" instead of "2.1", ie. " ... in paragraph ...
Service Pack updateVersion: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I am trying to install the microsoft service pack 1 and 2 for mac (I have the 2004 version) and each time the installer returns a message that it can't find the "correct version of office installed" and to check my system requirements. However, I am within all of the requirements.
Any suggestions?
PThrelfall
"threlfallgpa@officeformac.com" wrote:
> I am trying to install the microsoft service pack 1 and 2 for mac (I have the
> 2004 version) and each time the installer returns a message tha...
Web Site UpdateWeb site updated with:
- UTF8 conversion helpers and test program
- _T("") decorator macro
- Mix ANSI <--> Unicode in Visual C++ 6
http://www.geocities.com/giovanni.dicanio/vc/index.htm
G
--
Giovanni Dicanio
Microsoft Visual C++ MVP
Nice start.... Thanks for sharing your code.
Tom
"Giovanni Dicanio" <invalid@email.it> wrote in message
news:ODBM9OAwHHA.1524@TK2MSFTNGP06.phx.gbl...
> Web site updated with:
>
> - UTF8 conversion helpers and test program
> - _T("") decorator macro
> - Mix ANSI <--> Unicode in Visual C++ 6
...
In Outlook 2003 I can't get the 'run now' to work in 'rules&AlertsHello, I'm using the MS Office trial at present and have been trying to
set-up automatic replies. Despite following the assistant guide to the letter
on configuring this I am still unable to get the 'run now' button to action
my requests. All my other settings such as my pop.wanadoo server are in
order. Any clues would be wonderful!
What type of email account are you trying to run the rules on?
--�
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.
Afte...
Multiple outlook desktop client installation is required for shareHi all,
I have a shared workstation which 2 users use in shifts (day shift, night
shift). I want both of users to use MS CRM.
I have 2 seperate Outlook profies for them. Do I need to istall Outlook
desktop client 2 times(once for each user) OR just one installation of the
desktop client will be sufficient?
Please help.
Thanks in advance,
-Imran
Yes, you will need to install the Outlook client for each user. You will need
to log on separately as each user to install it, and they will need local
admin rights on the machine while you install it.
--
Matt Wittemann, CRM MVP
http://icu-msc...
Stuck at "Update in Progress" for the Past 2 DaysFor the past 2 days, I have not been able to do account updates. Everytime I
try to do online updaye, it says "you cannot perform this operation now.
Please complete current task and retry." When I go to Account List, two of
my Morgan Stanley brokerage accounts are listed as "update in progress." But
it has been like this for 2 days. It still won't let me do online update,
even if I uncheck the boxes for the Morgan Stanley accounts. I get the same
error above. It is as if the application is waiting for the Morgan Stanley
accounts to finish the update befor...
Required lifetime of gdi objects?When an object is selected into a CDC, are the values copied or does the DC
keep a pointer to the object? The point is, is it OK to select a local object
or does it need to be dynamically allocated? I can find several examples of
selecting fonts in the help, but none that shed light on this point.
Can you do this (where font selection is carried out in a separate function
from the TextOut calls):
//===============================================
CFont* pOldFont = NULL;
{
LOGFONT logFont;
CFont font;
logFont.lf... = ...;
if (font.CreateFontIndirect(&logFon...
Can't update free/busy for Exch 2003 clients.We have two administrative groups, and the servers in one
are in a separate domain and same with the other. The
users cannot update their free/busy the second
administrative group is all 2003 servers, the first is
all 2000, so the free/busy was created with 2000, and has
been reset based on the article to reset the GUID.
All offline folders and the free/busy is set to replicate
to all servers. Here is the error on the server:
Event Type: Error
Event Source: MSExchangeFBPublish
Event Category: General
Event ID: 8207
Date: 5/22/2004
Time: 6:20:01 PM
User: N/A
Computer: NVL-CS3N1
De...
Requerying AutomaticallyHello All
I have a query like this:
SELECT
utblPartListPriceQuery.ID,
utblPartListPriceQuery.Partnumber,
dbo_PART.ID, dbo_PART.DESCRIPTION,
dbo_PART.PRODUCT_CODE,
dbo_PART.COMMODITY_CODE,
dbo_PART.MFG_NAME,
dbo_PART.MFG_PART_ID,
dbo_PART.FABRICATED,
dbo_PART.PURCHASED,
dbo_PART.PRIMARY_WHS_ID,
dbo_PART.PRIMARY_LOC_ID,
dbo_PART.UNIT_PRICE,
dbo_PART.QTY_ON_HAND,
dbo_PART.QTY_ON_ORDER,
dbo_PART.QTY_IN_DEMAND,
dbo_PART.PREF_VENDOR_ID,
dbo_PART.BUYER_USER_ID,
dbo_PART.PLANNER_USER_ID,
IIf([UNIT_MATE...
determining how much of the components are requiredHello:
I have been told by several people that there is no report that can be
printed prior to the entry of Quick Manufacturing Orders that will tell users
(a) how much of the components are required for the quantity of the BOM being
built and (b) showing the manufacturing order that will be used to build the
BOM.
Has anyone ever found a way around this issue, even if a stored proc or SQL
view has to be built?
Thanks!
childofthe1980s
Well, as for (b), if you haven't created the QMO you can't show it. As for
(a) You are looking for a Gross Requirements Report. I am not awa...
Automatically copying fomulae when Inserting rowsI have a spreadsheet which has some complicated formulae in some cells, so I
want to lock and protect those cells to prevent other users from spoiling
them.
However, one of the things these users need to do is to insert rows to add
new data in the correct place. I would like the formulae from the
corresponding cells above the new row to be automatically copied. The only
way to get the formulae in that I know is to use the "fill handle" but you
cannot do that when the cell is locked.
Is there another way?
Hi Ian,
If you and your users are all using Excel 2002 or later, ...
FTP provider for windows 2008 ftp server to automatically delete file after it is downloaded by the clientHi All,
Development Environment:
Microsoft Visual Studio 2008, Version 9.0.30729.1
Microsoft .NET Framework Version 3.5 SP1
Windows Server 2008 server service pack1
IIS 7.0
FTP 7.5 service
Reference :
http://learn.iis.net/page.aspx/632/how-to-use-managed-code-c-to-create-an-ftp-provider-that-sends-an-email-when-files-are-uploaded/
Required: FTP provider for windows 2008 ftp server to automatically delete
file after it is downloaded by the client
Problem: I have followed each steps as mention in above link. I have
implemented following interface method.
...
DateDiff("yyyy",[Anniversary],Now()) returns rounded numberI am using DateDiff("yyyy",[Anniversary],Now()) in a query to return the
number of years between two dates. Since it is an Anniversary calculation,
the result needs to NOT round up. Currently, when the result is 11.73, it
rounds up to 12 when I really need it to stay at 11 until the anniversary
date is reached. Thanks in advance for any help.
First of all DateDiff returns integer values and never fractional values.
DateDiff returns the number of transitions that occur. So Dec 31 2008 to Jan 1
2009 will return 1 year even though only one day has elapsed.
The number...