Search results

  1. C

    Select a variable number of records in a table.

    I’ve done a search and cannot find any similar queries! I’ve a table that varies in length on each import. I want to divide it by a variable number in say a list or combo box and return the required no of records. i.e. table length is 120 so divide it by 10 and return the first 12 records or...
  2. C

    Run Access on recieving email in Outlook

    Hi, One the subject of emails How can I prompt an access database to run on receiving a mail with a specific subject. ? Basically IT ftp a file to a network drive and send a mail when the file is updated. I’ve 2 options 1.Get access to run when the file appears on the network or 2.Run when I...
  3. C

    Run Access on recieving email in Outlook

    Hi, One the subject of emails How can I prompt an access database to run on receiving a mail with a specific subject. ? Basically IT ftp a file to a network drive and send a mail when the file is updated. I’ve 2 options 1.Get access to run when the file appears on the network or 2.Run when I...
  4. C

    Populate duplicate blank fields

    I hope you can point me in the right direction, I need code to populate the blank values in field1 with the value above. i.e. 008HN is populated for each value in field 4 until 0121P See attached I've got code to do it in excel but not access. Thanks Ciaran.
Back
Top Bottom