Search results

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

The record source for the contact dropdown must include the customerID (?). The CustomerID is used to filter the record source. To do this ensure that in the query supporting the record source that the CustomerID criteria is set to something like Forms!frmCustomer!cboCustomer

On the subject of going Paleo? (my interpretation) - an amusing sidetrack to show the talents (or lack of) of some people I have an association with in Fathomverse (citizen science project).

Aaaegh! - the second part was meant to be directed to the OP.

Apologies CJ - @LarryE was who I should have referred to :oops::oops: You should at least start with a query to return these records - guessing but something like: (use is null / is not null in criteria as needed) That is then used as the basis for a totals query: Repeat the above for...