Search results

The issue is that the impact statement presented is that the "presentation" is an AI generated - a projected animated image of the victim: which in this case must be a confected representation given the victim was dead. The deceased did not have input/ or acknowledge personally that this was the...

One you will need to adapt and develop: https://access-diva.com/dm7.html

Using @arnelgp 's working db - in your report, you can copy his formula from the form for SubjectCount and for TotalCost to the applicable items in the report. However you also need to do some corrections, so that the formulae for TotalCost refers to the SubjectCount in the report. (also the...

You can select - for the free account, there are 10 servers in different countries from which you can select - one of which is the USA. Can't remember whether it retains this as a preference for the next time.

I used Windscribe - free vpn - for light use (10GB)

This might be a starting point: Richard Rost: Multi-Language

@bilakos93 Taking your database, I modified the schema as shown here (taking account of the suggestions made earlier) to support multiple scans per appointment, and to allow the location for the appointment where the scans to be conducted for the appointment to be recorded. The location would...

Quick question @LarryE - why have an inpatientDept in the patient record? (no relationship to Dept - perhaps it needs the Patient-Department table to resolve a M:M relationship of patient and Department that is not shown?) - the relationship of Scanlocation to Department to Doctor allow the...

A quick review: You have a table tblScans - which describes the types of Scans. The FK to scantype in tblBookings means you can only have one scan type for a booking. As multiple scans are possible for a single booking you must have a table tblScanBooking which lies between these two tables: 1:M...

Works for me too.. post #20 shows no other values entered apart from the subjects in the combo. Would you expect that to work? On another note: while you have found a way to add courses as a multi-value field, that is not a recommended method for longer-term / robust storing of the data. You...

Can you look at the properties of the list box, check the Event After update associated with it - and look at the vba? Can you set a Breakpoint at the start of the vba in that event and step thru the code: using <Fn - F8> until the error is triggered? What is the code on that line? Did you not...

So given that both @arnelgp and @Gasman reported that the error was not raised when they used the application that you now need to do some investigation: look at the error message: What was the user defined function in After Update that cannot be found? Where did the UDF come from? Can you...

Discounts can be applied to the total sales order or to the individual item in the order. Further they may be % discounts or a fixed amount. The discount as applied is stored against the sales record or sales item as appropriate - and linked to a campaign / scheme: Employee discount, managers...

So if the (expression result) is < 0, then 0, else .... Apply the logic, syntax of the iif statement.

@LarryE - the design also needs to include the sonographer/radiologist who is being engaged for the appointment, not just the Dr from the Department who ordered the ultrasound (the Dr ID in ScanTime can't be used for both - and it is the schedule for the Dr performing the scan that is the...

"Tax" column: IIf([tblEmployees].[Basic Salary] Between 0 And 12760, [tblEmployees].[Basic Salary])/([tblEmployees].[Salary Pay Period]), IIf([tblEmployees]![Basic Salary] Between 12760 And 25520, [tblEmployees].[Basic Salary]-[tblpayrolltaxes]![Lower])/([tblEmployees].[Salary Pay Period])...

I missed this earlier: If this is all you have to support the scans to be performed at an appointment then you will only be able to indicate one type of scan for each appointment. Earlier you indicated that you can have more than one scan scheduled at an appointment. If so then this is a...

Yes: as shown with the table structure, a single appointment can have one or more scans (of same or different types). Your form, displaying the appointment, will allow the addition of one or more scans to be performed. and post the appointment, the scans performed (usually as a subform) at the...

I appreciate the complexity of the questionnaire/response needed for the medical setting. It is indeed quite challenging and you may not be up to rejigging (normalising) the structure as suggested above. Pat's arrangement supports a simple multiple choice survey style arrangement that will not...

You should have some attribute which will indicate the source of the appointment: for outpatients you will have a referral from the GP. For internal, the source will be Hospital Dept. For an appointment of type Hospital Dept you will need a table to identify the Dept as an attribute in the...