Search results

  1. W

    Field Subtraction Problem

    :( no help ???
  2. W

    Field Subtraction Problem

    RV thats what I am trying to do, forget about the Borrower in house, they are actually column, that are holding values of Assets, Liabilities, and Equity from 3 different years. Right now the main issue is equity; I have to have a query that will produce the value of equity. I am attaching my...
  3. W

    Field Subtraction Problem

    so no help :(
  4. W

    Field Subtraction Problem

    Oh, I am really sorry about that. No thats not what I meant to say. Okay I have a combo box and its only one column combo box, the fields in the drop down are Assets, Liabilities and Equity. I want Liabilities to be subtracted from Assets so the Answer would automatically enter in with Equity...
  5. W

    Field Subtraction Problem

    I have only one column and its with that 1 column.
  6. W

    Field Subtraction Problem

    Bound column is combo box and how can i set it up with the column that is holding equity calculation. I tried through query. Query is actually giving me the exact value. But now my problem is I can't joined the field which is part of the table with the query(which gives the equity value).
  7. W

    Field Subtraction Problem

    I have financial table which contains list of End of year revenue titles. Since this combo box was suppose to be part of the master table so I made a joint query. Now there is one problem arising. Table and query and even the form is working fine. But in that combo list there are several titles...
  8. W

    Subforms causing problem

    I have this master form, under this main form there are 3 subforms, each subform is created from the same table as the main form; however, now the problem is that these subform are datasheet mode, I want to add as many field as i want to. But, one of the subform's entry is suppose to be...
  9. W

    access to word, once again!

    Yes I do. But, how would I do that? Can u please help me out. Thanx
  10. W

    access to word, once again!

    k the prob is I am kind of writting a letter in ms access and that would be output in word. However, this letter is commitment letter of loan so its kind of long like 13 pages in word but taking around 4 forms space on ms access now to output these 4 forms at the same time on the same record is...
  11. W

    access to word, once again!

    Okay, m sorry to bring this topic up again! I have created this command button from tools that output the access report into word file. However, it prints all the record into word file, is there a way that it would print one record or selective record at a time. I mean, lets just say if I am on...
  12. W

    #Num! error

    that was a typo, I did everything I can, still its there. Well, I am sure, I will solve it eventually. thanx though :)
  13. W

    #Num! error

    okay, thanx for your help though :)
  14. W

    #Num! error

    how do you want me to do that :( sorry I guess I am just too confused after a long day :(
  15. W

    #Num! error

    if you don't mind, can you tell me how would you do that. I haven't dealt with functions, so not so good at that. :(
  16. W

    #Num! error

    Hi, I have done my search and what I found was not sufficient enough for one of my query. It was for most of the fields but not for all. =Pmt((1+[Annual Interest Rate]/2)^(1/6)-1,[Amortization]*12,-((([Annual Rent]+[num8]+[num9]+[num0]-[Perc1]*[Annual...
  17. W

    Form and subform

    I am creating a Financial Statement database and I am done with most of the stuff. Except for one thing that is holding me back, that is there are four columns and these four column has Rent info, monthly rent, yearly rent and share of rent. Since, these column would have as many rows as user...
  18. W

    Importing formulas from excel to ms access

    Thanx Doc man, I really appreciate your help. Really you have made this thing really easy for me. I am so dumb, couldn't even figure it out :( SJ I just found that sorry, it was my own fault, I didn't look through it carefully.
  19. W

    Importing formulas from excel to ms access

    huh! I did try to look for it, but couldn't find it. Anyways thanx for ur reply. Uncle gizmo, I did try creating user form, but I kind of got lost in prog part, I guess I need to find a book on it so I could follow it step by step, I am working on it after 9 yrs, thats why i really rusty on it...
  20. W

    Listbox alignment

    thank you guys for ur replies. Uncle gizmo I did try to search for each and every parameter I could think of, but I wasn't successful in it. RoyVidar thanx for the code, let me see if I can use it. I will try it at work and would let u know.
Back
Top Bottom