Search results

This link is a reference to a solution for Combos and ListBoxes: ALL Option for Combo and list boxes Somewhat lengthy code,

This should be a new thread: Go to Forums --> New Thread: Post it in an appropriate Forum: General

The QR code identifies the keg allowing the keg's record to be found in the table of kegs (KegInventory). It does not change its status until you take an action to update the Location or Status. The keg record includes the type of beer (type of beer / brand etc is another table), Location is...

Perhaps the issue is that the relationship os not correctly defined - looking at the OP and the attributes, it would seem that, because the Project appears to hold the foreign Key (KF) to JobCards that a Job consists of many Projects. However looking closely at the attributes in each it would...

You need to have a clear understanding of the data you need to track the status of you "keg" inventory. From what you have already described you wish to track your kegs. A keg may be in store - filled, emptied or tapped -ie standing in the bar. The kegs have barcodes that allow them to be...

Yeah, whatever you say... it seems the OP needs to provide input - which we might not get.

Perhaps I was not clear enough in explaining this above @Pat Hartman - I think LarryE's posts about the relationship and normalising would be obviously useful to the OP to consider more deeply (I am not saying do not normalize). That is an appropriate activity, especially from what the OP has...

Wishing everyone a Happy New Year, a quick recovery, a siesta and the grace to hide your smirk :unsure: From Kiama:

Before jumping in perhaps we need to understand what the OP was seeking - It is quite likely that this is essentially a form to show the status of a Program/Project at a meeting - essentially a report to a meeting. It is unlikely that the OP has or requires a full-fledged application that...

This thread is 13 years old - so the OP is unlikely to give you an answer. Given the reference ME - it indicates it applies to a control on a FORM called MyPage. Suggests MyPage is a textbox or combobox where a page number can be entered or selected. The Page Number is a string value rather than...

I don't know what "sum" you need - I presume it is a calculation in which Quantity and Amount is involved using Rate, but I have no idea what it is you are trying to calculate. Do you need this in a query, or show on a form as a control in which the calculation is done? Could be: iif([Is Head...

Try opening your access database while holding the shift key down. No code runs so you can then review your code to adjust.

Not sure it is the same issue.. and suggest this should be a new thread. are your table relationships actually: tblApartments -- tblApartmntRooms (1:N) tblRooms -- tblApartmentRooms (1:N) If so, then your query should pull ApartmentName, RoomTypeName, with sort order by ApartmentName and...

Hmm -- is this the same question? https://www.access-programmers.co.uk/forums/threads/i-have-2-questions-regarding-query-limits-and-form-additions.333012/

Count: count of what - 1 query, 10 fields irrespective of using * to get them in the query or individually Unbound control: your sum is based on fields - which for the current record, if it is a new record the new field values are not committed to the table until saved. Also when edited, the...

Suggest you look at this item from one of our contributors: https://www.isladogs.co.uk/office-dual-install/index.html

... or the scanner used is associated to a work area. But in either case (as in Pat's suggestion or this one) what would happen if a worker is deployed to work in the other area or the scanner is moved to the other area because the existing one broke or some other need arose. Are all item types...

Read post 2. The lack of data constraints in Excel make it a poor choice generally for maintaining the quality of data when used /referenced by a database app particularly if the Excel file is not well managed. A thread with references/links to what you are proposing to do I think...

You need the table if you are going to be able to do what you want it to ... your path where there are multiple stop records for the same stop is fraught with issues requiring special processing. Definitely fried :oops: Normalisation is a fundamental part of the process that can only be ignored...

This is not supported by your current model. Stop-Customer is M:M if this is the case. Resolve by introducing a CustomerStop intersection table using 1:M for Customer-CustomerStop and Stop-CustomerStop. You can then have the ability to have multiple Customers for each Stop