Search results

I have a query which is grouped by year, facility name, and billing type and needs to display several columns of aggregate values for each of these, e.g. count of cases, sum of cases reviewed, average length of stay, etc. It would look like this: 2003 ABC Hospital Billed DRG 123 22...

bradcccs, Thanks for your response. I checked the tab order and it was correct. I have now removed this code since it was complicating the problem. The real problem is that Access is creating a record with a primary key of 0 instead of saving under the current record. This form is based on a...

I have a tab control on my form. In the change event of the tab control I am trying to tell it to move to the first field on each page of the tab control whenever the page no. changes: Private Sub TabScreenAssess_Change() 'when a new page gets the focus, set the focus to the first control...

How can I get the focus to move from one subform to the other? I tried the following to go from the last field of the first subform to the first field of the second subform. Private Sub EarlyIntDoc_LostFocus() Forms![frm58061]![sfrm58061C].Form![NursSvcDoc].SetFocus End Sub...

OK, I made a query for each of the three tables. Then made one of those the record source for the form. Then put 2 subforms on the form each based on one of the other queries. Now everything is updateable. Thanks - I got this solution from searching on the forum! :D

Originally I based my form on a query containing three tables which have a one-to-one relationship. The recordset was not updateable. I tried changing the join type or which pairs of tables were joined. Still not updateable. Tried putting 2 tables in a subquery then joining this to the other...

I have a report with columns Patient Name, Medicaid Nbr, Rate Code, etc. Each patient has their own Medicaid Nbr but may have multiple rate codes causing them to have multiple lines on the report. I want to number only the lines where the patient changes. I tried a textbox with running sum on...

I did end up doing what I suggested. Before the form is opened, clear the intermediate Events table and populate it with the active case. The use of keys for each event helps for the initialization and the saving. It works very well. Also, since there may be many forms (for different tables)...

I have a frmFindRecord where I select from cascading combo boxes: cboFacility, cboReviewType, cboSample, cboCaseNo. Then I click a button which has the following code: Private Sub cmdFindRecord_Click() On Error GoTo Err_cmdFindRecord_Click Dim strWhere As String Dim strFormId As...

Wayne, I tried your suggestion and got closer to the number that should have been marked. Then I figured out that the reason it is a little off may be because I am selecting males, females, and "eliminated" separately. My supervisor said it is OK, it is close enough. Thanks for your help!

I am trying to mark a random set of records in the table. The user enters the percentage of records to mark (txtPercentage). e.g. if the user wants to mark 45% of the records (s)he would enter 45 on the form. There are other criteria for selecting records also. It seems to work except that it is...

I have different versions of a form. The version of the form used depends on the current record. Each record has a field FormID and the form names correspond to the form ID's, e.g. if the FormID is 11267, that record uses frm11267. I want to know if in the underlying query of the form(s), there...

Just thought I would post an update on this problem. I have abandoned this code. I have now created an intermediate table, tblARVEvents, which matches the layout of the form (one record per column of the form). I created a bunch of append and update queries to populate the intermediate table...

Here is a sample of the code I tried. It may help explain what I am trying to do. Private Sub Form_Load() On Error GoTo Err_FormLoad Dim db As DAO.Database Dim rsCol As DAO.Recordset Dim strCriteria As String Set db = CurrentDb() Set rsCol = Me.RecordsetClone...

I have a working form with two levels of subforms, based on my table structure. However, I would really like the form to match the layout of the paper form which is scanned to populate the tables but whose format is very different. The table structure is as follows: tblARVMaster CaseID (PK)...

OK, looking back at the underlying query for the form, apparently I had renamed the field in the 1st column query. I removed the renaming and then it worked. Stupid mistake! Thanks for your help.

Ilkhoutx, thanks for your reply. I tried your first suggestion on the first subform's combobox and there was no change. For the second suggestion, since the other three subforms are copied from this one, the names are the same. Why would the copies work and not the original?

Now I have changed the background color to white, making the lines less visible against the background picture. It might be good enough. But I am still looking for a way to remove them entirely.

My form has a subform on it containing what should be 4 identical subforms. This represents 4 columns on the corresponding paper form. The underlying query for each differs by the criteria for ColumnNo. Each of the identical subforms contains a combo box called cboEventAns. The subforms (both...

Thanks for your reply, Doc_Man. It might have something to do with my background picture. When I turned the picture tiling off the gray or green became the background color of the corresponding section of the form. Then I thought it might be the picture type since other forms that did not have...