Search results

here is the sql for my query. Any selection from combo1 (range combo box) gives me the same results because I don't have it set up. when I open the report, I get the same result as the query - that means it is not being grouped by "ww". How do I make that happen? Also, how do I the query to...

oh wait! i think i get it. i will post you back

1) done 2) Add a group, then group on expression - a mini window opens up, and this is where I copy the code =DatePart(GetInterval(), [dte]) 3) yeah it should. this is where I would get the option of viewing the reports in either daily/weekly/quarterly view, right? how can I pursue? Do you...

1) I created a module and saved it as getinterval, so 1 is done 2) I put the expression in where you mentioned 3) Case "report" SetInterval "ww" DoCmd.OpenReport "report", acViewPreview End Select I put this code in the double click event of the list box! but it gives me the same error. I...

Option Compare Database Option Explicit Private strInterval As String Public Function GetInterval() As String GetInterval = strInterval End Function Public Sub SetInterval(strDatePart As String) strInterval = strDatePart End Sub I put this code in the on current event of...

ActivitiesID dte (datefield) employeeID and here are the reports names with (Numbers) e.g highcube Caseflow Prewab etc

I have a couple of combo boxes on a form and a list box as well. combo boxes: type of employees - day employees or night employees Name of employees Range of reports (Weekly, quarterly, yearly etc) Selecting appropriately shows the list box with the desired reports. basically, I learnt...

hi, I want to create daily/weekly/quarterly reports - the data is from the same table. Do I have to make separate queries to get each report. issue is because I need to make like 30 reports I know I can use datepart("ww", [dte]) to get the weeks, and similarly get the quarters. but is...

this is my query for 1 of the reports. Combo = combo box for EmployeeID combo1 = combo box for employeename combo3 = type of employees (night or day) thanks!

Hi, I am using a couple of cascading combo boxes to filter a list box which contains bunch of reports. Each report is based on query. Here is the situation: the user first selects Type of Employees "day or night" from combo then employees names comes: the list box will show the...

makes sense. okay so I used something like this: if userID = 1 then *placing your code here* end If If userId = 2 then *your code* end if it works! I assigned myself userId = 1, and I dont have to deal with the subform 2. but for subform 3: I need all the employees. in otherwords, if a...

I am using the following code in the mainform's on current event If EmployeeID = 1 Then Me.afternoon_slotters.Enabled = False Me.frmctrActivity2.Enabled = False Me.Afternoon_Slotters.Visible = False Me.frmctrActivity2.Visible = False Me.ctrActivity.SetFocus End If End Sub where...

I want the same functionality for all the employees! they open the database, see their respective subform, get blank records if a new day otherwise they see the records they entered :s

Here is some extra detail: subform 1 is for employees 1,2,3,4 and subform 2 is for employees 5,6,7,8 - but subform 3 (which i didnt list in the code here) is for extra reports which needs to be completed by all the employees

this is the code that I am using - it works for the second subform now, but stops working for the first one

Yes! same name and field type.

got it! but here is the thing. i have three subforms under the main form. each subform comes from a different table. I tried using 3 if statements but that doesn't work!! If I just use it once, it works for the subform I mention... how would I incorporate all 3? thanks again :)

just one more thing!! is it necessary to put the code in the onclick event of form which opens this form? can I put the code in the onload event of the mainform?

I guess I can only learn from here :D

oh well! thanks for your great help :) this was more than enough. I was just trying to be absolutely perfect lol