Recent content by Bandara

  1. B

    Form data to table issue

    There is table called ProductCost. I want to get All products Total Product Cost to a Form field. Form is not connected with table. How to do that
  2. B

    Form data to table issue

    There is table called ProductCost. I want to get All products Total Product Cost to a Form field. Form is not connected with table. How to do that
  3. B

    Form data to table issue

    Main form is Maintenance cost Use spare Part is another form but i added as a sub form of maintenance cost on datasheet view mode.
  4. B

    Form data to table issue

    Hi I add form with datasheet view to another form. and add this code (Marco applyfiltrer) to search data on table through form. [ACT ID] Like "*" & [Form]![MAINTENANCE COST]![Combo54] & "*" It worked perfectly in form view. Then I add thiss code with my sub form. The subform is in datasheet...
  5. B

    Form data to table issue

    Hi I add form with datasheet view to another form. and add this code (Marco applyfiltrer) to search data on table through form. [ACT ID] Like "*" & [Form]![MAINTENANCE COST]![Combo54] & "*" It worked perfectly in form view. Then I add thiss code with my sub form. The subform is in...
  6. B

    Form data to table issue

    hI THIS IS ANOTHER ISSUE IN FORM DATA SHHET VIEW. IF I SELECT VALUE FROM DATASHEET VIEW DROPDOWN THE ID IS GOING TO SECONDS 3RD ROW ALSO
  7. B

    Form data to table issue

    IF I RUN A UPDATE QUERY ON FORM WHICH ENABLED DATASHEET VIEW. QUERY DIDN'T GET DATA FROM THE FORM FIELDS AND POP UP TO ENTER DATA TO RUN QUERY WHY?
  8. B

    Form data to table issue

    What i am asking is if i remove the table field in Control source and add a expression to it. How can i submit that value to table.
  9. B

    Form data to table issue

    I have table and and i generate form from that table. There is a Field called Spare Parts and Control source is selected as Spare Parts. But I want to make =[USE SPAREPARTS].[Form]![Text41] to that control source. if i eter this the data not store in the table. any one know how to fix it
  10. B

    Marco Does not Work on Navigation form

    but it works on normal form. navigation form it doesent work
  11. B

    Marco Does not Work on Navigation form

    I added marco [ASSET ID] Like "*" & [Forms]![MAR]![Combo255] & "*" It works on Normal Form. But If i Open it on Navigation form it doesent work. Navigation Main Form Name : Welcome If any one can fix this?
  12. B

    Display Out of Stock message in a form as a text.

    Actually my idea is showing this message as texts. (like dashbaords) Can we put product id and quantity with remak out of stock. then i can hide other fields. And also is it possible to make reminders
  13. B

    Display Out of Stock message in a form as a text.

    one last can we display this result as a message like attached image red message. now it visible like form
  14. B

    Display Out of Stock message in a form as a text.

    Check this form 1. is it possible to disaply the data one by one . now i have to scroll to see it
  15. B

    Display Out of Stock message in a form as a text.

    it shows only one record at once
Top Bottom