query to find when an event happened
I have 12 years of weather data in one table, and have queries to give
me total rainfalls between different dates etc, as well as max and min
What I would like now is a query to tell me what date in a selected
range the max or min temperature was.
I have tried the WHERE clause just see what it would return but I got a
Getting a related field from a GroupBy (total) queryat:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/...Must buy new computer...Ideas?
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme
slowness has seriously gotten on my nerves and I'm now looking for a new
one. (Surprisingly, it's working pretty well otherwise...)
Maybe this isn't the right forum? But beside the usual things like RAM and
HD GBs, are there things I should be sure to have...or be careful NOT to
have on a desktop? After n ot looking into computers for over a decade I
feel like a Martian in the Earth. lol!
Also, is it possible to transfer to the new one ALL my stuff, including
programs, etc.? Do you thin...Default properties for new folders
How does one set the default properties applied when
creating new email folders? Currently, when I create a
new folder, it is created with the AutoPreview turned on
by default. I'd like to change that do that it is left
off by default. It's something of a pain to create a new
folder and then go in to customize it's properties.
You can do this by editing the Messages view; View-> Arrange By-> Current
View-> Define Views...
You might want to define a new view yourself and apply that view on first
use of that folder.
Robert Sparnaaij [MVP-Outlook]
www.howto-o...New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new
messages I received can only be received when I press the SEND/RECEIVE
BUTTON. My Outlook at work receives these new mail messages as they are
received. So how can I configure the system to make that happen?
The Trail Hiker!!
There are two settings within the accounts
1) Send on starting
2) Auto send/receive every xx minutes - set this for 10 minutes
"hiker0531" <firstname.lastname@example.org> wrote in message
>I just installed Outlook 2007 on my n...User Calendar Vanished
Just a quick query regarding a user whos calendar contents seems to have
vanished! for dates prior to June 05
This is not a big deal, but i thought a little odd.. any reason anyone might
know of why this would happen?
one thing i suggest was that some data archived off has been deleted.. do
archives include calendar data ?
On Tue, 21 Feb 2006 01:44:28 -0800, "Chris"
>Just a quick query regarding a user whos calendar contents seems to have
>vanished! for dates prior to June 05
>This is...ON_EVENT_RANGE & how to sink events
I have been trying to use ON_EVENT_RANGE for handling events from
dynamically created ActiveX controls, but in vain. I have traced teh
execution till the "Fire_xxxx" method on the control to see if the
event indeed gets fired. The outgoing interface on OCX is dispinterface
and I am connecting the client to the control using
When I step through the code for Fire_xxxx I see that the last
reinterpret_cast does not somehow work and hence the event is never
Please someone advice me if I am goind something wrong. The question
that cross my mind ...Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until
When I click "New" to write a new email I get an error window :
The messaging interface has returned an unknown error. If the problem
persist, Restart Outlook.
I have tried this several times, even restarted the computer to no avail.
Anyone have a solution????
...Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog?
I have removed permissions to the specific post to the lowest possible
access and people can STILL post a comment. If I uncheck one more item in the
list of permissions, the users can no longer see the post.
Weve got Exchange 2003 with most of our clients using Outlook 2003 or 2000.
We have kept the Exchange 5,5 server on the domain purely because we have a
newsletter public (folder which receives newsletters we have subscribed to
over on the internet), and which uses an agent script that forwards these
mails to different people and public sub folders.
We cannot get rid of the exchange 5,5 server until we figure a way to
forward these emails. I have tried using the Folder assistant to assign a
rule which forwards the emails but they dont seem to be working, all the
newsletters are just sitting in...Order of Events using the built in form Close Button
I have a form that is bound to a table that has required fields. When the
form is closed using the Close Button, which is made available to the form by
setting the form's Control Box and Close Button properties to "Yes", Access
displays standard messages about required field data. I would like to
intercept these messages via the order of events that occur when using the
Close Button. Does anyone know what that order of events is?
The main ones to use are-->
Before Update and Unload.
Both these events allow you to cancel closing the form if requ...A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of
minutes and watch this video. This application also allows for edit of
Global customer information in HQ installations.
Contact us for detailed info and demo.
It would be nice if you could encode the videos with a more common codec,
and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows
Media Player 11 doesn't automatically download the codec, and I'm not going
through the trouble to download and in...New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm
running MS Server2003 as well as Exchange 2003. Once moved, I will no longer
require the server (since I am setting up a home office).
Are there currently any steps or procedures available to correctly shutdown
one office...and basically setup a home office with no exchange server.
Also I will be removing the current pc's from the Domain, and setting up a
few in a workgroup.
I would like to receive emails from the other employees for time being until
I completely cancel this email account. I already have a...How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all"
buttons are not active which means I can not send mail. I have no problems
receiving mail. Also, on web pages with email links, when I click on them,
the Outlook application is not launched which is almost certainly related to
this. I think I'm missing something very simple here!
Are you in a mail enabled folder? Do you have an active email account
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert...Can I make a calendar event tied to a contact?
I would like to be able to make a calendar event and tie it to a contact.
For example. If I have a meeting with Mr. Smith, I would like to either
click on Mr. Smith's info in the Contacts folder and have an option for
making an event OR by adding an event to the Calendar be able to click a
contact for that event to be assocaited with.
I know I could do this if I was inviting someone to a meeting, but that is
not what this would be for. I want to be able to click on the Calendar event
and have the person's phone number information pop up, without having to then
go se...Style available all sheets new or old
I need a custom style that is available in all
spreadsheets, new or old. I can set style and save it in
book.xlt in xlstart, but that only works for new
workbooks, and doesn't work with old spreadsheets when I
call them up. I want to be able to select a group of
cells, or column or row and apply a setting for negative
numbers to have brackets. I am using Excel 2000.
I even tried saving the style in personal.xls, but that
doesn't work as it is hidden.
Do I have to use a macro? And if so what would it be?
Public Sub MergeStyles()
ActiveWorkbook....Sub Form Assigning New Values to Old Records
I am using a subform within a form to have users update certain fields in the
record where the rest remiain locked. On the Main form when the list box
(which is bound to a query) is used to select the record set to display in
the subform it sometimes takes an old record and assigns a new value to the
record. For example it changes the Period field from 9 to 10. Taking a
record created in period 9 and assigning a period ten to it which is the
selection I make in the list box. Addtionally, it looks like it is taking
the first record in the related table to assign this new value to. ...Which table will refresh by adding new Account / Contact
I am new to CRM and trying to update CRM Accounts and Contacts from our
Sales Management system. I am using Micorosft Bulk Import utility. I am in
preparation of CVS files but not sure what columns do I need in CVS file to
complete one Account/Contact record. Could anybody please help. I am .NET
expert developer, please let me guide If I could develop CRM by using .NET
Microsoft do provide CRM SDK for CRM enhancment using .net. You can download
from following url
http://www.microsoft.com/downloads/details.aspx?familyid=9C178B68-3A06-4898-BC83-BD14B74308C5...Adding new pages
Any thing I do on new pages happens simultaneously on any previous page. Can someone help me please?
Can you be more specific? What stencils are you using and what are you
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Joanie" <email@example.com> wrote in message
> Any thing I do on new pages happens simultaneously on any previ...New trend, new business, new year a new beginning
New trend, at start of new year.
"If you want things to work different, you must try a different...whatever..." Does that seem obvious?
Brighten up with this "reading" and attack the money issue with
I am finishing my year 2005 with some regrets and some joy.
For some the year passed has not been "tip top" in their view.
But I believe it has just been very well as the page I shall bring you
that has this statement which I believe wholeheartedly:
"THINGS ARE UNFOLDING AS IT SHOULD" (paraphrased) I invite you to read the whole "poem&quo...New messages comes up in Deleted folder
Sometimes when I receive new messages the go to the
Deleted folder instead of the Inbox. The messages are
from random people...not just one sender. What is the
Check your message rules/filters. "key word" in new mail
subject line of body is probably being tagged and
filtered to deleted items folder.
>Sometimes when I receive new messages the go to the
>Deleted folder instead of the Inbox. The messages are
>from random people...not just one sender. What is the
...New User has admin rights
I just created a new user and assigned her the role of Sales Manager. This
role is working correctly for other users with it assigned, but she has admin
This is the only role she has assigned....
...Creating new row in other table
Please teach me, how to make a new row/list in other table by entering
number in other table. Sample, In the table A and in the field "Details", I
put the number 2 and it automatically creates two rows in table B. Can this
be done in MS Access? Thank you for your help.
Why? What business need are you attempting to solve with this approach?
It's generally considered not very good database design to be creating
'empty' rows in a second table. Why do you want empty rows?
And if the number you enter in TableA is a 'limit&...AP
What would be the best tool to add a new field in the AP invoice screen to
deploy to a client? Extender? Modifier?
the ideal would be to add a field for "Job No." that is text info so the
user can get some info out on certain jobs that they are paying bills for.
You can use any tool, really, to accomplish this:
- Modifier with VBA. You can add the fields to the window with Modifier,
then use VBA and ADO or DUOS to store and retrieve the data.
- Modifier with Dexterity. You can add the fields with Modifier, then
trigger off the form with Dex...Button "New Account" in Sub-Accountsview opens Parent account
When I open an account, and then go to the subaccounts of that account, I
click on the Button "New Account" to create a new subaccount for this
account. Instead of opening a new account form, the application opens the
original Account form.
Anybody an idea how this is possible?
MSCRM, hosted as ASP, and configured for your business.
Have you installed any specific toolbars in your Internet Explorer? Like
google toolbar/msn toolbar?
> When I open an account, and then go to...cant print 1st aug in august calendar in outlook for 2010
I have printed out a yearly calendar from outlook, but when it gets to
august, it starts on 2nd aug, and the title is august 2010 september 2010.
All the other months print just that month, but this one doesnt.
Please help. I have made sure i clicked print exactly 1 month per page.
This was a bug in 2007 that was fixed by an update - it sounds like it might
be back. If so, I'll file a bug report on it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email: