Search results

  1. J

    hello friends, I have two tables in my database with name "Invoice" and "Supplier" now I want to...

    hello friends, I have two tables in my database with name "Invoice" and "Supplier" now I want to make a "Invoice form". And on this Invoice form I am having a combo box of supplier Name which is taking source data from supplier table. All the other fields on invoice form changes on change event...
  2. J

    hello friends, I have two tables in my database with name "Invoice" and "Supplier" now I want to...

    hello friends, I have two tables in my database with name "Invoice" and "Supplier" now I want to make a "Invoice form". And on this Invoice form I am having a combo box of supplier Name which is taking source data from supplier table. All the other fields on invoice form changes on change event...
  3. J

    insert fingerprints on form

    Hello friends i want to make a form on which i want to attach a fingerprint scanner so that when someone his finger on scanner it will identify if it is already in database and put the enter timings and end time and id no. So database can identify it and calculate the working time automatically...
  4. J

    how to take photos directly from camera on form

    Hp laptops inbuilt cam..
  5. J

    how to take photos directly from camera on form

    Hello friends I made a form on which I made a field of picture. When i click on it, it open the place from where you can choose photograph to add. But I want that when I click on box it will open my laptops webcam and i can directly take a pgotograph from my webcam. If anyone know about it or...
  6. J

    calculate time in hours minutes and seconds between two dates

    thanks i got it. it also working in ms excel. thanks a lot... to all of you...
  7. J

    calculate time in hours minutes and seconds between two dates

    Can I use it for Excel Sheet also.... if yes than how....???
  8. J

    calculate time in hours minutes and seconds between two dates

    thanks my dear friend but how to use this code to calculate time difference b/w two column in query. where to use it i have a column name TimeIn and other is TimeOut and both have time in as same format as you described above now i made a query in which i build a exp:[TimeOut]-[TimeIN] but...
  9. J

    calculate time in hours minutes and seconds between two dates

    Well thanks my friend but i am not getting anywhere as i am confused how to use cdate and how? Do you have your WhatsApp no or email it will be easier to send you photographs so that you can understand what i want?? But yes you got what result i want and what to do but somehow I am not...
  10. J

    calculate time in hours minutes and seconds between two dates

    I have two fields vehicle in timeT0 and vehicle out time T1 and both fields have the same date and time formate T0=12-11-16 1:00:00 and T1=13-11-16 15:15:00 and calculated them with datediff function in forms of second and the result is 137700 but I want a result formate like 38:25:00. Now how...
  11. J

    calculate time in hours minutes and seconds between two dates

    Is there any way to change a positive no into date formate without maths.
  12. J

    calculate time in hours minutes and seconds between two dates

    Hello friends I have a field name vehicle in time which has data type like 12-11-16 11:15:12 and another field vehicle out time which is also have same data type 13-11-16 23:11:15 now I want to calculate the time between them in hh: mm: ss formate? What to do
  13. J

    Hello friends I have a field name vehicle in time which has data type like 12-11-16 11:15:12...

    Hello friends I have a field name vehicle in time which has data type like 12-11-16 11:15:12 and another field vehicle out time which is also have same data type 13-11-16 23:11:15 now I want to calculate the time between them in hh: mm: ss formate? What to do
  14. J

    Query by checkbox value

    I want to make a form in ms access in which if i checked a check box than it value become an hour and it multiply by next field. My mean is if i check the box thats mean it will ask for next field value and if i will put 2 it will multiply with it and give me a value 4, so my question is how to...
  15. J

    financial year report date

    Thanks for reply but i made it.. ......
  16. J

    financial year report date

    I am making a report and want that when it is asking for year i will type 2015 anf on the top it will show the date 1/4/15 to 31/3/16. is there anything that i can try.. ..
  17. J

    financial year query

    Thanks its working.. .......
  18. J

    financial year query

    Thanks for reply will it ask for which financial year and if I will type 2015 will it give me all info from 1/4/15 To 31/3/16?? ??
  19. J

    financial year query

    Hello friends, how are you?? I need a help I am making a database and have a column named date. Now using this column i want to make a querry which ask me for starting financial year and and when i type 2015 it will give me all relevant info between 1/4/15 to 31/3/16. I need help.. ...
  20. J

    Hello friend, how are you?? I need a help I am making a database and have a column named date...

    Hello friend, how are you?? I need a help I am making a database and have a column named date. Now using this column i want to make a querry which ask me for starting financial year and and when i type 2015 it will give me all relevant info between 1/4/15 to 31/3/16. I need help.. ...
Top Bottom