Recent content by Ciaran_Enright

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...

Hi Cowannbell, I'm interested in doing the same can you forward on the code. Thanks Ciaran

Thanks Keith, I’ve tried the outlook but the system goes to sleep automatically after 5min, its an admin/IT security, I’ve also tried the scheduled task, but not the Poll function you mentioned. Can you point me in the right direction regarding the Poll function , In the meanwhile I’ll do a...

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...

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...

Thanks SJ used it to open a database while shutting down another EG. Dim appAccess As Access.Application Set appAccess = CreateObject("Access.Application") With appAccess .OpenCurrentDatabase ("d:mdb\autowvc2.mdb") .Visible = False End With DoCmd.Quit End Function

Thanks G... too busy at the mo ...later

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.