Can't enter data in query datasheet
I have a query (involving multiple tables) that I want to execute and then
use to enter/change data via the datasheet which results from the query.
On most queries, I am able to do that. One this one, I can't. What is the
criteria for determining what queries will allow data entry and which queries
What do I have to do to this query to allow data entry?
SELECT [4GateMeetingTimes].Time, ActivityTbl.Activity_ActivityKey,
ActivityTbl.Activity_Pl...install ssis on windows server 2003
I can't install SSIS service on my windows 2003 server.
SSIS service won't show up in the SQL Server Configuration Manager's
services list after i perform a full install from SQL Server 2005 SE
installation CD on my server. During this install I've selected a choice for
I have Microsoft Windows Server 2003 R2, standard x64 Edition SP2 installed
on the server.
I am able to run .dtsx package on the server from BIDS, but I can't run the
same script from commandline using dtexec, because there is no SSIS service
running. I get...SQL Server 2008 and CRM 4.0
Is CRM4.0 supported using SQL 2008 as the backend database? If not is there
any plans to do so?
Ignore this, I just found the new Implementation Guide which includes SQL
Server 2008 support details.
> Quick question,
> Is CRM4.0 supported using SQL 2008 as the backend database? If not is there
> any plans to do so?
...How can I?
I have a list of 32 numbers ranging from 166.80 to 4,231.22 in cells
R1:R32; there may be duplicates but there are no negatives and all are
to 2 decimal places.
I also have a total of 16,496.42
Is there a way finding a combination of cells within the range R1:R32
that equals the total of 16,496.42?
Thanks for any responses,
"DaveMoore" <firstname.lastname@example.org> wrote:
> Is there a way finding a combination of cells within
> the range R1:R32 that equals the total of 16,496.42?
Yes. But you might have to run through as many as 4,294,967,295...I can't get my letterhead to only appear on the first page of a l.
I can't get my letterhead to only appear on the first page of a letter. I
have tried using "different first page", but the letterhead keeps deleting
from the first page, but stays on the remainder of the pages. What am I
See http://word.mvps.org/FAQs/Formatting/NumberingFrontMatter.htm (for 2003
and prior) or http://www.word.mvps.org/FAQs/Formatting/front_matter_2007.htm
for details on how to have different Headers and Footers, etc. in one
document.Hope this helps
> I can't get my letterhead to only appear ...I can't resolve Error number: 0x80070020 downloading windows updat
Hi! While downloading windows updates to my computer I keep getting Error
number: 0x80070020. what can I do?
February 24, 2010 You receive error 0x80070020 when you use the Windows
Update Web site or the Microsoft Update Web site to install updates
> Hi! While downloading windows updates to my computer I keep getting Error
> number: 0x80070020. what can I do?
...Information service not configured
> Help! Does anyone know what's going on here? I keep
> getting the following message when receiving mail:
> "This information service has not been configured.
> Select an existing file to configure, or type the name
> a new file to create."
> If I hit OK (the only selection available) a dialog
> appears with a list of .pst files. No matter which one
> select, I just end up back at the initial error
> If I select cancel in the dialog, I go back and forth
> between the error message and the dialog several times...Mails are send out after restart the server
I have installed Exchange 2003 Enterprise, in the exisiting Exchange 2000
Ent. Organization. All went smoothly and I was able to move my mail box to
new server, and I was able to log in. For test I send one message to
internal user and did not received. So I rebooted the server and message
went to that mail box. I tried again to send he message internal and then
external. Again few hours I call both user (internal and externa) and did
not received the mail. I restarted again the server and they receive.
However I can receive emails from outside world and also fro...How to ensure recipient can't change message
Is there a setting I can put on a message I send so that the recipient is
prevented from changing any of the content, including attachments? Would
this apply even when the recipient forwards the message?
Use F1 help to read up on the topic of message sensitivity.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head scratching, Hall asked:
| Is there a setting I can put on a message I send so that the
| reci...can comments move themselves when you hide columns?
Comments in an Excel sheet seem to absolutely positioned, so that when I
hide some of the columns in my sheet, the comments stays where it was, way
off to the right of the columns that are still visible. Is there anything I
can do about this?
I've never seen a way to keep them where they belong.
But Debra Dalgleish posted some code to move them back when they get too
Jamie Martin wrote:
> Comments in an Excel sheet seem to absolutely positioned, so that when I
> hide some o...can i change plot area colors for different date ranges
if i want to shade the plot area of a chart diferent colors, for example gray
from Jan 1 through Fed 17, then white until March 10, is that possible? Will
want to change the shadinging preiodically and fairly frequently.
You should be able to use the technique explained on Jon's page
> if i want to shade the plot area of a chart diferent colors, for example gray
> from Jan 1 through Fed 17, then white until March 10, is that possible? Will
> want to change the shadinging pr...Can't edit my word document!
Operating System: Mac OS X 10.5 (Leopard)
I created a new document, saved it. Went back to edit it and make changes and I can't. No curser even appears for me to select a word to change. I can add and remove text boxes, but nothing else. It's behaving like a PDF... but it's saved as a doc.x <br><br>Please help! Thanks!
Answered elsewhere... Please stick to your original thread so we can keep
track of things.
On 7/04/10 11:02 AM, in article 59bb6991.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <sun...Error on CRM, SQL Server, SQL Reporting Services configuration doc
The file: "Additional Setup Tasks When Microsoft SQL Reporting Services Is
Installed on a Separate Server from Microsoft CRM 3.0 or Microsoft SQL
Server" contains an error that may result in confusion.
On page 2-3, Configuration 2 (Figure 3) shows CRM and Reporting Services on
a single server and SQL on a different server. Configuration 3 (Figure 4)
shows Reporting Services on one server and CRM installed with SQL on the
On Page 4, the Configuration descriptions shown in the summary table are
reversed. That is, Configuration 2 shows Server 1 with Reporting Ser...Events template
After experimenting with Access for a few weeks, etc I am now using the
Events template to create a database of events... but things are not working
as I expected.
Here is what I have done so far:
I added fields to the Events Table (in Supporting Objects) - things like
"Date of Event" "Catering Option" and a few others - text boxes/ check boxes.
I used the Event Details form (in Events) to add the events we currently
have booked. This filled in the Events Table - but not the Events List (in
Events) which I assumed was fed from the table.
I then adde...pop3 server
When i open outlook 2000 i get a setup wizard and it asks
for a pop3 server and an outgoing stmp server. i don't
know what those are.
These details are supplied by yr ISP
They are required if you have an ISP email account, as opposed to a web mail
"newell" <firstname.lastname@example.org> wrote in message
> When i open outlook 2000 i get a setup wizard and it asks
> for a pop3 server and an outgoing stmp server. i don't
> know what those are.
...Error Msg: "Server Error in /Reports Application"
New install of CRM 3.0 on 2003 Server. SQL 2005 also on same box. browsing
to "http://localhost/reports" shows error message noted in subject line.
Title box is "Parser Error" and the content says
'Could not load type MicrosoftReportingServices.UI.GlobalApp'
I tried logging in as local admin and domain admin - same error.
Using Sql Server Management Studio - logging into "Database Engine" is OK,
but receive following error when logging into "Report Services":
"Unable to connect to remote server (System)"
"No connection could b...Is there a function in excel where you can the beginning of the mo
I am trying to look for a function that would will display the first of the
month if the cell I am referencing is a date in that month.
For instance: I have a date that says 12/16/09 I want the function/formula
to return 12/1/09.
Is this possible?
I cant seem to find it anywhere.
This will return the 1st of the month for the date entered in cell A1:
Microsoft Excel MVP
"Monique" <Monique@discussions.microsoft.com> wrote in message
>I am trying to look for a fun...Current User ID
I am not understanding how to copy the code that Dev wrote getting the
current user ID into Visual Basic and then calling it from my Access
I copy the code. I insert a new module. I paste the code. I go to a
text box on my form. I go to 'before update' and hit expression
builder. I don't see this code or function anywhere.
Could anyone tell me what I'm doing wrong? I want this information to
go into a table along with my text box that I have current date/time.
When a new record is created using my form I would like a query or
dlookup to pull the current user informatio...Time log adding time from separate sheets
I have a time log I am keeping on separate clients however, I would like
to create a sheet that adds up time from each client sheet.
How do I pull time from sheet 1 and time from sheet 2 to create total
time on sheet 3?
teastman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30030
View this thread: http://www.excelforum.com/showthread.php?threadid=497161
Try something like
='Sheet1'!A1 + 'Sheet2'!A1
--...New Exchange Server with User Accounts in Child Domain
Origianlly I had an NT4 domain with Exchange 5.5. In the past few months we
have created a new 2003 domain and created new accounts for our users there.
These domain accounts were given permissions to the old Exchange mailboxes.
The New domain has a root domain with two child domains. I have installed
Exchange 2003 in the root domain. I used ADC to create a connection between
the two domain servers. I can see all of the accounts using the 2003 snap-in.
But, I cannot move a mailbox from the old Exchange server to the user in the
child domain. The option is not displayed in the Exchange ...How can I drop a flyer from Publisher into PowerPoint as a slide?
I have created a flyer in Publisher but I now need to drop it into PowerPoint
as a slide, is this possible?
No, not really. You could open up both instances, Powerpoint and Publisher,
and then drag and drop/copy and paste from the Publisher window to the
Powerpoint window, the reformat as needed.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"melann" <email@example.com> wrote in message
&...Event Error 929
Hi all and thanks in advance for any help.
I recently installed Exchange 2003. It seems she is running well except for
the MS Exchange Routing Error 929 showing up in the event logs every hour.
This was a fresh install on a new box, no other Exchange servers in the
Any advise would be much appreciated.
We need more information to help. Please copy out the entire event and post
to the group.
MCSE: Messaging, Security+
"Heather" <firstname.lastname@example.org> wr...Can Not Print
I have a User who is trying to print a record from a Terminal Server Session
and is getting the following error:
The script you are executing is taking longer than expected to run. Click
end to abort the script, or continue to continue script execution.
Any one have any insights?
...can excel check one column against another
Hi. I have a spreadsheet with columns such as A, B, C, D, filled with
numbers. Each row across such as row 1, then row 2, then row 3, etc of
numbers is totaled in column E. Countless rows, each of which is
totaled per row and then ends with a grand total at bottom of column E.
Next comes columns F, G, H, also filled with numbers (but different
numbers), which is totaled per row in Column I. At the bottom of Column
I is a grand total. Even though arrived at using different sets of
numbers, -both grand totals - in columns E and I must match.
Sometimes they don't match. Ouch.
So here is m...Can I get the mode, min, and max with multiple criteria?
Thanks again for the previous response.
Is there a way to get the mode min and or max with
You're close -- SUMPRODUCT does the job, but you've left
off the final piece:
>"BobT" <email@example.com> wrote in message
I want to get an average based on multiple criteria
without having to sort the records and identify the range.
Of course I can get to the average if I can...