how do i create an office data connection file
i want to call a parameterized data connection. i want to eventually put
this in office sharepoint server 2007's data connection library. every time
i open the connection file i have successfully created that connects to the
db, it want me to pick a table. i can cancel out of that and change it to
sql and say to use a procedure, but i can't save this file, and the "Edit
Query..." and "Parameters..." buttons are disabled so i can't set
why is it so hard to work with this thing?
...Reinstalling MS Office Small Buisness Edition, 2003
When reinstalling MS Office 2003 from the orginal CD, it states a
PA561401.CAB file is missing. How can I retrieve this file if it's not on the
Is your CD an OEM version or a full MS version. If the product key contains the
letters OEM then post back
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"Dave" <Dave@discussions.microsoft.com> wrote in message
> When reinstalling MS Offic...National City auto-update
I used to be able to have Microsfot Money automatically download transactions
from my accounts. Now whenever it goes to check it says it failed. I tried
setting it up again but it prompts me "National City Requires a Password
Change", but no matter what I enter in these boxes it says the password/pin
is incorrect. I called National City and they said there wasn't anything
wrong with my account.
What should I do?
In microsoft.public.money, Josh wrote:
>I used to be able to have Microsfot Money automatically download transactions
>from my accounts. Now whenever i...Office:mac 2004 installation problem
Hi, I'm wondering if anyone out there can help me...
Way back in March I bought a new MacBook, and with it a copy of
Office:mac 2004 student & teacher edition. I installed my copy of
Office straight away, but didn't realise I needed to uninstall the
Trial edition first.
Every time I opened anything in Office, both the REAL and TRIAL
editions started up - which is obviously quite annoying - so I tried
to uninstall the trial. However, the REAL Office then stopped
Getting a bit fed up, I tried to completely remove all traces of
Office and start again. However, when I tr...Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
Some of these rows only need a few columns updated, and others need
all of them updated. If possible if say row 800 column 'S' is filled
in the access DB but is blank on the excel spreadsheet, if possible i
like to keep the existing data in access and over right it with a
The spreadsheet is a export of the access DB, changes were made/merged
from other spreadsheets so the Unique ID is the same and in column A.
A script suggestions to complete this?
set dbe = createobj("dao.dbengine.36")
set db = dbe.openda...Removing RAID controller at XP boot up
I installed a pci card with two ATA 133 HD drive ports it came with drivers,
I think I installed the wrong driver (RAID instead of straight). Cant get
rid of the Marvel Raid control because it comes up before boot and has
presumably tucked itself in the bios somewhere. Is there a solution? Perhaps
reflashing the bios?
"Charlie+" <firstname.lastname@example.org> wrote in message
> I installed a pci card with two ATA 133 HD drive ports it came with
> I think I installed the wrong driver (RAID inste...I have Korean Office...I need English (US) Office
LIPs don't seem to provide me with a solution...apparently there is no
English LIP!?!?!?!?!? Seriously? That's crazy!
LIP = Language Instruction Pack?? Why NO English? Where is Windows /
Office developed? America, right?
I'm in Korea. I bought a Korean computer. It came with Korean Windows. I
need English menus and whatnot on my MS Office applications.
abundantmind <email@example.com> typed:
> LIPs don't seem to provide me with a solution...apparently
> there is...Exchange 5.5 MTA Event-ID 290 after site removal
hopefully someone can help me.
We have Exchange 5.5 Org (most SP4) – 1 hub site and 5 spoke sites.
In our hub site we have 1 connector server and one mailbox server.
Due to Exchange server consolidation, I removed one site (KB324340) – same
procedure as I did it three times before -
Now I’m getting every 4 hours on the bridgehead server in the hub site the
following event-id, which points to the old and removed server/site:
MTA Event-ID 290 – NDR,..
A non-delivery report (reason code unable-to-transfer and diagnostic code
unrecognised-OR-name)) is being generated for message message. ...Signature page not printed for Credit card transaction
I have set up new POS system and the POS system does not print
signature page for credit card use.
I check 'require signarue' for the receipt from tender type window and
print Z-out to apply it but it still does not printing out the
Please be advised.
thank you for your help!
This is a multi-part message in MIME format.
Make sure the receipt is set to print it. Manager | Database | Register =
Lis...SQL to update Item.LastCounted based on PhysicalInventory.CloseTime
Because of a bug/deficiency/oversight in a third party inventory counting
application , I did a bunch of physical inventories that did not update the
Item.LastCounted field. I need this field updated so I can see the correct
date each item was counted last.
I am willing to do a seperate SQL statement for each physical inventory
sheet for which I have the problem.
For example, I want to take each item in the PhysicalInventoryEntry table
with PhysicalInventory.Code = '0000057' (or whatever the code is) and set
Item.LastCounted = PhysicalInventory.CloseTime.
I am not great at SQ...Pictures removed from sent emails
I've always been able to paste pictures (such as screen shots) from the
clipboard within the body of HTML emails, but something's happened and now
when I paste a picture it gets removed before it's sent.
I can see the picture in the email when I'm writing it, but after clicking
Send and opening the email in my Outbox before sending, there's just a blank
empty frame with the message "The linked image cannot be displayed. The
file may have been moved, renamed or deleted. Verify that the link points
to the correct file and location." and the little &...Office 2004 Project Gallery
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
In the main screen of the Office 2004 Project Gallery, there are icons for
things like �Mail Message� and �Calendar Event�. How can I add, for example,
�Address Book Entry� or �Task� to the Project Gallery?
<HTML...No sound after updating SP2 for Vista
Hi,sorry if this is a duplicate post,but I'm not sure mine posted the first
time,it's not coming up in my searches.
My Dell Inspiron 1420 laptop automatically informed me of an important
update last night,and I went ahead and clicked through it and restarted.It
had me download the SP2 for Vista and install it,but when I turned my
computer back on after the requisite restart,my computer wasn't making any
sound whatsoever.I tried using the volume toggle on the taskbar,I tried
pressing the volume and mute buttons on my laptop and playing with the volume
sliders in eac...Running Office 2004 with network homes on 10.4
Im really at the end of my tether with office now, for well over a
year it seems as though no matter what I do office just behaves like a
Were talking 10-20 minute load times just to load an office app.
It will sit there and first it say configuring microsoft office
then through a host of other things until eventually as i said about
20 minutes later it will actually open.
I've seen things about fonts before, but i can tell its not just (if
at all) this.
I have a reasonably fast network, so i cant see how it is network
All clients have networ...How do I Remove a Split from my Comments in Excel 2003?
I have set my current workbook to split/freeze the first column and first 2
rows. Now, when I add a comment to the second row (in any column) my comments
are cut off if I should scroll down.
I don't ever remember the behavior before. And I don't know what I've done
to enable it but it's really annoying.
How do turn this off.
Instead of Window>Split try selecting B3 then Window>Freeze Panes to hold top
2 rows and left column in view when scrolling.
Gord Dibben Excel MVP
On Thu, 6 Oct 2005 10:54:01 -0700, JesusPresley
<JesusPresley@discussions.microsoft.com>...Todays Date that does not update
I created a macro and a button that when clicked it entered todays date in a
cell, which is what I wanted. I used "Today( )".
Problem is the date keeps updating to todays date and I want it to stay the
date I entered it in. Is there some other value or formula to do this so it
does not update everyday?
You need to enter the date itself. Any function will always
update to the current date. Ctrl+; will enter the current date in
In VBA, use
Range("A1").Value = Date
Microsoft MVP - Excel
Pearson Software Consulting, LLC...Can't get automatic updates to work
I get this message:
[Error number: 0x8DDD0018]
The site cannot continue because one or more of these Windows services is
Automatic Updates (allows the site to find, download and install
high-priority updates for your computer)
Background Intelligent Transfer Service (BITS) (helps updates download more
quickly and without problems if the download process is interrupted)
Event Log (keeps a record of updating activities to help with
troubleshooting, if needed)
To make sure these services are running:
1. Click Start, and then click Run.
2. Type servic...Can I remove blanks from a range without using sort?
I have a range of cells A1:a10, say, which obtain data from another source.
Some of those cells a3, a6:a8, say, under certain conditions, will be blank.
How do I reorder this range such that the cells containing information are
listed together, removing the blanks? I want to do this using a formula,
rather than filter or sort, as the data, and hence the blank cells, will
change, and I want to perform analysis on the cells containing data.
from one of the newsgroup correspondents
use this code statement
Range("a1:a10").SpecialCells(xlCellTypeBlanks).EntireRow.Del...money2004 hanging on updates
I upgraded from money2003 to money2004 last night, then
went to online updates. The program can download my bank
transactions but when it gets to "updating securities and
news" it hangs. I cancel, and it hangs on "cancelling
call". I end up having to cont-alt-del and restart
money. Happens every time.
Any suggestions or is it a server problem?
thanks in advance
In microsoft.public.money, jeff wrote:
>I upgraded from money2003 to money2004 last night, then
>went to online updates. The program can download my bank
>transactions but when it gets to &q...Windows Malicious Software Removal Tool
Just a quick question, I am wondering if anyone else is having problems
downloading Windows Malicious Software Removal Tool. I can
download/install it from the Windows Update site but, it will not
install using Automatic Updates. This is obviously not a serious
problem but, I would like to solve it if possible.
Never such a problem here.
Always state your full Windows version (e.g., WinXP SP3; WinXP 64-bit SP2;
Vista SP1; Vista 64-bit SP2; Win7; Win7 64-bit) when posting in a forum or
newsgroup. Please do so in your next reply.
What anti-virus application or sec...Time Stamp in office
Does anyone know of a way (keystroke, etc...) to put a time stamp into a
On 5/11/04 6:00 PM, in article BCC6EF5F.firstname.lastname@example.org,
"Thomas Jones" <email@example.com> wrote:
> Does anyone know of a way (keystroke, etc...) to put a time stamp into a
> Entourage document?
Get "Date Stamp X" script at
It gives you about 20 different date-time formats to choose from. By default
you do it with cmd-ctrl-D but you can change the key combo if yo...Update Query
I have 2 tables: Member and Bulk Mail
I have linked them on Last Name
Member has these fields: First Name, Last Name, E-mail
Bulk mail has these fields: First Name, Last Name, e-mail address
The member table has no data in the E-mail field
The Bulk Mail table has data in the e-mail address field
I would like to update the Member E-mail field with the data in the Bulk
Mail e-mail address field using the Query Wizard
Glenn T. Dulmage
207 Valley Road
Chestertown, MD 21620
So, you quite certain that you don't have and ...Signature #9
I am trying to create a signature to go in all of my emails. I used the outlook help, but the "signature picker" button is not able, so I can't do it. Is there some way I can enable the signature picker?
Did you get an answert to his question? I am having the same problem EXACTLY. Please help if you can. Thanks
----- C. Johnson wrote: ----
I am trying to create a signature to go in all of my emails. I used the outlook help, but the "signature picker" button is not able, so I can't do it. Is there some way I can enable the si...office 2008 beta
I wish to uninstall an expired beta version, but the program closes
after displays the message that the office is expired. How can I do
"firstname.lastname@example.org" <email@example.com> wrote:
> I wish to uninstall an expired beta version, but the program closes
> after displays the message that the office is expired. How can I do
If the Remove Office application doesn't work, I'd start with deleting
the Office 2008 folder, and the preferences...How to remove send/receive externally for a user
I have a request to setup some users for internal email only and remove their
ability to send/receive external email. How do I do this?
I have a 1 Exchange 2003 Server.
"Paula" <Paula@discussions.microsoft.com> wrote in message
> I have a request to setup some users for internal email only and remove
> ability to send/receive external email. How do I do this?
> I have a 1 Exchange 2003 Server.
In Exchange 5.5 ...