Answer Questions

• prashantpk Odd or even and converting Decimal to binary, octal, or hexadecimal and back.

  how do I make an algorithm that asks the user to enter an integer number, then determine whether the number is odd or even.  How would you write that in Visual Basic code Secondly I need to figure out how to convert a decimal number into binary, octal, or hexidecimal.  It needs to ask the user to enter a decimal number and then ask if it needs to be converted to binary, octal, or hexidecimal.  The Algorithm should ask until the o ...Show All

• Franz Strele How To Transfer Data to ADO Data Source from Excel with ADO

  Hye Is it possible to write/udpate data into a table in Access-database from an Excel-workbook using ADO I wonder if anaybody can help me Regards Fiftyfive Yes it is. ADO is a COM object that can be used in any Office application to update a Database. There a bit to it and don't have much time right now so many this post might continue on for a while. The first you want to do is create a reference to ADO in Excel. Tool ...Show All

• LisaAnn XSL applied with VBA

  Hello, everybody, Derek, Brenda Acctually I'm doing a test based in Instructional program evaluation faced with library resources. The goal of these evaluationsis to assess the adequacy of library resources to the needs of courses offered within a program and to determine the ability of the library to support teaching and related research. This methodology of collection evaluation based on the analysis of the content of individua ...Show All

• Andy_T Can no longer enter wscript for debug

    Hope someone can help me.... I have early installed wscript 5.6, and able to enter and single step a script file. Now now matter what I do, re-install, all kinds of options  Wscript will no longer allow interactive debugging... it just executes the script... How do I fix this   I am open to suggestions Roman   Thanks..... the key was the to use installing the right script engine....   ...Show All

• Anthony_Sebastian Can anyone download VS Team Edition?

  We are a Certified Partner with the ISV Competency. The ISV Competency gives us a license for Visual Studio 2005 Team Edition for Developers but, we can't download that or the Team Server from MSDN. We can download the evaluation editions but not the real thing. Is this a problem for all partners with the ISV Competency or just us Can anyone download the real editions of Team Foundation server and/or VS for Developers Thanks, John Vot ...Show All

• Brainsponge How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Hmmm. Okay. I'm not really code savvy but can I simply use it like this Do while variable <> "\p{L}" STUFF Loop Thank you. Just thought I'd share that I ended up using OR instead of AND. Private Sub TextBox1_KeyPress(ByVal KeyAscii As ...Show All

• Rich Fore html tag not working

  Anybody can tell me why the COLGROUP tag below does nothing to my table Sub send_email_confirm() Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) ' determines if sale or purchase Dim side As String If Sheet2.Cells(6, 8) < 0 Then side = "Sold at " Else side = "Bought at " End If With objMail .To = " tradeallocations@trade.com " .C ...Show All

• Nelk portal question ???

  i want to know http://msdn.microsoft.com/vstudio/ which techonlogy used to design like this site is it sharepoint or another technology thanks I think it's designed using ASP.NET . ...Show All

• cguanchez how long does it take to get the MSDN subscription? with Empower .. and does it include Sourcesafe

  Hi All, We have signed up to Empower and received our DVD pack but I can not see any information regarding MSDN subscription , this is critical to us, we must have signed up nearly 3 weeks ago now. I also phoned and was told it was going to take about a week.   Dos anyone know how long we are going to have to wait for the MSDN subscription I have emailed LatamISV@microsoft.com  and am waiting for a response but wondere ...Show All

• muntyanu Problem in Saving Excel 2003 Workbook in Excel 97

  Hi all, I am experienced that when i saved a workbook in Excel 2003, then save the workbook in Excel 97 running the VBA code, it will prompt a message about: "This file was created using a later version of Microsoft Excel. If you save this file using Microsoft Excel 97, information created with features in the later version may be lost. ............................................................. -To continue with the Save, click ...Show All

• Gromey Expiry dates on Code signing certificates - One Year?

  Hi, I am not a certificate expert, so this may be a simple question. We have purchased, for the past few years, Class 3 code signing certificates from Verisign. These expire every year, and we have to then acquire a new certificate, individually open, resign and republish all previously signed apps (usually Excel workbooks). This is a major hassle as we have a lot of signed apps. Recently, we decided to use MS Certificate Server to sign ...Show All

• shahji I need help figuring out what is crashing my VBA for Access 2003

  Access VBA keeps crashing on me... I know why, but can't figure out the cause. I go into code view... and type something like "Me" then when I type the '.' which should bring up the list of possible options... it crashes VBA... this only happens in access, I can open up excel and do the same thing and it works fine. I've tried re-installing but it still occurs. Can anyone provide me with some insight Thanks, B ...Show All

• Peter Mooney Form Requery

  I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD Hello, Try calling the method dir ...Show All

• Raman-astix VBA for Excel Query. From Someone New

  I am fairly new to programming. I have a worksheet containing various events and a combo box which the users makes a selection from to format the spreadsheet in respect of their paticular activities at the time. This calls a procedure in a module to carry out the reformatting. The problem is that the module dosn't recognise the ComboBox and therefore dosn't work. It is not possible to place the code block into the worksheet as the code can b ...Show All

• Craig Mellon Unable to trust makecert signed COM Add-in (Outlook)

  I have a COM Add-in made for Outlook that I have signed with a test certificate made with the makecert.exe utility. When starting Outlook, the add-in loads and a security warning comes up. The problem is that the checkbox that allows me to 'Always trust macros from this publisher' is disabled. Is this because I have not used the right options with the makecert.exe utility or do I need a proper certificate to be able to trust the add-in in Out ...Show All