Recent content by Starscream

  1. S

    ALTER TABLE and SEPARATE DATA SQL STATEMENTS

    I attached the database to the thread Cheers, Ghislain Bob Hachey
  2. S

    ALTER TABLE and SEPARATE DATA SQL STATEMENTS

    Filter by date on the fly Hey me again. I've been trying with the tips you gave me for a while now and I think I'm getting closer to the solution. However, I just can't seem to get it to work. Is there a way I could attach my database or send it to you by email or something. That is if...
  3. S

    ALTER TABLE and SEPARATE DATA SQL STATEMENTS

    Thank you for your help I REALLY appreciate people like you who take time to help others. I'm getting closer to the solution now. However, what do I write in the CDate(??????). How will access know that the date is only the first 8 characters. How will access know that 01062005 is DDMMYYYY...
  4. S

    ALTER TABLE and SEPARATE DATA SQL STATEMENTS

    Helo…please really need your help. I designed a small desktop database to automatically import some Log files. A sample of a transmit log file (emails sent from our rural email stations) looks like this when imported in access. Date Time Direction Sender MessageID 03062005 133501...
  5. S

    List Boxes in forms. Help please! :)

    NO your not off track. You will find this easy. First your tables have to be already defined. You should have a table for your users and a table with your departments (with data already entered) right?. You also need a relationship between the two tables which I assume you already have. Ok...
Back
Top Bottom