Search results

I have a main form and sub form. The subform is linked to a query as the information pertains to an employee id. I need the subform to update as soon as the main form record is saved. I have a button that saves the information. Where and how do I get the subform to immediately display the...

I am looking to do a single form sum. I have already created my option groups and assigned a value to each check box. I have an unbound text box and was trying to use this formula =sum[q1]+[q2]+[q3] The answer I am getting is from all forms and it is not totaling the numbers it is just...

Could someone break down openargs for me please? I am new to access have taken several access classes I even have the access 2003 bible, but this concept is very new to me. I need the main form to link to a secondary form using the same table. I need the employee information to match to it is...

I already have two tables setup with relationships setup for each table with primary keys. I want the primary table to fill in data already on the first table like last name, first name, and employee ID#. I have the forms connected already with a button/macro. I don't have room to create a...

I am currently using this on the report which is attached to my query: =DCount("[Patient Type:]","metroQ","[Patient Type:]='Level 1 Care Coordination'") and this is working correctly. However if I add this to my query so that you can manually enter the date for the report I get #error on...

I am getting an error on this report I am simply tring to have the report count " Level 1 Care Coordination" I need a total. This is what I am trying to use, but it gives me #Error on the report. =Abs(Sum([metromonthlytotalQuery1]![Patient Type:] Like "Level 1 Care Coordination"))...

I have multiple queries let's call them A, B, C, and D. I want that data all on one report. I had tried doing subreports, but that seems very complicated. Is there a way to point the control source to the specific data? I was trying to use =Abs(Count([rejected1 Query]![Case Disposition:]))...