Search results

  1. S

    Attache finger print reader in access database

    is there any method to connect finger print device directly with Access Database.? Respected. i have device installed ZTK-628 Fingerprint device with my PC. it has a built in software. Now i want to attached/connect this device through access database. with my application.the device has a IP...
  2. S

    access table link to oracle table

    Good Day i am using oracle 10g Database with form 6i. now i want to connect ZTK 628 finger print device with oracle. The device using the access database. now i want to link when a access table update it will also update oracle table automatically. how i can use this. i have also used ODBC...
  3. S

    update table after every five minutes

    i am using access database. my requirements is after every 5 minutes it should check the new entry in table and insert it into new table after every 5 minutes only the new entries. please advised. Table A Stuid Number Intime text Otime text Dated date Table B Stuid number msgto...
  4. S

    calculate present and absent

    i have two tables. table-1 contains 3 fields and table 2 contains two fields. i want to get the result in group by class on specific date. please view the attached file.
  5. S

    path of picture in field

    i want to store file path in cell value not in form.and i want to use this path to show picture in corel draw print merge.how to i save the file path into a string? (if i click on properties of the image, the file path is under the picture property)
  6. S

    insert the previous balance into new record(arrears)

    Dear i am using this query to insert the previouse balance into arrears as shown in the figure. it will insert some record correct and some are not correct.pls help me. SELECT fees.[gr no], sum((Admission+Registration+Fees.Tuition+[Fine]+Fees.Transport+[Exam]+[Misc])-Fees.Paid) AS bala FROM...
  7. S

    insert and update at same time......

    Private Sub Tuition_AfterUpdate() Dim intS As Integer 'Please use Long if the numbers expected is Greater than 32,767 intS = DSum("[Balance]", "12356", "[GR No]=" & Me.[GR No]) 'I have assumed that InvIN and InvOut is in the same table. This will work if you maintain seperate tables just change...
  8. S

    add balance into next record..

    i want to add arrears(balance into next month arrears when i insert new month fees.please review the attached query; INSERT INTO Fees ( [GR No], Class, Tuition, FMonth, TMonth, [year], Transport,arrears) SELECT [Fee Student].[GR No], [Fee Student].Class, [Fee Student].Tuition*2 AS Tuition, [fee...
  9. S

    Insert/select values from selection combo boxe

    Dear all, i want to insert obtain marks of the subjects.please find the attached my db for your kind review. when i select combo value my requirment is to insert the all records which associate with the combo. but when i select combo value it will happen nothing. pls see the required...
  10. S

    add Button oblem.

    i have 40 records of Student. i want to insert diffrent mobile no against the same [GR No]. ----------------------------------------------------------------------- Record in Table Data: .[GR No] [Name] [Class] [Mobile] 1 AfeefuD-Din...
  11. S

    formopen event

    Respcted, i have a table name fee. which contains the following fields: GR No Date Month Year AdmFee TutFee ExamFee Other Total Paid Balance .................................................. ............................................... i want to unpaid records insert into another table when...
  12. S

    form open event not working

    Respected,I have a table name (fee) which have the following fields:it will only send one message and not send other messges which dues is unpaid...please advised. -----------------------------------------------------------------------GR No: 1, 2,3,4,5,6,7Name: Aslam,Naveed,Wasif,Altaf etcDate...
  13. S

    outtime of employee not update

    I want to record emp in and out time. i have attached the form with this query. The structure of table is: Code Text Intime Date/Time Otime Date/Time Dated Date ----------------------------------------------------- When i put code (e.g 1569) in code field it will track only intime nd when i put...
Back
Top Bottom