Search results

Wow that worked you are a hero today! Thank you so much!

still getting a run-time error '2465': application-defined or object-defined error Thanks again you have been a big help

okay getting an error "application-defined or object-defined error" I added the code into the save record button. The code as it stands currently is as follows: Private Sub Command107_Click() On Error GoTo Err_Command107_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

Yes they are named the same subcaredb1 for subform1 and dep2 for subform2

How do I find that out? Sorry I have been playing around in access for awhile and I am only using the subforms as subforms I did not rename them when I added them as a sub form. I hope that answers the question

I hope I answered that question correctly, but both subforms are linked by customer id not for sure what else you are looking for. Thanks!

subform 1 is called "subcaredb1" subform 2 is called "dep2"

I don't know hardly anything about VBA programming I just want a button that will requery my first and second subforms while still in the main form. Can you give me any additional assistance. Thanks!

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

Thanks Boblarson it worked

still all that does is is group the option groups together so for example in option group 1 the third check box is checked and in option group two the 2nd check box is checked I get:21 It isn't adding the values from each option group already assigned it is just listing them in a row. Thanks!

is the 1,0 in the above formula trying to assign a value to the checkbox for example if checked =1 or not checked = 0. The formula does not seem to work as I have four check boxes in an option group. The values of the check boxes are again already assigned from 0-3.

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

it already has a ton of tabs on the form or I would have just added a tab.

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

So this is what I am trying to do. I need to add a second form because I have no room on the first one. I need the second form to reflect the same data from the first table and the forms must match with last name, first name, and employee ID #. I am trying to make it to where it is a second...

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

Well okay so this is what I am trying to do I have a combo box with several different options to choose from. I need to be able to get a detailed count of all the options selected from the combo box. The reason why a combo box is used is at any point the patient can chance their level of...

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