Search results

A reasonable starting point using youtube, with many videos on you tube is the computer learning zone - richard rost. Start with introductory videos at no cost.

Search for cascading combo boxes: where the data source of the bedrooms combo depends upon the value selected in the Floor combo

The relationships between your tables are nonsensical - every table is related to every other table and at least some of the attributes appear poorly assigned. Think through each of the tables as concepts: ROOMS: Presuming these are the items that are normally "rented" or booked, not beds. But...

Yes. And the JobID is probably obtained from the parent form: intJobID = me.parent.JobID and the quantity of the part is likely also needed as a further item in the insert statement - set to 1 and allow the user to adjust the quantity in the subform after requery: set the focus to that control...

When you press the button - triggering the On Click event obtain the PartID, and the JOBID. In your code construct a SQL INSERT statement, which you then execute: INSERT INTO table_name (column1, column2, column3) VALUES ('value1', 'value2', 'value3'); so it might be intPartID = me.PartNo...

You might also consider a find as you type capability - see @MajP (FAYT classes) has provided a range of capabilities that can be applied - as a search form (for parts), or a list box, a text box or combo that can filter as you type across any number of fields. Once an item (part) is identified...

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