Search results

Hi, 1. I have a sample database table in excel where depending on column 2 value >1 is checked and logical results by IF check placed in Column D. The values having "Y" in column D are placed in Columns E:F. 2. Now I want to place count of values meeting the condition on last...

Hi Markk, Your observation about payee field is understood and appreciated. It shall be incorporated immediately. I am grateful to you for explaining the working and design aspects of the forms. I feel that this problem stands resolved and if you agree this thread can be closed. Best Regards...

Hi Ranman256 Your guidance works fine. Thanks a lot

Hi Markk, After studying example entries provided in a sample database, I have reworked the personal account ledger and is being attached for your kind perusal. I hope it is in order. I would like to know that how the Balance column in fTransaction form is getting its balance value. I am not...

Hi pwbrown Range:="Template!"[/I] this pulls data from the template worksheet in a workbook. This is not clear to me ie what is the structure of template, where it is stored and what is its relationship to files stored in Directory. Your code snippet is excellent and based on it I have...

Hi Ranman256 The contract file provided by me has combination of merged cells and normal cells. I have Access 2007 and it is not imported in right way. I do not find facility of repeated automatic import of files in Access 2007. Purpose of deleting some portion of file is to remove specially...

Hi, I have contract notes files in .xls format towards sale of equity shares from the brokerages. I have to do some editing in these files like deleting some rows, adjusting width of columns and inserting date of contract. a) Contract-A.xls shows original file. b) Contract-B.xls shows modified...

Hi Markk, You have nicely explained the concept with illustrated example. I will try to modify database accordingly and shall aprise you after the needful is done. Heartfelt Thanks to you.

Hi Markk, Greetings. I have modified the personal accounts database and have created 3 tables tTransaction, tAccount, tLedger. Also created forms and sub-forms. Summation query "exp_summ_acttws" return 0 amount means sources and utilization are matching. (New file attached) I am very much...

Hi Markk, Thank you very much. You have clearly explained. It gives me enough lead to proceed further.

Hi Markk I find your suggestions quite valuable and practical. I will try to modify the system as soon as possible incorporating the important features mentioned by you. Your guidance is clear to me for tTransaction and tAccount but tPost portion is not very clear to me. Kindly guide for one...

Hi, Further to my previous post today I have created one main form and two sub-form which are enabling me to proceed further and allow data entry. (File attached) However If I wish to enter a new expenditure type ,it restrains me from adding mentioning that it has a related item in other form/...

Hi, I have reworked the personal expenditure data base on the basis of guidance provided by Markk. It is working fine and provides me expenditure totals date-wise as well as type wise.(File Attached) However it has scrapped my entry forms which are to be redesigned with following objective. a)...

Hi Markk, I feel you have guided me in right direction. I will work it out and inform you. I profusely thank you for the same.

Hi, I have a personal expenditure data base indicating daily expenditure on various heads ( File Attached). I want table to reflect expenditure on various heads on daily basis in COLTOT column. Any subsequent change in any of the field to be dynamically updated. Presently I am exporting file to...

Hi, I am an engineering professional with more than 3 decades of working experience. I have extensively used Microsoft Access. Only recently I have started learning VBA Automation and advanced capabilities of Access. Best wishes to all of you. :)