Search results

  1. K

    Add Text after value

    Not working showing #Error
  2. K

    Add Text after value

    Hi I got report with value Summary: 1550 I want put : "1550 Kg" Normally when I design Query I tray Summary: [table1].[value] &'Kg' - but now I can't because I using in query sum function. Is possible to put "Kg" in report?
  3. K

    combo box lock

    Not working
  4. K

    combo box lock

    Hi, Is any chance to lock combo box at 7am and unlock at 14pm?? Please help me and show any example. I try something like: Me.controlname.Locked=True but I don't know how use function IIF with time
  5. K

    Criteria like

    Hi I using query in criteria: Like "%VOL%" and working I using: Like "EURO%" and working but when i using: Like "%VOL%" And Like "EURO%" - not working why? its something wrong??
  6. K

    Query iif

    I traying build func. iif IIf(IsNull([query_info.product]),[query_info.product],[query_extra.product]) but not working
  7. K

    Query iif

    how start please schow me example
  8. K

    Query iif

    How build function iif when i had querys: query_report product, price, invoice date - its report query query_info product, price, invoice date query_extra product, price, invoice date I want build function iif - query_report should be checking product in query_info if is true should show...
  9. K

    Criteria from other query

    not working - showing blank screen
  10. K

    Criteria from other query

    Why in PK1 Table 2 criteria - Is null??
  11. K

    Criteria from other query

    Sorry I try but still not working can you show me exmple?
  12. K

    Criteria from other query

    Hi i had two querys: SELECT dbo_2m.order_no, dbo_2m.return_code FROM dbo_2m GROUP BY dbo_2m.order_no, dbo_2m.return_code, dbo_2m.warehouse, dbo_2m.date_received HAVING (((dbo_2m.return_code)="REJECT") AND ((dbo_2m.warehouse)="GI") AND ((dbo_2m.date_received) Between...
  13. K

    check box locking

    Hi in one form I had check box - connected with table "sts" in table I selected option true/false In another form I want lock field: Me.FieldName.Locked = True Question is how read information form table sts to line Me.FieldName.Locked = true or false Please help...
  14. K

    how to lock field by time

    Hello Any chance to lock field on my form between 4 am and 4 pm ? Please help me.
Back
Top Bottom