Link to text file in code
I'm relinking a set of tables to Access 2000. Most of the links are other
databse tables & excel workbooks which all work fine. My problem is with a
fixed field length text file. The code below runs without errors and shows
the linked text file in the tables list however it does not function
correctly. I'm wondering what the DNS=MyTextFile Link Specification2 refers
to? There is no such DSN in my registry. I just copied the code from
another example and the MSysObjects connect field after manually creating
the link. The Database portion of strConn is the path to the text fil...Using 2 versions of Mac Office 2004 (Japanese and English). How do I set the default for which version my machine uses to open office files?
I using 2 versions of Mac Office 2004 (Japanese and English). How do
I set the default for which version my machine uses to open office
files? It would of course be better if MS allowed users to switch
menu languages within the program just as Mac does with its OS and
associated software. But since that is not the case, I have had to
purchase install the English version of Office 2004 (at great expense
both monetarily and memory wise). When I open files already on my
computer it always opens them with the "default" version of Office
2004 which is in Japanese. I can't seem to ...Access 2003: Getting a link or button in results
hello..kind of a tough one..
I need to be able to access a new form for each user in a result set.
In order to make it intuitive i am looking to add a button or some hyperlink
in the result table to that it will pop up the form when selected.
So..if results of query from a table looks like:
1. UserName1 Data1 Data 2
2. UserName2 Data1 Data 2
UserName 1 or UserName2 should be a hyperlink or a button should be put in
it's place to go to a new form....Is this even possible...
On Tue, 5 Jun 2007 ...Out-of-office twin replies
I've seen some posts here with regards to OOO replies
generating two replies, one of which is blank. This is
happening on at least two different versions of Outlook
and Exchange 5.5/2000 so it appears to be a server side
Does anyone have a solution to this?
...autonumber is it possible to link two fields
Hi, Iam trying to do a project for uni and i need to have a letter infront of
the id number that is generated. pls help!
I have 15 unique ids and 3 variables, the 3 variables are to specify if the
game in question, a league, cup or friendly so i need a F,C or L infront of
the id num, all three of the variables are in a list box hope that helps!
If you check Access HELP for "autonumber", or search on-line for "Access"
and "autonumber", you'll find that Microsoft Access does NOT do that for an
Autonumber data type field.
Given that this is a &q...Vista
I have just purchased a PC with Windows Vista already installed, and have
installed Microsoft Office 2003 on it & registered it.
However, whenever I launch Excl I am confronted with a screen showing a
Microsoft Office End Users Licence Agreement which requires me to agree to
each time before the programme will launch.
Does anyone know how to stop this happening?
You registered but did you activate?
Gord Dibben MS Excel MVP
On Thu, 6 Dec 2007 22:55:54 -0000, "Gunga" <firstname.lastname@example.org> wrote:
>I have just purchased a PC with Windows Vista already installe...Link to the FIRST worksheet
I added a summary worksheet at the end of the sheets to summarize some info.
I will name the range and use it to pull in info from an Access db. I want
to link this to the FIRST worksheet only. What happens is every fiscal year
they add a new worksheet in the first position, so this year ws1 is 'MD
2010', but in a few months they will add 'md 2011', and I want my summary to
link to the worksheet in the first position, not any particular name. (so
the cell link ='md 2010'!B2 won't work) thx
After the new sheet is added, you can highlight all the cel...Office Macros
What is the latest about when we will be able to upgrade our Office
for Mac so that it can run all of our spreadsheets with VB macros?
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."
- James Madison
The only official word from Microsoft is that VBA will return in the next
release of Mac Office which is tentatively scheduled for "Holidays 2010" - I
take that to mean late 4th quarter of next year. I would not expect to see
anything m...Office 2007
I have Office 2007 installed on an WinXP machine.
I've added to my start menu the following short-cuts:
New Microsoft Office Document
Open Microsoft Office Document
I have a few questions,
1. What is the default location of the files listed in the New Microsoft
Office Document window?
2. Can I add tabs to the New Microsofot Office Document window? If so, how?
3. What is the default location for the Open Microsoft Office Document
Assume I've made no changes to the install of Office 2007.
Your assistance and help is greatly appreciated!
...Send Exchange 2003 Out of Office Replies to non Exchange mail serv
I am new here, so please bear with me. I am hoping someone can help me. I
have looked and looked and looked for the answer to my question with no luck.
I am wondering if it is possible to setup Exchange 2003 Out of Office
replies to respond to a non-Exchange mail server within the same domain
without opening up to the internet. The reasoning is to prevent spam
programs from detecting legit addresses.
Main Mail Server for Staff & Faculty: Exchange 2003 Enterprise Edition
Main Mail Server for Students: SurgeMail from NetWinSite.com
They are in the same domain, but I am wanti...outlook:// link to bring up post items?
I am somewhat familiar with the outlook: protocol style links to
interact with the Outlook client. For example, you can probably go into
your browser and enter the URL:
If you have Outlook installed, this will probably bring up your Inbox
in the Outlook client.
I am familiar with the special way to tell Outlook to link to a
specific item -- the tilde (~). For example, if you have a message in
your Inbox with the subject "marklar", this link MAY work to bring up
that specific message:
I have spent many, many hours researching and reading what...Categories disappeared after upgrade from Office 2k3 to 2k7??
After upgrading from Office 2003 to Office 2007 all of my categories are
I still have a complete backup of my system containing Office 2k3 with
working categories, is there a way to manually transfer the Categories to
Any help in this area would be completely appreciated.
> After upgrading from Office 2003 to Office 2007 all of my categories
> I still have a complete backup of my system containing Office 2k3 with
> working categories, is there a way to manually transfer the Catego...How do I change the data set on the X axis? (office 2003)
OK, so I created a frequency histogram (bar chart) by selecting the values
for the Y-axis, but I can't figure out how to change the values on the X-axis
to fit the rest of my values....
When I make the graph using both sets of data, it gives me two separate bar
charts on the same plane.
Help please :)
Remove the text in the top cell over the x-values; now make the chart.
Excel thinks you have two data series
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"jrexattack" <email@example.com&...Opening/importing data from database takes forever after upgrading office!
I recently reinstalled a users computer and upgraded his
office version from 2000 to xp. Now when he imports data
from a database it takes forever. It can take several
minutes and before the reinstallation the operation only
What could be wrong? I did the same on his coworkers
computer with the same result so there must be something
that can solve the problem. I just can't figure it out.
The run windows 2000 sp4.
Please help. :^)
It never hurts to empty the windows temp folder (with excel closed), but it may
You may want to take...office 2003 eula comes up each time you open word,excel
...Re-installation of office
I need to re-install office on my pc after resetting the pc to the original
Insert Office cd, install.
Dont have cd? ....explain
"Lisa Lucey" <Lisa Lucey@discussions.microsoft.com> wrote in message
>I need to re-install office on my pc after resetting the pc to the original
> settings. HELP!
...Office 12.2.1 update/Reentering Product Key
Operating System: Mac OS X 10.5 (Leopard)
I attempted to update my Microsoft Office 2008 from 12.2.0 to 12.2.1 today; however, after the installation was complete, when I went to open a Microsoft Office application, an error message appeared stating:
"Office for Mac has determined that your product key is not valid. To use Office for Mac, you must enter a valid product key" and refers me to this link: <http://www.microsoft.com/mac/help.mspx?MODE=pv&CTT=PageView&clr=99-0-0&target=f2d51b70-f7d6-4a3c-ae8b-b90597d7530e1033>
After deleti...Office 2003 and mac office
I have a workbook with some macros and such that i made on my XP computer. I
sent it to a friend of mine to use, but he has a mac. The macro i made to
sort runs into a problem when he runs it, however when he sent me the
workbook and i ran the macor it worked fine. It had a 1004 runtime error.
Is this a common problem due to it being made on a pc and ran on a mac? what
changes need to be made to make it work on a mac?
Selection.Sort Key1:=Range("IA3"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
Da...Can I update from Office 98 to Office X
Can I update from Office 98 to Office X for mac?
I should of said upgrade from Office 98 to Office X for mac?
> From: Aggregates & Roadbuilding Magazine <firstname.lastname@example.org>
> Newsgroups: microsoft.public.mac.office
> Date: Wed, 14 Jan 2004 14:37:48 -0500
> Subject: Can I update from Office 98 to Office X
> Can I update from Office 98 to Office X for mac?
According to the Mactopia site:
You can upgrade to Office v. X for Mac if you already own any of the
Office�98 Macintosh Edition
Entourage�2001 Special Edition
I have a soccer club database that weas created using
access xp and I need to be able to run it on my home
computer that uses office 2000. Certain parts of the
database such as the listing of teams will not work.
When you switch between database versions many times the new computer does
not have the appropriate references set or is missing references it needs in
order to run. Assuming you can open the database on your machine with Access
2000, you need to open the database and open the code editor window. Select
Debug | Compile.
Generally, a 2002 database won't run u...Upgrade to Power Point 2010 from Microsoft Office 2008
How can I upgrade from Power Point in Microsoft Office 2008 for Mac to Power
unfortunately the Beta version is only available on windows platforms.
Preliminary system requirements for Office 2010 include the following:
• Windows XP SP3, Windows Vista or Windows 7
check out: http://www.microsoft.com/office/2010/en/faqs/default.aspx#29q
"4jswest" <email@example.com> wrote in message
> How can I upgrade fr...How can I get Dictionaries for Office XP?
I find vague references online to to an "Office XP Proofing tools" but the
online stores seem to have no references to it - only Office 2003 Proofing
tools. Is that compatible with Office XP? If not, where can I find proofing
tools for XP. Or alternatively, where can I get dictionaries and grammar
checkers for individual languages for Office XP.
No, they are not compatible. If you can still find Office 2003 Proofing
Tools online, then I would advise upgrading to Office 2003 so you could use
Office 2003 Proofing Tools. You have very little chance of finding Office
XP...Office Clipboard in Office XP and Office 2003
How do I turn this off permanently? If I click on Options when it appears
and select 'Don't show Office Clipboard automatically', it only gets rid off
it until I restart Excel at which time I have to do it again. I'd like to
turn it off permanently.
Any help would be appreciated.
In Excel 2002 the option is;
"Show show Office Clipboard automatically''
"Dont show Office Clipboard automatically"
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http...ExOleDB Permissions problem as linked server
I have Exchange 2000 server and SQL Server 2000 installed on the same
box. I using the ExOLEDB data provider to set up Exchange as a linked
server in SQL Server. A public folder is queried in a stored procedure
using OpenQuery and a SQL Query against the Exchange folder.
This all works fine, as long as the user is an administrator. If a
non-admin attempts to use the stored procedure, the SQL Server returns
the error "Could not create an instance of OLE DB provider
'exoledb.DataSource.1'.". I know that it can (as I can do it as
admin), so it appears to be a permissions proble...Turn off Out of Office Assistant as an Administrator
Is it possible to turn of ooa for a user from an administrator snap-in?
Connecting to the users mailbox seems a little too clumsy to me.
3rd party products like:
For Exchange news, links, and tips, check:
"Collin" <Collin@discussions.microsoft.com> wrote in message
> Is it possible to turn of ooa for a user from an administrator snap-in?
> Connecting to the users mailbox seems a little too clumsy to me.