Recent content by Falcon88

  1. F

    Give me some Advices

    thanks for you ........
  2. F

    Give me some Advices

    What the free tool do you recommend to use to do automatic backup every ten minutes ?
  3. F

    Give me some Advices

    hiii to all last week im get alternative job as an admin for the system in the corp. that i work in it . we have a server connected to 12 client computers. the OS of the Server computer is windows server 10 . the db is sql server . this is first time i work as an adminstrator to a system. i...
  4. F

    Solved How to update default value

    On the default value property of OrderDate : Dlookup([DfltD];"tblDefaultDate")
  5. F

    Solved How to update default value

    Hi to all I have a form to insert some data to orders table , i use default value for OrderDate field , another table tblDefaultDate designed special to store one record only contains a field of date datatype to use it as default value for orders orderdate default value . but when i change the...
  6. F

    Solved Allow zero length string property

    When changes allow zero length property for text and memo fields , the append query that records that changes on that fields don't work . See to the audit table on the attachment , and change allow zero length to "no" for memo and text fields and see what happen.
  7. F

    Solved Allow zero length string property

    Hii all I use audit trail as the attached sample on some databases but i get read about allow zero length string property on text or memo datatype fields must be No, based on : http://www.allenbrowne.com/bug-09.html But when i changes that property to no , there a problem on the action query...
  8. F

    Filter a form based on continuous form

    T This will filter only the current record . Notice : i want like filter by extended listbox that select more than record.
  9. F

    Filter a form based on continuous form

    Thanks But could you give me an example .
  10. F

    Filter a form based on continuous form

    Thanks for your replay On the head of continuous for i use unbound textboxes and comboboxs to filter that continuous form for general data that filter that c.form to displays multiple records based on that unbound textboxes , i want a command button to open the single form by filtering based on...
  11. F

    Filter a form based on continuous form

    Thanks but splitform filter one record only ....
  12. F

    Filter a form based on continuous form

    Hi all I want to filter the main form that displays a single record based on continuous form that may be displays multi records ,( not the current record on the continous form but on the displayed records ).
  13. F

    Sum for text datatype for some values.

    I put this as an example , i write values have total 144.46 ( where total <>100 ) , which suppose the program alert the user in such a case.
  14. F

    Sum for text datatype for some values.

    Hi all I have a continuous subform contains cboTestNo. txtresult Based on testsDetails tbl The textbox txtresult is text datatype . There is a condition Where If user select 4 and 5 and 9 together by cboTestNo, for same person (that is in the MainForm). The total of that values in the...
  15. F

    How to stop repeat code

    Thanks for all
Top Bottom