Recent content by Surdeymon

ok - I have searched multiple forums and I found many posts but none that rectify my issue. I have a form (frmAllowReview) that is based off of a query of 2 tables with a basic one to one link. That form has a subform (frmAllowList) that is based off of a table. They are linked by an ID...

Hello - I have a form (frmIssueList) with a subform (frmIssueChgList). Each IssueID has a one to many relationship with the subform. So when an Issue is create a list of charges that fall under that issue is inserted into a subform. That is ok with the RunSQL command. The only problem is...

Hello - I have a form (frmIssueList) with a subform (frmIssueChgList). Each IssueID has a one to many relationship with the subform. So when an Issue is create a list of charges that fall under that issue is inserted into a subform. That is ok with the RunSQL command. The only problem is...

Morning - I have been searching a bit but to no avail. I have a query (qryTopTenList) set up in a database that selects the Top Ten "Classes" from a table with a key field of "insclass". I have a multi select list box (LstInsClass) that allows end users to select multiple insurance classes...

That did it - Thx for your help! That did it - Thx for your help!

Hello - I have a subform set up in datasheet view and I want the following to occur: When a user enters a date in one field - I want code to calculate the difference in months between that date and another date, find the value of nbr based on that difference and assign that value to another...

Hi - I searched hi and low to no avail - I have a subform that is in datasheet view - Whenever a user enters in a "visit date" I want the following code to calculate the value of Nbr - and store that value in a different subform control (Me.cboPostOpID.Value) - BUT the system cannot identify...

Thanks Wayne In lieu of a report - I will create a control that based upon user selections will create a QueryDef that defines that control and use the ORDER BY as the sort drive. Thanks for the feedback. Surdeymon

Hi - I am curious if this is worth my effort. I am in the process of putting together a form that has a lot of end user options to filter data on reports based upon the values they select on a few list and check boxes and a combo box or two. In lieu of creating 15-20 different predefined...

Trying to do a Crosstab I suppose it has been awhile...Some recs will exceed 255 columns - or at least when I try it states that there are too many crosstab column headers. The thing is If there is more than 6 services for any given ActivityID", then a new line must be created. This is prob...

I have a single query that contains a list of info for say medical patients and services they have used. Example - John had 3 services Mary had 2. I need to create a single line of services for each activity ID. So I am trying to turn this ---> Activity ID Patient Service 123...