Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rbel
-
How to remove, strip periods or fullstops or dots and hyphens?
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...- rbel
- Post #3
- Forum: Microsoft: Access Forms
-
How to remove, strip periods or fullstops or dots and hyphens?
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...- rbel
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
-
Import Excel files into Access XP using a Common Dialog Box
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...- rbel
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
How can I send reports using MS Access XP via e-mail?
DaltonVB Thank you for your so prompt reply. I thought as much, this wasn't going to be easy. Much Appreciate it anyway. rbel- rbel
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How can I send reports using MS Access XP via e-mail?
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...- rbel
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
