Answer Questions

• Siddharth Bhatia MSFT 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 have done this using some additional software. We used NS Elite for Terminal Emulation, which has a program called NS Transfer,This all ...Show All

• Siggy2006 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! Hello. You can accomplish this by utilizing regular expressions. Here is a brief article one how this is accomplished in VBA. http://www.mvps.org/access/modules/mdl0063.htm Here is a site to test your regular expression (has some nice tutorials too) http://regexlib.com/RETester.aspx ...Show All

• Bharath2k5 Print folder files to a file

  Hi all, I am trying to print a folder files and sub-directories to a xls or csv or txt file. I know i can do it through the Command Prompt, like that: c:\>dir /s >"File List.csv" This code under command prompt, will print all the files and sub directories and thier files of c: to the file: "File List.csv". i want to do the same from VBA, through excel, or stright through VB exe file. pls advise Than ...Show All

• Lester Leonard Go the best tools

  Hi everyone, We are trying to decide what kind of application (with VS.Net, prference VB.Net) to develop for a client.  They have a central administrative office that includes space and people who serve their clients directly.  They also have two remote sites that serve clients but do not have any administrative responsibilities.  We are not sure if we should develop a web based application, a Windows application that connects to ...Show All

• steveharper Wierd error I cannot figure out

  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

• Jeroen Boiten additem issue with populating a combobox

  Hello, I have been working at this for days and am no better off. I could really use some help. I need to populate a combobox with data from a column in an SQL table. I have put together the code below but am having an error at this line: invBegNum.additem rs.Fields.Item("RMDNUMWK").Value Error message: "Object doesn't support this property or method" I'm really a newb but am trying hard to get this.  When I write this line of code to popul ...Show All

• Shanti Adding an Outlook Feature

  What I want to do is relatively simple. I'm not asking for someone to do this for me, I just want to pick people's brains for a little direction and I can take it from there. What I'd like to do is write a script that would give Outlook users the option to right click on an email message and have a function, say "report spam" that would create a new message with the selected message as an attachment that has a specific email address in ...Show All

• Florent Montsegur create command button that holds a procedure to another workbook

  I have a code to create a chart and put it in new workbook (then i "save as" AdvanceReport.xls). Assume that the current workbook i'm working on is oldWb, and the new workbook as newWb. The first sheet in the newWb contains the data and additional information about all charts. I need to add command button that holds a macro to copy all chart from excel to word in newWb's first sheet. I made the code already,that is: The code to create c ...Show All

• Habbit Code erroring out.

  Ok here is the code that is breaking: If Range("useSP").Value = "Y" Then startpoint1 = 1 startpoint2 = 1 Else startpoint1 = 144 startpoint2 = 943 End If 'Inputing formulas and making needed properity changes For x = 0 To 142 With Sheets("Pyramid Evolution").Range(Range("SalaryPointPE").Cells(startpoint1 + x, 1).Value) .Formula = Range("SalaryPointPE").Cells(sta ...Show All

• stakei Help to do macro more dynamic

  Hi, I’ve been trying to help a buddy of mine at work with some macros. But I’m having a lot of trouble figuring out how to do this. Its very simple, he has all these country codes on a spreadsheet. We want the program to read the code and the write the country code next to it. We’ve created a two dimensional array with all the codes and country names. Here is some code: Dim selNum As Long Dim tri ...Show All

• paso Run SQL Server 2005 DTS Package from MS Access

  Can anyone help me I have recently upgraded from SQL 2K to SQL Server 2005 and I am trying to run a newly created stored package from MS Access using VBA. I was able to perform this task easily when calling a DTS package using SQL 2K. But as of yet I can't seem to execute this package from Access. Does anyone have code or suggestions ...Show All

• brianpmccullough Custom Date Picker Control

  I am developing a form for entering data into Excel and for some of the fields have dates as values. I really like the built-in date and time picker control for this, except that I want to be able to change the background colour of the part of the control that looks like a combo box. And that is simply not possible with the standard date and time picker. How can I get around this problem I have been trying to create a custom control to ...Show All

• jimschor VBA Collection Object

  Is it possible to use the key of a collection object to scroll through items in the order of the key I know that either I can work through from 1 to Collection.count or by using For .. Each .. Next, but a method to work through in key order would be very useful. Hello ADG, Looking at the collection object it doesn't look like it's possible, there is no property to get the keys used by the collection. The way ...Show All

• MYVB Access and VBA application in the mdb file

  Hello, We have an old software running on a touch screen computer. The software uses DAO for operations on a .mdb database file. It connects to the database before each transaction and disconnects after that. There is another program writen in VBA, runs in the .mdb file. Some people accesses that program by openning the .mdb file stored on this touch screen computer from a remote computer. As soon as someone opens the .mdb file, MS Access locks ...Show All

• tie lake synchronized swim team 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