Search results

  1. D

    use concatenated expression in Instr function

    thanks!! I got it working. great ideas there to create different Querys :D
  2. D

    use concatenated expression in Instr function

    Hello. I have been looking and searching but havent found an example for my case so I decided to post here in the hope of help. I have "table1" which contains a, b, c fields. I have "table2" which contains d,e fields. Im interested in one whole field composed by a and e from tables1 and...
  3. D

    limit what the reports show.

    Thanks! After you pointed me to the "Where" clausule of the OpenReport, I searched the forums and found this help guide: http://www.baldyweb.com/wherecondition.htm now it works! Really thanks!
  4. D

    limit what the reports show.

    Hello all. I have created a Report which is exactly as I want to display by clicking a button on a subform. But, the report shows all the results from the query (of course...) . For example, the Query alone shows information for Adam, Betty and Charlie, hence the report will show the...
  5. D

    help! related table doesnt update :(

    thanks for the reply. Yes effectly the database wont create something that it doesnt need. I just figured out the problem. I thought that just by adding a new MNN it would be added to their childs, but it is not added UNTIL another field for the child table is filled, in this case, after I...
  6. D

    help! related table doesnt update :(

    Hello. I have this problem. Please refer to this small picture. http://www.geocities.com/luiguibanez/help1.jpg The details_MNN table relates to the details_AA14 and details_IR21 tables with the field MNN. In the subforms that I have, when you create a new MNN entry for the details_MNN...
  7. D

    change record values after checkbox "YES"

    Hello. 1st of all thanks for your reply. Your explanation worked a lot and helped me to access controls. But I have one question. I need to apply the "math" to a whole column of data- the tariff column. How do I tell it to run through that column and change every value of it? thanks again.
  8. D

    change record values after checkbox "YES"

    Hello all. Im currently building a DB with Access and Ive found myself coding simple VB lines (its been about 6 years since Ive programmed! im doing allright though.) in order to make it work as I want to, but I ran into a problem and im kind of stuck. I have a Calls table with about 5 fields...
Back
Top Bottom