Answer Questions

• fattycat Problem solved!

  After working fine for days the following standard code to send an Outlook email is not running: Dim objOL As New Outlook.Application Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) I get now the following error message: Run-time error Automation error The specified module could not be found When I click on Debug the line code in yellow is: Set objO ...Show All

• Matthew Feng Accessing Win32 API in VB script(.VBS files)

  I used the win32 API functions in VB Script to find the window handle of a message box using a wrapper dll (dynwrap.dll) In the same application I have to get the window text for the message box. I used the getwindowtext API function. In this API function the window caption is stored in string. But in VB Script we can use variant data type only. With this variant data type the API function does not return the window caption. It returns o ...Show All

• ChrisWFL BSM Scorecard Report Views

  Hi All, I have created a scorecard,and added 2 reportviews(Type:Pivot chart) in the report view Tab, both of which belong to the same group i.e 1. I have added this scorecard on my sharepoint site along with Report view Web part and defined the relationship between them,by connecting them using "Webpart connections" . I have also selected the "Report view groups" thats needs to be displayed in the "Reportview w ...Show All

• Brendan Egan pl help ,how to give warnings or Error Messages in Access Reports

  dear ISV's i am trying to print label in the report using vba. with some conditions for printing. for example: if one of the input value is above the stored value in the table(database) i want a warning message or Error message or exit: which i want something look like this " Plz enter the correct value" and should exit . But now my current situation is this , when i enter the value above the stored value in tabl ...Show All

• NL_Sander VBA Visio 2002 and OpenEx

  Has anybody else experienced that the flag argument to the Documents.OpenEx method have no effect in Visio 2002 I try : Call Documents.OpenEx(FileName:=MyFileName, Flags:=vizOpenDontList + vizOpenMinimized) But I see that the Visio document opens maximized and it also appears in the history list. What am I doing wrong (I see that the Object Browser calls the argument Flags , while the help file calls it openFlags ) Thanks in adv ...Show All

• west coaster how to change the picture when i change the combobox selection?

    I designed a OUTLOOK form . There is a combobox control which list cities . I want to add a image control and text control that can show the picture of the city and a breif description of it. when people change the combobox selection, I want the picture changed to the the responsible city pictures and the breif description. How to do that     ...Show All

• Kervin CGI Upload

  Hi I'm using the following code for PDF file upload via perl The code is working. but the file size is zero bytes any suggestions #!/usr/local/bin/perl -w ####### Load Needed Perl Modules ###### use strict; # Make HTML/FORMS/UPLOADING easy to deal with use CGI; # Report errors in the browser use CGI::Carp 'fatalsToBrowser'; # Limit file size $CGI::POST_MAX=500000;  # max 100K posts #######   End Perl Module ...Show All

• LTN Removing Hyperlinks

  Hi I have inherited an excel database with various links somewhere that i cant find. Everytime I open the file it will ask me for the file.Obviously its linked somewhere within the spreadsheet. When I get into the spreadsheet I tried to search for the links but could not find it. Question. Is there a way to show up all the hyperlinks and remove it from the file Thanks Try looking at the list ...Show All

• jackycn Problem with RecordCount by CrossTab

  Hi, i'm getting a problem with a CrossTab in Access 97. When I open the query by clicking twice it returns 4 records. Thats OK and correct. The problem is when I open the query with VBA code, it returns 1 record (property recordCont = 1) I'm opening the query this way: Dim DB As Database Dim MyQuery As Recordset Set DB = CurrentDb Set MyQuery = DB.OpenRecordset("CrossTAB_Compras") Anyone can help Thanks, Felipe ...Show All

• AAx as400

  I have been researching a way to rread data from an AS400 database using MS Access, but have been unsuccesful in finding something listing step by step directions. Is there any way to retrieve data from AS400 using MS Access or VBA alone, or do I need other things Thanks in advance, geebee I DO NOT want to use any additional proprietary software. Thanks I have done this using some additional software. We used N ...Show All

• FedorSteeman Microsoft Partner Program

  Started by adityabhatia at 04-26-2005 1:34 AM. Topic has 0 replies.  04-26-2005, 1:34 AM adityabhatia Joined on 04-26-2005 India Posts 1 Microsoft Partner Program Any Possibility to serve Education accross the country Hi Kumar, Could you please help us understand your question Thank you, Mustafa Kilicaslan ...Show All

• DragonWalsh from VBA to C#

  Hi! How I can get value of VBA -variable from C# Or How I can run C#-method from VBA Sorry my english. Per one of our support engineers: Based on my understanding, our buddy wants to have cross language interoperation. He wants to call VBA in C# and call C# in VBA as well. Here’s my update. 1.        How to call VBA in C#. ‘Microsoft Script Control 1.0’ component is ...Show All

• Sérgio Brito Accessing Active Directory trough Access 2002

  I need to build the security in one of the Microsoft access app based on Active directory.How can I assess Active Directory trough Access 2002. Thanks Marina Per the support engineer: Buddy mentioned that he would like build the security in one of the Microsoft access app based on Active directory and he wants to know how to access Active Directory through Ms Access 2002. I would l ...Show All

• Peter Homberger help me

  hi every body i want to know how to write the macros to access the data base form sql server using vba for excel .please help me You want to look into ADO. There is FAR to much to cover in a post but ADO but it's what your looking for. ADO are objects that let you communicate with a data source, including Access and SQL Server. To be honest your best buying a book on it. D. Sceppa - Programming ADO (MS Press) looks good. ...Show All

• laurie0718 ScrollBars for Userforms

  hi, I want to enable scrollbars for the userforms created during design time. I am adding certain no of controls based on an input during runtime to the userform which was created during design time. I want to have the size of the userform fixed and if the controls are more then enable the scrollbars so that we can scroll and view the controls during runtime. Is there any way to do this regards, sk80. ...Show All