Recent content by NiceMan331

yes janr , you are right i changed the target to another folder , it works well now another thing , is there a way to programmataly adding filename as additional filed in access table to label the data cause now too much data added to the table , but i wish to know the source file for each one

thanx janr it works but how to avoide alert of confirm replacing the exciting excell file i note that alertdesplay=false , but it still appearing you know with a big number of workbooks , it is necessarry to avoiding like this alert

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

thanx that will be better but can u lead me to the suitable approche to study SQL Server ? ok there is SQL Server section , but i need practice lessons for it regards

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

:) here , i disagree with u life is dippend of our view to it , if we look to it as a trial period only , it will seem to us as a simple life , happy . else , it will seem to us as a difficult life any how , i will use your first advise : linked table manager " ,

Thanx Neilg it is ok , but i is there any other way to do it else of table linked manager ? because i wish to skeep the wizard , means i wish to do it out of that wizard if could be by code will be easier also , i dont like to rename the oroginal file , it should be in same name for reference

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

georgedwilkinson , when a proffisional programmer as u , make sorry to one bigginer as me , I Admit that u r a very good person i respect u all , georgedwilkinson , Neiling ,,, and all other experts here i hope u accept me as a student to learn alot from u regards

u r right Neileg , english is my second language , i appriciate what u typed here but , georgedwilkinson , has no right to say what he posted above any how , it is ok now , i learned hope i will get more and more from u thanx

actually i get it from Neil when he post " In that case you have no entry in BillTransaction because there is nothing to link. " ok , it is understood thanx to u all regards

this talk is totally rejected , because first of all i start posting my question with respect to all members here including u second , let any memebr read the total thread , to highlite any un_respectable sentense in my 3 posts , and i hope u to refer to me in which exactly sentenc i said u &...

ok neil said that there is no link in this two tables , i accept it georgedwilkinson , how u can solve this case where we have an entry in Payment Transactions and no entry in Bills, or vice versa ?

this will help only if one or more than one payment is closed to one bill id but as i decribed above in the example : one payment may be done for one or more than one bill transaction , not that only , but also it is not necessary payment will cover all bill due amount in addition , there is a...

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