Recent content by rfaircloth

AWESOME!!!! Thank you so much!

I did see that code in my research but I wasn't quite sure how to use it. Do I need to first identify the selected row? Or just loop through all the rows in the form? The button is within each row of the continuous form so the end user will click on the button for each corresponding client.

I have a form listing out a bunch of clients. There is a button associated with each client that pulls open a new form with additional client information. There is information that is calculated on the backend and stored in the database when a user is inserted or different fields updated (i.e...

Yes, I had inserted records automatically in other tables for this project to make the queries easier to deal with. I should have done the same here. Thank you for the help, I think that should probably work!

I can't get this to work. My forms and subforms don't seem to be able to see each other's Controls. When I enter the code into the main form it only sees the Tab control and not the hidden field. When I enter the code in the subform it only sees the hidden field and not the Tab control.

The third example is what I am looking for as the output. fName lName week completed date clientID(hidden) John Doe 5/19/14-5/25/14 Checkbox Null 1 John Doe 5/26/14-6/1/14 Checkbox Null 1 John Doe 6/2/14-6/8/14 Checkbox Null 1 John Doe 6/9/14-6/15/14 Checkbox Null 1 John Doe 6/16/14-6/22/14...

No go, I am able to name the tab with plan text using the property sheet, but I need to concatenate the field to something like this: "Initial Treatment Plan (" & intFieldValue & ")". I think that it is going to have to be done in VBA code on the back end. I'm thinking something like...

I figured out how to get a hidden field on the continuous form that contains the row count. I created a textbox and set its Control Source to "=Count(*)" and it counts the number of records displayed. Now I'm trying to figure out how to put that number in the tab name.

I have a form that contains a number of tabs, each tab then contains a subform. The basic gist is that there are clients and each client chart needs to be audited to make sure that the every clients chart has all of the correct information in it. So if for example, each client needs an initial...

I am trying to determine the best method for how to handle this query using Access 2013. I have a clients table that contains the following: clientID fName lName admissionDate dischargeDate 1 John Doe 05/06/2014 06/27/2014 2 Jane Doe...

Yeah, I ended up creating a tiny text box and putting it up in the corner and setting the focus to that and it works now.

Tried moving it down about an inch or so, but that still didn't work.

No, no other fields in the main form. All it has is the tab controls with subforms.

I have a form that I created that has a tab control. When the form loads, it automatically sets the focus to a field in the subform. This wouldn't be a problem, except when it does it hides the tabs at the top of the form so I have to go and scroll back up every time I click a tab so that I...

Did you ever figure out a solution to this problem? I am having the same issue with a form focusing on a subform after on_current.