Search results

  1. M

    Help with 4 digit numbers to date format?

    Hello, I have extracted 4 digit numbers from a long strings of characters and numbers which I have identified as date. Some are inputted as mmdd (example: 1129) ddmm (example: 2310) I have to calculate the number of days between the start and end dates. I tried formatting as date, but...
  2. M

    Help - complicated strings extractions

    Hello, I have trying to figure how to extract strings from a cell with different starting location, number of strings, date and time format. I'm hoping you can help. Below is an example of strings in a cell. I'm looking for the following value: 6BS1, 6BC1, 6BM1 and 6BZ1 only then I need...
  3. M

    Query specific column name from a list box via code

    Hello all, This is a new project that I'm working on using Access 2000 version to modify/automate the company's current database. I'm dealing with ugly unnormalized database and they don't want to change anything at this time. What the users would like to do is produce a report for certain...
  4. M

    Import Excel - add sheetname as a record in access

    Hello! I have to import excel spreadsheets with multiple tab/sheet names which changes all the time. The tab/sheet name is the invoice number so I need to add the invoice number as a record in the Access table for reporting purposes. I know how to display the sheet name using vba code in...
Back
Top Bottom