Answer Questions

• salvodif Open a Word Document

  Hello i need to find out how to open a word document from my access database any one know a good solution. i have an ole object and you can drag and drop the file onto it but i need a way to have it load up in Word so it can be read/written/printed via word 2003. The following code actually opens a Word document in Microsoft Office Word 2003 from a ASP.NET 2005 /Framework 2.0 Webform. Imports System Imports Microsoft.Offic ...Show All

• Bruce_Daddy reportbuilder

  Hi all, I have seen forms in databases where users select from unbound fields and click a button that would give them a report based on their selections. Here's is the code but it give me an error "object required" Private Sub cmdPreview_Click() On Error GoTo Err_cmdPreview_Click Dim strSQL As String Dim strnewQuery As String strSQL = strSQL & "[" & ctl.Name & "] " & " like " ...Show All

• Markis_au Strange Error

  I have an Access 2002 SP3 DB and on occasion it seems to corrupt and all forms are no longer accessable any 1 else had this problem i am unsure to what causes it so cant fix it. i open it and it reports a corrupt error offten after a change to some code has been made and saved i always test before before closing so i know it works fine then on next load it corrupts and the MDB file is reduced to only half its original size. any help or adv ...Show All

• Justin Chase getting web pages from VBA?

  Dear VBA gurus, I would like to open and process a web page in a function in VBA version 6. (I am calling VBA from Excel 2000.) Thank you! Hey, Is this what you mean Sub CallWebPage() ActiveWorkbook.FollowHyperlink _ Address:=" http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=225018&SiteID=1 ", _ NewWindow:=True, _ AddHistory:=True Application.WindowState = xlNorm ...Show All

• JonathanNTU Help with using Outlook from Access

  I am openning Outlook by calling createobject, which I expected to open a new instance of the application. However it appears to use the one open on my desktop. This means that my quit statement closes my e-mail. How should I amend the below to leave my original e-mail session open Also I will be replacing the debug.print statement with code to work with the attachment to copy data into my database. I am intending to save the file to a tempor ...Show All

• frostfire Help with DDEExecute

  Hello, I have created two excel workbooks called Server.xls and Client.xls. Client.xls has a button which when clicked executes the code below. Private Sub cmdSendCommand_Click() lChannelNum = DDEInitiate("Excel", "[Server.xls]Sheet1") sRequeststr = "[New]" DDEExecute lChannelNum, sRequeststr DDETerminate lChannelNum End Sub When the button is clicked in Client.xls indeed a new blank workbook ...Show All

• Alan.328 ftp using vba

  I hope I am posting this to the right place. I am trying to do a save as to an ftp location. The following works ....but... I have to establish the ftp connect each time the computer is started, So somehow I need to establish the Initial ftp connection within the code.. And once the save as is done I need the ftp connection to be stoped so that it does not remain open In short the need is to open an ftp location save the file to the loc ...Show All

• Akheiran Excel 2003 Macro to VB .Net v7

  All,   I've seen bits and pieces of this topic, but not enough to get me there, so here's my situation.   I've created a set of Macros in Excel 2003, that I want to turn into a .exe that can be called from a DOS window with a set of command line parameters. I would think the first thing that needs to be done is to save the Macros as a VB Project, but I don't see how that is done    I would then think the next thing that ...Show All

• Robert Finch 'Call was rejected by callee' using VBA with Excel

  I'm trying to debug a VBA routine (which basically updates data in an Excel file.) that has recently migrated to a new platform. (FYI: old platform= Windows 2000 Server w/ Office 2000; new platform= Windows 2003 Server w/ Office XP.) I'm pretty sure that the problem isn't with the platform per se. The routine is usually launched from a scheduler program and runs under a service account (I'm assuming the permissions for the service account ...Show All

• kiranin Own Right-Mouse-Click Menu item in Outlook

  Hi everyone! Can somebody tell whether it is possible to have like an extra menu item in the right-mouse-click menu. Say, if I had a Macro called "DoThisOrThat" then it this would appear in the right-mouse-click menu What would be the code for this (maybe even: what's the code for this if it was to appear as "start a new group", ie. with a dividing line to the other menu options) I think you can do this in Excel but I don't ...Show All

• MichaelBrietzke Programatically Add Pages to MultiPage Control

  Can someone please provide assistance in adding pages to a MultiPage control programatically. I wish to add pages based on a user's input. Thanks for any assistance. Hi, this will do it... use the MutiPage control's Pages collection to Add a new page, the first parameter is the name of the new page, the second parameter is the caption. This returns a Page object of the Page you added. You can use to ...Show All

• bhargavpatel Business Scorecard 2005 Installed - Just cannot connect to Analysis Services database

  Followed the readme for installation step by step. Installed the Server and the Builder on the same machine - db is SQL Server 2005 April CTP.  - Will the Business Scorecard work with the April CTP  - Launched the BS Builder and when trying to connect to a ADOMD.NET datasource, in server specified the <Servername>, the database dropdown always comes blank.....error "could not connect to data source" (Analysis Services is run ...Show All

• emtiez MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• loreyvt Help required.....

  Can someone help me please I am trying to create a VBA User form to open up individual Spreadsheets rather than having to have all the sheets open (as with a workspace). I have designed the user form and now need to code the command_buttons. However I am stuck with what code I need to use. If it helps, I need to program 7 buttons, 6 will open spreadsheets and one will open a MS Project file. This is fairly urgent as I have to have ready ...Show All

• azstrummer Extract text within several tables in word document

  Hello everyone, I have several word documents where there is some text inside some tables that I want to extract. The formatting of this text is (or at least, should be) pretty unique where no other text within this word document has a table around it like it. The text I want to extract looks something like this: Rack 4, Breaker 3 The script should basically scan through the whole word document looking for all instances o ...Show All