Search results

Thanks. I think you kind of cleared the doubts that I had. It is a simple time tracking application that the manager wants for his team. I am just helping them out. It is the normal access front end. The application is just going to reside on a shared drive which the team has and can open it up...

Sure.. I have a form which has different buttons wherein a user can update the current record, add part of the record being displayed into a different table or enter new data on the form and add a record to the table. Each of those sub routines has the following code Set cnn1 = New...

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

Thanks. That helped

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 think you answered my questions. Thanks!!

Here is the form attached. One thing that I am not too sure is if an unbound form can appear in a continuous form view or not. If no, then that is probably the issue. Also I am not sure of the option to use with the docmd.openform. I left that blank and also used the Datasheet option but didn't...

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 did try this approach and it worked great though. also understood that the bound column being set to the employee id forces that to be picked up. One question that I have is, if I need to use / pass the name to a different form, how do I do that? Based on this won't I be passing the employee...

In the above approach, how does it know to pick up the employee id? Using the cboCurrentEmployeeName would imply it is picking up the name correct? Shouldn't I be retrieving the employee id and then using it here?

Thanks. I like the first approach that you mentioned using the bound columns. I will try and use that approach to eliminate the subquery

Thanks. that was perfect. I see the mistake I was making.

I am not sure at all now. I am uploading the file now. I am hoping someone can take a look at it and help me out Thanks in advance

Hi Paul, I am new to this so I apologize in advance if I misunderstand / misstate anything. So based on my form, I think this is what I should be using. Me!Subform1.SourceObject My main form is frmMainForm and my subForm on this is called frmActiveTasks So I tried doing 2 things but both...

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