Answer Questions

• James Webster Beta 2 resource kit SQL server 2005

  Just installed the hands on lab  files to run from Virtual server 2005. Installed fine but as soon as you log in to W2K3 it say the license for the trial period has expired and windows shuts down (reboots continually actually but same difference) Whats the solution. (an why must i shut down my firewalll (zonelabs) every time i need to post to a thread, thats annoying as well!) ...Show All

• George R. Execute an access DB macro from VB.NET

  Hi, I am having problems trying to execute an access DB macro from my VB.NET APP. Any help is welcome. Thanks Mike Hi, Thanks for the code. I have it working now. The only part that I could not get to work was the "CloseCurrentDatabase"; however, the quite command worked great. Thanks Again Mike Mike, One way this can be done is to include the reference to Microsoft Access obje ...Show All

• Ned Radenovic Send Email via outlook through excel

  Hi to eveyone, I’ve been looking around to find some code that could send an email from excel but I found the next problems: I need to put a message in the body of the email. I need to attach the active workbook or a file saved in my PC. I need to control via the code "on error resume next" if the email cannot be send because the variable passed to outlook with the name of the person is not located in the outlook agenda, bu ...Show All

• zeinab day of the week

  hello all. my macro must include some logic that's based on whether certain events happened on the weekend or a week day. does anyone know the code to tell what day a certain date falls on it certainly does. thankyou The WeekDay function might help http://msdn.microsoft.com/library/en-us/dnvbadev/html/pullingpiecesapart.asp ...Show All

• aashah40 Close excel

  Hi!! I've a problem. Need close excel when raise an error, but a don't know how can i do it. can anyone help me thanks. Regards. thank you very much!! it's just all I need. Thanks again. Hi there, Will the error be raised in your code If so, you can probably put an error handler in the appropriate place and call Application.Quit and this'll close Excel. Hope that helps, but sorry if it doesn't and I miss the mark com ...Show All

• Jim Fox Check the feasibility to program with the PowerPoint's presenter's view.

  Presenter's view is a good tool in slideshow which enables the presenter to see and control more information during presentation. I would like to check the answers for the following 2 questions 1. Is it possilbe to know whether the Check box for "Show Presenter's View" is checked I could not find the value for this setting in the PowerPoint "Application" Object, e.g. the "SlideShowSettings" object. Does anybody know how to r ...Show All

• philselmer internet explorer 6 prefetching webpages?

      hi all, I didn't know where tu best put this question, so I just chose this forum. I'm currentlt recognizing some strange network traffic caused by internet explorer. ie seems to request certain websites that are linked on a site I'm currently developing. The problem is that the user mustn't visit a certain page under certain conditions and usually can't, but internet explorer requests it arbitrarily. So, the simple question j ...Show All

• supermorph VB Postgres connection problem

  Hi I am using postgres 7.4.0. I have developed an application,  I am having a debtor table in which around 55 lacs of records are there. I have debtorid as a primary key. I am using like query to filter a data and display the data in the grid. Where as when I am debugging an application it took comparatively less time to execute it and to display data. Where as after compiling it and creat ...Show All

• Pascal Deliot Vb migration to Access 2003

  Can someone help to convert the following VB so taht it is usable in Access 2003 Thanks. Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Layers() As String = { "100" , "100" , "100" , "120" , _ "120" , "140" , "140" , "180" , "180" ...Show All

• icesun WORKING ON WORKBOOK WITHOUT OPENING IT

  I am doing some changes in a workbook. The first thing I do is to open it. Then I do the changes. Then I save it and close it. Is it possible to effect the changes without opening the workbook This is the code: directory = "c:\Documents and Settings\Antonio\My Documents\Client " Workbooks.Open directory & "Geroa\Geroa Inventory.xls", 0 Worksheets("renta variable").Activate Worksheet ...Show All

• M. Mondok AppHung in SQL Server (SQLEXPRESS)

  Good morning, the below is the error I keep getting each time I try to create/connect to a database using Visual Studio 2005.  I upgraded from VS 2003 Professional to VS 2005 Professional.  My OS is XP.  Programming language is C#.  szAppName : devenv.exe szAppVer : 8.0.50727.42 szModName : hungapp szModVer : 0.0.0.0 offset : 00000000  Thank you for looking into this for me. Vis ...Show All

• TMedhurst Error On Execution

  Hi All when i execute the following code i'm getting the error ***************************************************************************­* Content-type: text/html Software error:  Malformed multipart POST ***************************************************************************­** <% dim strDownloadedCode1 Class MultiPartFormPost Public Boundary Private NewData Private PreviousData Private ItemString Private blnLast ...Show All

• arunprakashr RTM - Q3 or late Q4 ?

  Are there any indications of whether VS2005 will ship in Q3 2005 or late Q4 Whilst probable dates used to be "late summer" (september-ish ), recent MS announcements seem to be more vague, suggesting only some time in 2005. This could be as late as 31st December! I have a sizeable project starting soon, which I would prefer to be in VS2005. If however, the RTM date is end of 2005, I may be forced to use VS2003 (would you take the risk& ...Show All

• eerboe Getting New Textbox value without using Afterupdate

  Hi. I'm fairly new with programming and I hope someone can help me with this. I trying to filter a list based on the value entered on a textbox but the only way I know of getting the new textbox value is wait for the AfterUpdate event. This works fine but I need to activate the filtering routine as the user types in the new value. Im thinking of using keypres, can anyone show me a way doing this. Any help would be appreciated. Thanks ...Show All

• mw2005 Extracting email addresses (from column), date and subject line from Outlook to excel

  Hi, I need to know if there is a way to code something in an Outlook Macro which will scan all Folders, extract SMTP email addresses to an excel file There are probably alot of duplicates as well and I'd want to deal with that as well (NOT bring over duplicates) Also want to capure the Subject line and Date received as well. I tried to do this with a simple EXPORT in Outlook but I did not get the desired results.. ANY help would be greatly ...Show All