Search results

Okay so after playing around with this I haven't been able to solve the issue; however I think I have been able to "debug" and get more information. I have code executing when the form loads and that code as the following line: DoCmd.GoToRecord , , acNewRec When I comment out this line of...

Hi namliam, I read through that post but the information in the post wasn't able to help. Regards, Zohair Yousafi

Hi jdraw, Well I have two main tables I am pretty much doing everything with. One table is called tblTasks and the other is called tblTaskHistory. The first table, tblTasks, has a one to many relationship to the other table, tblTaskHistory, via the "TaskID" field. The end-user comes to this...

I honestly have no idea what that means. I am using something like this: BoundField.Value = UnboundField.Value The unbound field is a combo box and the bound field is a text box.

I have a form that has a SQL query with a JOIN of two tables as the recordsource. I have one unbound field, a dropdown, on the form and one bound field, a text box, and both of these fields have to do with the TaskID. The JOIN of two tables is as per the TaskID. Now if I pass a "TaskID" to...

Thank you very much Plog! That worked like a charm.

tblTasks TaskID,AssignedTo 1, Zohair Yousafi tblTaskHistory TaskID,TaskStatus 1, New 1, In Progress 1, Completed 1, Reopened 1, In Progress 1, Completed 1, Reopened I want to be able to count how many times Zohair Yousafi's tasks were reopened. The count should be distinct as both tables have...

I have been at this a couple of hours and I just can't seem to make any headway. I need to count records based on multiple criteria from two different tables. I have two tables (i.e. "tblTasks" and "tblTaskHistory"). The tables have a one-to-many relationship based on the "TaskID" field...

Yes Mihail and JHB there is data for Task 250. I was able to fix this by simply assigning focus to the subForm, using the "requery" method, and then setting the focus back to the main form. Worked like a charm.

Hi Mihail, I select the task from a combo box on the mainform. The combo box is populated with a query itself. If I don't click on the subform the combo box performs exactly as intended; however if I click on the subform and then click back on the mainform and make a selection from the combo...

The field on the mainform is called "TaskID" and the linked field on the subform is called "TaskID". When I first open the form and select, for example, "Task 100" the subform requeries correctly. When I make another selection from the dropdown and I select, for example, "Task 200" the subform...

A subform on a main form is not populating after the user clicks on the subform and then returns to the main form and updates the field which the subform is linked to. The first time the subform populates absolutely okay; however once the user clicks on the subform and then returns to the...

Hi JHB, I sort of tried what you said. I say "sort of" because I don't have the "Rule Type" option when I open up the "Conditional Formatting" window. I tried what you said nonetheless and it still didn't work :( The Microsoft Office Tutorial also made it sound that easy; but for some reason...

For example I was writing the following in SQL: SELECT COUNT(AssignedTo) FROM tblTasks WHERE AssignedTo = Expr1; However Access responded by saying it could only return one record at a time with this particular query. Then I used the following DCOUNT and got the desired result...

I have tried using all of the help guides provided by Microsoft and several other guides I found online; however conditional formatting is simply not working. I have two fields on a report, the report is based on a query, and the two fields are called "ExpectedCost" and "ActualCost". I want...

I am trying to accomplish a simple count. The query is based on a table, tblTasks, and the query is supposed to tell me the unique names of who the tasks are assigned to and then how many tasks have been assigned to them and how many they have completed. I tried what each of you suggested but...

That is giving me a syntax error. Access 2007 is saying the issue is with "(SELECT COUNT(*) DISTINCT(AssignedTo))".

Yes I get the same error.

I keep getting an error with the following query: SELECT DISTINCT (AssignedTo) AS Expr1, (SELECT COUNT(DISTINCT (AssignedTo)) FROM tblTasks) AS Expr2 FROM tblTasks; The error is "Undefined Function 'DISTINCT' in Expression". What am I doing wrong? The "References" are okay because the...

I have a Main Form which is essentially the based on my child table called tblTaskHistory. The Main Form has a subForm which is based on the parent table called tblTasks. I am using SQL queries to feed the combo box recordsource that is located on the Main Form. The After Update for the combo...