Search results for query: *

HiTonyJollans I tried the code using what you suggested but no go. Here is what I have done: Public Function Remove(InText As String) As String Dim R As String R = InText Do R = Replace(Replace(R, ".", ""), "-", "") Loop Until InStr(R, "") = 0...

I was wondering what code will effectively remove, strip kill etc,. any periods or fullstops or dots and hyphens from a field.(e.g. Tax N°: 96.567.402-K) This being an alpha numeric combination which could have any number or letter after the hyphen like 2,3,4,5,6,7,8,9,0,K,L etc,.In responce to...

I have a situation where I need to “Import” an Excel file into Access XP using a “Common Dialog Box” from any Directory, Path etc. What want to do is, have form with a command button that when clicked it will open the Common Dialog Box and allow me to import ANY Excel file, and then perform the...

DaltonVB Thank you for your so prompt reply. I thought as much, this wasn't going to be easy. Much Appreciate it anyway. rbel

am a MS Access Database Developer in need of your help. I currently am working for a French company Coface Seguros Chile S.A. and have developed an application which deals with several clients. One of the problems that I have come accross is that I need to automate the sending of "Summary...