Search results

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

You appear to have a very peculiar view of evolution - perhaps it is founded in the false premise that evolution extends to the cultural/political perspectives of the individual. Here and elsewhere your attempt at invoking evolution or explaining by analogy is flawed. Evolution is fundamentally...

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

What query have you attempted using the data? Have you used the Query Design feature? The application of the criteria in Query Design would suggest 4 separate queries and corresponding reports based upon those queries. The database as supplied shows no relationship defined between the tables -...

A couple of things: 1. txtCurrentDate - is the name of the control which is the date the last audit was completed? It would be a simple matter using the OnCurrent event of the form to perform a datediff calculation to determine the days elapsed between the txtCurrentDate and Date(): or more...

Labelling requirements for processed foods are very involved. Don't know about "E" numbers. In Australia and N there is this enforceable standard: Food Labelling Standards: FSANZ Explicitly indicates ingredients are listed by weight (including added water), and any known allergen is listed...