update trigger question
If I have something like this in an update trigger:
if update(FirstName) or update(LastName)
update n set FullName = i.FirstName + ' ' + i.LastName from Names n
inner join inserted i on n.NameID = i.NameID
I only want FullName to update if either FirstName or LastName are updated.
Here's my question. A batch update updates 50 rows in the table. Of the 50,
only 20 have changes made to the FirstName or LastName columns. It's my
understanding that the "if update()" ONLY allows 20 rows that fit the if
update criteria to be updated in the...Computing formula for time
I have three columns: StartTime, EndTime, TimeTaken and
the format of all three is "time"
Now i want to compute the time taken using start time and
i.e timetaken = endtime - starttime
Can anybody tell how to add funtion for this in My sheet.
i.e on entering endtime and starttime i should get the
The following return the answer in time serial numbers representing
decimal parts of a day.
In all cases we can choose the time format to be displayed.
hh:mm:ss displays 09:15:00
h:...Updating Accounts #2
I just upgraded to Money Plus Deluxe (Have XP) When I go into Money it states
its "updating account" and my CPU usage is at 99% when I run Money. There are
NO accounts that are being automatically updated as I do them all manually.
The "updating accounts" icon stays up until I finally have to turn off
computer because I cannot work on any other part of money as it says it is
doing an online function.
It also goes online to seek its own updates. Do you have SSL2 enabled in
Internet Options? Do you have firewall software enabled beyond the XP
I am writing a multithreaded server application.
I have written a class to handle thread(CThread , say) activities like
creating, suspending, resuming threads etc. I have derived a class from
CThread (CMainThread, say) and a class (CClientThread, say) to handle
client connection which is also derived from CThread. In CMainThread
class i am creating a thread and waiting for incomming connections. As
soon as a connection came i am creating an object for CClientThread and
call the function to create a thread and so on.
1. Start the main listening thread.
2. wait for a con...Custom Button #2
I need help to creat custom Button for some of my item code/Item description
What sould I put on Comand ?
> I need help to creat custom Button for some of my item code/Item description
> What sould I put on Comand ?
Don't know if you found your answer but this is how you do it:
Leave ItemID as 0 and just put in the ItemLookupCode, if you want a Matrix
put in the MatrixLookupCode.
PerformAddItem 0, ITEMLOOKUPCODE, 1, 0, 0, 0, 0
...How do i access microsoft excel on windows xp? #2
I recently purchased a pc that came with windows xp home. I thought the
microsoft excel programme would come with it, but i can not find it anywhere.
Does this mean i have to purchase it seperately?
Yes; or as part of Microsoft Office.
> I recently purchased a pc that came with windows xp home. I thought the
> microsoft excel programme would come with it, but i can not find it anywhere.
> Does this mean i have to purchase it seperately?
...MS CRM Certification question
I have a question regarding the CRM certification? What, if any,
certifications are there available with MS CRM? Is there anything like CRM
Have I earned any certification if I passed the Applications Professional
Kuba Skalbania [MCAD]
...Dateserial same every time
I don't know what I am doing wrong but I am using DateSerial as a default in
a textbox and no matter what I keep getting 1/31/2010.
I have tried to put in anything just to get it to be something other than
1/31/2010...DateSerial(Year(Date()),Month(Date()),0) AND DateSerial(Year
(DateField), Month(DateField)+1,0) AND even tried to hard code DateSerial
(2005,12,12)...still got 1/31/2010!
What I doing something wrong? Thanks in advance...
Message posted via AccessMonster.com
I can understand why you...Excel File #2
unable to open xls file from shortcut or explorer
will only open from withing excel
I have changed the options / general / ignore other apps
still the same issue
thanks in advance
Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close Excel and
Windows Start Button|Run
Windows Start Button|Run
The /unregserver & /regserver stuff resets the windows registry to excel's
You tried the first, how about the second???
> unable to open xls fil...how to aviod outlook pst file created locally? #2
I am using postfix as MTA and storing pst file on server. But everytime
there is a network problem (ie. disconnect), outlook will create a new
local pst file(coz it can't find the network path to the pst file).
Because of that i had to manually go to reconfigure the default
delivery to the correct path (after network back on line).
I just want to know if there is a way to aviod outlook to not create a
pst file while user still able to open outlook? Or is there a way to
allow outlook automatically look for the pst on network (when LAN
connection resotre)? Its a pain to manually re-configur...Really simple questions re CSliderCtrl
Using SetSelection() I can get a CSliderCtrl to display a highlighted
selection ... but so what? What use is it other than to look pretty?
Which of the following is possible, and how do I do them?
(1) Prevent the user from moving the thumb outside the highlighted range.
(This seems to be what the documentation suggests that SetSelection does,
but in fact it doesn't, the thumb can be moved outside the selection.)
(2) Have the user change the selection. (The documentation seems to suggest
this is possible, but I can find no combination of keystrokes or mouse
actions that will do it.)
...Newbie, accnts. payable & accnts.receivable sample DB
I�m running access 2003, windows xp pro SP2
I've been commission in my work to do a small application to track and
report the accounts payable and accounts receivable movements, I'm not an
accounting savvy person :(, does anyone know of a link or sample access
database that can help me with the basic structure of the tables and
reports?, any help would be greatly appreciated.
...Count No. of times Dates are repeated
I have a database where in dates are repeated in column D and names in
I want a formula in a different worksheet of the same file wherein I get the
count of dates column along with the individual name.
The intention is to get number of days each individual is present. The same
dates could be repeated any number of times for the same individual.
Example for the month of Dec. 2005
Have you considered a Pivot Table?
Select your data
Click the [Layout] button
ROW...Email Setup Questions
Howdy and Happy New Year!
I just bought a new computer and I'm trying to set up Outlook.
Other than logging onto work email using the internet from a hotel o
at home, I've never used Outlook away from work.
I have several different email accounts: Hotmail, AOL, and work emai
(which uses Outlook).
Is it possible to utilize Outlook to retrieve my emails from th
separate accounts? Can I setup each of the folders for the differen
email accounts all on the left side?
After I set it up, how does Outlook know which account I'm using when
send email? Hotmail? Work?
I need h...Old emails sent out after reboot #2
I have a strange problem that I haven't been able to resolve yet. I recently
updated my Exchange 2003 SP2 server with the latest patches from MS. After a
reboot all the messages that had failed to deliver (timed out after 48 hours)
were retried and many of them were sent since the servers that were
unavailable were not working on the Internet.
This was pretty bad since some of these were from month's ago. Has anyone
ever experienced anything like this?
On Tue, 7 Nov 2006 07:43:01 -0800, Will73
>I have a str...Military Time in Excel
I would like to create a timetable in Excel with the format in the 24 hour
clock without the colon, which I believe is known as military time. I am
leaving the colon out for a number of reasons, aesthetic and to speed up
I wish to enter the time, for example, 8:30 am as 0800 and have Excel
interpret it as a time, as these will be graphed, so need to be interpreted
as time, and not plainly a number. At the moment Excel simply shows "800"
when I type 0800.
I have tried formatting all the cells as Custom "hhmm" instead of "hh:mm",
but when ...Rules don't work #2
I've read a few posts and haven't seen any useful advice. I've created the
When messages arrive, forward to firstname.lastname@example.org when from
The rule works fine, if I run it manually. It doesn't seem to work,
however, "when the message arrives." My other rules are working fine, but
some of the users in my office are having this problem occasionally. We are
all on XP, using Outlook 2003 or 2000. Can anyone shine some light?
This message will self destruct.
Hello all, this is my first time using Visio for drawing a floor plan and I
have a quick question.
Yesterday, (Using a tape measure) I mapped out the floor plan of an office
my company might be moving into. I wrote everything down in Inches.
Is there a way once I get a room shape kinda close to teh measurements, that
I can manually type in teh length for each wall?
if not in inches, at least in feet.
For example, I have one wall that is 154 inches ( 12.83 ft) Then the next
wall is 242 incehs( 20.1 ft) The opposite wall of the first measurement is
288 inches, third wall 100 inches, then 13...counting how many times a certain month appears
Fourth try's a charm....I'm getting errors trying to post my question. Here
1 workbook, 4 worksheets each named for a different office.
Column A for each sheet is the date in the following format 03-May-10.
I need to count how many times May appears in column A, range A3:A5000, from
the 'Montreal Office' worksheet. I thought I could use =countif but from
other posts, it seems maybe =sumproduct is the better option. I need your
help. My stats are due pretty soon.
Looking forward to your replies.
Yes, you want to use:
=SUMPRODUCT(--(MO...SFO synch questions
When SFO synchronizes with CRM server are all records
updated? or just the modified ones? and if i change some
fields in one record and another user changes other
fields in the same record, does it keep all the
information when both go online?
thanks in advance.
My understanding is as follows
When SFO syncronises with the CRM server it uses a method called 'playback'
to write changes only back to the CRM server. It syncronises at a field
level for only the modified records
The current issue with sync will only affect a record if the same field on
the same record is updated whil...Weighted Average #2
I am new to the weighing of numbers using excel. I really need help.
I am able to do this manually, but I it takes too long. Yes I still
use the calculator instead of excel. I am new at this.
Please help. I need to figure out the Quaterly total of the Average
Manualy, I divide the total of the month and divide it by quaterly
total then this number is the multiple by the months average second.
And I repeat for all months. I then add and this is where my 0:18 comes
Please help if this makes sense.
October 7,727 0:26
November 6,292 0:12
December 5,4...file will not save #2
I moved sheets from a number of different files to a new workbook and now the
file will not save.
Have you saved the new workbook first?
"ned kelly" <ned email@example.com> wrote in message
> I moved sheets from a number of different files to a new workbook and now
> file will not save.
...RMS 2.0 startup error
I get a small box opening up with the word "setwaitchar" in it and
"Incorrect function" as well. Eventually if I persist by clicking it a
million times SOM or POS opens.
Any clues this pain
...Time Sync help
Does anyone have an example or article handy of a way to sync
workstations time w/ a server?
Are you talking about a Server and WorkStation that you have created.
If so I have done the exact code in the past, however, not sure if I can
It all depends on how your server and work station communicate. This can be
further complicated if you have a server running along with several work
stations.. across time lines.
"Kelly Brimstone" <firstname.lastname@example.org> wrote in message
> Does anyone have an example or articl...