Search results

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

Here is what I have so far I have a module that has a global variable defined as shown below Module: initGlobals ----------------------- Option Compare Database Option Explicit Public strGlobalUserId As String Sub initvar() strGlobalUserId = "Myuserid" End Sub This is invoked in a login...

Not sure what the problem was. When I manually selected the column and hid it in design view, it worked fine...

Hi.. I have a main form that has 2 subforms. I have a field on both forms that I have marked as "Visible="No". Both are text box controls and I have made sure that both the label and the text box itself are marked "Visible="No". In the first subform, it works correctly, while on the second one...

Thanks. I kind of updated my post right before you posted this. I will figure that out. This is not going to be a heavy duty database. A person will access it once during the whole day and worst case twice. Based on what you told me so far, I believe it should be ok with a single front end. If...

Everything resides on the same place i.e. the shared drive I still haven't figured out, how to separate out the front end from the backend.. Can you point me in the right direction? Split the database? Thanks