Search results

thank you very much! that was the root cause. that even when I call query still gives error. now all is well. again thank you very much. problem solved.

Payroll main form to post attendance record. Before I open the attendance form, I wanted to check if there is a record in the sql statement. The code below produces error MS Acces object "Variable or With Block Variable Not Set" Private Sub cmdPostAtt_Click() Dim stSQL As String Dim dbHBK As...

i cannot strip post the file, its too large now. about 1.2GB mnt.accdb (Access 365) file. however, this is what i did that works: i made an add query named qryaddrep and qryaddpm. here is the code containing repair: INSERT INTO repair(bdate, id, refno, [desc], otherinfo) SELECT history.hdate...

I did use this and the same result... no update. :( Private Sub cmdUpdate_Click() Dim strSQL Dim dbMNT As Database Dim rstHist As Recordset Dim rstPM As Recordset Dim rstRep As Recordset Set dbMNT = CurrentDb() Set rstHist = dbMNT.OpenRecordset("SELECT * FROM history ") Set rstPM =...

It does not use wildcards because its values are "P", "R", "C" and "O" from combo box value list.

Inserting data from History Table LIKE "P" Type into Preventive Maintenance Table and LIKE "R" Type into Repair Table. I don't quiet get it because it says "PM Data Update" but nothing happened. Below is the code: Private Sub cmdUpdate_Click() Dim strSQL Dim dbMNT As Database Dim rstHist As...

Thank you very much for the information and for sharing your knowledge ... My problem has been solved. Again Thank you very much.:D

Thank you very much mailman!! You save my headache from the last 3 weeks. Yeas the numbers 0000000085 and 0000000004 refers to Employee ID and the Dates refers to the working days. And the sequence for time-in and time out. That I would like to import into table and filter the 8:00 to 19:00...

uploaded here. extracted from biometrics: http://www.mediafire.com/view/u7zas0tryx6pcux/February01.tbp

I have no problem with the query. Just the extracting tbp content. And ADO connection is just fine. I am Using MSAccess 365. accdb connection.

Still confused with the loop; Please help me clear things up. Thank you in advance.

I tried the method 1 yesterday and it didn't give the data as required in the automation. Now trying the method 2. I'll keep you posted of my progress. The only Procedure I was aiming to achieve was BIOMETRICS (Feb.tbp) - > MS ACCESS Attendance (frmATTMain) -> tblAttMain -> frmMakePayroll ->...

i can read in notepad. but not directly in ms access. no idea how to do it. i've searched from the forum for procedures but can't find any.

This is an existing MS Access Database that is migrated from Access 97 to Access 2010. And trying to add a feature that will automatically record Biometrics data. And I have no Idea how to make it. I cant Read the biometrics data.

I created the same sometime in December 2013. I used 2 tables, 1 for Vehicle/Equipment List and the other table is vehicle/Equipment History. What is recorded in the Vehicle table are the description of Vehicles, bodyno, serial, plateno, type, model, date acquired, purchase amount, and...

The typical Payroll System with 8 users 4 of them are maker, 2 of them are approver and 2 of them are admin. The link will be the data from biometrics which is composed of time and date (in and out) that will be collected for bimonthly and daily basis. computation and structure for payroll is...

Done with the Equipment Management Systems. Thanks for the help. I am now in the payroll system. I would like to know how to automatically import biometrics data into VB-MSaccess procedure, if there are samples then it would be great help. right now, I designed the data to manually input in an...

thanks i take note of that. i have other purpose of record counting. when exporting intended records to excel. but not at the moment. just finishing my development the hr department is putting me under pressure of the payroll system and the employment history record. i am focusing on finishing...

I'm at wits end... the code did not work. so I decided to change the view. I placed the original fields into locked = yes enabled = no visible = false and created an unbound fields. So I don't have to worry about locking and unlocking since the data will not save unless clicked the saved button...

The code unlocks the fields when new record was clicked and when moved via navigation button, so even if there were records, it unlocks itself. or something is wrong with my code. Private Sub Form_Current If Me.NewRecord Then Me![empno].Enabled = True Me![empname].Enambled = True...