Search results

Hi, i place my access file on shared network. Then i email my excel file to my colleagues. The problem is, only 2 pc can get data from access the other pc will prompt " Do you want to connect to..?" And asking for password etc. But i did not set any password. I also tried tick allow trusted...

Hi, thanks a lot. They're using Firebird for their system.

Thank you so muchhhhh..

Hi, i have this tablestaff Date staffID 11/22/2016 .. .. 11/23/2016 .. .. 11/24/2016 My query: Select tablestaff.staffno, max(tablestaff.date)as maxofdate From tablestaff Groupby tablestaff.staffno But.. it still not giving me all the staff ID with latest date.

Hi, so first things first i need install ODBC driver on the computer. Then... i need to choose between User DSN, System DSN, or File DSN (what is all that things)? Sorry, I never done this before. Can you assist me step by step or give me a link for tutorial? Btw, I'm using MicroEngine...

Hi, Thank you sooooooo much CJ_London my problem solved.

Hi, B'cos sometime the scan device will come out with "Card can't be read" when the staff scan their card. So the staff will try to re-scan their card. Tht's why some of the data (IN/OUT) came twice. Well, I'm just need to download the transaction report from the time management system and make...

Hi, I've tried: SELECT Attendance.[Staff ID], Attendance.StaffName, Attendance.Process, Attendance.Shiff, Attendance.Date, Attendance.Time FROM Attendance LEFT JOIN qry1 ON (Attendance.Time = qry1.MaxOfTime) AND (Attendance.Date = qry1.MaxOfDate) AND (Attendance.[Staff ID] = qry1.[Staff ID])...

Hi, I've tried using this data Staff ID StaffName Process Shiff Date Time Code 1234 Rebecca SE1 A 11/16/2016 7:05:03 AM IN 1345 Tom SE3 B 11/17/2016 7:30:30 AM IN 1234 Rebecca SE1 A 11/17/2016 7:32:01 AM OUT 1346...

Hi, I feel like I'm so so dumb. Stuck with this data for weeks. I need to find out total staff that is still in the building. Staff ID Staff Name Date Time Code. 1432 Rebecca 11/17/2016 7.15am IN 1431 Stanly. 11/17/2016. 7.30am. IN...

Hi, I'm new in microsoft access and I'm trying to make attendance report graph using access and excel. In order to get the data, i need to download the transaction report from time management system (.crv)and update the excel file that i've link to access. Is it possible for me to directly link...