Search results

  1. S

    Yes, Another Cant Go To Specified Record Err

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

    DSUM Problem totaling value of a query to a control

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

    DSUM Problem totaling value of a query to a control

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

    Assign Query output to Multi Select List Box

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

    Prob with Update Code

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

    Updating field in subform set up in Datasheet View

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

    Allow End User to Select Sort Groups?

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

    Can I do this via queries??

    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...
Back
Top Bottom