Search results

  1. S

    Balance in a Inventory Database

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

    Calculation Like Inventory

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

    CalculationHistory

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

    Duplicate Records in a one-to-many relationship

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

    TextBox #Name? Error

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

    MessageBox in combination with IF function

    Dear Fiends, I have a tbl called tblUsers:[Fields]: Userid, Name, HireDate. I created a form with this fields. Also i placed a textbox with controlsource: =DateDiff("d",[HireDate],Now()). What i want: If the text box value is greater then 100 a messagebox must must popup. I tried the IF...
  7. S

    Question ShowLastrecord!!

    Dear Friends, I hope u all are fine. I need some help. I created 2 tabels (tblusers and tblpayment). tbluser has user information tblpayment hourly payment information. I created a form named frmHrm. I placed the user information and payment in the form. The payment of every user can...
  8. S

    Question Calculations in Form/Subform

    All, Greetings to everyone. First of all i am new to this forum. I have a challenge. I created a database, The database has a Form an a subform. In the form i have employee information and in the subform employee payment information. There is a "one to many" realationship between the table...
Back
Top Bottom