Excel Regional Date Format Options
A client of ours in NZ is complaining that date format options for English
(New Zealand) have changed from older versions of excel (they are using 2003)
Some of their spreadsheets have dates formatted as dd-mmm-yy, mmm-yy and
dddd,dd,mmm but these options do not exist anymore.
Is there anyway to add options to this list without using the custom format
I just compared the Excel 97 and Excel 2003 built-in date formats and they
are mostly unchanged. 2003 has a few more but I don't think there were any
subtractions. The formats dd-mmm-yy and mmm-yy are righ...CRM / SQL Reporting Co-Exist
We are trying to run Microsoft CRM and SQL Server Reporting on the same
server. We have experiemented with several approaches but with no luck.
Either SQL Server Reporting's Report Manager will not run with an error that
session state in disenabled in ASP.Net or I get an error that there is a
problem with the assembly Microsoft.CRM.Platform.Types.
Does anyone know where I could find a document on how to make CRM and SQL
Reporting co-exist on the same or server. It must be possible since many
people run Small Business Server 2000 or 2003.
...Crazy Sorting Problem.....
Ok so I have colums A though D that need to line up with E through P. I have
a common symbol in D and F. I need to get rid of everything in colum A
through D that does not line up with the E through P useing the common symbol
as a referance. I am right now deleting extra info by hand. Please help.
see your other post
> Ok so I have colums A though D that need to line up with E through P.
> I have a common symbol in D and F. I need to get rid of everything in
> colum A through D that does not line up with the E through P ...WaitForSingleObject Problem
I use WaitForSingleObject(hProcess, INFINITE) to wait for execution of
the MS ActiveX Control Pad Setup (started out of my application).
CreateProcess(NULL, "setuppad.exe", NULL, NULL, FALSE,
DETACHED_PROCESS, NULL, NULL, &startupInfo, &processInfo)
At the beginning of installation everything is fine, but after a
little bit of time, the CPU usage is 50% and nothing is going on (it's
after searching for installed components).
When I don't use WaitForSingleOb...Problem Syncronizing.
HI, I have problems with a syncronized store that I had
to syncronize again from the beginning. Give me alot of
TIme out when I use the 401 Worksheet. Since some of the
data is in the HQ Database I would like to know if there
any operation I can do so then tell to the HQ client that
I just want to upload some information?. Thanks in
advance for your help.
Go to Manager, Help, About. If your version is 1.2.0151
you have a version that won't work with Global Customer
turned on. Contact MBS and ask for a Hot Fix to address
this issue. Install the Hot Fix on all PC...INSERT INTO problems
I hope this doesn't appear twice, I did it a while ago and it never
came up! So here goes again!
I am trying to use INSERT INTO to insert one record in to a table (tna
feedback) in two fields (USER ID: and DESK/LAPTOP).
The values are generated by two different forms; stUser comes from
this form and stMachine comes from another form which has been hidden
once the user has chosen the value. This part works fine.
However, every time I run it I get an "Incomplete Query clause" error
message but can't fidure out what I've done wrong!
Here is the code:
Dim SQL ...Access 2000 Package and Deployment Wizard problem!
I have created an Access 2000 application that I now wish to distribute to
users as an MDE file. The Access 2000 Package and Deployment Wizard does a
fine job of storing the relevant installation files on a CD, exploiting A2K
However, I would prefer to let users download my application from a website.
The Package and Deployment Wizard offers a 'Web Publishing' deployment option
that appears to address this need. My only problem is that it doesn't work
for me. I get the following error message,
Unexpected error number 48 has occurred: File not found: WebPost.dll
I...Vendor summary report
Hi, This is my first post here. I am trying to generate a report in GP V8.0
that will allow me to identify local vendors (by zip?) and provide a summary
total of how much we have purchased from them during different time periods.
Thanks in advance for any help.
Have you tried to create a smartlist under payables transactions? You can
then export to excel and sort and subtotal any way you like.
> Hi, This is my first post here. I am trying to generate a report in GP V8.0
> that will allow me to identify local vendors (by zip?) and provid...Can I see the summary report of each resouce's booking status ?
Here we using AutoAcceptAgent to booking resource account like meeting room.
Is there any method to view the summary report ? for example, a summary
report show which meeting room booked by which one for what agenda. I have
tried to use public folder with email address, but can't register by
AutoAcceptAgent. Any one has any idea of such request ? Pls help soon. Thanks.
On Thu, 20 Jul 2006 19:14:02 -0700, Enid
>Here we using AutoAcceptAgent to booking resource account like meeting room.
>Is there any method to view the summary repor...Count problems[Excel 97]
I did a search on the forum to find an answer to my question but didn'
Here is my prob :
Lets say I got this page->
1 Name Type Job bla
2 Name Type Job bla
3 Name Type Job bla
4 Name Type Job bla
5 Name Type Job bob
I want a Cell to write how many row I got( 5 in this exemple) and onl
count the cells with bla in the D column(4 in this exemple).
Sorry if I'm not really clear but if you can help me feel free t
-----------------------------------------------------------...Problems with german characters (umlaute)
it happes every months that a mail reaches us with I don't know how coded
german characters. Our german customers are calling us, asking what we're
missing on our system.
I've checked one of these mails and the only thing I found out that the
codepage, which was specified in the header, was the same than in the other
mails I've in my mailbox and which I can read perfectly.
The strange thing in current case is, that the email is displayed correctly
when the mail is opened in Outlook Web Access.
I need some help how to get hand on these problems.
Many...reported error (0x80070057)
When I try to send an email to several addresses using Outlook 2003, I get
Task 'xxx - Sending' reported error (0x80070057) : 'Could not complete the
operation. One or more parameter values are not valid.'
I see no apparent problem with the addresses. Please tell me in simple
English (well, as simple as possible) how to solve this problem. I am not an
What type of mail account is this? Exchange, POP3, IMAP?
"lemonscented" <email@example.com> wrote in message
news:EC994AB1-B72B-4...looking for cash drop and paid out reports
Does anyone have a report on these transactions that can be selected by date?
Any help would be appreciated.
I wrote a formula in a cell that contains the following:
=countif(f5:f268,"> char(32)") / countif(e5:e268,"> char(32)")
I have verified that any unused cells have blanks spaces in them.
Both columns have data in the same rows so the counted value for each
column should be the same but it isnt. All cells contain only numbers or
letters and the cells format is general.
Not sure I get it, but try
=countif(f5:f268,">"&char(32)) / countif(e5:e268,">"&char(32))
"psion" <firstname.lastname@example.org> w...Problem with printing listbox bigger than one page
I created form "Invoice". It contains few list boxes (like: Brand,
Product, Price, etc.). Each list box is big enough to display 50
items. It works in this way: user is chosing product from table
Products_tbl and clicks on "Add to invoice" button which adds to each
list box new item containg apropriate information about chosen
product. At the end, user can print the form. Before it was limited,
and user could put max. 50 products on one invoice, but I wanted to
get rid of this limitation. I did it in this way: after 50th item,
with each added product I extend list boxe...Carriage Return/Line Feed Problem
I wrote some code that gets the HTML from a Web page and stores it in a
buffer, then I display the buffer in a big multiline CEdit box. The problem
is that on many pages I don't get new lines, I just get a thick solid
verticle line kinda like this: || where it should return.
Also, if I view the pages (view source) in Notepad they look fine.
Most pages do that, but interestingly Microsoft pages do the proper new line
and look great in my edit box.
Maybe I have to replace all the \r with \r\n or something like that ? Does a
\r\n still only take up 1 char ? I download the page in...Conditional formatting help #4
My problem is that, that i want to ignore blank i mean i had set a
conditional formatting say
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
If value in ColA is less than value in ColC, cell A1 is shaded blue OR
value in ColB is greater than value in ColD, cell B1 shaded blue.
I have done above formatting but my problem is that if i dont enter
anything in colC then also colA is shaded in blue similarly if i dont
enter any value in colD then also col B is shaded.I mean i want to
ignore the blank.I need , if col C is blank then the Col A must be
normal .& if col D is blank & i ent...Audience rule, problem with Domain Local Group.
I try to create a rule for my audience on Portal 2007
User = Member of --- some Domain Local Group (I need to add people from
other trusted forest)
But it can't be relolved :-(
I checked it on 3 Portals, no luck
I cam only create such a rule: Work e-mail Contains @needed_domain.com
or add individual accounts from those domains, but there are 1000, too hard
to add manually ....
Please help. Perhaps there is another way
These groups need to be either Global or Universal groups. Universal groups
are better for SharePoint, and they can contain global...FRx
I encountered problem of changing default base period.
The version of FRx software is 6.5.28 and it is running under Windows
The situation was:
After opened the Catalog of Report Window, there was a pop-up message
box which said 'Changed the default base period to C'. I did not know
why this could happen.
- Would you please tell me under what circumstances this pop-up message
box would display??
In order to continue to use this software, I only could click 'OK' from
the message box. The report date is then changed to 'Default Base
Period' - (Ja...backup problem
Hi I had installed backup for office 2003, I had been backing up to a
I had removed the disk and kept getting messages that was unable to back up
to removable disk, even though I have turned off all automatic backup
I have since removed back up "feature" but still get the 4 or 5 steps
stating unable to find disk etc, any ideas how to get rid of this wonderful
If by removed you mean 'uninstalled' then it would appear the uninstall
In OL ensure backup is not selected within Addins
"Tim&...VFW, webcam, image format
I'm trying to grab pictures from a webcam with Video For Windows (VFW).
The source code I use is the following:
HWND _capwnd = capCreateCaptureWindow("Capture",WS_POPUP,0,0,1,1,0,0);
HBITMAP hBmp = (HBITMAP)GetClipboardData(CF_BITMAP);
GetObject(hBmp, sizeof(BITMAP), &bmp);
int size = bmp.bmWidth*bmp.bmHeight*bmp.bmWidthBytes;
unsigned char* data = new unsigned char[size];
I upgraded from Outlook 2000 to 2002 and now every time I open Outlook I get
a Microsoft LDAP Directory window with Server Name, Port, User Name, and
Password. What is this thing and how do I get rid of it?
Remove .spamnot to respond by email
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 11/7/2004
You can remove the LDAP address book provider via Tools | Email Accounts |
View/Change address books. (Might be listed as Active Directory or LD...shortcut/hotkey-problem
I have set a custom hotkey to a shortcut/program on my Windows XP Start Menu
(CTRL-ALT-B). However, this programlink was deleted. If I now try to
reassign this shortcut, it does not work - it seems that the combination has
been still reserved for a non-existing link. Is it possible to unmap the
combination to map it then again?
Hopefully someone can help me.
Thank you, Johannes
Perhaps the info in this thread will help.
johannes pfeffer wrote:
> Hello NG,
...Outlook 2003 Personal Address Book forwarding problem
This Outlook 2003 is connected to a Exchange 5.5 Server
The problem is this, everytime I try to forward any e-mail and use any
distribution list on the Personal Address Book it does not want to send the
e-mail but if I try to send it any other way it works fine.
...Both sides of a report page
Is there a way to utilize both sides of a report page as if printing a book?
On Wed, 9 Jan 2008 08:06:03 -0800, TRS <TRS@discussions.microsoft.com> wrote:
>Is there a way to utilize both sides of a report page as if printing a book?
Yes. But it is dependant on the printer your using, not on Access.