I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" and "Microsoft Office 12.0 Access database engine Object Library." The stuff I've read on the web says that the ADE 12.0 is supposed to supercede the DAO 3.6 reference, and that by just checking the ADE 12.0 box everything should work. Since they both provide references for objects of the …

Member Avatar
+0 forum 0

Hey people, first all let me apologise if this in the wrong section I couldnt find a seciton for office or just excel. So i figured windows software was my second safest bet, he hopes lol. I'm having a problem with excel. I'm trying to write a function that will search for an email address and find out if they are un-subscribed or not. But I would like it to not just search once but do so for 500 different email addresses, as atm i am doing it all myself and their really isnt that long in a day. EG …

Member Avatar
Member Avatar
+0 forum 2

Hi, My code opens Excel 97-2003 version Excel file correctly, but gives error when the Excel file is in 2007 (*.xlsx) format. How to solve this? - Mahesh

Member Avatar
Member Avatar
+0 forum 2

Hi I have designed a database for use in an academic arena, but I have come across a problem that I can't find an answer to in the help files or on the web. I think it is something really simple but frustrating to put right! I have designed a form in Infopath which works and sends data back to the database. I have also designed a form in Access which also works. There is a unique identifier for students which is Alpha Numeric, I couldn't find a field that allowed A/N input so I made two fields one text …

Member Avatar
Member Avatar
+0 forum 2

Hi all. I attached a code creating file from datatable. I have a problem saving Excel file in c# using Microsoft.Office.Interop.Excel. When I'm saving the file as Exsel 2003 (xls) format the file is OK. When I'm saving the file as Excel 2007 (xlsx) format I get error massage from office Excel 2007 regarding the file structure. what should I change in the below code in order to save the file in 2007 format. thanks in advance. [CODE] Microsoft.Office.Interop.Excel.Application app; Microsoft.Office.Interop.Excel.Workbook workBook; Microsoft.Office.Interop.Excel.Worksheet workSheet; object misValue = System.Reflection.Missing.Value; app = new Microsoft.Office.Interop.Excel.ApplicationClass(); app.Visible = false; workBook = app.Workbooks.Add(misValue); workSheet = …

Member Avatar
Member Avatar
+0 forum 5

Hi, Outlook 2007 goes offline, once I shutdown or restart the system, even after work offline option is unchecked. Please help me to know the steps how outlook can be online. I am using windows XP service pack 2.

Member Avatar
+0 forum 0

I have installed Microsoft Office Home and Student 2007 on windows 7, and it is installed good, but when i try to open Word or Excel it gives me a message saying "Microsoft Office word (excel) has not been installed for the current user. Please run setup to install the application." i have reinstalled it again and again and it always gives me the same message. Does anyone have any idea why it gives me this message and what it means by (not installed for the current user)?!!! Thanks in advance.

Member Avatar
Member Avatar
+0 forum 1

greetings, on my xp / ofc 2007 system, i have copied several documents in to a single doc. on the far right hand side / past the right hand margin, there appears a great deal of white space... to what appears to be a page width of ~10". i have checked / re-checked the page size, orientation, etc, and can't find the hiccup. seems likely to be operator error, but in a 400 page doc (w/images) i'd appreciate any tips you have to offer on finding the error / hiccup. thx in advance.

Member Avatar
Member Avatar
+0 forum 2

Yesterday, the [URL="http://www.businessweek.com/technology/content/dec2009/tc20091222_416170.htm"]Federal Appeals Court ruled[/URL] in what appears at first blush to be a shocking decision, that Microsoft must stop selling Word 2007 by January 11, 2010. But a closer look at the decision suggests that this isn't as big a deal as it first seems. Sure, Microsoft has to pay Canadian developer [URL="http://www.i4i.com/"]i4i[/URL] close to $300 million, but that's really chump change for a company that has tens of billions in cash reserves. Microsoft itself has tried to minimize the impact calling the disputed tool, "a little used feature." Regardless, it appears, this has no impact on product …

Member Avatar
+0 forum 0

I have a machine here running Windows XP with office 2007. The prob is when you send a mail it shows 2 mails leaving outbox. I've checked for spyware with ScanSpyware and the have licensed nod32 firewall and antivirus running for over a year. I checked if it might be some setting but everything is seems fine. No read receipts etc. which I thought could cause it either. Has anyone ever heard about outlook 2007 or earlier doing this? It bugs me and would really want to change this, or atleast understand why.

Member Avatar
+0 forum 0

I have an Add-In for Excel 2007 (can't post the code here unfortunately) and in some instances, when the user makes a certain change within the Add-In then closes Excel 2007, they are prompted to enter the password for the VB code within the Add-In. The password prompt dialog can be closed by killing it in the Task Manager but we'd still like to get to the bottom of what's causing this issue so that we can save our users from the annoyance. The information I've found online from Microsoft references that Google Desktop or the Google Toolbar may interfere …

Member Avatar
+0 forum 0

hi am developing a Outlook form using csharp, if am click Get contact button contact in the outlook are displayed in the 'datagrid view' . Its working well. at the time am getting a error message as "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". (ChkBox) Allow access for (x minute) Yes / No ****** I click 'Yes' means contacts details are displayed in the datagrid view. I want to disable the these message alert. …

Member Avatar
Member Avatar
+0 forum 2

The End.