| # NB: you may need to convert tabs to spaces when you copy it into your GT program | |
| gt_program = r"""copy and paste your program here>""" | |
| lines = gt_program.split('\n') | |
| images = [] | |
| for command in ["*image: ", "\t\t*picture: "]: | |
| images.extend([line[len(command):] for line in lines if line.startswith(command)]) |
| Option Compare Database | |
| Sub ImportFromExcel(filename As String) | |
| ' remove any previous data | |
| CurrentDb.Execute "DELETE * from tbl_excelImport" | |
| CurrentDb.Execute "DELETE * from tbl_requests" ' delete all previously recorded requests | |
| CurrentDb.Execute "DELETE * from tbl_clients" ' delete all previously recorded clients | |
