Recent content by suradj

I checked the zipped file. It's oke :) I know how to create a Form etc. But in my database i want a form with a field wich shows me the balance and quantity on the most recent date I looked at the sample database of Allen Browne. See attachment

Hi All, i have created an inventory database. I used the code of Allen Browne(http://allenbrowne.com/appinventory.html). Now i have to create a Form which shows me the balance and quantity on the most recent date. I looked at the Inventory Sample of Allen Browne but can get further. Can u...

Need more information?

Friend, i tried this one but with no success. TABLE tblPayment UNION all SELECT EmployeeID, [DatePaid] as DateUsed, Ont * [WorkedHours] AS AmtUsed from tblPayment UNION SELECT [EmployeeNum], [DateUsed], [AmtUsed] ; I have attached the database. Can u please tell me more how to create a union...

Friends, I need your help. I created a database with 2 tables and 1 query: tblPayment,tblEmployee,gryCalculation tblPayment is updated twice in a month. every payment has his own paymentID. I have a calculated field "ontv"(total workedhours) I have a vacationfactor For paymentX the...

Dear Friends, How are you all?. The Spain fans congrats :). I need your help. I created a database with 2 tables and 1 query: tblPayment,tblEmployee,gryCalculation tblPayment is updated twice in a month. every payment has his own paymentID. I have a calculated field "ontv"(total...

Thanks man. It worked. I created a subform and the problem was solved.

Friends, I need some help. I have a database with 3 tabels: tblUsers,tblHourpayment,tblPayment. tblHourpayment and tblPayment has a one to many relationship with tblUsers. i have created a form based on tblUsers, and one field(hourpayment) of tblHourpayment. In tblHourpayment one UserID can...

Thnx Man. This great

Steve, Example: if i have 10 records and i navigate to record 9 and if textbox with controlsource: =DateDiff("d",[HireDate],Now()) = greater 100 a messagebox must be prompt. The Hiredate is already has a date value. So i want this to be triggerd if i am on a record and the textbox with...

Steve, I tried this code on Afterupdate: NO success I tried this code on doubleClick: With Success Did i do something wrong? Same code, nothing els If Me.HireDate + 100 < Date Then MsgBox "YourMessage" End If

Steve, Yes the name in the table is Hiredate Name of the textbox is txt328. I made i copy of the database end if i open the copy i am not getting any #Name?. I reopend the database mostly 10 times and now its working. But the error is not solved! Ps: I tried date() in another database and...

I want the date difference between the hiredate and the date of today. So if i open the database after Xdays it must use dateX. Any other option friend?

Friends, I have a textbox in my for with in the controlsource this: =DateDiff("d",[HireDate],Now()). When i open the form i get the error: #Name? After reopening the database many times is see the values. Please help.

Thats also possible. The messagebox would be better. Let me try with conditional formatting. Thnxfor the new idea. I wil try this.