Search results

I'm not sure I understand your table relationships. It appears like "Each patient can have 0 to Many Note records". If that's the case, it would follow that each Note would be different. If that's the case, why *wouldn't* you want to show the Note field multiple times?

The best way I know is to set the RecordSource of the form. I assume currently that the recordsource is bound to a Table. Instead: 1. Set the form's recordsource to a Query which is simply requesting all records from the source Table 2. In the query set the Sort property of the field you want...

To draw that picture seems quite difficult and impractial. I think it would be better to create a line item report for this. Take your table where you link 1 person to 1 computer at 1 time. Then create a report off this that groups records by Day and Hour. For each Day/Hour grouping list the...

I would either have a different type of bill (as you suggest) or add a new Yes/No field to the table called 'ApplyTax'. Either way, if you are processing the tax *within* the query you'll probably have to use some kind of 'if-then' statement. Something like...

Put similar code in the OnClick() event of command42... If not isnull(Forms![Timesheet1]![HoursWorked]) then 'Perform refresh end if You might also be able to reference a control in the subform using: Form.Subform.Control ...

Put code similar to this in the AfterUpdate() event of the combo box which triggers the change... If Not IsNull(<COMBO BOX>) Then Select Case <COMBO BOX> Case "In Review", "In Work" <CONTROL>.Visible = True Case Else <CONTROL>.Visible = False End...

I'm not positive, but try this.... Set cmd = New ADODB.Command cmd.ActiveConnection = "PROVIDER=SQLOLEDB;SERVER=KCNTLBASE;DATABASE=Test;U ID=testuser;PWD=testpassword" ... If that doesn't work tell us what the error message that is being displayed....

Without looking at the data, here is my assessment... In the recordsource for the report, modify the query to include a 'Group By' on both the Month and Status fields (i.e. Denied). Then also have the query contain a field which Counts the number of records for each grouping. In the query...

Smart is on the right track, but you'd want to take a second step. 1. Yes, add a column and set the sort order starting with 1. Also, for any records that you want to sort alphabetically, set the sort numbers THE SAME. Example: 1 Performance 2 Second Item 3 Third Item 3 Fourth Item 2. Now in...

You can reference a control of a subform from the main form (to check for a condition where value <> 0 for instance). An example of a control reference on another form: Forms![Form1]![Control1] So the code for the On_Click() event would be something like... If...

Also, watch for how your SQL begins... You wrote >>> strSQL = strSQL & "HAVING ... You might want >>> strSQL = strSQL & " HAVING ... Notice the extra space between the quotation and the word 'HAVING'. If you are combining the contents of strSQL with this new text you might need a space...

Yeah, you might be right. Another easily solution is simply to bind the data source to the field itself. Why use Dlookup?

Try this: =DLookUp("[Name]","tbl_GP_Details","[GPNumber] ='" & [Forms]![frmPatient_Dets]![GPNumber] & "'") Strings variables need to be concatenated with single quotes around them.