Recent content by knn9413

Thanks Paul. That worked. Wonder why I did not think of that before :banghead:

Doesn't work. I somehow think that it is mandatory to include the column name in the SELECT statement. Might be an Access limitation for all I know. The moment you include the column name in the query, it works fine.

That result is incorrect though. You will see 2 different rows for the same Project and Task since you included the Workdate. What I wanted was the first 2 rows combined into one.. That is why I am questioning if access can even do that. I know Oracle, DB2 support that feature. Year End Tax...

I tried that as well. No luck.

I posted this within the Reports as well, but since this has a little bit of VBA decided to ask this here as well. I have a report that is created from the following query (qryTotalProjectHours). What I am trying to do is get the total hours spent on Tasks within a given time period. A given...

I did debug the code, it looks good to me. See the contents of WorkDate below. The "#" sign works everywhere else so I believe that should be ok strWhere : "WorkDate BETWEEN #4/1/2015# AND #4/30/2015#" : String : Form_frmManagerReport.cmdRunRpt_Click

Is there a way to check what the query looks like before it opens up the report? If so, can someone please guide me how to look into it?

I have a report that is created from the following query (qryTotalProjectHours). What I am trying to do is get the total hours spent on Tasks within a given time period. A given Task can we worked on by multiple individuals and hence I need to find a way to aggregate the hours spent. SELECT...

Here is the database that I am working on. Hopefully you should be able to understand looking at this. Once you open up the database, open up the login form. Use the password as "password" for any user. You will see 2 forms. one for active and other for non active tasks Click on Add task up...

That didn't work..Maybe because the data is in a subform within the mainform? Or just because the record in the add form is getting added by clicking a button... unsure at this time

I actually went through each event under the main form to plug in the requery and didn't see any of them firing. Currently I had to implement a button on the mainform which when clicked will refresh the subforms. I was really hoping to get away from that..

I had the different version of the me.parent as I mentioned in my post. Me.Parent is incorrect. The version I had was working as long as the subform was not shared between 2 forms. The problem is strictly because of the fact it is shared now and I don't want 2 forms with different names doing...

I have one additional doubt since my form activate / got focus event isn't work. I click on a command button to open up the subform. So when I close the subform, what event should be triggered first? I think I would need to put the requery in there...

There are 2 mainforms and both of them share a subform. This subform is an add subform and I want the mainform to be refreshed after the data entry. Prior to the sharing, I had it coded it the way below and it works fine Forms!frmMainformnoproc!frmActiveTasks.Requery How would I recode this...

This is weird.. I got up this morning and it works just fine. Not sure why it showed spaces yesterday night...And I was not even drinking:p