Search results

  1. R

    Question query calculation: autocalculated value + manual entered value

    Hello ALL, I am strugglying deeply with this database i'm designing. OK, here's my problem: I have 3 tables: tblTransaction, tblCertificateNo and tblTransactionType - tblTransaction table fields: transID, transDate, transParticular (dropdown from tblTransactionType), transAmount, certNo...
  2. R

    Error Handling on Date Range

    Dear fellow readers, I have two comboboxes, one as cboStartTime and the other cboEndTime How do i notify the user after selecting both controls that cboStartTime is greater than cboEndTime or in other words, if the user inputs 08:30 AM on cboStartTime and 07:20 AM on cboEndTime, i want to...
  3. R

    Autofilled txtbox on continuous form AND one control to do two calculations

    Dear Readers, I'm working on a staff attendance database where it should generate total hours worked per staff generate report with staff total hours and leave (if there any) I've put them all together in one form with the the followings: Date on main form then staffname, login time, logout...
Back
Top Bottom