Is there any way to make a dated entry insert itself in the worksheet in the
correct order without doing a sort operation, or inserting a new row?
would be a big help for my reservations workbook
You could try the worksheet change event:
Private Sub Worksheet_Change(ByVal Target As Range)
This should re-sort your selection everytime the worksheet changes.
Hope this helps
"Dave" <firstname.lastname@example.org> wrote in message
> Is there any way to make a dated entry insert ...Sort by Credit Card Type on EDC Detail Report
What do I have to do to get my EDC Detail Report to show different credit
card types, like Visa, MC or Amex. Now under Tender Type, it just shows
Credit card...well...I kinda knew that. How do I fix it?
add tender types for each credit card type rather than just "credit card".
then z out. all transactions after this change will reflect what you want in
"tl" <email@example.com> wrote in message
> What do I have to do to get my EDC Detail Report to show different credit
>...Resolving Email Address to existing contact problem
Has anyone else come across this issue in MSCRM3.0? - when you attempt to
resolve an email address to an existing contact in CRM (that does not
currently have an email address stored in their details) the contact resolves
OK but does not update the email address in the contacts details.
Is this by design, or have I found a bug?
...Web query timeout setting.
I fill an Excel table using data that I take from an Internet
Unfortunately, this site is very slow and so I often get a "query did not
provide any data" error message.
How can I increment the default web query timeout limit?
Thanks in advance,
...HELP Recovering addresses and email from Outlook 2003
I had some serious driver issues that required re-installing XP from
disc. I did use the backup option and have a backup of all the old
data. And of course had to reinstall Office 2003.
Will third party software restore my old email and addresses or am I
out of luck?? Thanks for the help
> I had some serious driver issues that required re-installing XP from
> disc. I did use the backup option and have a backup of all the old
> data. And of course had to reinstall Office 2003.
> Will third party software restore my old email and addresses or am I
> out of lu...Macro for Sharepoint List and another Table?? Same # records?
I am creating a database which we have a form made up of prepopulated data
(from a sharepoint list) and also data input needed by a user (for example,
I have two tables: one sharepoint list that is linked to sharepoint website
and another table that houses the additional user inputs [table 2]. I have
linked the files based on the primary key. So, every record in my table 2
has a plus sign and it will expand and you will see the linked data from the
Is there a way that I can automatically create a record for every
corresponding record ...Use exchange from a trusted domain
I have domain a and domain b. Domain a is all set upp with exchange etc.
Domain b was bought, and they don't have exchange. I have trust between the
domains and file sharing and authentication are ok.
What we want to do is, make users on domain b and let them use the exchange
(on a seperate storage) on domain a.
The users on domain b must logon to domain b, but need to have mailbox on
Domain a are running on win2003 and exchange 2003. Domain are running on
win2003 with forest and domain ready for exchange.
thanks in advance,
Thi...Using mouse wheel in VB editor
Just tried using the mouse wheel to scroll within visual basic editor in
excel but it wont let me. How can I turn this feature on. I am using Excel
Thanks in advance.
This is a known problem with the latest MS mouse drivers. You
can either install version 4 of the drivers (current version is
5), or use FreeWheel, and freeware program at
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"fullers" <firstname.lastname@example.org> wrote in message
ne...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
d...Comments to print on invoices and packing lists
We have a client with a specific need for printing customer comments
and item comments:
1) They want to store comments on Customer Master. When a sales order
is entered these comments should default on the sales order with an
option to change. They want to mark these comments to be printed on
sales order, invoice, packing list and pick ticket.
2) Items are stored with item specific comments. These comments need
to come to the sales order when the order is entered with an option to
change. They want to setup comments with similar setup where they
print on order, invoice, pick ticket and packi...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...Unable to sort on customer CRM 4.0
When you try to change the campaign response views to have customer as
sorting CRM gives an error. You can't even click on customer column to sort
when it's now customer that is default sorting.
Is this a bug ?
same here. I think its a bug
"Help needed" wrote:
> When you try to change the campaign response views to have customer as
> sorting CRM gives an error. You can't even click on customer column to sort
> when it's now customer that is default sorting.
> Is this a bug ?
...How Use ShellExecute with a CMemFile
I need to store files of various types (such as .doc, .xls, .jpg, .pdf,
..wmv, ...) in a database. Upon retrieval of such a file I have the file as
data in memory in a CMemFile. I need to then "display" the file in the
aproriate application. If I were to write the CMemFile to disk and create
an actual file I could then, of course, use ShellExecute() to launch , say
Word to display a .doc file.
However, I would much prefer to avoid the overhead of writing the data to an
actual file and then dealing with having to detect when the User is done and
cleaning up the file I had ...LDAP Write access?
My ldap server allows Write access to entries - and a few clients now
Any plugins available for Outlook to allow this too?
None that I'm aware of.
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/
Outlook Tips by email:
Subscribe to Exchange Messaging Outlook newsletter:
Outlook Tips: http://www.outlook...sort by day of the week?
I have 10 years of grain prices...one price for each trading day of th
year. In 'A' we have the date, in 'B' the price. What I need to do i
get a list of prices for Mondays, Tuesdays, Wednesdays, etc...
Possible? (I really, really don't want to do this manually)
Message posted from http://www.ExcelForum.com
add a column = weekday(a1,1) etc and do a sort on this colum
Message posted from http://www.ExcelForum.com
Thank you. You saved me 3 or 4 hours of excruciating data entry. Thi
was the last step of a vital report. Now I can do my char...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...Using INDIRECT within functions
I learned a bit from JLathman in a previous post but tried to use the same
methodology with this formula (also learned from this Group to get the last
entered value in a column) without much luck.
The original formula was this with 2009 sheet being static:
Trying to make it dynamic I tried the following without success:
=LOOKUP(INDIRECT("2,1/(" & O1 & "!$H$3:$H$65536<>"")," & O1 &
Did I miss something or are...sorts not sorting
OK- Thanks to everyones help I now i have a list i can work with... but
there are a few problems.... the zips are all 5 digit and now i have to
sort them... the problem is, THEY WONT SORT CORRECTLY!!!!!!! The
numbers are not in order... some are but a lot are not... is there
anyway to fix this???? i need to sort them by zip code but cant seem to
get them to do it correctly.. any ideas???
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You are going to be far better of...Sorting by file extension in a worksheet
I have an excel worksheet which has a list of file names from a
directory and various stats about each file. I need to be able to sort
them by the file extension.
I would like to sort them by the ".eps" extension. I have tried using
the Data,Sort menu and something like *?*.eps as the criteria. But am
obvisouly missing something.
Any help would be most appreciated.
You could use a helper column to extract just the extension then
include this in your sort range and sort on the helper col...How to use count for calls per hour
I am trying to create a pivot table and chart that will show me the # of
calls per hour by day for a range of dates Aug 1 - Sept 19. My data looks
like this where each line is the date and time of the call:
How do I get a count of the # of the calls per hour by day?
8/1/08 12:48 AM
8/1/08 1:53 AM
8/1/08 2:36 AM
8/1/08 3:24 AM
8/1/08 3:37 AM
8/1/08 4:04 AM
8/1/08 4:44 AM
8/1/08 4:55 AM
8/1/08 4:58 AM
8/1/08 7:02 AM
8/1/08 7:28 AM
8/1/08 7:43 AM
8/1/08 7:47 AM
8/1/08 7:56 AM
8/1/08 7:58 AM
8/1/08 8:13 AM
8/1/08 8:33 AM
8/1/08 9:07 AM
8/1/08 10:28 AM
8/1/08 10:38 AM
8/1/08 10:44 AM
8/1/08 ...How export all mailbox-enabled users from the GAL using Outlook?
We have a user which, for administrative reasons, needs to export all
mailbox-enabled users in the GAL now and then. They just need all the
names. Is there a straightforward way for them to do that?
We don't want to give them any special permissions and want to avoid
server scripting. Ideally, they should be able to export it to a CSV
file or any text file.
> We have a user which, for administrative reasons, needs to export all
> mailbox-enabled users in the GAL now and then. They just need all the
> names. Is there a straightforward way fo...SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would:
1. Set the Restock Level for all items to be equal to the current on-hand
quantity for each item.
2. Set the Reorder point for all items to be equal to 1/3 of that items
I'm currently doing this manually, or using a formula in excel when items
are initially imported into the DB, but there are still several thousand that
need to be retro-fitted like this...
Thanx in advance!
UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)
UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0)
Ne...SQL 2008 running on a VM using all allocated memory
I've got a sql2008 server running on a VM. There's 9GB of physical RAM,
which 7GB have been allocated to SQL Server. But when i look at task manager,
i see that the SQL server is actually using all 7GB, which is pegging the
memory usage of the overal box at above 90% used. We're mostly a sql2005
shop, and none of those servers are doing this. I have sql2005 running on
VM's, someone actual servers as a named or default instance, and some even
clustered. None of them have this problem. Is this a normal thing with
sql2008 only? Any insight would be greatly appre...Format List Box!
Can I format a list box which has a query,so if one of the fields called
[Spelling] had the word "Spelling" it will change the colour of the font for
Thanks for any help....Bob
It's not possible with the native Access ListBox control. Instead, setup a
Subform control to resemble a ListBox and use ConditionalFormatting to
achieve the desired look. I think Arvin has a sample on his site here:
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can ben...List the UNIQUE certain fields from the database
Please help related to the above subject.
From this discussion, got the following formula which is work well and
faster for small of database.
where $G$1, the first row of DATA.
how to convert it to VBA as this time i have a huge database.
for Tab Data, Advanced, Unique Record only (works well also, but i need the
basically we would like to do similar like this: