Over 1 million tech questions and answers.

Sharepoint, Access 2010 & Word 2003

Q: Sharepoint, Access 2010 & Word 2003

Hi,

Is there a way to connect Access and Sharepoint together so that the following can happen.

User adds a new record to an Access 2010 database published onto Sharepoint
They then run a mail merge from Word 2003 which picks up the new record.
At the moment only 1 PC is running Office 2010 and Windows 7. The rest are still Office 2003 and Win XP, hence the use of Sharepoint.

Thanks
Karen

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Sharepoint, Access 2010 & Word 2003

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 81.2

Hi,
I hope someone can help me with my problem.

I have a database in Access 2010 which has been published to Sharepoint 2010.
The users of the database only have Office 2003 installed on their PCs with no upgrade in sight.

Is there anyway to connect a Word 2003 mail merge document to the Access 2010 database? I've tried connecting via New Source and selecting ODBC DSN but it only displays files from Office 2003. If I use Other/Advanced I'm not sure what the location of the data source should be. I'm guessing it would be on the sharepoint server, but I'm not sure.

Any help gratefully received.
Thanks
Karen
 

A:Access 2010 and Word 2003

Read other 6 answers
RELEVANCY SCORE 80.4

Hi All,
I would like to know is there is any way i can Integrate of Access 2007 , Sharepoint 2010 and Info Path 2010, because as far as my knowledge we can upload Access 2007 into Sharepoint 2010. In Sharepoint i cannot able to use Access 2007 forms so i need to create another good looking way of showing the access lists.
Can you please anyone help me how i can implement this and if we can what are the requirements need to be done, like tools required and steps for the implementation.
If anyone can suggest some books also i can able to read it and learn it myself.
All the response are welcome and thanks for all your support.
 

A:Integration of Access 2007 , Sharepoint 2010 and Info Path 2010

I see no one is offering anything on this post. Not a great site for SharePoint(SP) information. But SP its self is relatively new for developers. We can't afford real SP developers so se make our own. Not a great plan but we are supporting a large SP site.

I think with Access 2007 the best approach is to use it to update list and make reports from list. There is no integration to InfoPath forms that I know of. You have to build them on top of your list with SP Designer.

I did find this video in my favorites that says publish access 2007 to SP2010. I haven't whatch recently...
YouTube
If you really need Access (in SP) you have to go to 2010. I waited till Access and SP 2010 were available on a test site and build a relatively simple db with a couple of reports and queries that did funcion correctly (without too much alteration). I did have to key each table before it would 'publish'. The 'publish' wizard will walk you thru needed fixes. I looked for the DB to refresh my memory but someone has rebuilt the test site and dropped it.

Any way good luck. I wish I had some recent experience on the issue to offer. Maybe this will 'bump' your thread and get some more information!
 

Read other 1 answers
RELEVANCY SCORE 75.2

Looking for comments on your experience using SharePoint 2010 and linking to\from MS Access. It seems there are many methods to push/pull data between\within these two products.

Our organization is upgrading from SP2007 to SP2010 and I've been taxed to review options available SP2010 and MS Access 2010/2007 and see what might be some 'best practices' and solutions to persue.

I have googled and read/watched many articles and videos discribing THEORIES and simple examples of how SP and MSA can work. I'm looking for comments from a real application not Contoso or TradeWinds (what ever that sample database is).

I'm looking for good and bad. Links to blogs or other post are welcomed.
 

A:SharePoint 2010 and MS Access - your experience

Read other 8 answers
RELEVANCY SCORE 75.2

I want to make a metro app and want to use Sharepoint 2010 data. In the javascript library there seems to be no Sharepoint connection. Am I wrong? Is there a javasript example of accessing a sharepoint list, or sharepoint document library?

A:Access Sharepoint 2010 with metro app

Hi Mike,

I am looking for the same.... did you find any solution to this?

Regards
Gokul

Read other 1 answers
RELEVANCY SCORE 74.4

Please help point me in the right direction.  I checked the File association on Internet settings and document type docx is associated with Word, but it won't open.  What do I need to change?
I received the following information when I clicked on the troubleshoot link:
Windows has the following information about this Protocol. This page will help

you find software needed to open your file.
Protocol Type: ms-word
Description: UnKnown
Windows does not recognize this Protocol.

A:SharePoint 2010 document broken link due to unrecognized File protocol: ms-word

Title:  SharePoint 2010 document broken link due to unrecognized File protocol: ms-word
Please help point me in the right direction.  I checked the File association on Internet settings and document type docx is associated with Word, but it won't open.



Try refining this symptom description.  What exactly do you mean by "it won't open"?  Answering that might explain why you are posting this in an IE forum.  E.g. right-click, Copy Shortcut whatever it is that you are calling
a "broken link" and Paste it here.
Otherwise, try right-click, Save target as... to put the file into your Downloads (Ctrl-j) and then use right-click, Properties to find its
full path and name.  Note that that would be quite different from what the Copy Shortcut step would have shown.
Next I suspect that the Set Associations GUI tool may not be showing you the correct information.  FWIW it certainly doesn't show me the correct information in W8.1.  So, I would try checking if you have an explicit association and file type combination
by using the assoc and ftype commands in a cmd window.  In fact, instead of just showing the ftype for the current association I would use this:
    ftype  |  find  /i  "word"
Then you could take the most appropriate template (not necessarily the one pointed to by the assoc command) and fill it in on a Run... dialog (or a ... Read more

Read other 14 answers
RELEVANCY SCORE 74.4

Hi,
I need to access a workspace on Microsoft SharePoint Workspace 2010, But I do not have Office Pro 2010, and I can't find a download link.
Does anyone know any way I can connect to this workspace?
Thanks.

A:How can I access a Microsoft SharePoint 2010 Workspace?

Is this work related? From my little experience with SharePoint, the "owner" of a site must grant permissions for users to access it.

Read other 2 answers
RELEVANCY SCORE 68

Details:
Windows 7 Professional Edition Service Pack 1 Build 7601
Microsoft Office 2010

My user has spent years building her Auto-Text feature within Word 2003 to the point it is now, but her company just bought her a new Windows 7 Pro machine with Office 2010 installed. She asked that I migrate her Auto-Text data to Word 2010. After researching on google.com I found that this data is stored in a Normal.dot file and this file needs to be migrated to (in Windows 7)
C:\Users\<User Name>\AppData\Roaming\Microsoft\Office.

Having done this, I now find the Normal.dot file I placed there in this location, as well as a new Normal.dot file that Word 2010 has created, but the two aren't merging. I see the new file has macros enabled... Does anyone have any ideas on how to merge these files into one file useable by Word 2010?

Thanks,
S~

A:Help with migrating a Word 2003 file to Word 2010

Normal.dot is the global template for Microsoft Word and is stored in different locations on the system based on the version of Windows and Word.

You dont want to merge them you want to backup the existing normal.dot file to something like normal.old.
Then replace the file in the correct location, which I cant research for you right now.

The bad thing about doing things like this is that if normal.dot gets corrupted, all the work put in to this is lost!

Read other 2 answers
RELEVANCY SCORE 68

I normally use Word 2003 for documents, although I use Outlook 2010. This morning I opened a Word 2010 document and after quite a while of some sort of an installation, I was able to open the Word 2010 document. I did not think too much of it, except that later I was sending an e-mail and attached a Word 2003 document and when I went to check it (i.e. open it up) it opened in Word 2010. How do I disable Word 2010 as my default program to open Word documents. I do not want to uninstall the program, but at this point I am not ready to learn how to use Word 2010.

A:Word 2010 is opening my word 2003 attachments

SHG818 welcome to Sevenforums!

Have you tried this tutorial?

Read other 3 answers
RELEVANCY SCORE 66.8

Hello,

I have a new issue that has come up since we converted an Access database to 2007 file format.
Here is the history.

We have an access database that was created in the old file format. In that database there is a button that opens up word and a mail merge file. Word's mail merge then uses a query from the access database to populate the mail merge document.

We recently converted the Access database to the Office 2007 file format and now the merge process will not work.
I have tried to relink the files and have done some research and it appears that the DDE way of connecting is no longer used in Office 2007. I did finally get to the point where I could see the queries i needed but once I try to open that data source Word give me a general error that it can not open the data source.

How can I get these merge files working again?

PS. We are running Windows XP if that is needed.

We are quickly moving to office 2010 also but that uses the same file format as 2007 so I assume it won't be an issue. Any help you can give me would be GREAT!.
 

Read other answers
RELEVANCY SCORE 66.8

Hi, I have set up a new Access 2010 database (saved as .accdb) (copying tables, forms and queries from my current one then deleting the old data and modifying a lot of fields). I have a query in with some simple calculations. All the calculations work perfectly in Access. When I merge this into Word 2010 (set up as a letter document) it doesn?t use/show the correct data.

The calculated fields in the query are ?number of people * price tea & coffee = cost tea & coffee? and ?number of people * price buffet = cost buffet". I then use these costs in the same query to work out ?VAT? (another calculated field adding up the calculated "cost tea & coffee" and calculated "cost buffet" as well as a number of other non-calculated fields and multiplying the total by 0.2) and ?Total Cost? (a calculated field adding up various non-calculated fields, the calculated "cost tea & coffee", calculated "cost buffet" and the calculated VAT field).

There are two errors in the data that ends up in the merged Word document:
The "VAT" doesn?t add in the two calculated fields, it only uses the data from non-calculated fields in the query.
Also the "Total Cost" doesn?t add in any of the calculated fields (teas & coffees, buffet and VAT), it only uses non-calculated fields from the query.

It doesn?t ping up any error messages. Why is it changing the data between Access (where the query works per... Read more

Read other answers
RELEVANCY SCORE 66.4

I have a word document set up with fields that I want to create a mail merge from a Query. When I go through the steps to add my query as the source then click on edit recipients there are no recipients. I have tried the same steps with other queries that I have and it works. I'm not sure why the query I want to use isn't working. The query I have set up does have a lot of expressions. Here is an example IIf([fie dt] Between #8/1/2010# And #7/31/2011#,[fie dt]+1096,Null) I have tried to change the expression and it still doesn't work. Any ideas? Thanks!
 

A:mail merge issue with Word 2010 and Access 2010

Read other 10 answers
RELEVANCY SCORE 64.4

I have Outlook 2010 but it does not work with my Word 2003. I do not have the spell check as a write and there is no integration with Word 2003. Is there a way in which I can integrate these programs or do I have to buy the Word 2010? I'm absolutely happy with the 2003 version.

A:Outlook 2010 with Word 2003

Just as a starter, here is a comparison of Using Outlook 2010 with or without Word 2010 installed - Outlook - Microsoft Office.

Read other 4 answers
RELEVANCY SCORE 63.2

Hiya

This document is designed to help solution developers and architects understand how Microsoft Office Excel 2003 can be integrated with back-end systems (in this case Microsoft Windows SharePoint Services) to create powerful client-side applications through which back-end functionality is exposed. In particular, this solution is used by project managers to launch a new Windows SharePoint Services team site and to collect data that will be used to manage a project. It shows how various Microsoft technologies can work together to improve and simplify business processes, with an emphasis on Microsoft Visual Studio 2005 Tools for Office. The code sample is available in C# and Visual Basic.
System Requirements
Supported Operating Systems: Windows 2000; Windows Server 2003; Windows XP

Microsoft® Visual Studio 2005 Beta 2
Microsoft® Visual Studio 2005 Tools for the Microsoft Office System Beta 2 (included with Visual Studio 2005 Beta 2)
Microsoft® Windows® SharePoint™ Services 2003
Microsoft® Office Professional 2003
or
Microsoft® Office Excel 2003


http://www.microsoft.com/downloads/...56-3fdd-427a-b512-427906359669&DisplayLang=en

Regards

eddie
 

Read other answers
RELEVANCY SCORE 62.8

Hi,
My company was using Office 2003 until 4 months ago when they moved to Office 2010. When they install Office 2010 Office 2003 was left on the machines so that we currently have both versions installed. I have developed and deployed several databases since Go Live, all in Access 2010, and all was going fine until Office 2003 was uninstalled from several machines and when they tried to open the database they got:

"Execution of this application has stopped due to a run-time error.
The application can’t continue and will be shut down."

I went all thought the code and couldn't find anything so on a whim our IT guy, the one that had removed Office 2003 reinstalled it and BAM, working again.

I have no clue as to what is going on here, Shared DLL, a Reference that's 2003, nothing. i need any thoughts as to where to look and what it might possibly be.

Thanks!
 

A:Solved: Access 2010 / Access 2003 Issue

When you uninstalled Access 2003 did you re-install or repair Access 2010, Office overwrites certain dll files so that the one in current use has control, if you then uninstall it the dll files do not necessarily return control to 2010, hence re-installing 2003 also re-installed the dll files.
Normally you can't run both versions of Access at the same time due to this problem.
 

Read other 2 answers
RELEVANCY SCORE 62.4

Hello,

since I installed SP1 for Office 2010 I have problems with opening some (not all!) older Word documents created with Word 2003 (*.doc). I get a message that Word can't read the document and it is probably corrupt.

On a other client (same OS, Office 2010 without SP1) I can open the same document without difficulty.

Has anyone an idea?

Thank a lot

A:Office 2010 SP1: Problem with opening Word 2003 documents

Hello curuska, welcome to the forum.

Are the two computers accessing the exact same document from the same location, or is the same file saved to their own local disk?

A quick test to try:
Open Word, select File?> Open
Choose the corrupted file (but don?t open it yet)
You will notice that next to where it says ?Open?, there is a little drop-down arrow. Click on this and change the option to ?Open and Repair?, then click on it.

Read other 1 answers
RELEVANCY SCORE 62.4

Does anyone know of a way to force Word 2010 to save all files as .doc files not .docx for any user that ever logs in to a pc?

I know it's simple to save this setting for a given user but I need to do it for everyone that ever sits at a given pc....

Thanks

A:Force Word 2010 backwards compatibility to 2003 for all users

I would create a file doc.reg and save it in C:\whatEverLocation\

Code:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Options]
"DefaultFormat"="DOC"
Than I would start a Task Schedule (taskschd.msc) and "Create Task"
(NOT Basic task!!!).

Check "Run with highest privileges" on General tab.
Triggers tab: At log on - Any user.
Actions tab: Start a program.
. Program/script: %windir%\System32\regedt32.exe
. Add arguments (optional): /s "C:\whatEverLocation\doc.reg"

Reg file gives us desired setting in a file form that can be easily imported for any current user.
12.0 is for Office 2007
14.0 is for Office 2010
15.0 is for Office 2013

Task schedule allows us to create a task that will run for any user of the current Windows system with administrative privileges (when corresponding options are selected).
regedt32 will import desired setting for the current user silently (/s).

User can still change this option manually later on, but the next time this user log in, the same setting from the file will be imported and user's custom setting will be overridden.

Read other 6 answers
RELEVANCY SCORE 62

I want to merge 1 record from Access 2003 to Word 2003. After trying everything, I finally was able to get a process working where I opened Word and then ran a Word macro to run the merge, passing . However, it stopped working, and I can't figure out why. I haven't changed anything.

The problem is the same one that all the other attempts run into - Word 2003 won't let me connect to the database when the merge file is opened, if a record is open in Access.

I tried having my code in Access close the form, but that didn't work. However, if I manually close all the forms, so only the database window is open, then I can open the merge form manually in Word without any problem.

When I run the macro, Word askes me to connect to the database, then bombs out, saying it is locked or Admin hasn't given permission.

Anyone know a way to get Access to merge to Word?
 

A:Merge Access 2003 to Word 2003

Have you change from XP to Vista or a later version of Windows? OS security changed the way things behave in the newer Windows operating systems.

Connecting to an open file isn't the best practice anyway. Forms are often linked to tables which is probably why closing the forms works for you. A possible solution, if its important to keep the database open, is to make a copy of the table thats desired for the merge and update the copy as needed.
 

Read other 2 answers
RELEVANCY SCORE 62

I would like to be able to click on a name in a Word 2003 doc and instead of it using smart tags to access Outlook's contacts I need it to pull from an Access2003/Excel2003 Database. I don't even need the smart tags menu that gives options to appear, I simply want to see contact information from the db come up in place of that or just have one option come up that opens a small window displaying this contact information.

Any suggestions on how to code this with VBA or any third party apps or plug ins or anything?
 

A:Word 2003 Query Access 2003

mcollins4, welcome to the Forum.
You can communicate with other MS applications, see the Word VBA Editor's Help Topic
Communicating with Other Applications

But I think you might find that this does want you want, with a bit of modification.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=490
 

Read other 1 answers
RELEVANCY SCORE 61.6

Hey my name is Alex,
 
I'm a Computer Technician at MicroChip Foundry and here is my problem below..
 
 
So i'm having a problem with a Windows Xp Pro Machine that has office 2003 pro with access. A employee uses it to run querys and database but also uses it to run other programs. It started running slowly after awhile and so I figured out the 2010 Runtime Access would make it run faster. So it did but, the two conflict with each other. Is there a way to cause this not to do that?

A:Access 2003 and Runtime Access 2010

this might shed some light on it, there's a few suggestions for compatibility solutions.
 
http://social.msdn.microsoft.com/Forums/office/en-US/dbf6bfaf-f6d1-4864-b3d9-944c88b959e4/installed-access-runtime-2010-and-now-2003-and-2010-database-just-flashes-on-screen

Read other 2 answers
RELEVANCY SCORE 61.6

I have a corrupted mdb access file 61Mbytes. There seems to be many paid for programme 'fixes' around that will repair and extract the data, I can do that. BUT I cannot see a program that will actually REPAIR the database so you can double click it and get the original programme to work. Anyone have any suggestions.

A:Access 2003/2010 fix.

Hi Mike8, maybe this will help:
How to troubleshoot and to repair a damaged Access 2002 or later database

Read other 4 answers
RELEVANCY SCORE 61.2

I've read postings from OBP, Cristobal and others about the down sides of OLE, how it bloats a database and so forth. With that under my belt, I nevertheless have a need to inlcude Word docs in the Reports created by my Access 2003 database.

The spec is as follows:

The application is to provide a sales quotation tool. Users will add a quote by choosing the customer, adding parts to the quote and choosing pricing mechanics, Thats all easy to do and in fact is nearly complete. The user can then, by selecting one or more tick boxes, choose from a range of pre-formatted product literature which will be included in the output quote that is created as a report (then spooled to PDF). The pre-formatted product literature content is not needed to be visible in the form.

The product lit files are Word docs.There are about 30 or so of these different Word docs and they are stored on a central server (same path for each doc), so I see no problem in having a table containing the filenames as text file names with full paths.

So, when the report is run, the quote is produced, with full pricing and ALSO with the chosen word documents in all of their glory.

What is the best way to do this? Can it even be done at all?

Suggestions on a post card!

Chris
 

A:Access 2003 : Word Docs inside an Access Report

Read other 9 answers
RELEVANCY SCORE 60.4

We have an existing access database that crunches some reports from Quickbooks into a usable chunk of info. It basically shows all of the open purchase orders for a given sales order, where they are coming from, and when they are expected to arrive. Its used as a daily reference to make sure orders are on track to be shipped out on time.

We also use a hand-genearated word document to follow orders as they make their way through the warehouse. This document lists much of the info in the reports from above (SO, POs, Vendors, and Dates), with a bunch of other fields that are filled in by hand as the order goes on its merry way.

The problem is that on any given SO, there could be from 1 - 20 POs. I can create a report easy enough to list the info, but that doesnt give me the ability to fill in blanks and save the info.

Is there a way to make a report INTO a word document? Or is there a way to pull the key info as well as the sub lines (the POs) to a word document?

Jeff
 

A:Using an Access 2010 Qry in Word

Read other 14 answers
RELEVANCY SCORE 60.4

Hi All,
I have alot of experience working with systems Oracle/PLSQL. However not as much experience dealing with Access/VB. I am attempting to solve an issue whereby the Access 2003 database switchboard form opens and functions normally in Access2003. However when attempting open the same database using Access2010 the switchboard form opens but does not function normally. More specifically the form opens but with a blank window. When attempting to minimize the window and then maximizing it the items on the form display.

Any thoughts are much appreciated!

Sysguy!
 

A:Access 2003/2010 Switchboard Issue

Read other 10 answers
RELEVANCY SCORE 59.2

Hello,

I am having issues with Word and Outlook 2003. I just upgraded them from 2000 and now I am running into a couple of issues. Help!

Microsoft Word 2003
- Can't highlight or select an area on my Word page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.

Microsoft Outlook 2003
- Can't highlight or select an area on my page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.
- Can't open Word document attachments only. I can open excel, pdf, etc..., but not Word.

I have restarted my pc, reinstalled office 2003, erased the normal.dot profile, removed the 11.0\Word\Data registry and no luck. Any solutions would be greatly appreciated. Thanks!
 

A:Can't highlight in Word 2003 and Outlook 2003. Can't open Word 2003 attachments.

Read other 9 answers
RELEVANCY SCORE 59.2

Hi

New to InfoPath, but have been doing some 'how to' lessons at work, and we jotted all notes down. Went away, and created the Infopath form, which worked.

Managed to publish to our Sharepoint site, and then when we clicked on our form's Submit button, its supposed to email people, and it didn't.

So, went back to the original form, and all our rules have gone. Someone from IT just had a look when we said it wasn't working, noticed the rules were not there and said that is the reason. I explained we put them there, so he put one back in so we could get it working, and he published it again.

It worked, apart from emailing.

After he went (was doing this via Lync), the rules had gone again.

We saved the rules before publishing the first time, is there something that is needed to select to stop this from happening?

Many thanks

eddie
 

Read other answers
RELEVANCY SCORE 59.2

Hi guyz, (just learning a few new things here so please bear that in mind)

right this may be long so bear with the explanation.
Just got a windows server 2008 r2 build up and running, made sure and got all AD services, dhcp, dns all working fine etc.
Main reason I did this was to run an application server with remotely accesible web apps.

So got sharepoint 2010
installed fine, let me work away on whatever sites i want to fine.
I now want to start testing these sites and access them over the internet.

So where do i start? hoping someone knows of step by step guides to doing this?

I have my site/sites ready to go.
I have a FQDN for my server. The sites are listed in IIS. I have a dedicated adsl line (static ip) which the server is connected to, and made sure all the ports needed to access my sites are open. built in windows server2008 firewall setup to make sure access is allowed to the sites. (no isa)
LAN is all setup for internal and external IP addresses.

now obviously i realise this isn't just enough since i obviously cannot access my servers sites over the internet yet.

Where do i go from here, now i have been looking at other soloutions to my problem, but they are all split down into so many different catagories that im getting a bit confused of where to start and where to look for some of the settings i need to change.
From what i understand so far. I have to create a DNS record linking my FQDN to my ip address?
now i assume this is already done since i alr... Read more

Read other answers
RELEVANCY SCORE 59.2

Hi Folks...

I have recently joined an organization and the very first task is assigned to me is as follows.

We have a Sharepoint Server 2010 deployed over here. There's an site in it which was working perfectly fine till yesterday. Last night sharepoint had some automatic updates. and since then, site is no more accessible.

Following are the updates installed last night, I'll bold the one which i doubt created the problem.

KB2553014
KB2566450
KB2566954
KB2566456
KB2566958
KB2560890
KB2560885
KB2494022
KB2494001
KB2553094
MS Sharepoint Project server 2010 Service Pack 1 (SP1)
MS Sharepoint 2010 Service Pack 1 (SP1)

I Guess project server 2010 SP1 created the problem.
When we try to access the website, it shows the error as follows.

"Project Web App cannot connect to Project Server. For more information, contact your system administrator."

Any Quick help is highly appreciated, Guys please be quick as its my new job and very first task assigned.
Thank you in advance for your kind time and help.

Regards,
Farhan.
 

Read other answers
RELEVANCY SCORE 59.2

I'm "scundered" to only now discover a whole raft of text effects are available within Word 2010 except I can't access them!! That's partly the reason I'm only now realising they exist, as the button's been greyed out and I've continually missed spotting it to investigate until I read about them online and twigged.

Anyone any ideas on how I can get them to show again? I've gone through the options and checked they're all in the menu ok and even tried to set up a new group and put them in there, but same problem. The button shows but as unavailable. I've no issues with any other buttons in the program being like this but given the bulk of my Word usage is text editing, I'm SO upset to have not spotted this a LONG time ago, as no doubt the beta will soon be closing and I've no means to afford the full pkg. So ideally I'd like to be able to utilise the functions and set text into documents that at least then I'll have for future use.

A:Can't access text effects in Word 2010

I could be wrong but I don't remember that feature being enabled in Beta

Read other 2 answers
RELEVANCY SCORE 58.8

I have found from several forums and support sites including Microsoft that many users are asking solution for the error generating by MS Access 2010 or 2007 while running their custom made Access 2003 database usually after after upgrade.
The error is showing as "The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Office Access can't find."

The solution is as below:
This error is causing due to disabled macro setting by default. So you will need to enable the macro as per the following method.
Go to File > Options > Trust Center
Then Click on "Trust Center Settings".
Here click on the Option " Show the Message Bar ... ..."
Re-open the Access File in exclusive mode
Now click on the yellow message bar on to to enable macro..... ..... problem solved.
 

A:Access 2010 or 2007 upgrade error for 2003 database

Welcome to TSG and I appreciate the pro-active post.

A another solution is to learn the Trust Center. In there you can enable all macros.
 

Read other 1 answers
RELEVANCY SCORE 58.4

I am designing a sharepoint site for my office. I am giving each department their own page on the site. The problem I am running into is giving a person specific rights for a page. I.E. the director of the department needs to be able to modify their page to add, remove and modify their page only and view only for all other pages in the site. Any direction would be appreciated. Thanks in adavance.
 

A:Sharepoint 2010 Rights per page

I'm a backup support with SharePoint (SP), by no means an expert. The group has struggled with getting permissions managable. This is a large site collection (7000 members and 100+ sites) and has gone through several configurations over the years. The big thing to learn first is to make multiple site and use a 'site collection'. They learned the hard way.

Using multiple sites (not pages) for the departments allows permissions to work like they want. This also protects the 'other sites' from someone screwing up and taking the whole thing down. Each site has Owner(Full Control), Member(Contibute) and Guest (Read). A mix of Active Directory and SP groups seem to work best. Owners can control membership through AD and the SP group controls and where these groups go in SP.

Some departments have a development site (and a developer) where things(business rules for one) can be tested and not affect every one else. Breaking members out of 'group permissions' is a constant head ache, especially if a member leaves or changes department. That's where mixing SP groups and AD helps. I.E. when removed from AD group they are removed from SP. If you use only AD groups its hard to see\understand the permission on the SP side.

The SP team is understaffed, undertrained but still keeps the SP site collection running and most people happy..Our organization get a lot of production out of SP. AND do not let it become 'document storage'. There are ... Read more

Read other 1 answers
RELEVANCY SCORE 58.4

I was recently put in charge of managing SharePoint for my organization and have wanted to post a batch file for individuals to be able to use. It is saying that I amnot allowed to save a .bat file for users to access. My objective of this .bat file is to allow my users to open internet explorer and have about 20 separate web pages all pull up in different tabs. Any ideas of how to get around this if SharePoint is not allowing me to do this? I have the .bat file written already, and I have also converted it to powershell too... But to no avail that does not work either.
 

A:SharePoint 2010 and Batch (.bat) Files

Sharepoint will not allow certain types of files to be uploaded - .BAT being one of them.

The simplest way to do something close to this is to save the .bat file to a network share location where everyone (who needs it) has access, and then put a "link" to the .bat file under the Links section in Sharepoint. IE will most likely force a user to "save" the file locally though. Which means that they must save the file, then double-click on it to run - so this sounds like it would defeat the purpose of what you are trying to do.

The only other suggestion would be to put each individual URL link under the links section in Sharepoint and put that link page under each user's "Bookmarks" (or Favorites).
 

Read other 2 answers
RELEVANCY SCORE 58.4

Hi

I don't see any questions in here about SharePoint but wonder if anyone can help with this one. We have a corporate SharePoint that we create systems on for various business users. We do not have server access to the Share only front-end.

For one of our applications I created an email announcement list that is emailed by a SQL Server Integration Services package task. When our package runs it sends an email that displays the message on the webpart frame above the data view as to the current state of play with the data.

This is fine except that when a user creates a custom view of the data view, which they do a lot, this Webpart does not show up above the data view. I could add it manually but this would be an administration nightmare for me trying to maintain and delete view on 8 different sites with no idea when and where views are being created.

So I wonder if anyone can hazard a guess as to how I can make this Webpart appear on each custom view as well as the default view (it is imported here as a Webpart); I imagine there is going to be some sort of programming involved, which I don't mind to much but not got much experience in doing this in SharePoint?

Thanks for any input

Andrew

Read other answers
RELEVANCY SCORE 58.4

Using Word2010 and Access2010, I am attempting to build VBA code that will automatically import word form field data directly into my database table.

I have copied code found on the net and modified very slightly.

I am pretty confident I have the word side of the puzzle setup corrrectly.
The Access side using VBA has ben throwing a number of errors.

I have modified the statement in
Code:
[COLOR=black][FONT=verdana]cnn.Open "[/FONT][/COLOR][FONT=Calibri]Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Users\XXXX\Documents\Testing .accdb;".[/FONT]
That got me a step past not being able to open the word file, assume that is correct. Not sure of the required references, but here is what is curently checked. I suspect there may be a mismatch between my provider statement and the references.

Visual Basic for Applications
Microsoft Access 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Access database engine Object library
Microsoft Word 14.0 Object Library
Microsoft Office 14.0 Object Library
Microsoft Visual basic for Applications Extensibility 5.3
Microsoft Active X Data Objects 6.0 Library
Microsoft Office Runtime 1.0 Type Library
Currently I am getting the error "424: Object required". No luck finding the source of this.

I attach that code below in hope someone has a tip that gets me moving again.

Code:
[/FONT][/COLOR]
[COLOR=black][FONT=verdana]Sub GetWordData()[/FONT][/COLOR]
[COLOR=black][FONT=verdana] Dim strDocName As String
... Read more

A:Importing Word form data into Access 2010

I am not familiar with your code, but I do have code that works, however it does require the use of a Word Doc with "Bookmarks" set.
 

Read other 2 answers
RELEVANCY SCORE 58.4

Hi,

If I upgrade only the Outlook part of my Office 2003 installation to Outlook 2010 will the "Ribbon" style menu of Outlook 2010 be installed in my remaining Office 2003 menus?

I accept that at some point I will probably have to get to grips with the "Ribbon" style menus introduced initially in Office 2007. However, for the time being I would prefer to keep the classic menu layouts in Access 2003 and Excel 2003.


Rgds

A:Will Installation Of Outlook 2010 Install Ribbon In Access/Excel 2003

Aud Bint, No Installing outlook 2010 will not add anything to the office 2003 products that you have installed.
One problem that I noticed with office 2003 and outlook 2010 is that Sometimes after a microsoft update where they update some of the office products and outlook. You have to go to installed programs and repair the outlook 2010. It happened almost any time that microsoft updates were run and the office products were also updated.

Rich

Read other 2 answers
RELEVANCY SCORE 58.4

I am having an issue. I'm using XP and when I click 'Open' in Word I get an error message reading:

Microsolft Visual Basic: Compile error in hidden module: modShadowMacros

This means nothing to me. Does anyone know how to fix it?
 

A:Word 2003; Can't access 'Open.' HELP!!

Read other 10 answers
RELEVANCY SCORE 58.4

I just installed MS word 2003 my home PC that runs xp home edition. Every time I start a new document it looks like it tries to access the Internet. Will I be able to use word without Internet access?

A:word 2003 & internet access

I just installed MS word 2003 my home PC that runs xp home edition. Every time I start a new document it looks like it tries to access the Internet. Will I be able to use word without Internet access? Yes you will be able to use it without internet access. I block it from using the internet unless I want it to update.

Read other 1 answers
RELEVANCY SCORE 58

Not sure what I did but I recently modified a document on our SharePoint and saved it locally. Now when I open that master document on SharePoint it opens the one I saved locally a while back and asks if I want to update the server. I've searched on various forums for a fix for this but have yet to find a solution.

How can I open these master documents on sharepoint without having it ask to update the server. I'd hate to accidentally save over the master document.

I'm using MS Office 2013, and SharePoint 2010.

Read other answers
RELEVANCY SCORE 58

Dear all,
Some of our business users have been complaining that since the time of installing Office 365 recently on their systems, they are not able to open SharePoint lists/libraries.
Is there any issues/fix identified regarding the same ? If so please advise . Appreciate your help

Thanks & Regards
Ajay 

Read other answers
RELEVANCY SCORE 57.6

I have an Access database and a folder containing template letters created in Word. Command buttons in Access open and merge with the template letters in Word. Both applications were written in Office 2000, and work perfectly. My client has now converted to Word (only) 2003 and the mailmerge no longer functions. Questions:
1. I know that there's a mailmerge bug in Word 2003, and the service pack does not fix it. Does anyone know of a fix?
2. Is it possible to run Word 2000 and 2003 concurrently on one PC, and....
3. If I dump Word 2003 and reload Word 2000, can I open documents created in Word 2003?

Thanks
 

Read other answers
RELEVANCY SCORE 57.6

I have created a report in Access 2003 which shows each customer's invoice on a separate page. I want to transfer this to Word 2003 so I can use the mail-merge facility to email it to customers. However, when I use the Office Links icon & select Publish It with Microsoft Word (the only option for reports) it puts all the invoices simultaneously into the document rather than retaining the separate pages.

Does anyone know a way around this, please.
 

A:Access 2003 Publishing report to Word

Read other 7 answers
RELEVANCY SCORE 57.2

The scroll bar does not appear on the loading of the sharepoint site. It appears only after refreshing 2 or 3 refreshes. We have found that SP.Ribbon.js does not load on page load it gets delayed as it appears after the refreshing.
 We have tried various CSS work around but could manage to get the scroller in browsers but the ribbon will not still appear. from CSS we are able to bring scroller but its a Page scroller but ribbon wont work, somehow we need to load sp.ribbon.js
after all webpart loads at one server request by the browser.
if any more information  required please get back to me.
we tried.

http://kyleschaeffer.com/sharepoint/sharepoint-2010-scrolling/ 
http://www.greggalipeau.com/2011/01/28/a-better-enhanced-sharepoint-2010-floating-ribbon/
http://www.webpoint0.com/blog/fixed-width-layouts-scrollbar-ribbon-sharepoint-2010/


Guruprasad Marathe

Read other answers
RELEVANCY SCORE 57.2

Hello,
we are about to upgrade from IE9 to IE11. While testing we found a problem when opening our sharepoint 2010 site. At the bottom we get the following message:
"This webpage want to run "NameCtrlClass" which isn't compatible with Internet Explorers enhanced security features. if you trust this site, you can disable Enhanced Protected Mode for this site and allow the control to run." 
You can choose between "Run control" oder "don't run". But the result stays: The message still pops up every time.
I searched the web and realized that the NameCtrlClass is used to display the availability of a person in sharepoint. As this feature is not used we disabled the NameCtrlClass through GPO. But its not helping either :(
Ah, we are using Office 2010, and the NameCtrlClass Version is 14.0.6109.5000. So we do not have the common error, that the NameCtrlClass wasn't updated while installing Office 2013.
Any ideas how we solve this problem?
Thanks a lot for every hint
Jan

A:IE11 - NameCtrl Class not compatible on Sharepoint 2010

Hi,
It is unclear from your question whether the
"This webpage want to run "NameCtrlClass" which isn't compatible with Internet Explorers enhanced security features. if you trust this site, you can disable Enhanced Protected Mode for this site and allow the control to run."
occurs with IE9 or IE11.
you can try
1. File>Properties .... which IE security zone does the sharepoint site map to (expected Intranet).
2. Tools>Internet Options>Security tab, click "Reset all zones to default"
then Intranet sites icon, uncheck "Enable Protected Mode"... close all open IE windows and restart for the full changes to take affect.
3. Tools>Manage Addons>Show all addons..... locate NameCtrlClass in the list and double click on it to show its properties... also make sure that is enabled.
Please post back with your answers to my questions if your sharepoint site currently does not map to the Intranet zone.
Regards.Rob^_^

Read other 3 answers
RELEVANCY SCORE 57.2

Anyone has any idea about Microsoft SharePoint 2010 servers?

I am trying to click "Manage User Profile" under the Service Application. But whenever I do so, I get this below error.

The service is already running. I am trying to setup personal sites for each user to access their /my page. But I keep getting that above error.
 

Read other answers
RELEVANCY SCORE 57.2

I've created a new enterprise WIKI and uploaded documents to the 'Documents' Library on the WIKI site. If I browse to the document library and click on one, it opens the document within the browser (Office Web Apps are installed). It allows me to view and edit the document inside of the browser without having Word installed on my machine. However, if I create a link to the document on a WIKI page, it prompts to Open or Save (Open meaning download and open in Word). It only will open in Word and not in the browser.

For some reason I can't get it to open within the browser even through the default action for both libraries are to open documents in the browser. Is there another configuration option I am missing? Maybe a setting when I create the link? Or is this just the way it works?
This is Sharepoint 2010 Enterprise. The documents in question are Office 2010 .docx files.

The way I am creating these links:
Create Wiki page, highlight text for link, Click Insert, Link > From Sharepoint, double click on document I want it to open. Save page.
 

A:Sharepoint 2010 Links to Docs Prompts to Save

....
 

Read other 3 answers
RELEVANCY SCORE 57.2

I am in the process of assisting some users in switching from Win XP/Office 2003 -> Win 7/Office 2010 and have hit a roadblock. I have a user that has an excel macro that opens an ADO connection to a SharePoint and grabs a record of the excel files on the SharePoint. The macro works perfectly on XP/2003 and XP/2010 but fails on 7/2010.
They are using this connection line:

Code:
davDir.Open "", "URL=http://SharePoint/Directory/URL", _
adModeRead, adFailIfNotExists, adDelayFetchStream

Set davFiles = davDir.GetChildren()
Once they have the record they iterate through each Excel file on the SharePoint to open and parse them.

On Win7/2010 I get these errors when it gets to the davDir.Open line:

When they error trap it throws this error:






Quote:
Object or data matching the name, range, or selection criteria was not found within the scope of this operation.


Without error trapping it throws this error:






Quote:
Run-time error '-2147217895 (80040e19):Automation error


I can connect to the SharePoint fine via IE or File/Open in Excel 2010. I have tried every variation of the URL I can and I just keep getting the same error.

Does anyone have any ideas? The fact it works on XP/2010 screams Win 7 issue to me, but beyond that I am lost. I have spent the last 2 days scouring Google and I am starting to lose my mind.

Thanks!

A:Excel 2010 WebDav Connection to SharePoint Errors

I've had just this problem and have narrowed it down to making the connection. The following code produces the same error on SP 2007 from Win 7:

Dim Conn As New ADODB.Connection
sURL = "http://sharepointtest2/personal/kraviss/Test docs/ACT Contracts Data" RepositoryRepository"
Conn.Open "URL=" & sURL


I've found WebDav to be most unreliable when uploading files to SP doc libraries and a little less unreliable when reading properties. I use the Frontpage Server extensions to do most uploading. FilesystemObject calls work most of the time to get file and folder properties - the following code fragment will get folder contents. sFolder is the UNC path for the SP doc library

Dim objFSO as New Scripting.filesystemobject
Dim objFolder as Scripting.Folder
Dim colFiles as Scripting.Files
Dim colFolders as Scripting.Folders

sFolder = "\\sharepointtest2\personal\kraviss\Test docs\ACT Contracts Data"
set objFolder = objFSO.GetFolder(sFolder)
set colFiles = objFolder.Files
set colFolders = objFolder.Subfolders

This will need a reference to Microsoft Scripting Runtime scrrun.dll in C:\Windows\SysWOW64

Read other 1 answers