Using checkbox to edit criteria
I have a table (Table1) that has a field referred to as 'Type'. For some of
the records, 'Type' is null and for others there is data in that field.
I would like to run a query that returns the records from thTable1 where
'Type' Is Null based on whether a checkbox is checked on a form, however, I
am unsure as to how to accomplish this. Here is the query that I have now
which is not working:
Select * FROM Table1 WHERE Table1.Type IIF(chkType = FALSE, Is Null, Is Not
Thank you in advance for your help.
Try this --
...Using PowerPoint to create slides for karaoke lyrics
Our music ministry is wanting to use PowerPoint slides of our original music
on our overhead computer projection system during church services. We need to
be able find individual slides quickly since we do not plan our song list
before services. Does anyone have an easy solution for making this possible.
Will a catalog work? Should we use Access instead?
It's probably time to move on from PowerPoint if you need to find songs
quickly. I use a Program called Presentation Manager where the songs are
listed in alphabetical order and you can search for a song even when you are
...Use icon sets relatively in a pivot table
I can use icon sets for certain things, but am unable to figure out
how to use them with my existing data.
I have a pivot table that may list sales from Quarter 4. If you expand
that level of the pivot table you would see the monthly, weekly and
daily sales that constituted Quarter 4. But I want to show icons to
give a visual cue if Q4 was up from Q3.
I would need to do this again in the future to see if Q1 is up from
the previous years Q4.
Sample Data would be:
Week Sales (want to see icons in this column, beside numbers)
I w...How do I configure simple categories in the task application
I am using outlook 2003 at work and am thinking of using 2002 at home. I
want to simply configure the task view so that I can in one window look at my
tasks. Either filtering them so only one category shows, or by showing them
all and which category they belong to. Further I want to be able to check
off from this list similar to how you might flag messages in email etc.
Anyone familiar with how palm desktop works will know what I'm talking about.
If this is too much of a mouthfiul to explain then at least a link to a site
with helpful outlook howtos would be good. (Note- I hav...Using text and formatting sum function in formula
I am attempting to show text in a cell concatenated with the sum function and
it works fine. The problem is the result has 10 decimal places in the
resulting number. I have tried to use the format function with the sum
function without success. Here is the formula I am working with:
="Total is: " & Format(SUM(B96:B104),"0.00")
What am I doing wrong?
Try it like this...
="Total is: "&ROUND(SUM(B96:B104),2)
Microsoft Excel MVP
"Billy B" <BillyB@discussions.microsoft.com> wrote in message
news:...Video stays black or is corrupt when using video conference in RTC
We are using WinCE 6 R2 (x86) which is updated up to August 2009. In this
environment we have developed a video codec for use in the RTC environment.
The codec is tested with several senarios, which includes:
- Testing on a single WinCE device within a costum FilterGraph, which does
the encoding and decoding perfectly.
- Testing the encoding and RTP sending process with a receiving client on a
XP machine, this also works perfectly.
- The incoming RTP data is captured, and this data is able to play perfectly
However, after testing it inside the RTC environmen...Creating entity record in inactive view using crm 3.0 sdk
I want to add entity record in inactive view by using crm 3.0 sdk.Already i
created a record by using sdk but it was added in' active' view records,but
my requirement is to add record directly in 'inactive' view records.
Can anybody suggest me how to solve this problem ?
Pls provide code samples if anybody have.
Waiting for replies.
you will have to create the record (which you have already done), and then
set it's state/status as a separate operation.
"prabhakar.penugonda" <prabhakarpenugonda@discussio...Let me use the Line Color icon on charts
It would speed up a lot of my work if I could use the Line Color icon on
Excel charts, the same way I am able to use the Fill Color and Font Color
However, when I highlight any chart object, like the Plot Area, Chart Area,
or a Series, the Line Color icon is disabled.
Stuart Bratesman, Jr., MPP
Muskie School of Public Service
Univ. of Southern Maine
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If ...Outlook 2003 using too much CPU on Vista
Outlook 2003 on Vista constantly uses 40%+ of the CPU. What is it
doing? Didn't do this on XP. Also, when I close it it doesn't
completely shut down. I usually have to kill it after 5 or 10 mins.
I have a dual-core cpu running at 1.9 GHz.
Do you have any addins installed Are you using any applications that access
outlook data? (including syncing with a pda)
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
...Document won't print using show/hide parargraph marks. Blocked?
When I click on the Show/Hide button on paragraph section above the document,
it shows my entire page to print with the marks. When I click on it again to
Hide the symbols, almost the entire page disappears, and it won't print what
I want it to show. What did I do wrong?
Maybe almost your entire page somehow got formatted as Hidden text?
With Show/Hide turned off, select the whole document (Ctrl-A) and
press Ctrl-Shift-H (once or twice). If your text reappears, then that
was your problem.
On Feb 20, 12:39=A0pm, Sadiemitzi <Sadiemi...@discussions.microsoft.com>
wro...When do I use quotation marks in an Excel formula?
What are the guidelines as to when you do and do not use quotation marks in
the criteria section of a function.
Quotation marks around a text string; no quotation marks around a number.
"Deb" <Deb@discussions.microsoft.com> wrote in message
> What are the guidelines as to when you do and do not use quotation marks
> the criteria section of a function.
It can get confusing in some cases but the GENERAL rule of thumb is:
Always quote text
Never quote numbers
...How can I use this expression "=SUM(RC[a0]:RC[a1])" work in Excel
I need to insert this formula "=SUM(RC[s0$]:RC[s1$])" in a cell such that the
values a0 and a1 are variables.
How can this be done? Please assist and advice.
dim s0 as string 'I'd use long's
dim s1 as string
s0 = "3"
s1 = "6"
somecell.formular1c1 = "=SUM(RC[" & s0 & "]:RC[" & s1 & "])"
> I need to insert this formula "=SUM(RC[s0$]:RC[s1$])" in a cell such that the
> values a0 and a1 are variables.
> How can this be done? Please assist and advice...I'm using outlook on both the desktop and laptop computer
I'm using Outlook on both my desktop and laptop
computer. I would like to put the files in a location
that they may be accessable on both without having to
save them to a disk and update the files. I am using a
wireless router and I think I should be able to update my
calendar and task and contacts using either computer with
a certain amount of sceurity. Please tell me how I can
http://www.slipstick.com/outlook/sync.htm should be a good place to learn
how to do this.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discuss...Facility for using COST CENTER codes while entering transactions
To minimise the number of account codes and to analyse my expenses for
individual departments , I would like to allot CC for all the Depts. /
Activities and use them while entering transactions in the system. Is it
possible to do in MS GP ?
Is anybody using such a feature now ?
Yep, either MDA or Analytical Accounting will do this for you.
"INTERNAL AUDITOR" <INTERNALAUDITOR@discussions.microsoft.com> wrote in
> To minimise the number of account codes and to analyse my expe...Error in loading DLL
We have a Microsoft Office 2000 installed & use it via Terminal Services for Windows 2000. All has been working fine until recently when we try to edit a Macro in Excel 2000 it comes up with the following error
'Microsoft Visual Basic - Error in Loading DLL' then when you click on Help it points to Error 48
You can click on OK several times & it may let you into the macro
In addition we sometimes get when trying to record a new macro you get 'Unable to record
I have repaired & reinstalled Microsoft Office but this has not resolved the problem
Any advice would be ap...Does Outlook use the DAV protocol?
I'm an Outlook Express user who wants to switch to Outlook. I received a
notice from Microsoft that includes the following: "... as of June 30, 2008,
Microsoft is disabling the DAV protocol and you will no longer be able to
access your Hotmail Inbox via Outlook Express."
Please tell me if this action by Microsoft will affect Outlook in the same
manner, or am I free to make the switch.
"BudV" <BudVitoff@(NO)att.(SPAM)net> wrote in message
> I'm an Outlook Express user who wants to switch to Outlook...Outlook is used by malware ?
Something weird is going on with my Outlook 2007.
After I have new email composed and hit “Send/Receive” button the status
quickly display a “Sending a message 4/4” message.
Why it says that it had sent 4 messages instead of one (I am absolutely sure
that it has no other messages in the queue and only one message added to
“Send” folder after the whole thing)?
I have a suspicion that may be some malware on my PC using outlook to send
emails and to conceal its presence it only does that when I and sending mine.
I checked my PC for any viruses and spyware and found nothing.
Any ideas of...Creating and using a template
I want to send the same email to a couple of companies with a theme (artsy).
I created the email I wanted, saved it as an outlook template but have been
been unable to reload it to make minor changes and send to another company. I
have been using outlook for some time but not templates.
Any help appreciated.
...Upgrade Publisher 97 to newer version
HI - I have Publisher 97 cd that came w/ my old computer (long gone). I wnat
to get an entire new software upgrade so I can put in on my new Vista Oper
Do I have to pay for brand new software or can I just pay for an upgrade?
If the latter is the answer, how do I go about doing this?
Thanks so much.
These are the Upgrade qualifying products:
Microsoft Publisher 2000-2002; Microsoft Office Publisher 2003; Microsoft
Publisher Deluxe 2000-2002; Microsoft Office Publisher 2003 with Digital
Imaging; any 2000-2007 Microsoft Office suite; any Microsoft Office XP suite.
http://o...using money on windows nt
I have been trying to install the trial version of money
on windows nt. However, the installation is never
completed. The message I get is this: money requires
either windows 1998 second edition, 2000 service pack3, or
Can I run money on windows nt?
To use Microsoft� Money Deluxe 2005 you need:
a.. Windows� 98 SE or later, Windows 2000 SP3 or later, or Windows XP
b.. Multimedia PC with Pentium 166 or higher processor (or
compatible); Pentium II 266 (or compatible) required for Windows XP; Pentium
II 300 (or compatible) recommended
c.. 32 M...version compatibility between GP 5.5 and 6.0
Can I open a GP 6.0 file on GP 5.5?
Which file you are talking about?
> Can I open a GP 6.0 file on GP 5.5?
This is NOT recommended. Should you hit any tables that have been changed,
you will have unpredictable results.
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
For help learning and better using Dynamics GP,... check out our books at
> Can I open a GP 6.0 file on GP 5.5?
...Using Office Assistant to display MY message
Someone sent me a spreadsheet and when I click certain
cells, the office assistant pops up with information
specific to the spreadsheet...much like the text you
would see in a comment box, although comments are not
used in the spreadsheet. Very bazaar! I didn't know it
was possible to have your own text display through the
How do you do it?????? Thanks!!!
Is it the Office Assistant or just a message that pops up?
If so, it could be Data>Validation>InputMessage.
With one of these cells selected go to Data>Validation and see what's...Problem with different versions of Access
I am working on a VBA Access pplication which connects to a SQL Server
I have a continuous form displayed with data, ad it is linked to a
database table, so when I enter a value from my form the data in
instantaneously updated in the database.
The problem I have is that this form works perfectly when I am
developping, and using my developpement environement (with Access
allowing me to set breakpoints, go step by step in the code and so on),
but it does not work when I use it in the PC of the ending user : in
this case, when I enter a value in the form, and click in a...Using CTRL+End
I want to use CTRL+Home and CTRL+End to move from top left to bottom right
having finished build the spreadsheet. I am have a problem with CTRL+End in
as much as it moves the curser to a long way off the finish spreadsheet even
though the cells appear empty. Can anyone advise how to overcome this
Reply in worksheet.functions. No need to multipost.
...I'm using outlook 2000 office sp3
I have enable the multi profile.
I'm unable to open other user mailbox profile other then
my own login mailbox.
My exchange is 5.5p s3
I have login as in userA
I selected userA profile and keyin the right user id and password.
I'm able to read userA mailbox
I selected userB profile and keyin userB user id and password.
It give me the error message saying I'm unable to open default email
what the problem here any solution