Can I use a Report expression for queries?
Is it possible to use the following expression that is used in reports on
Or some expression to get the result.
No. In your query, you can refer to text boxes on a form, but not on a
That's because of the way reports are formatted (sequentially.) Forms have a
current record, which identifies which value you want. Reports don't.
In the context of a query, there are other ways to get totals, such as
or a subquery:
Allen Browne ...Viewing IMAP messages #2
I connect to a Linux IMAP server remotely for my emails. When I click on an
email in Outlook P once the headers have been updated the system seems to
download the email and the attachement. All I want to do is read the message
before I download the attachment - Is this possible?
Its a bit of a problem if an email has a 3mb attachement and all I want to
do is read the mail content before deciding to download the attachment -
especially a pain if I am CC into some mail.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
I am trying to use Sumproduct with dates that come off an SQL databas
and are in the format of 02/12/2003 15:30.
This is forcing me to use the following formula
where $G3 is 02/12/2003 00:01 and $G2 is 02/12/2003 23:59
Is there any way I can just look at the date only rather than the time
as well, so that anyone can enter a date from, and a date to
~~ Message posted from http://www.ExcelTip.com
~~View and p...pasting into merged cells #2
Every time I try to copy and paste data into a merged cell I get error
messages about the cells not being the same size. Even if I try to just
paste values only. Is there any workaround or fix for this???
Try pasting into the formula bar. It's a pain, but it
>Every time I try to copy and paste data into a merged
cell I get error
>messages about the cells not being the same size. Even
if I try to just
>paste values only. Is there any workaround or fix for
See my res...Work out overtime hours for individuals #2
I have a question which i am hoping someone will eb able to help me
with, i have a spreadsheet which contains infromation for part time
hours worked during the course of a month for individuals (e.g. below)
Name Start End Hours
Persona 1:30 2:30 1
Persona 3:30 4:30 1
Persona 9:30 11:30
person d etc etc
What i need is a formula that will allo wme to add an extra column
which gives me the total hours person a worked, person be worked and so
on. The original data contains multiple lines (i.e persona could have
10 lines, personb15 lines etc etc), and...Dynamic List Box using VBA
I wasn't really sure how to phrase this one -- this isn't your Typical
I have a SELECT statement which queries SQL Server 2005 and displays the
data in Excel.
Let's say that a database lists products that have been delivered to 4
different cities, on 3 seperate days -- without knowing (in advance) the
delivery dates, how could I create an input/drop-down field to allow the
user to specify a particular date? I envision something like this:
VBA code produces a list box of delivery dates based on a particular product
and city. The user selects a delivery date ...Using ExecuteQuery to get Listing of Cases
I'm attempting to programatically extract a listing of Cases (similar
to the Cases listing in the Case Manager of the CRM app) using the
I can successfully extract Account and Contract info using
ExecuteQuery, but I've been unsuccessful in locating a sample of a
"QueryXML" string for listing Cases.
This is my latest attempt, but I'm not even sure if "Incident" is the
correct Entity for what I'm attempting.
<order a...Synchronize data across 2 sheets
Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a
sheet called Previous around 5000 rows records.
Both have 31 columns and identical column headers
On the 2010 sheet there are records that have changed, how do I get the
changed records details onto and overwite the same record on the Previous
Not sure if it would help but each record has a unique reference number.
How do i do this ?
Hope this makes sense
thanks for any help offered
If you know which colums are to be changed I would use vlookup function.
Vlookup(lookup valu...MS Office VBA Automation Specialist #2
is there such a certificate? MS Office VBA Automation Specialist, I tried
googling it on microsoft website and couldn't find any info. I just passed
the excel 2k expert exam and I want to take the excel instructor exam, I
haven't however been an instructor. is it possible to take the exam without
an instructor experience?
last but not least, I am thinking about putting together some excel webcasts
for beginners for free. I have always liked to learn by audio/visual versus
reading so I am thinking about implementing this...
here is the link for the first test webcast ...Making cards --2 to a 8 1/2 x 11 page
I want to make cards to send out for memorials, etc. I want 2 cards to a
page, top folded 5 1/2 x 8 1/2. What happened to the old Picture It!
Do you want to make these cards in Publisher?
If you do, look at page setup, folded card, tent card, width 4.25, height 5.5.
Publisher will say it will print two pages per sheet
Mary Sauer MSFT MVP
"A Holt" <A Holt@discussions.microsoft.com> wrote in message
>I want t...I have SQL Server installed on my workstation, can I not use MSDE
I have SQL Server Developer Edition on my workstation and I don't
really want another instance of SQL on my box. Is there anyway for MS
CRM 1.2 to use my existing installation?
If you are referring to the MSDE datastore for the SFO client, then no, there
isn't. It will install a new instance, but many of the underlying files are
shared amongst the instances.
On 23 Apr 2004 10:07:41 -0700, firstname.lastname@example.org (Shawn Ramirez) wrote:
I have SQL Server Developer Edition on my workstation ...Using Emit to Return a Value
I am trying to write a piece of code that can implement an interface's
methods simply by returning a specified value. I am trying to see how
Mock libraries are written.
For instance, I have a piece of code that looks like this:
What I want to be able to do is somehow implement ISomething.Foo so
that it returns "abc". However, I am having a hard time figuring out
the Emit code for taking an arbitrary object and incorporating it.
I've never want...Excel Formulae #2
I have a spreadsheet with value in one column & a series of dates in 5
other columns.For each row depending on the value
in the first colunm a date may be applicable in one or more of the
other columns.e.g 550 in the first column will mean dates will be
inserted in the next 2 columns similar to authority levels. My qn. is
how can I show what's outstanding if the relevant authority levels have
not signed off-basically this is used as a tracker of invoices & I
would like to show what is outstanding awaiting approval at anytime.
----------------------------------...Using a Button to increment numbers in a database among other things.
I know that it is difficult to assess and solve a problem without
being able to look at it physically. Therefore I have included a
download link to the database I am working on.
I have been have some trouble with this database what I would like to
do is set up the logdb form to increment the lab number field with the
click of a button following a format of the last two digits of the
year "-" "0000", otherwise I would just like the field to be entered
with a format of "00"-"0000". I tried using a ...Download email #2
How to download email from Microsoft exchange 2000 to
Outlook Express?? without leave a copy at Exchange server.
Outlook Express cannot download mail from Exchange. Why are you trying to
do so without leaving a copy of the mail on Exchange?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Edi asked:
| How to download email from Microsoft exchange 2000 to
| Outlook E...How can i use DAO Application
I have a software which is made in MFC and connected with MS Access 97
through DAO(Direct Access Object via MS jet Engine).
Now i want to use same software for Postgresql and wanted to connected
it through ODBC.
Problem is that Old software has been developed for DAO,all main file
like ,recordset,view doc r made for DAO.
If i want to make it in ODBC,my classes like Set ,view Doc and other
would be generated for ODBC.
I dont know any option to use same software,
Should i write whole software from the begining?
I need ur help.
...Problems with Using Word as Email Editor
We use Hummingbird DM 188.8.131.52 for our document and record
management. When using this program, it has a problem
with Outlook using Word as an Email Editor. When this is
turned on, it seems that Outlook opens a different
instance of Word. When you try to open or create a word
document, you lose the ability to save or print. These
features return to normal when you uncheck Word as an
Email Editor in Outlook. I have heard that Microsoft was
taking this up with Hummingbird to have them fix it. I am
just wondering if this was to be resolved, or if it is
Hummingbird's problem to ...Using OUTPUT TO in VBA, then how to modify the XLS from Access?
I'm using the simple "OUTPUTTO" command to send a query over to Excel,
however we will have many users and we would like to programmatically add the
header rows, date printed, turn on the auto filter and freeze panes, all of
which I can do within a Macro in Excel, but how do I call that macro to run
from Access and How to run it on the file that they just created?
DoCmd.OutputTo acOutputQuery, "MainRptWUser", acFormatXLS, , True
> I'm using the simple "OUTPUTTO" command to send...Inability to connect with exchange server using entourage
Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
I have a 2008 version of entourage that I connect with my exchange server. I added a ms office home edition to my computer, and now I am unable to connect to my server. The error message now says that I must upgrade to a std edition of office in order to connect to an exchange server. If my previous version of entourage would connect and it is still on the computer, why won't it do it now with office installed? Any advice? <br>
What version of Microsoft Office 2008 entourage did you down...How to best imitate using Word macros in Outlook 2007
In my previous Office 2003 setup, I used Word for email editing,
allowing me to use Word macros to generate common sections of text in
the emails, etc. I see that in Office 2007, the email editor does not
support the Word object model. How do I program a macro that would
allow me to enter a certain text in the Outlook message under 2007?
What happens when you try using the Outlook Macro editor?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After furious head scratching, AMolotkov asked:
| In my previous Office 2003 setup, ...missing wab dll first time using outlook 2000
while trying to install outlook 2000 for the first time I get a missing dll
file message. A computer search did not turn up any wab file. I have a new
phone (droid) I am trying to set up a sync with it from outlook
Applies to Vista and Windows 7 when it comes to this *.wab error
See the following about Outlook 2000 and missing *.wab
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"airport mark" <airport email@example.com...Percentile: Different Result Using VBA?
If I populate some cells on an Excel spreadsheet with, say, 1, 2, 3, 4; and then
set another cell to =Percentile([cell range], .9) I get a result of 4.
OTOH, if I'm in VBA and feed the those numbers to
gExcelApp.WorksheetFunction.PercentRank, I get 3.7.
Only diff I can see is the use of a VBA array of double to pass the numbers 1-4.
Does this sound familiar to anybody?
Try formatting the cell containing the percentile function to display some
decimal places: then you'll get 3.7 as expected.
"(PeteCresswell)" <x@y.Invalid> wrote in message
news...Field Chooser #2
Guys-is it possible that some of the fields in Outlook
2000 (from Field Chooser) can simply disappear or could
the problem be that somebody else is accessing my mailbox?
It happened to me that the From field and Subject field
have simply disappered twice without my action? Could it
be a bug or something similar?
Is it possible those fields are already in the table view? I've been spooked
by that one before.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
I seem to keep getting a password and ID prompt in outlook for my HTTP
Hotmail account even though I am entering the correct password and ID
because i can get to this account over the internet. remember my password is
also checked in tools\account\properties etc.
Version of Outlook? Does it work if you log into the site in a browser?
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Exchange Messaging Outlook ...MsgBox #2
I have been search the web for hours looking for example spreadsheets using
MsgBox to no avail.
Can someone direct me in the right direction?
What I am looking to do is ask a question and if the answer is "yes" do 1
thing and if "no" do something else.
"Ed Davis" <firstname.lastname@example.org> wrote in message
>I have been search the web for hours looking for example spreadsheets using
>MsgBox to no avail.
> Can someone direct me in the right direction?
Look at this: