Hello, What are best practices for deploying an Access application? I use a BE/FE architecture, both parts Access 2007. I don't want the users to change the VBA code or the design of forms or tables. May be adding adhoc queries. Should a make a ACCDE file? Thanks in advance for your suggestions. ...
I’ve got a macro that does a search/replace in a selection but at the end of the task it shows the 'Do you want to search the remainder of the document' dialogue and I never want it to search the remainder so I’d like to have it click ‘n’ and then continue with the rest of the doc. In is there a way to do this? ...
I have a simple COM add-in for office that I am developing (for access specifically). I have added a custom commandbarbutton item to the context menu that pops up when you right click on an object in the navigation pane. This works fine. The debug code I added runs (currently just a msgbox command). The one thing I cannot figure out ...
This is still related with my previous questions, VBA: How to display an error message just like the standard error message which has a “Debug” button? Now, I successfully make the current cursor in VBE jump to a particular procedure in VBE. I used Application.Goto to achieve this. However, what actually I want is to make the current cu...
I want to find whether ms office is installed and version of it... how can i do it ? ...
After creating a new account in Windows 7, I can't type Persian in MS Word. When I press the keys, no letter appears in screen. I have checked all setting of Regional and Languages in control panel but to no avail. Also, in MS PowerPoint, when I type, the letters are detached. The mentioned problems do not occur when logged in to the mai...
I have an excel table that looks like this: Date Original Actual 11/10/10 15 12 12/10/10 12 10 ... 24/10/10 2 1 25/10/10 -2 0 I want to know the date at which the original column becomes negative, 25/10/10 in this example. I've managed to figure out the va...
Where would I even start? I doubt that the save file formats are published .. or ... didn't MS move to XML? Or can you still save MS proprietary stuff? Would it be easier to implement a stand-alone program, or somehow integrate it with MS office? I am just curious. Looking for a new hobby project, but I think that it could turn out to ...
I am aware of of the infamous Considerations for server-side Automation of Office from Microsoft and it clearly lists products from the 2010 suite. However, today I was made to believe by an IT ops techie that Office 2010 does not suffer from the issues mentioned in that article and can be used without issues within a server environment...
Hi All, I just want to know is there a way of locking a MS-Word files author, while keeping the document editable. in MS-Word 2007 currently you crate a document save the document right click on the document and go to properties go to summary tab it shows the 'author' of the file and it can be editable. what I want to do is, lock ...
We are currently investigating options for migrating a legacy application built using .NET 1.1 to .NET 4. Office 2003 was used in the application and we need to migrate away to Office 2010. The old application used CDO/MAPI to interact with Excel/Outlook... so what is the prescribed p&p for accessing Excel/Outlook 2010 from .NET 4? ...
I'm designing a ribbon in Visual Studio 2010 and I have reached a problem, that I really don't get. As the title says, how do I change the size of a group? There are no visual way to change the default size and it seems to auto-size when being used instead. My main problem is that I want to position the button labeled "test" to the rig...
I wrote an office addin and with which there is a function : openFile(String path) and in the office addin I embed a browser object and with that I can embed a webpage on the office addin, and now I hope I can call the C# function "openFile" and pass in a path in the webpage with javascript, and let office open the designated file for me...
Hello all! I'm pulling my hair out because I've run into the following problem with one of my clients: My program uses extensive VBA automation in Word. Macros are saved in a specific Word template that is attached to each document. Some of the macros save the current document to a temporary folder under [User]/AppData/Roaming/... for ...
Hi, I am using PHP COM Object but i guess it is the same in all other languages. How do i add watermark to a .doc / .docx Microsoft Word using COM / OLE Automation? try { $word = new COM("word.application") //$word = new COM("C:\\x.docx"); or die(error::asString("couldnt create an instance of word", 20100408.01812, true...
Are there any free alternatives to using "Microsoft Excel 12.0 Object Library" component in the application? It does the job, but it's very slow. I know there are commercial third-party tools, and wondering if there's anything fast, but freeware to accomplish the task. ...