Search results

I uploaded the db. Its LogOff and LogStatus not stamped.

I dont get you well. Where is it qdf.Execute dbFailOnError Debug.Print like that ...

I had change it Private to Public. Not work

Its had two ID used. a)Login b) LogOff

I tried Recordset . moreover QueryDef

Thank you very much, I tried it, however its not function on ".AddNew". Later, twice fields is not stamped "ActivityLogOff & ActivityStatus "

Hi, appreciate any help. I tried is twice ways, however its not worked. Private Sub LogActivity(activity As String) Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim logOffTime As Variant Set db = CurrentDb() If activity = "Logoff" Then logOffTime = Now()...

thank you very much. Its worked. tblTransactionWorkersIn recored is append. not insert duplicate. but, if tblTransactionWorkersOUT table have any update like field 'Leavedate' , then append not upldate. Said, '0 recored is append'

Hi, any help will appreciate. I facing a little problem in append query make duplicate each hit in the button. My appending query Like: INSERT INTO tblTransactionWorkers ( EmployeeID, TransferDate, CompID, BranchID, BranchTypeID, WorkCategoryID, LeaveDate, Status ) SELECT...

Any help ?

Now, I facing some problems with records. frmJobOrder - in sfrmJobOrderDetails if I enter data in the subform, then the Next data will autofill without EmployeeID. I Just Enter the EmployeeID the Others fields have been autofill frmJobOrder - sfrmJobOrderReplanceDetails if I enter...

Noted.

No, New job order is not relate with Order details. But when replacement can related. Kindly check with post #8

I had update with JOBORDERID in post 8. Later I will re-format JOBORDER numbers by sequential This database use each department manager. Manager request JOB Order to HR manager. then HR manager finds notification that someone order to him. He will approve.

My apologies, May I explain yous. I dont try to make a purchase order database. Work Details : I tried to create a Recruitment Database. We have 5 departments in this company and 42 projects. Sometimes we need to deployed new workers in various projects whose has joint recently. Sometimes...

I agreed, Actually I have no idea how to easily to design the table for this transaction. Post # 4 is my sample db. I try to show you What I need. I knew my table need redesign field relationship. Need some help to redesign my table.

I had make it two table. JobOrder and JobOrderdetails. By mistake to remove Job Order Numbers Operation Manager request for some NEW worker give to him for replacement or Operation Manager request for some worker change placement . If HR manager has approve the list of the messaged then...

Good Morning ! I would like to create a Job order Form and Job Order history Searcher. Example : This order from Operation Manager Operation department request a Job Order Like : OrderDate OrderUserName DepartmentName EmployeeID EmployeeName Country CompanyName City Category TransDate...

Thank you very much all of you's. I working on it, shortly I will give you feedback. I don't have any server. I using my BE file by shared folder. My computer have others 6 folders shared enabled. Problems is 5 users can ACCESS my others folder which also shared enabled. HOW TO resolve this...

Thank you very much for your reply. I had split. FE and BE. I did not make it like an installer. Its .accde file only. Should I put a copy each computer .accde file ? I don't like user can modify query. for that, I had stop to access File menu and SHIFT keys disabled. Further, My question...