Recent content by sahh1419

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...

but i have not find any que yet.

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...

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...

database version please

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.

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)

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...

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...

not working the code .pls advised.

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...

1. Open access and open your file and press alt+f11. 2. on the left side click on project explorer and and go to module. 3. create new module and put this all code after the Option Compare Database option. and from where u an call this finction... hope to understand...

pls see the attached file...when i insert records in one class and after in the new calss the previouse class also duplicate record...

please see the attached file.... 1.jpg it contains the exact data with one class. 1a.jpg it contains the other class data. 2.jpg (Wrong one) when i change the class it will insert record in new class as well as in the previous class also.how i can insert this happening... pls advised.

please see the attached file.... 1.jpg it contains the exact data with one class. 1a.jpg it contains the other class data. 2.jpg (Wrong one) when i change the class it will insert record in new class as well as in the previous class also.how i can insert this happening... pls advised.