Search results

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

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

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

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

Ok.. I am still a newbie working on access. So far, what I have done is I have included code to open a connection in every module i.e. add, update and delete. Obviously there is duplication of some code. The one I am currently working on will probably be used by 5-6 people. My question is in...

I have main form (frmProcedures) that has a tab control with 2 pages. One of the pages I have a subform that contains a listbox control controlled by a query. The subform is a search and display form. When I open the subform on it own, it opens up fine. However when I try to open up the...

I have a mainform. When I click on a command button, it opens up another form. That form is designed to be as a continuous form, yet it does not display the header. The header is present in the form view. I have attached the screenprints to show the header in my form and the corresponding...

I have a main form that has a combo box (cboCurrentEmployeeName) to select an Employee Name. And then there is a subform within the same form that displays the list of active tasks. The record source for the subform is a query. The query is as follows. Please note that the tables are joined on...

Hello from Rhode Island, USA