Search results

So you could have two flags set on the record: One for suppliers / or orders to the supplier, for which an email is not to be sent (emailRequired) and another for email issued (emailIssued). The person doing data entry must "know" form the flow you describe which are to be processed and issued...

As you indicate the issue is with data quality in the product table: names and part number and description. I assume say sales data which uses the PartID and so you do not want these altered. Issues: How to prevent ongoing issues with users selecting invalid/"bad" PartIDs - those deemed to be...

DoCmd.OpenReport has the following structure: OpenReport ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs Where you are trying to pass the expression for the WhereCondition - A string expression that's a valid SQL WHERE clause without the word WHERE. So what do you have...

Your issue: Both DoCmd.RunCommand acCmdSaveRecord trigger a write conflict. 1. The first forces a save of the current record on After updating the Town_suburb control. This is not an appropriate place for this action. Validation checks of data on your form from occurs in the Before_update...

I do not use followhyperlink - you have the associated files in a dedicated folder, so the path is defined. You simply need to open the file using the link. Creation of the record and possible edit of the display name and to make the display name work like a hyperlink. Something like as shown...

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