Recent content by Misiek

can you be more specific, how to do it?

I already have section that filter data for specific day. I just need to know how to create the bar chart and make it look like one from the link (in previous post).

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

sure, Of what I was able to find, the FORMAT only works with manual date entry. In my case it gave an error when tried with datevalue(myfield) or datevalue(date()). Therefore I have returned to FORMAT. The solution proposed by CJLondon, wouldn't work in my case, as users need to see records...

Need to select each day separate as this is a TASK PLANNER application, we enter tasks ahead of time and then on the day we execute whatever is due. Tomorrow, Next Monday, etc are there to preview whats coming and we can reschedule. I will look into DateValue, Thanks :) EDIT: I tried with...

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

thanks, sorted.

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 again, Unfortunately I found another problem, When I open the form and click Filter button, it gives 12 records, then click REPORT button and I still have 12 records. All of it is ok. Please memorize 1st and 2nd record issue 1. When I click Common Resource button I only get 1 record...

Yes works superb! Would never think this was the problem. Many thanks :)

So I just need to simply add it to q_actionplanner?

please see stripped version.

I tried this yesterday but when I run it it shows prompt to enter userResource instead of filtering. Like it doesn't know this filled name. The spelling is 100% correct. I also tried TableName.fieldname = true. But this gives the same prompt :/

Thank you. I think so, will try it tomorrow at work. can i skip this part? """ & Me.cboUser & """ As I don't want to select any user, just click on button and the code will run in background giving me wanter result.

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