Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mtomar

    Unbound text box in Form

    Hi, I have Access database file for warehouse (recieving+issuing), so I want help to creat unbound text box in the form shows the balance of stock item when I do transaction for posting issue documents, and the validity rule to privent posting when balance QTY < issued QTY . Thanks, mtomar@msn.com
  2. mtomar

    How do I fill in multiple fields?

    How many tables you have in your database file? If it is one table I think you can't do it. But if you created two tables like: tbBASE & tbMOVMENT and zipcode is primery key in tbBASE and many in tbMOVMENT it is possible to get what you want. mtomar@msn.com
  3. mtomar

    Access Report Layout

    Thanks, Q240826 already fixed the problem.
  4. mtomar

    Unbound text box in the form

    Hi, I have Access database file for warehouse (recieving+issuing), so I want help to creat unbound text box in the form shows the balance of stock item when I do transaction for posting issue documents, and the validity rule to privent posting when balance QTY < issued QTY . Thanks, mtomar@msn.com
  5. mtomar

    Show data prompted for by query in a report?

    Yes, you can put criteria in onnce: 1. Creat a form in design mode, and give it a name for example: fmDLG. 2. Add two unbound text box. 3. Rename first text box (for example) bdate, and the other edate. 4. Add botton to open the report from wizard. 5. Go to the quiry which include the data...
  6. mtomar

    Access Report Layout

    Hi, After created Access report and generated it, some times the report dose not keep original layout, for example if report made as landscap in next time become portrait. How to keep layout? Thanks, mtomar mtomar@msn.com
  7. mtomar

    Auto Sequence Number In Report ??

    Hi, To add a seq# field in your report, see below: 1. Add unbound field in the details of the report. 2. put inside the field: =1 3. go to the property of the field and choose a tab &quot;data&quot;. 4. choose &quot;yes&quot; in runningsum. Bye mtomar@msn.com
  8. mtomar

    Roundation Function

    Hi, After created query or access report, I want a good function to round figure in calculated field x*y/z I used function &quot;round&quot;, but did not give me exact amount. Thanks. mtomar@msn.com
  9. mtomar

    Roundation Function

    Hi, After created query or access report, I want a good function to round figure in calculated field x*y/z I used function &quot;round&quot;, but did not give me exact amount. Thanks. mtomar@msn.com
  10. mtomar

    Page total in access report

    How to get total amount for each page of access report.

Part and Inventory Search

Back
Top