Search results

Thanks @arnelgp. That looks very good. I'm seeing everyone taking my vba sql and making a query gui with it in order for the continuous form to work. Is that the proper way to do it? Or can the same thing be done through vba? Because one of the problems I was having was trying to pass the...

This is nice. (y)

I removed it. In your example, I was only interested in techinque1 so my cbo2 is your cboProductType. I tried to follow everything related to cboProductType As it is the On Load event triggers Call RowSourceDisplay. I was thinking, can I use a parameter query to filter cbo3's row source after...

It's not on cbo2 I want the method to work it's on cbo3. I'm getting it to display properly but I am not able to filter cbo3 after updating cbo2 cbo3.RowSource = "SELECT DISTINCT FGVariants.FGVID," & _ "[FGMD] & ' ' & [RMSUB].[RMCODE] & ' ' & [FGVariants].[DIMEN] AS [DESC]," &...

I'm trying the method to cascade combo boxes as described in this post https://www.access-programmers.co.u...boxes-in-datasheet-or-continuous-form.275155/ But I am not getting it to work. The Process: After making the selection in cbo1, ......└ cbo2 rowsource is filtered. ............└After...

Update I think I did it First I did this to return the following Saturday based on the WDate Public Function getSat(sDate) As Date Select Case Weekday(sDate) Case vbSunday getSat = DateAdd("d", 6, sDate) Case vbMonday getSat = DateAdd("d", 5, sDate) Case vbTuesday...

Hourly. I tried this: SELECT TimeSheet.EID, Sum(TimeSheet.STDHours) AS SumOfSTDHours, Sum(TimeSheet.DTHours) AS SumOfDTHours, Sum(TimeSheet.OTHours) AS SumOfOTHours, DatePart("ww",[WDate],2) AS WeekEnd FROM TimeSheet GROUP BY TimeSheet.EID, DatePart("ww",[WDate],3); The pay period runs...

Ok. The workflow goes like this - The week ends and the data is pulled from the clocking machine - The data is printed out and the supervisor verifies the TimeIn and TimeOut. (this is a manual process) - The sheet is signed and then given to me for data entry. - Any allowances, time deductions...

That was a data entry error. It should have been 15:00 not in 3:00 in the TimeOut field Now you see why I need WDATE. Payroll, IMO, should always have a human element in it to verify the data. If I only relied on formulas how would I know what pay period to put the employee in. The supervisor...

Hello everyone, Still working on my Payroll db and I am looking for a way to make a query to return the total hours worked for weekly employees. Payroll ends on a Saturday and for each employee I want to generate a report to get the hours worked for each week in a month because statutory...

No, I wanted to know why STDHours was totaling twice for some employees and it was explained in post #2 by @plog

Yes, @bastanu already guided me on that in this post https://www.access-programmers.co.uk/forums/threads/return-a-specific-field-from-a-recordset-query.320919/page-2#post-1803022

1. How come an employee can have multiple statuses? EID=32 has 2 statuses, both of which have an Estatus of ACTIVE. So does he really have 2 current statuses or does the one with the latest EffDate take precedence and ESID=21 become an older one? I am using the Employee Status table to keep...

I ALWAYS use RI.

I have the Main Employee table that uses EID as the PK. EID is the FK for the TimeSheet and EmployeeStatus tables.

Oh, I see. I just wanted the total hours for an employee between the given dates. I will remove the EmpStatus table and join it in another query. Thanks.

I am running a Totals Query on a table but for some reason the sum field is doubling the values for some of the employees.

Thanks @bastanu, This is what I should have been doing all the time. Non-Domain Queries are always faster and now that I know how to hide them, I would start relying on them more.

I'm sorry @MajP have no idea how to implement this. I just started getting a handle on how to use recordsets, this and class objects are a whole new area to me. Do I put the EmpWNIS.CNIS, EmpWNIS.ENIS equals to the sql? @MarkK I got it to work, will continue to test. @bastanu you are right...