Recent content by GaP42

Happy fathers day to the guys out there. Our Fathers day is celebrated in September

by the short and curlies - refers to the pubic hair - the literal meaning. Too much obfuscation and vapid euphemism being used here. :)

You indicate the values are boolean - so do you expect to find the text "true" in each of those? If it is in fact a text field then you need to look in to text delimiters. Certainly no OR before the first criteria A useful link: https://www.w3schools.com/sql/sql_update.asp SELECT, FROM, WHERE -...

This may also provide some insights: batch-production-record-database A search showed some access templates: at a price, free to explore. Try searching Production Scheduling Database Template And not access, but the introductory material may give some leads to your solution...

Thank you for sharing the sample database. I have managed to get it to “work” after finding I could not get it to compile and commented out some code that I hope will not adversely affect its operation for this investigation. Hower, please note that you should (MUST) do some remedial work on...

@moin555 - I understand that the thread you initiated before : https://www.access-programmers.co.uk/forums/threads/when-i-select-courses-in-the-subject-enrolld-list-list-box-the-count-either-doesnt-show-or-shows-incorrectly-how-can-i-fix-this-please-guide.333926/ resolved the issue of...

Before commenting on the functioning of the buttons i would suspect that the operation of creating an order and its progression in a workflow could be more sophisticated: eg deleting an "order" record - do you really want this to happen? A processed order needs to be retained in the system, even...

How many Isaac's does it take to change a light bulb? :-) Perhaps we will never know.

Happy that it was considered as potential solution- and the immediate resolution was as expected, as the potential solution should be packaged with other fixes/improvements that may involve workflow changes that require possible changes to training.

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