I notice that I have ACCESSRT.msi and ACCESSRT.CAB on my MS Office Professional CD. Why would I need VSTO? For the packaging wizard? Why can't I just install these files on the computers of my users and then an .mde file?
Why would they have included these files if this wasn't their intention?
It just seems silly that I would have to pay $799 for files that are included on my disk. (Microsoft? Silly? Surely you jest.) I would need VSTO for absolutely NOTHING else but this.
Can someone "enlighten" me on the thinking here?
I would also clarify this is for interoffice work only (if it makes a difference) and not something I'm distributing for a "paid" end user.
Hi, I have created a database with Office developer 1.5 and I am having problems creating my runtime version. I have been told that the VBA included in this program wont do the job, that I must purchase a full version Visual Basic 6.0. Is this true? Thanks all
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard. But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007. I can't use the Package Wizard.
Is there anyone based in or near Nottinghamshire (UK) who would be interested in reviewing the current database system we use at our office? We are a skiing holiday company and the database is fairly complex.
It was created about ten years ago and over time has had various bits and pieces added on etc. and I am under the impression it is currently a mess!
I am looking for a professional database developer, not an amateur who fancies themselves as such! If anyone can help, please post your details and credentials and I'll give you a shout.
Please can you help. I have installed Windows XP Professional and Access 97. When I start the database by clicking an ENTER button on a form I get the following message:
The OpenForm action was cancelled
You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box.
For example, you used the close method to close a changed form, then clicked cancel in the dialog box that asks if you want to save the changes made to the form you used a method.
I have installed SP1 and 2 and the problem persists. I know the database can run as it is working on my laptop with XP Pro.
Hello If the web server is windows 2000 server.there no problem. If I am changing it to Windows xp professtional.I am Getting the following error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa34 Thread 0xeb0 DBC 0x1052ed4 Jet'.
While opening a connection to access data base. How to solve it?
I have developed an Access mdb file with lots of tables, forms, queries, reports, and VBA code. I want to be able to distribute this to Access-less users. I understand that the Access Developer Extensions enable this to be done and that the two wizards assist.
My first question is this: Are the Access Developer Extensions and the two wizards included in Visual Studio 2005 Professional Edition?
I ask because this is what was recommended by a Microsoft representative and is what I’ve purchased. This came along with something called MSDN Library, but I’m not sure what that allows me so it is possible that this library will contain the elements that I’m searching for, but so far I’ve not found it.
Are the Access Developer Extensions only provided as part of the Visual Studio for Microsoft Office Tool package, as I’ve seen referenced in several forums and articles, including yours, or are these in fact part of other tools, such as the Professional Edition of Visual Studio that I’ve purchased?
I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .
Code: Loop through files in folder folderspec = "O:QA FilesQC ReportingPending Review" Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.GetFolder(folderspec) Set fc = f.files
I needs some advice on how to proceed. Our company is devolving some operations to a sub office for 3 out of 11 business units. we have a central DB that we use to record monthly events the problem is that the parent group has to be able to update records for all units but the sub office is only allowed to see and edit their records
At the moment the data is all stored in one table and we use a Front end back end with local front ends for access I have a table to say if a unit is part of the sub office or not and in the sub office front end i have a Query which links the 2 tables together and filters the records to show only sub office
SELECT tbldatatable.*, tblShipName.Manager FROM tblShipName RIGHT JOIN tbldatatable ON tblShipName.ShipName = tbldatatable.Ship WHERE (((tblShipName.Manager)="nv")); the remainder of the forms and querys all run from this query rather than the tables
the problem is the join makes it a non updatable record set
what is the advice on how to achieve what i need as i cant see a simple way to proceed thanks ND
All of the session from PDC content is also available online to anyone, for free, for six full months. For more information, refer to this blog post http://blogs.msdn.com/mswanson/archive/2005/10/24/484434.aspx. There are a few sessions that are interesting from the Access perspective:
OFF307: “Access 12”: Developing Collaboration Solutions with “Access 12” and Windows SharePoint Services “v3” Speaker: Clint Covington – Broad overview of many new features. http://microsoft.sitestream.com/PDC05/OFF/OFF307.htm#nopreload=1&autostart=1
OFF201: “Office 12”: Introduction to the Programmable Customization Model for the “Office 12” User Experience (Part 1) Speaker: Jensen Harris – explains the philosophy behind the new UI and the ribbon changes. http://microsoft.sitestream.com/PDC05/OFF/OFF201.htm#nopreload=1&autostart=1
OFF302: “Office 12”: Developing with the Programmable Customization Model for the “Office 12” User Experience (Part 2) Speaker: Savraj Dhanjal – explains how to customize the new UI. http://microsoft.sitestream.com/PDC05/OFF/OFF302.htm#nopreload=1&autostart=1
OFF310: Windows SharePoint Services: Developing Collaboration and Tracking Applications Speaker: Mike Morton – explains many of the changes to WSS that can be used while building Access applications with WSS link tables. http://microsoft.sitestream.com/PDC05/OFF/OFF310.htm#nopreload=1&autostart=1
OFF417: Visual Studio Tools for Office “v3”: Creating Office Application Customizations Speaker: Andrew Whitechapel – details around how to develop managed task panes and addins for Office including Access http://microsoft.sitestream.com/PDC05/OFF/OFF417.htm#nopreload=1&autostart=1
OFF415: Windows SharePoint Services: Developing Custom Workflows Speakers: George Hatoun; Pravin Indurkar – details about workflow that can be used while building applications with WSS. Access will have hooks for working with WSS workflow. http://microsoft.sitestream.com/PDC05/OFF/OFF415.htm#nopreload=1&autostart=1
Last, if you don’t read the blog post, know that you can right-click on the speaker video, choose Play Speed, then Fast to watch the presentations at a higher speeds.
Enjoy!
-------------------- Clint Covington Lead Program Manager, Access Microsoft Corp.
Not sure if this has been posted yet. Microsoft has released beta of Office 2007, this includes a new UI to many of the old office programs. For the time being you can get it here: http://www.microsoft.com/office/preview/beta/getthebeta.mspx
Beta 2 of Internet Explorer 7 has also been released: http://www.microsoft.com/windows/ie/default.mspx
And I know I've posted on this before, but just so it is in the same place, Visual Studio 2005 can be downloaded here: http://msdn.microsoft.com/vstudio/products/trial/
There are also many business-oriented programs in beta for testing. If you own a small business, or think your company may have a need ~ test it out, get a feel, for free.
I just found out something that was pretty cool about Office 2007, specifically Access 2007 and Outlook 2007. Working with them together, you can create an email form to gather data for Access and when the email is returned, all filled out, Outlook will export the data into your specified Access table.
I just played with it a little and it appears to have some issues when dealing with multiple tables, but for a simple data gathering it would seem pretty cool. In fact you can set it up so that it won't automatically process until you want to, or you can have it process right when the email comes in.
If I design an .ADP project in 2007, will users be able to use this if they only have Office 2003? ...or is there a way of making an exe file with Access projects?
Ever since my company upgraded everyone to Office 2003 I have the following issues:
When I click the checkbox that automatically send an email I get the following Pop-up.
"A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this?
If this is unexpected, it may be a virus and you should choose "No". Then you click either yes or no.
After you click yes you then get the next Pop-up which basically says the same thing and you have to click yes again and it finally take you into outlook so the email will go.
Is there anything to get rid of this nuisance? We did not have to do this with Office 2000. I have lowered the security to as low as it will go and still this keeps happening.
I had a Label in the form that when i started design the Form, I supposed that will be permanent. After few records, users needed to change the Text on that Label depending the customer they reffer to. Therefore i attached a Microsoft Word Document OLE Unbound Object to give permission to users to change the text when they need it. But if u change the text in one record then will change to all of the other records. Can u give any idea how i will manage to have a default label for all the records and users when they need to change the Text only for a particular record. Is this possible? Or I need to declare it as a Field on a Table therefore can be saved in every record? Please any idea... Thank you
I hope I am in the right forum area. I have just upgraded to XP Home and have a choice of Office systems to install. However I have Office 97 Developer Edition that I use for Access Databases and this must be installed. I can also install either Office 2000 or Office XP Professional. What are the problems with having any of these combinations and Access 97 with the developer.
I have heard that there may be licencing issues or I may have to install in a particular order. Any advice would be appreciated.
I´m thinking of starting to use office XP for a small system I have. My question is:
Is office XP more compatible with internet explorer in terms of VBA automating? I have had to work around internet explorer quite a lot in office 97, and I haven´t been able to do what I want.
We just switched to Access 2003 (from 2000) last week, and now none of my reports will open. Everything else works fine, I can open tables, queries, forms, etc., but I can't even open a report in Design mode.
Has anyone else had this problem? Is it an Access 2003 quirk or am I doing something wrong? Any ideas on how to fix this would be great. Since all of the other objects work I guess I could just redo the reports--there are only thre of them. I seem to remember something funny happening when I moved from Access 97 to 2000 too...
Just wondering what the consensus is on MS Office 2007 package. I find it tasty and is quit different from the past versions. That being said, I am relearning the options and finding many new features that weren’t available in the past.
