Search results

  1. N

    VBA Code to Save ExcellSheet as file format

    hi i have AN access database ,which in one part of it will analyse a big amount of data with excell sheet format i am using this code to import the sheet to my database DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Calls", "d:\My Documents\myfile.xls", True, "details!b1:h1068"...
  2. N

    Using Single or Multi Databse For Each Year ?

    hi i designed an accounting system which consist of : databasse and interface file it is working well , but i wish to get your advice regarding year end colsing , in my mind i have 2 options : 1- the one which i dont like is to split the databse file to each year , means 2007 seperate , 2008...
  3. N

    Relink a different Text Files in the same name

    hi again i am working for my company as cost analyser , one part of my job is to analyse the cost of telephone bills where my company has more than 1000 phone lines our local telecom company provide good solution in its web site , where each user can download the detalis of his bill as csv file...
  4. N

    Find A Relation Between 2 Diff Tables

    hi i have a database to manage utility bill payment , it consist of - Bills : - billID - Benificiary Name -Cost Center - Bills Transaction : -TransID -bILLid -BillDate -BillAmount -Payment Transactions : -PayTranID -bILLid -PayAmount -PayDate...
Back
Top Bottom