Search results

Hi DJKarl, I know i shouldn't store a calculated record, but because i have to assign a new certificate number to it, i have to. Certificate Number is unique for every new transaction especially when it's a new face value, new balance brought forward, new rollover amount, or a transfer amount...

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

Thank you DCrake! Now it works on query but i want it also on report, is there anyway to format this again on the actual report where financial years are my column headings? Thanx in advance, RandomT

Thank you DCrake... I've just done that but an error message prompts me that "The Microsoft Jet database engine does not recognize 'FinYear' as a valid field name or expression' after i put my label on the page header on my report like =FinYear[Date] Please help! Thank you so much in advance...

Hi visacrum! I've been searching on google how to go about doing this, and i know this is the closest to what I really want to do. I've done what microsoft support offered using FYear statement, but I want my financial year to appear as 2006/2007...2007/2008...2008/2009 and so forth on a...

Thank you Dennisk, Apparently, i'm still learning VB so I cannot create my own function other than just the simple ones so please clarify more on your point DCrake, I'm using a pop up calendar to choose the date from so i'm not too sure if cascading combo box tricks work for me - should...

Found a way to solve my proble, i've been using DATE as PK, i had to change things around and now using DateID instead of DATE as PK. I also understand that in Continuous form, if i assign a formula to a control, it will apply to the rest of the records like it or not AND, one control such as...

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

Thanx Thunder and jal, I have a Staff Table with their details, Leave Table with the leaveID's and the assigned hours eg; CASL as LeaveID in LeaveID field, Casual Leave in the Description field and 7hrs in the allocated hours field. I also have the Attendance Table with date(from Date Table)...

AprileC - please remove my first thread without the ICON under the Form Discussion Board.. i thought it didnt' go through so i had to redo the second one....thanx

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