Recent content by ma143hal

  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

    Thank you very much, Bob! Have a wonderful day! Regards, Marita
  4. M

    Query specific column name from a list box via code

    Thanks! Not quite sure yet how to incorporate your advise, but I will give it a try.
  5. M

    Query specific column name from a list box via code

    Hello BL, Thanks for your reply. I'm using a ListBox not ComboBox so that they can select 1 or multiple at a time. The user even want ALL the list to be visible so that they don't have to scroll down.
  6. 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...
  7. 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...
See more
Back
Top Bottom