Recent content by GaP42

larry - it is on the screen dump you just posted - About Access - Current Channel - Case of TL:DR ? :)

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