Help understanding DateAdd...
Thanks to all of you I was able to add the below expression to my query to
give me the date of the Friday of the week represented by the value in my
However, I would like to understand what's happening as opposed to just
pasting someone elses work.
The value of [Date] = 6/26/2007 as Tuesday
Result of Week Ending = 6/29/2007 a Friday
Week Ending: DateAdd("w",6-Weekday([Date]),[Date])
I'm having a hard time understanding the concept of "w" = weekday and the
I've been staring at this for so long, I may be ram...need easy to understand instructions
I have 2002 office xp installed and would to configure my windows live
account to OUTLOOK and/or OUTLOOK EXPRESS. Also whe I go to WORD, there's no
"SEND TO" button for mr to click on...Thanks to anyone who can help....
Is your Outlook configured with all the info that was supplied by your ISP
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"screwed up" <email@example.com> wrote in message
>I ha...How do I understand MashalAs
How should I understand this with MarshalAs in this example ?
static extern void
Is it correct to understand it in this way. When the managed code is excuted
we have type MySystemTime
but when the unmanaged type is called the type is changed to be LPStruct.
Tony Johansson wrote:
> How should I understand this with MarshalAs in this example ?
> static extern void
> GetSystemTime([MarshalAs(UnmanagedType.LPStruct)]MySystemTime st);
> Is it correct to unders...hashCode understanding
Assume I have 2 instances of a class called Test see below which will work
as key in a hashtable. The Name property of instance1 is set to 'Paul', and
the Name property of instance2 is set to 'Piet'. Both instances will
generate different hashcode, and they're also different according to the
Equals method.So far so good. When looking up Piet I will get the value
object whatever it can be.
Now, suppose that I change the Name of instance2 to 'Paul', then, according
to my Equals method, both instances should be equal, and according to the
hashcode...Help me understand mysterious Temp files.
Three of these appear every time I log on to Windows, in this folder:
C:\Documents and Settings\Owner\Local Settings\Temp. I can always delete all
but the three most recent. I see repeated references to Adobe Photoshop,
which is not now nor has it ever been installed on my computer--though I do
use the Adobe PDF Reader.
I've heard lately of a strange new kind of "cookie," but can't remember what
it's called. Could that be what these are? I'd like to know why they appear
all the time, and have for several years. They don't do any apparent harm,
but d...simple question: to update the record in a table that is not the current datasource...
I suspect, I'm in the right church, but the wrong pew...
I want to update a table, which is not the record source for the current
form, when the value of a combobox [cboPresetOption] on the current form is
the table [tbeFixtureSchedulePrintOptions] which contains the fields to be
updated has only (1) record
I've got the code below written, but the record is not updatin; and I
suspect I have a simple error, but am blind to it at this particular
thanks in advance,
Private Sub cboPresetOption_Cha...Understanding IPSec FrontEnd BackEnd with e2k3 or e2k
Who can help??
What is the problem when I try to connect e2k FE and BE with IPSec.
Is IPSec not transparent for Application Layer ???
What was changed in e2k3
...Problem while mailmerging with an Excel datasource
This is a multi-part message in MIME format.
is there a known issue when trying to mailmerge in WORD with an Excel =
datasource when the merged EXCEL columns contain formulas.
Everything works fine, except that WORD doesn't respect the format =
settings defined in Excel.
For example, a value (63,24) in a column defined in EXCEL as NUMBER - =
decimal places 2 shows up in the mailmerged WORD document as =
We wor...I need help understanding OutLook Express
I have been helping my family and a few friends with Outlook Express and
so far I have been lucky.
Question is usually "Where the heck is the (inbox, address book, stuff
that I should be backing up, a Backup selection on the product toolbar)".
I have been in the computer game for a lot of years, successfully
transitioning from mainframes to minis to PC's - networked PC's, and I
know the need to backup data. I am sure Microsoft would agree - but why
do they make it so difficult find where the stuff to be backed up is
located - or am I missing something obvious.
Used ...Trying to understand Preferred Names
I have a gazillion of transactions in the format of the following:
HEB #428 10/17 #000784200 PU
HEB #428 10/13 #000150600 PU
HEB #428 10/08 #000723400 PU
How do I make this read just HEB. I guess I'm not sure what I'm
looking at when it shows me the Payee Name Variation and Payee,
because every variation appears to be a payee.
Do have have to rename every transaction every time I update my
In microsoft.public.money, Mark Johnson wrote:
>I have a gazillion of transactions in the format of the following:
>HEB #428 10/17 #000784200 PU
>HEB #428 10/13 #0001506...I don't understand the OnPaint method
I have some problems to fully understand the OnPaint that I override in my
I do understand when I have an event handler for the Paint event.
I mean when I override the OnPaint method this OnPaint is not an event
handler I just override an existing method that exist in a more general
class higher up and say now we use my implementation of OnPaint so windows
will call my OnPaint instead of the other method OnPaint.
I know that my OnPaint work as following when I have a windows with graphics
on and hide it by using for example the notepad and then move the note...Help me to understand formulae
Searching for the solver examples on the net I came across the example where
I find a formulae that I don’t understand and I just wonder if any one could
explain in very simple words the formulae is
=B14*MAX (B10, 0) ^$H$4
where b14 =Unit Profit
b10 =Units Produced
$H$4= Diminishing Profit Factor (0.9)
I can see that when I remove the Diminishing Profit Factor the result is
much higher but I don’t understand why it has been included on the first place
Thanks in advance
It is just a way to model reduced profit. For example, if H4 were set to .5
and B10 was 16, the...Understanding PO and Taxes
It's been requested that we start entering taxes for every item on POs at the
PO Entry level. We want it to report taxes on every item whether we are
invoiced for them or not. I have three questions:
1. If we have setup for advanced tax - do we need to go into each item and
change the item to taxable in order for it to print on the PO. The PO is
showing the tax but when we print it, it is showing 0 percentage and the
subtotal without the tax.
2. When I go into the Receivings screen and receive the item, the tax field
is dimmed out. Why?
3. Can the tax amount be distributed ...Understanding Mapi transport
I have to block some users to send external email; i have created a group
(i.e. "smtp senders") enabled to send external email, adding it on smtp
virtual server and allow to submit and relay.
From Outlook Express client to relay is impossible (for users not included
in "smtp senders"), the problem is that the outlook (mapi) users continue to
relay external mail, why?!
How is possible to block external MAPI relay !?
i guess the best way is to block at SMTP connector which relays your
mails outside of your organisation. well r u using Exchange 2000 or
2003?? for 2000 there...Pivot Table
I have an excel pivot table using a query from an access database as the
source. Worked great, including refreshing the data. Now I have a
problem because I had to change the structure of the underlying
database and didn't fix some of the querys yet. When I try to hange the
query I'm getting the error message: "This query can not be edite". On
OK I get the next message: "Too few parameters. Expected 1." I'm sure
that's because of my changes in the database structure. But my problem
is, that I don't know which query I used for the data. Is there anyway
t...Understanding the utilization of XML
Can some one provide me with a summary and a URL which will do the trick
I.e. EXACTLY what is the utilization of XML and HOW does it help as
compared to how (whatever it does) it was done before XML was here.
XML is an open W3C standard than can be used to capture and contain data.
The problem XML was designed to solve is that of data sharing. It seems
that each one of the countless information systems in use today has a
different mechanism for storing and transmitting data. Because all the
mechanisms are different, a "customer record" (for example) from one s...Having difficulty understanding SMALL function in formula
I have the following in a spreadsheet:
A B C D E F G H
row 1 1.1 1 76 71 #N/A 71 5
row 2 1.2 1 124 117 #N/A 117 7
row 3 1.3 1 156 159 159 159 3
row 4 2.1 2 12 5 #N/A 5 7
row 5 2.2 2 54 59 59 59 5
row 6 3.1 3 41 45 45 45 4
row 7 3.2 3 252 310 310 310 5
row 8 3.3 3 305 438 310 310 5
row 9 3.4 3 422 438 438 3
row 10 3.5 3 441 #N/A 438 3
row 11 4.1 4 33 35 35 35 2
row 12 4.2 4 107 111 111 111 4
row 13 4.3 4 180 175 #N/A 175 5
row 14 5.1 5 227 230 230 230 3
My array formula in column H is as follows:
IG5ld3M6ZXNTVkxsS2ZGSEEuMjQyNEBUSzJNU0ZUTkdQMDkucG...understanding "TRANSFERS" in the monthly Income Statment
I need help in understanding the TRANSFERS in the
Monthly income and Spending STATMENTS....
Why are they a neg?
My basic understanding is that
INCOME - EXPESNE = 0
That is what the report is trying to show...like a mini PL for yourself
I am assuming ....
However... if in the above example I have 400 in transfers...
what would my INCOME - EXPENSE = ?
Thank you ... maybe I am dense...
In microsoft.public.money, T Grier wrote:
>I need help in understanding the TRANSFERS in the
>Monthly income and Spending STATMENTS....
>Why are they ...Can't understand the error message
When I open this form I get a "Data type mismatch in creteria expression" and
when I click on the button on the form I get "The expression you enetered
refers to an object that is closed or doesn't exist" error in the code. When
I click on Debug, it takes me to this line of code:
Me.OutofScope_Table_subform.Form.RecordSource = "SELECT * fROM [OutofScope
Table] WHERE [Project Number] ='" & _
Me.cmbProjectNumber & "'" & " AND [Task Number] ='" &
Me.cmbTaskNumber & "'" & "...Attachements
We have Exchange 2003 latest SP.
We receive many attachments that get as large as 50MB. Sometimes an email
with this attachment is sent to 3 people and then those 3 people forward
it to 5 other people in the company, and then all of them may save it to
various locations for their use. When they save it to their network
drives we obviously have a lot of storage starting to be used up with
1) One of my questions is how does Exchange deal with attachments and if
multiple people receive the same file?
2) Is there just one copy that Exchange references or are there x co...Having problems understanding sub-form selections and uses of comb
Hi all, I guess i'm having fundelmental problems getting my sub-forms and
combo boxs to work for what i'm trying to attempt.
I've posted my first problem with use of 'drop down combo box" and getting
it to show me the text in the destination field already. I've made progress
Now i can't get a grip on the use of sub-forms and combo boxes for my next
So i don't burden you to much can anyone recommend any useful visual demos
or examples for these. The online help is of no use to me for my needs, and
i can't...power options properties help me understand
I have recently re done my laptop, running windows xp, sp3, I am unsure what
to set in the power options properties. My laptop is always plugged into
power sourse, so I do not keep battery in all the time. I was told to , by
dell, to shut down over night when not using it. Ok, but in the daytime if I
am away where do I leave it in- do I log off, go to standby or hibernate?I
do not see a sleep button on my keyboard- very confusing- at the moment this
is what I have done-turn off moniter-never-plugged in-turn off hard
disks-never- system standby-never- system hibernates-never-unde...datasources
I was wondering if it is possible to join 2 different datasources in
No. You have to do this somewhere else.
If you are doing master-detail then use subreports to do this.
MVP SQL Server Reporting Services
"Ben Watts" <firstname.lastname@example.org> wrote in message
> I was wondering if it is possible to join 2 different datasources in
> Reporting Services.
...understanding of a formula
Placing a + infront of a sum means what?- eg:=+SUM(C6+C8+C10)
It usually means that the author of the formula started with Lotus 123.
In lotus, you could start a formula with +
Excel starts with an equal sign:
But some people have muscle memory and can't stop typing that + even though they
don't need it.
> Placing a + infront of a sum means what?- eg:=+SUM(C6+C8+C10)
"sabi" <email@example.com> wrote:
> Placing a + infront of a sum means what?
Nothing special. It is a...