I am currently using validation ina cell on many pages to se the mode
using vba how do i change the validation cell value ?
Just set the value
Range("A1").value = "some value"
be aware that DV will not check it for validity this way.
(remove nothere from the email address if mailing direct)
"Alexandre Brisebois (www.pointnetsolutions.com)"
<email@example.com> wrote in message
> I am currently using validation ina cell on many pages to se the mode
&...trying this out
This is a test posting.
On Tue, 13 Nov 2007 16:06:51 +0800, "hmmmm" <firstname.lastname@example.org> wrote:
>This is a test posting.
Please use microsoft.public.test or microsoft.public.test.here for your
testing. This is a working newsgroup. If you have questions about an Access
database, please post them.
John W. Vinson [MVP]
...Exporting Word 5.1 addresses to Office 2004
Is it possible to export addresses from Word 5.1 envelope function to
Office 2004? I find this tool is very clunky in Office 2004.
Thanks.......Arnie~~~Silver Spring, MD
We're not ignoring you, we don't know :-)
The envelope is saved as part of the template in Word. If you copy your 5.1
template to your new computer, it should just work... Try it...
On 30/12/06 1:50 AM, in article
> Is it possible to export addresses from Word 5.1 envelope function to
> Of...I am trying to round up to the nearest 25 cents
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP
In article <2DB8F007-1E27-4A48-923B-C7D4D0238B5E@microsoft.com>,
sypher <email@example.com> wrote:
> I am trying to round a money value to the nearsest 25 cents and it keeps
> rounding to the nearest dollar HELP
"sypher" <firstname.lastname@example.org> wrote in message
> I am trying to round a mone...Graph intra-day stock data
How do you graph intra day data (Date, Open, High, Low,
Close) format. Where the Date includes the time: (2/22/04
9:00 AM format). Currently, I get a chart with all the
individual 30 min bars being grouped into just a daily
bar, I would like individual bars for each half hour.
The easiest way would be to use a XY Scatter chart, rather than a Line
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <email@example.com>,
firstname.lastname@example.org...Deletion Service CRM 4.0
Deletion Service in CRM 4.0
We have a CRM 4.0 Enterprise installation and have a question about the
deletion service which we understand to be controlled by the CrmAsyncService.
We used the data migration tool to import in 74,000 leads to test the system,
then used the same tool to delete the data (only leads). The deletion process
completed successfully but when interrogating the backend SQL database
noticed that all 74,000 leads are still in the system. They are marked for
deletion by the DeletionStateCode=2 but never get deleted. The end users
never see these records but am concerned...exporting report to 1 html page
I have a report that when run shows our current open positions. I can choose
to export the report in html format, however it does so and makes 3
different html files, one per page. I want to put the html file in our
web-site via Dreamweaver so I want it to create just one file with all the
listings instead of one file per page. How can I do this?
As far as I know, this feature is not available. Please rest assured that
your feedback on this feature is routed to the proper channel.
Also, you may want to consider SQL Server Reporting Service. You could use
...Trying to clear up Received but not invoiced report
I am trying to clean up the received not invoiced items. The problem
began with entering a purchase order and then not matching the invoice
to the items received agaisnt the purchase order. SO we thought that
doing a returned transaction entery would solve the problem. The only
thing is now the return shows up on our Received/ Not invoiced report.
And the report is becoming a huge mess and difficult to use. What is
the best way to clear up items that have been received but were not
matched and already paid through the invoice entery?
There is a knowledgebase article on this very thing av...send/receive (2nd try)
New computer. Microsoft XP Home. Microsoft Office XP
Small Business 2002. Earthlink dial-up account. Two e-
mail accounts. After opening Outlook, 1st send/receive
(option 3, all accounts) usually prompts for both
passwords, downloads messages, all good. Next time,
though, no prompt for account 2, error cannot connect to
server, account 1 usually gets messages. Every five
minute send/receive option eventually degenerates to
cannot connect to server errors for both accounts.
Meanwhile internet browsing slows to a crawl. Any ideas?
...New CRM 1.2 installation login problems
I'm sure this has been asked before but my searches did not turn up
anything that matches so ...
I just installed CRM 1.2 on a box running SBS 2003 Premium with SQL
Server 2000 SP3a. Everything went fine during the installation. I
followed the procedure in Microsoft's document found here:
After installation, when I try to browse to http://crmweb from a
computer joined to the domain, I get prompted to provide user name and
password credentials. After providing them three times I get a 401.1
error ...CRM 4.0 Cisco Unified Connector
Does anyone have any experience with the Cisco CRM Connector
in terms of hardware/software requirements, configuration…etc I am also not
sure if the connector for CRM 4.0 is available…
I believe the 4.0 Cisco connector is due for release imminently... :)
...business cards #4
Hi, I'm using Microsoft Publisher 2000 for the first
time. I have made up some business cards and am about to
cut them out. I know from other programmes that I have
used before that you can display cutting guidelines for
using a guillotine. Does anyone know if this is possible
with Microsoft Publisher. Any help greatly appreciated.
Don't use perforated card stock?
Vancouver, USA - One of the great cities in one of the 45+ countries in the
"Debbie" <email@example.com> wrote in message
This is a multi-part message in MIME format.
I am actually surprised at Microsoft. I have always wonder why they =
never implemented the new reader into Outlook. I understand that Outlook =
Express was made for home users which need basic email functionality. =
But as an office user we use Outlook heavily for email, collaboration, =
contact, etc.. It is a real pain to have to open and configure Outlook =
Express as well just to be able to use Newsg...How do I cancel a msg Outlook keeps trying to send unsuccessfully?
How do I cancel an "in process" email Outlook keeps trying to send
unsuccessfully due to a huge email message I tried to send with way too many
attachments? It's stuck in "send" mode, and as a result, I can't send any
emails because Outlook cannot get past trying to send this message. How do I
cancel a pending outbox transmission while it's trying to send? I've tried
everything I can think of to no avail. Please help!
Angelczech wrote on Fri, 12 March 2010 07:32
> How do I cancel an "in process" email Outlook keeps trying to send
...Select TOP 4 Records For Each Group
I have a query that I need to select the TOP 4 records for each distintive
2 Columns of data(Charge and ICV). Charge is an integer and ICV is a single.
I need to get the TOP 4 ICVs for each charge. How do I set Grouping and/or
Summing to do this?
Subquery basics: TOP n records per group
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tirelle" <Tirelle@disc...Page breaks #4
Can anyone enlighten me to the use of page breaks ?
I thought if I were to "insert page break" in a spreadsheet where the print
range had already been established
the printer would automatically divide the print to two pages
but this does'nt happen
What am I doing or not doing?
Go to Page Setup, tab Page and make sure Fit to x by x
pages is not ticked.
>Can anyone enlighten me to the use of page breaks ?
>I thought if I were to "insert page break" in a
spreadsheet where the print
>range had alread...trying to insert a 0 in front of zipcode
Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels with...about
700 of them but the problem is my zipcode column there needs to be a zero in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
One of these
1) format the cells with custom format 00000
2) format the cells with Special / Zip Codes
3) format the cells as Text
4) begin all zip codes with an sin...error message when trying to install WMP 10 or 11
My operating system is Windows XP Home Edition 2002. I'm trying to download
either WMP 10 or 11 and I get a message saying it was not possible to
complete setup, see webhelp for more assistance, however there is no
additional information when I click Web help. the Error message is 8007F0DA.
Can anyone help me? Thanks.
On Tue, 30 Mar 2010 07:54:01 -0700, Nate
>My operating system is Windows XP Home Edition 2002. I'm trying to download
>either WMP 10 or 11 and I get a message saying it was not possible to
&g...Avoid automatic text to column split while pasting data
I am copying data from Access and pasting it in Excel. The column containing
"LastName, FirstName" is automatically getting pasted in 2 columns. I want it
to get pasted in one column only.
I need it to be
You probably used Data>Text to Columns>Delimited by "comma" for some other
Excel remembers this.........thank you much<g>
Run through Data>Text to Columns with some dummy text and change the delimiter
Gord Dibben MS Excel MVP
On Wed, 25 Jun 2008 09:41:00 -0700, Query...ADCtool step 4 reports too many objects
I am in the process of migrating from an nt4 5.5 exchange server to a
win2003 exchange 2003 server.
The problem is with step 4 of ADCtool. It completes the first pass ok
(reports 254 objects in 5.5 that are replicated to AD) but then says
that objects exist in AD that aren't replicated to 5.5 (items
I realised that there were some duplicate contacts and conflicting dist
groups in AD and deleted them thinking this would fix the problem. It
didn't. The strangest part being that the number of ites processed
(279) didn't go down.
I turned the logging level...DON=?ISO-8859-1?B?uQ==?=T OPEN MICROSOFT EMAILS!
I think you get the point!
However, none of them are actually coming from Microsoft, so it's somewhat
Doug Steele, Microsoft Access MVP
"Ryan McLeod" <firstname.lastname@example.org> wrote in message
> I think you get the point!
...split commissions on order and transfer it to invoice
Customer would like to be able to split commissions between different sales
people on an order and then be able to transfer it to an invoice without the
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 pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolution...error message when trying to delete messages in inbox
I cannot delete messages in my email inbox. When
attempting to delete messages, Outlook says "The messaging
interface has returned an unknown error. If the problem
persists, restart Outlook. I continue to get the message
even though I restarted Outlook. My mail works fine, but I
just cannot delete anything. Does someone know a solution?
Can you delete them if you hold shift as you delete? How many items are in
the deleted items folder? Are you using any type of AV scanner on the
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coa...account blocked error code: 550 5.3.4
I get this error message when trying to send email. I don't believe that I
have violated the term. Please unlock my account.
550 5.3.4 Requested action not taken; This account is currently blocked
from sending messages. If you don't think you've violated the Windows Live
Contact your ISP's Customer Support and not WLM
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"1martian" <1martia...crm 1.2 to crm 3 upgrade time out
CRM upgrade from 1.2 to 3 is failing with a timeout issue on a very large db
15:06:31| Info| Adding attribute :StatusCode To Entity : Email
16:06:55| Error| Install exception.System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Reflection.TargetInvocationException: Exception has been thrown by the
target of an invocation. ---> System.Data.SqlClient.SqlException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.