Replies

I agree with Charlotte, the timer seems to be the cause of your problems. Yes, there are ways around it (like she suggested), but why do you have it?

As for highlighting a row, you have that capability in Access2000. You need to look at the conditional formatting capabilities. This allows you to change the backcolor property of controls when they are on the selected row.

I’m assuming, from your description, that an individual can have only 1 schoolID; and that this ID is stored in the individual’s record. I don’t know why you have a subform at all. It seems that all you need is a combo box on the mainform. In design mode, click on the combo box icon in the tool box, then click and drag the schoolID field from the field list to a place on your form. The combo box wizard should then pop-up and guide you through creating a combo box in which the school name is displayed.

I think you need to be a reseller to get such a license. Best thing to do is check the Microsoft site.

While they may have the same source, it doesn’t mean that they have the same records. The subform only has those records that meet the criteria of the Master/Child linking fields. So, let’s suppose that your listbox rowsource is “select * from sometable”, and suppose your subform’s record source is the same. The listbox will contain as many entries as there are in [sometable]. But your subform may not contain any records, since it depends on the value of the Master link field on the main form.

Such a temporary table would only be practical if the number of records was static, or if you created the table through code such that you could adjust for the total # of recods. That is, if there were 110 records, your sequence would be 1,56,2,57, etc.

Well, I learned a long time ago that if you learn how to do someone’s job, THEY WILL LET YOU!

yes. You need to identify a unique record if you want to “find” the same record in the subform.

First of all, the bound column needs to be the column that contains the SchoolID, which I guess is column 1 in your list box.

The last line of your message, in which you indicate that the subform works standalone, seems to indicate to me that (as I said before) that the recordset used by the listbox is not the same as the recordset used by the subform. Remember, the subform’s recordset is filtered by the Master/child links on the subform control on the main form.

>>Technique #2 can lead to streaks and smears on the output because of the toner already on the paper when you pass it through a second time. If you do select this technique, you’ll need to be very careful about running cleaner sheets through the printer in between runs.<<

Yes, but at that point it becomes a hardware issue, and is therefore out of my hands!

There are several places to put it, depending on how you call that promotion form. In your promotion form’s Close event, you can tell it to requery the subform on the mainform, like this (substitute your own form and control names):

Forms!yourFirstFormName!subformControlName.requery

There are a couple of ways (some tongue in cheek!). The easiest is to configure you report so it only prints on 1/2 sheet of paper. Then when they cut the report in 1/2, they will throw out 100 1/2 sheets that are blank.

Technique #2 is really contrived. Again configure your report to print on 1/2 sheet. Make sure the query for your report’s recordsource specifies TOP 50. Run the report. Now, put the paper back in the printer, but turn it over and around. Configure you report sorting options to be in Descending order (assuming it was in ascending order before), and keep TOP 50.

Technique #3. Look at them like they are complete idiots. Then ask why they need to do that. Then offer better method.

I’m assuming you have one record per day which holds all the “slots” for the day. If so, then I’m afraid you are pretty much out of luck. You basic database design is non-normalized, and you are seeing the results. Each “slot” should have been a separate record.

The code you listed before should work if the listbox is on the subform:

Sub LstSchool_AfterUpdate()
‘ Find the record that matches the control.
Me.RecordsetClone.FindFirst “[SchoolID] = ” & Me![LstSchool]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

There are a couple of things that could, however, that might prevent it from working. Is [SchoolID] a number? Also, and probably most important, your listbox must have as it’s rowsource a query which will produce the same recordsource as the subform! If the listbox has items not in the subforms recordset, then it can’t find those items.

Assuming that the listbox or combo box is the “master” link in the connection between the mainform and the subform, just put a line of code in the AfterUpdate event of the list box that requeries the subform control:
Me.subformControlName.requery

I’m not sure I follow what you are trying to do, but I’ll take a shot at it. It seems to me that you need a 3rd table for procedures, which are specific to an appointment. So, your relationships would be:
Patient ==> Appointments (1-to-many)
Appointments ==> Procedures (1-to-many)

You can’t put a tab within a tab. However, a tab page can contain a subform, and the subform can have a tab control on it.