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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JohnJoker
  • Content: Threads
  • Order by date
  1. JohnJoker

    assign value to a field

    Hi Guys I have got the following function, that Generates value to a field by getting the first letter of Firstname, Surname + 3 numbers. I am having an error "Subscript out of range" on the following lineline "ip = k(Asc(Mid$(nam, 1, 1)))" Function Soundex(na As String) As String Dim m1...
  2. JohnJoker

    Visual basic split name

    I have the following code I need help because it does not work. Private Sub Command0_Click() Dim NUMCHECK As Integer Dim SURN As String Dim CD As String Dim CURCH As String Dim PREVNO As String Dim ADNUM As String Dim PREVCH As String Dim LONGA As Integer Dim C1 As String Dim C2 As String...
  3. JohnJoker

    Export Range to Delimited Text File

    I am trying to export an Excel file to delimited text file. The code below works fine for one range. I would like to include others ranges. How can I do that. CODE: For example I want to export also B44:F44, B48:F48, H56 ...etc Sub CallExport() 'ExportRange(range,where,delimiter) Call...
  4. JohnJoker

    Update records in a table

    I am using the code below to update the fields in a table. It works fine if I do one record at a time. What I want is to update all records when I click the button, I have tried so many things and none of them worked. What I am doing wrong? Dim db As Database Dim rst As Recordset...

Part and Inventory Search

Back
Top