Search results

Dear All, I have a table for tasks. Fields: ID, TaskOwner, Task, Date(with time) Execution time, and couple more Is it possible to create a bar graph view of a day. or part of a day? similar to this...

Hello All, I had a request from my boss to add time to out date field - "tTaskDueDate" I have changed default value from Date() to Now() in the form. I had this code working fine until now: Select Case Me.cboAPduedate Case 1 strWhere = strWhere & "tTaskDueDate = date()-1 And "...

Hello, I'm attempting to learn MySql, first issue I found, It doesn't do TRANSFORM like access, Here's my old SQL from access, I need to change it into standard SQL: TRANSFORM nz(count(*),0) AS FoundMonth SELECT month(dDateFound) AS [MONTH], Count(*) AS [Found] FROM Q_Defects INNER JOIN...

Hello all, I'm struggling to find answer online, perhaps not asking right question. In one of my forms I use Alan Browne's filtering code http://allenbrowne.com/ser-62code.html This shows all records with specific user: If Not IsNull(Me.cboUser) Then strWhere = strWhere &...

Hello all :) I am trying to transform a query as need to create a customisable graph in report, I got other 2 working but struggling with this one. Here are my 2 base queries: Q_YTDmonthlyAREAchart3_sub1 Q_YTDmonthlyAREAchart3_sub2 This is third query a combination of...

Hello all, A union query counts how many records has a date entry, the second field counts how many records has another date entry. my query: Trying to calculate field in union query, but gives me this error: I need to do this calculation: Fixed/Found=Result Can anyone advice please?

Hello, I have been trying to find a best way to open a report based on form filtered data, with additional chart on it. The form and report works perfectly fine. Then I created second query and added a chart based on this query to the existing report. It does work well but unfortunately I don't...

Hello all, I followed this: http://www.fmsinc.com/microsoftaccess/Forms/openargs/index.htm which works perfectly, but When I want to add 3rd value or in the future potentially 4th, I'm struggling with code. Can anyone advice please. This is button command in form: Private Sub...

Hello, I have been searching for past 6 hours but can't find my answer. Have an after update event, where depending on selection a report will open and show all records with due date for next Monday, or with due date within next week. here's my vba: Private Sub cboAPduedate_AfterUpdate() If...

Hello, I have a table DEFECTS and table USERS in the table Defects is a field called dUserFK which is linked to table Users. I need to make some changes to layout of the database. Until now, we had PERSON REPORTING which is dUserFK, but need to add another field in the same table PERSON...

Hello, I have a button that open a form DoCmd.OpenForm FormName, , , , acFormReadOnly form opens as read only and everything is as it should be. In the footer of this form I have filters and I need to be able to use them. Is it possible to have form opening in read only for...

Hello all, Created a query based on one table, this table has few 1-many relationships. Query works as it should be until I replace FK numbers with texts from related table. It works for all table but one. When I add table T_area query starts to duplicate records, but only in the query, doesn't...

Hello all, We have one database with table Incidents and table Task, every task must be assigned an incident to it (one-many). We will also have another database with table task. Those are singular records, not related to anything, just task and due date, completion date. Yesterday, my boss...

Hello all, This works: SELECT sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100 AS Calcul FROM Q_Defects WHERE (Q_Defects.dAreaFK)=[Forms]![F_MainMenu].[cboStatsArea]; This doesn't, can't find out why... TRANSFORM nz(sum(iif(dDateClosed is...

Hello, The following code supposed to let me print all records OR only those where dAreaFK = myCBO currently I get an error message "Object missing" if i remove this: Or Me!cboStatsArea Is Null from the last line the it works but only if i make selection in combo. Private Sub...

Hello, I have a form with 2 cbo. I want query to show all data if nothing has been selected, or show specific data to whatever has been selected in cbo1 AND/OR cbo2. My query was working ok for couple of days and then stopped. I don't know why, as no changes has been made. if both cbo are...

Hello all, After couple of weeks of using the DB one of the reports which load up automatically when main form opens, stopped working, and gives an error message: the expression is typed in incorrectly or is too complex.... report has 13 txtboxes, in every single one of them ive placed...

Hello, I have a TRANSFORMED query: TRANSFORM nz(count(T_qa.qaQAPK),0) AS SumOfQAs SELECT month(qaDate) AS QAmonth, Count(T_qa.qaQAPK) AS QAs FROM Q_ALL_qa GROUP BY Month(qaDate) PIVOT month([qaDate]) IN (1,2,3,4,5,6,7,8,9,10,11,12); This query is record source for a report, then this...

Good day all, I have been trying to resolve those 2 problems, but so far unsuccessful, probably didn't asked the right question. Would appreciate your kind help. Problem 1. The following code was showing #num! if [cboDeptStats] was left blank, after I added the iff(Nz.. function to what I used...

Hello Again, I am using this code: http://allenbrowne.com/ser-62.html works excellent for me, but I need to add a combo with value list (only 2 items) and will be singular selection. I have type in those 2 values in the cboTaskType row source, and then tried to use this: If Not...