How do I minimize to the trey
I have a requirements to put an icon of my app in the trey when it is
minimized. How would I do this.
1. From a console app.
2. From an MFC dialog app?
Yes, an MFC dialog app. All Dialog apps, if I remember
correctly, come with an App.ico file. You can draw on
this or replace it with your own. If you replace it, then
you may need to find how it links with the code and make
sure your file is used instead.
Not sure if you can override the icon of a console window.
>I have a requirements to put an icon of my app in the
trey when it is
>mini...Remove Meeting Time from Monthly Calendar Print
Is it possible to remove the meeting time from a monthly calendar print and
only show the meeting title?
Yes, you need to use portrait mode so the cells are too narrow to include
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
Do you sync your mailbox with a smartphone or pd...Minimized Outlook
I was glad to discover that I could minimize Outlook to an icon at the right of
my task bar instead of to the standard big minimize bar.
At least, until I found out that half of the time when I click on it to expand
it, I get a ! message telling me that Outlook is not responding. I suppose
that's a function of my Exchange server. But having to click again slows
Is there a way to disable this message and maximize Outlook quickly?
Howard Brazee <firstname.lastname@example.org> wrote:
> I was glad to discover that I could minimize Outlook to an icon at
> the right of my ta...When does a query/subquery return a NULL and when no value at all, not even a NULL?
a) If a query/subquery doesn=92t find any matching rows, then it either
returns NULL or no value at all, thus not even a NULL value. Based on
what criteria does a query or a subquery return a NULL and when
doesn=92t it return any results, not even a NULL value?
b) I assume a scalar subquery will always return NULL, when no
matching rows are found? I assume most-outer scalar query also returns
NULL if no rows are found?
SELECT FirstName, LastName, YEAR(BirthDate)
WHERE YEAR(BirthDate) IN (SELECT YearReleased FROM Albums);
* If subquery finds no results...Dynamic Chart Generation
I am trying to use VBA to dynamically produce a number of charts. Th
number of charts produced depends on the amount of data that appears i
a seperate spreadsheet...
I have taken the code produced when I recorded a macro to produce on
such chart and adapted it to meet my needs, however I am getting erro
1004, "Unable to set the XValues property of the Series class" when
try to assign the x-axis values using a range I have dynamicall
I'm sure the problem is somewhere with my syntax, but however I try t
phrase it I cannot seem to get it to work.
Please find a copy o...Multiple lines of criteria without repeating header
I'm using the database functions DMAX etc and want to have a variety o
criteria in a column. However I believe the "criteria" range has to b
a minimum of 2 rows with the top row containing headers. If I want t
reference a row of the range of criteria, I am then lacking th
headers. Including the headers would then include all rows of criteri
in between too - creating an undesirable OR condition.
6...Difficult One-to-Many Query
I have (2) back-end SQL Server tables that I've linked to a front-end ACCESS
db. One table contains Overall (summarized) data associated with a Product
Order, and the other contains Specific data associated with the order. Both
tables have Customer Number as a Primary Key -- here's the structures of the
(2) tables, as well as what I'm trying to do with the data:
Table 1 Overall Data.
(No Primary Key)
Table 2 Specific Data.
(No Primary Key)
O...Problems Query with MSQuery
I try to Query from CSV file to Excel worksheet using MSQuery
One of the fields contains both numeric and text data but MSQuery return to Excel only the numeric data
What can i do to fix the problem
The following article on Dick Kusleika's weblog may help (from a post by
> I try to Query from CSV file to Excel worksheet using MSQuery.
> One of the fields contains both numeric and text data but MSQuery return to Excel only the numeric data.
> ...Complex (for me) IIf query
I have tblEmployeeProduction which is populated via a form using an
Update query with the following sql:
PARAMETERS forms![frmSetEmpHours]![txtDate] DateTime;
INSERT INTO EmployeeProduction ( EmployeeID, ProductionDate,
Department, Shift, JobFunctionID, ShiftHours )
SELECT Employees.EmployeeID, forms!frmSetEmpHours!txtDate AS
ProductionDate, Employees.Department, Employees.Shift, JobFunctionID,
FROM Shift INNER JOIN Employees ON Shift.Shift=Employees.Shift
WHERE (((Employees.Department)=forms!frmSetEmpHours!cboDept) And
Thi...CRM Queries #2
I am new to MS CRM.
I will highly appriciate if anyone could answer my below queries.
· 1) Why My Work in CRM showing All personal & official Emails - How
& from where should disable this emails. as i want to see only CRM Cases
· 2) Where can i explore & see more information about CRM General
Tab & Details tab of MS CRM
· 3) What should i do to access my MS CRM from outside of company
(Web Interface accessibility).
· 4) How should i Add columns in KB Article's in Published section....Minimized form
I have a big issue with Acces 2007,whne i open a form,the window is
always minimized,i try to set the property "Auto resize" to yes,but when i
open the form it's minimized as usual and displays one record only unless
users scroll down the bar to see the records one by one...
Is there any solution for this?
What I did ( Access 2003 though ) was to put a macro with the command
Maximize in the form onload event
> I have a big issue with Acces 2007,whne i open a form,the window is
> always minimized,i try to set the proper...Month-End Closing in Great Plains 8.0
Might I get some information about Month-End Closing?
The detailed steps I should take
The precautions and cautions I shoud aware of.
There are so many factors that goes into this depending on which modules
you have, but generally speaking, Great Plains doesn't have a "hard" month-end
as with many other ERP solutions. Perhaps contact your VAR to help you determine
what procedures you need to perform as part of your month-end.
A> Might I get some information about Month-End Closing?
A> Th...why does my parameter query repeat the prompt?
I have a query with three parameters. The query asks for each parameter and
then repeats itself before returning the data.
Probably because the query is being run more than once -- perchance, is this
query the RecordSource of a subreport or subform?
<MS ACCESS MVP>
"nickaf" <email@example.com> wrote in message
>I have a query with three parameters. The query asks for each parameter and
> then repeats itself before returning the data.
OR have you applied a filt...Repeating 9095 9096
We are running Exchange 2003 SP1 on Windows 2003, in an all 2003 server
environment. Exchange server is running 4gbs of ram, quad xeon, stores
are located on a SAN on 120gb drives.
Did I miss anything?
Outlook clients are Outlook 2000 or 2003
We have a bit of a strange thing going on. Every few days (randomly)
we have the 9095 & 9096 events filling the log, every minute.
While this is happening, the server is extremely slow to respond, and
clients cannot access the application. There is NO problem getting to
OWA, just through Outlook.
Sometimes it stops on it's own,...Repeating (or Looping?) an Action with VBA in Word 2007
I am very new to VBA. I am trying to create a macro for a Word 2007
document that finds a graphic, then resizes it to original size (Reset in
Format Picture dialog box). I have recorded the following, which produces
the result I want for one graphic. How do I make it loop so that it will
perform the action on ALL the graphics in my document? When responding,
please keep in mind that I am a novice with VBA. :)
' ResizeSlide Macro
.Text = "^g"
...Copy the sub-totals not the details
I have a worksheet (Excel 2007) that shows accounts sales data. The table
sub-totals showing the sum of the sales for each account.
I need to transfer the sub-total data to another sheet to create a table
just the rows with sub-total values, and without the rest of the source data
that I can import the sub-total figures into another piece of software).
Anyone know how to do this?Jeff
__________ Information from ESET Smart Security, version of virus signature database 4888 (20100222) __________
The message was checked by ESET Smart Security.
http...sql aggregate query
ID - Autonumber Field
Patientid - This can have a number of records with the same number
dDate is the date of the record and can be duplicated.
I need to create a new table with the max of date for each unique
So far not a problem.
SELECT TblCurrentEncounter.Patientid, Max(TblCurrentEncounter.dDate)
GROUP BY TblCurrentEncounter.Patientid;
But the kicker is that i need the id of the row containing the max of
As soon as i try to add ID to the query I get error about not being
part of the aggregate function.
Any ideas w...Calculating time in query
I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another query to
calculate the totals of these differences. Is this a logic way to do this?
And I'm trying to make a expression to calculate the difference but with no
luck. The result is something like this: 3,2515785. I've found a kb article
but I still can't figu...Minimize
I can minimize the whole program, but I can not minimize
the file itself, the minimize button for the file is not
there, what do I do?
Your Workbook is protect with Windows Checked
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Shawn" <firstname.lastname@example.org> wrote in message news:email@example.com...
> I can minimize the whole program, but I can not minimize
> the file itself, the minimize button for the file is not
> there, what do I do?
&...Visio Reopens Repeatedly.
XP -Pro Visio 2002 SP 2
When I close Visio, it relaunches the application 6 times before staying
closed. Just started doing this today.
Anyone see this, have a cure?
Did you install Adobe Acrobat 6 just before you started seeing this
behavior? If so, you may be seeing a conflict between Acrobat and Visio,
with suggested workarounds discussed in these newsgroup messages:
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rikk" <rfloh...Rolling 12 month data charts
I was wondering if someone could give me an example to help me get my
head around the best way to do this.
I have posted before on how my charts us data tables and that I would
like to change that. I need to add annotations to specific months
that stay with the data point as the calendar year rolls to the next
What I am needing is someone to help me out by giving me an example of
what my chart should look like with the chart and then the data below
in a similar format as the data table. I have close to 35 charts that
I have to do this for and I want to make sure I start this new pro...How to add "minimize" button for the dialog
How to add "minimize" button for the dialog - that is - the little "x"
on the top right of the window?
In resource editor, right click on the dialog and click properties. In
styles tab, you will find the option "System Menu". Check it in your
I am sorry. I also want minimize, that is "-" on the top right of the
How to add it by using code?
This option (minimize box) is also available in the styles tab.
Play with GetSystemMenu of your dialog and remove...macro worked for a month and then stopped
I have a Scheduled Task running on a Windows Server 2003 box. If I am
logged on as the administrative user and run the task manually, it runs
perfectly. I can tell it runs, because the task places a report as a ".txt"
file in a folder. Again, when I run the task manually, this report appears
and this task runs.
When I schedule the task to run at a certain time of day and stay logged on,
it also runs fine. The report appears in that folder.
But, when I schedule the task to run at a certain time of day and log off,
it does not run. The report is not there.
The IT ...Minimize??
For some reason when I click on Minimize the window still takes up the full
screen. Obviously I've changed something.
How can I restore it back to where the full screen is not used?
Do you mean minimise which is the leftmost icon, or do you mean the one in
the middle which takes it from full screen to a smaller screen. Assuming it
is the latter, hit that and then manually resize your window to the size you
want. After that it should alter to this size when you hit the icon.
Ken....................... Microsoft MVP - Excel
S...Parameter criteria in MS Query to bring in all items for a single day
I think this is an easy one!
I am querying on a date time field with e.g. 21/12/2003 07:00:00 and
just simply looking to filter for all times on a specific date using a
parameter query.(so keying 21/12/2003 in the parameter prompt returns
all items for that day although the timestamps will be different)
I guess I could create a calculated field using INT or similar but I'm
sure there is an easier way than that. I don't think that worked
because of the data type situation. Presumably using ROUND is not
Also tried criteria 'between [date1] and [date1]+1' bu...