Sort by Last Name #2
Sorry if this posted twice. I have waited about 1/2 hour and my original post is not showing up. I am sure I phrased this better the first time but here goes.
I am using Crystal Reports to extract data from our practice management system which stores the patient's name as last_name, first_name, i.e. Doe, John F. i then run a formula in Crystal Reports to switch the name around to John F. Doe. I then export the file to Excel (simple name address c/s/z file) they use for mail merge of letters and other fun stuff through out the year. Once the data is in Excel, they want to be able to ...Unable to Edit/Add records on Form in a New ADP
I just started playing around with rebuilding a MDB file as an ADP. I built
a form and subform from scratch, but I'm unable to edit or add records.
SELECT Id, LoadDate, TrailerDOTNumber, SealNumber, SealDate, SealId,
LoadLocation, LoadStatus, DispatchStatus, DispatchLocationId, DispatchUserId
FROM TrailerActivityHeaders ORDER BY LoadDate
Recordset Type: Updatable Snapshot
I'm getting the 'This recordset is not updatable'
Never mind... (Does anyone have a spare bandage btw? I cut my head banging
it on the wall due to my stupidity...)
"D...Unable to open calendar
Folks, i cannot open or view my calendar.
When I start Oultook a Pop Up appears saying "Could not read the Calendar"
On clicking Ok, the pop up vanishes and nothing happens.
If i then go over to my calendar, it says "Cannot display the folder"
I have run Oultook Diagnostics and nothing shows up as irregular. I ran the
repair function (off my setuo CD) and nothing happened. I also re-installed
Outlook and rebooted my comp and nada.
When staring in safe mode i also get he same errors.
I am using Off 2007, Win 7
"phamiltonsmith" <...Mail Box Size #2
I have a user with a 6 gig + mailbox. We are using Exchange 2003
(enterprise) and Outlook 2003. He is now experiancing problems with the
program running like a slug. It doesn't appear to be locking up, just
taking for ever to do everything. He claims it was fine until front page
crashed, which took the computer down (needing a re-boot) and outlook hasnt'
worked right since.
So what I have done, is delete the profile and recreate, appear to work for
me, but now is locked up again. The auto archive does not appear to
removing items from the mailbox.
Does anyone hav...unable to download emails and unable to stop synchronization
I am going to try one more time to get this fixed. My Outlook 2003 has been
unable to download emails. While it is trying, a small box in the tray
section shows up and it states that it is trying to synchronize folders.
After a time out time Outlook gives me errors. This is the error message. It
has these numbers 0X800CCC15 , or 0X8004210A, or 0X8004210B, which these
error messages state that either I did not have enough timeout or look and
see if server name is wrong. All of you have given me these suggestions. no
joy. Thank you very much however.
I went ahead and finally found a sect...Version 3.0c with Update Rollup 2
According to http://support.microsoft.com/kb/927751/en-us the updated files
in the CRM client with Update Rollup 2 should have a datestamp of
I have been testing deployment of the rollup on a PC which initially had the
"compatibility update" version of the client installed (CRM_V3C_CLIENT.ISO)
and the updated files have a datestamp of 1-Jun-2007. Is this normal?
PS The file version of the updated files is 3.0.5300.1558, as expected.
...? Rich Edit Formatting Lost When Inserting At Position 0
I'm using a CRichEditCtrl but am having trouble with the formatting. I
use SetSel and ReplaceSel to insert text into the control and if the text is
inserted in the middle or at the end of the control's buffer it works just
fine but if I insert it at the start (SetSel(0,0)) then it takes on the
formatting (both character formatting and paragraph formatting) of the text
immediately after it (the text formerly at 0). There is a small note about
ReplaceSel in MSDN:
"This function will format the inserted text with the existing character
formatting. When replacing the e...Sending Mail #2
I want to be able to allow a set of users to send INTRANET & INTERNET mail ,
another set of users to send INTRANET mail only.
Is there a way in which this can be done in Exchange 2000 srv.?
"cozierj" <email@example.com> wrote in message
> I want to be able to allow a set of users to send INTRANET & INTERNET mail
> while allowing
> another set of users ...Out of memory #2
I developed a workbook that has some macros for sorting
and condensing several sheets to a single sheet in a
workbook. When I run it everything works fine, but other
get an out of memory error. I'm assuming that this might
not be just an Excel issue. The workbook at this point is
only 365kb and will only become larger with time. I've
been running it from a local drive, other run it from the
network. I have no idea where to start with this issue and
any input would be appreciated.
I think that the size of the workbook has nothing to do with the problem.
The error...Trial Version #2
I downloaded a trial version of Publisher 2007 yesterday. The site says it's
a 60 day trial...now after less than 24 hours it has told me my trial has
expired. I have tried uninstalling and reinstalling, and then I tried
redownloading the program to start over. Any help on how I can get this
trial copy to work like it should?
> I downloaded a trial version of Publisher 2007 yesterday. The site says it's
> a 60 day trial...now after less than 24 hours it has told me my trial has
> expired. I have tried uninstalling and reinstalling, and then I tried
>...unable to scroll the page
on microsoft office frontpage 2003 - when i up loaded my web pages to my web
site www.millertimeauction.com , there is no sroll bar for up & down of page -
it scrolls for me in IE8
scroll bar will only appear if it needs to
Microsoft MVP Expression Web
"FrontPage Error" <FrontPageError@discussions.microsoft.com> wrote in
> on microsoft office frontpage 2003 - when i up loaded my web pages to my
> s...Unable to start POP3, NNTP, IMAP4...
I'm evaluating to install Exchange 2003. After the installation I find the said protocol haven't been started. I tried to start
them in "Servers --> Server Name --> Protocols" but no help.
Please comment.... Thanks!!
Windows 2003, Exchange 2003, Active Directory DC with all roles of FSMO as it's the first DC in the forest. Thank you very much!!
Are you boring? Let's come to talk together... ^^
Those services are disabled by default in Exchange 2003. Go to
Administrative Tools, Services and enable...Plotting data in Excel #2
Is it possible to generate a cell range mathmatically using formulas and
"Concatenate" in one reference cell, and then use the contents of the cell to
define the data range for an X-Y plot?
In other words, instead of manually selecting the data range to be plotted
using a pick box, I want the reference the contents of a cell that has
computed the data range.
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 p...importing .pst file #2
I recently tried to import "outlook.pst" from one
computer running Office 2003 to another running same. I
imported "archive.pst" w/ no problem. When I attempt to
import "outlook.pst", I get an error message that says
one or more parameters are invalid. Can anyone help?
Try here I got some good answers..
"Phil" <firstname.lastname@example.org> wrote in message
> I recently tried to import "outlook.p...Personal Folders #2
Hi, I really need some help...........
I made a personal folder and always put my emails in
seperate sub-folders after I read them. We have to keep
our inbox fairly small or the server statrts yelling at
PROBLEM! My personal folder is now just over 2gig in
size. Outlook 2000 won't let me access the file. It
says there is an error and to use the inbox scan to fix
it. I use SCANPST.EXE, but even it comes up with a error.
Is there a 3rd party program that will let me access this
file? Maybe I can go in and delete some things to get it
below the 2gig limit.
Please email m...Unable to conect
I have set up my email account to work with aol using the guidlines for
outlook 2002 but it is still unable to connect. Any suggestions? Thanks.
John <John@discussions.microsoft.com> wrote:
> I have set up my email account to work with aol using the guidlines
> for outlook 2002 but it is still unable to connect. Any suggestions?
Since you pay AOL for their service, my suggestion is to ask AOL.
...2 different recipient update policies
If i have 2 different RUS policies. Which will be a users default
reply address? The lowest prioirty because it is applied last, or the
highest priority because it is more important?
The highest priority Recipient Policy that does not exclude the recipient is
How the Recipient Update Service applies recipient policies
MVP - Exchange
NEW blog location:
<email@example.com> wrote in message ...Counter #2
I need to have a counter that will count the number of x's in a column how
can this be done?
Thanks for the help
> I need to have a counter that will count the number of x's in a column how
> can this be done?
> Thanks for the help
Thanks very much for all the help
"Peo Sjoblom" wrote:
> Peo Sjoblom
> "Polina" wrote:
> > I need to have a counter that will count the number of x...Unable to click on charts & unable to create any new charts Excel
Just started using Microsoft Excel 2007 and I seem to have done something
that means the chart option is unavailable. The chart section is now grey
and all charts I have created are 'locked' I cannot click on them anywhere.
I'm working on a project and need it finished by Monday.
Do you mean that if you click on a chart it does not get a border to show it
is activated and there are no range-finder borders around the data that
makes the chart?
This is a bit odd.
Have you tried a new workbook to see if the problem is with just this one?
My advice with all odd things is...how can i insert a holegrame inmy publication
if it's an image insert it like any other image...except if you mean
"hologram" I kinda doubt you can make it work.
As good as inkjet printers are, production of 'holegrames' is presently
beyond their capabilities..
"marcus" <firstname.lastname@example.org> wrote in message
Where would you get a hologram?
If you mean those shiny pictures that change when you look at them from
different angles and look sort of 3D (like they put on a driver's license
somewhe...MSXML6 C++ unable to locate node
Hi, I am new to using the MSXML functions in C++. I found this on MSDN as
an example of what I wanted to do,
I have tried a number of XPATH examples to try and retrieve the
"><Code>12455</Code>", but have been unable to do so. The MSDN example works
fine. So, I am wondering if it's a namespace issue?
Any help would be appreciated. Thanks. Jeff
I have changed the code as follows:
int _tmain(int argc, _TCHAR* argv)
CString sResponse = "<?xml version=\"1.0\" encoding=\"utf...Tab Name #2
How can I display the tab name on a sheet? I'm looking to have a template
that pulls the name of the tab that I assign and displays it in the sheet.
Something similar to "&TAB" used in the Header and Footer option.
See Bob Phillips' site for formulas.
Gord Dibben MS Excel MVP
On Mon, 18 Sep 2006 13:58:02 -0700, Cantru <Cantru@discussions.microsoft.com>
>How can I display the tab name on a sheet? I'm looking to have a template
>that pulls the name of the tab that I assign and di...I am unable to send e-mails -unable to download files from IMAP.
I am so frustrated with this
ajmtextiles <email@example.com> typed:
> Please help.
> I am so frustrated with this
I can understand why you might be frustrated, but you've provided no useful
information for anyone to go on, so I doubt anyone can help you. When you
post in here, always include your version, SP level, and mode (if
applicable) of Outlook - you can find this information in Help | About. Also
include the type of mail account(s) you use and any other pertinent de...Skinning dialogs? #2
I have 2 questions about CDialog skinning...
1: I'm handling the OnNcPaint and OnNcCalcSize, but always when it is the
first time the window is drawn, when I click on the caption, it draws a
border around the caption, and then it doesnt happen anymore... No idea
2: How can I draw the Min/Max/X buttons also?
Hope you can help...
...'OWA was unable to get to your inbox'
OWA is working fine for everyone on my domain (and has been for years)
except for one person. When he logs in it gives the error mentioned above in
the subject line. I've checked his exchange account and it doesn't seem to
differ from anyone else's...
Does anyone know how to solve this problem?
Repost in an Exchange group as OWA is a function of Exchange, not Outlook.
When you do, include the Exchange/Windows versions, and SP-level for each.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to