Search results

For me the template is a starting point - look at the table design and think (deeply) about whether they can hold the sorts of data you need. look for gaps you need - set your scope - eg will you need to track depreciation? service schedules? service companies/contractors/employees. When you...

If you are really new to access - are you really new to databases? Do you know how to design tables to minimize redundancy in your data? That step is independent of the database tool. While you might think about the tables to store and manage the data you also need to have a good roadmap of how...

Just two tables? Table one: Customer .. CustomerID autonumber and customer detail attributes ("Main table" in plog's post) Table two: CustomerQuote .. as per plog suggested structure however do you need a QuoteDate? and QuoteID (InsuranceCompanyQuotes - icv - in plogs post), quote accepted flag...

also requires the customerquoteid - as the icv_value is presumably the quoted policy premium value from the icv. There may be other common attributes of the quotes which might be used judge the best deal, but that was not indicated.

Good to hear - good luck. Also consider how to get quantity entered for each Job-Part. Set to 1 as default.

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.