Search results

As a variation on DHookom's solution you might be able to aggregate the relevant values in subqueries in a single query, rather than joining multiple queries. The following query is a simple example which, in addition to the individual transaction details, returns the sums of the credit and...

One context in which they are useful is in referencing academic sources. The following is an example of Harvard citation format, which is commonly used in the UK: Thagard, P. (1990) ‘Philosophy and machine learning’, Canadian Journal of Philosophy, 20(2), pp. 261–276.

Then I guessed right! Perhaps, as I approach 80, the grey matter is in better fettle than I normally assume to be the case.🦉

In the early days of spell checking we fed all our names in the family into a document to see what it came up with. My wife Fiona Sheridan was changed to Viola shredding!

I'm a little unsure about the relationship type between tblDwgReg and tblDwgTypes. At present its many to many, modelled by tblDwgRegDetails. This is predicated on the drawing type being an attribute of the relationship type, i.e. revisions of the same drawing can be of different types, rather...

I've just unzipped it again. Now it does open in Report View!

Not in my case. All open in Print Preview.

As noted in your earlier thread, I am unable to reproduce the behaviour you are experiencing. More fundamentally, however, I think your model needs amending as below to avoid the current encoding of data as column headings in tblProjects: PS: I've just noticed the redundant DrawingID column...

I've been unable to reproduce the behaviour which you are experiencing. All of the reports open correctly from the links in the frmDwgReg as expected, and can be printed without any issues. However, by having multiple columns for the different design consultant types in the tblProjects table...

There are many instances of this with authors' names, e.g. F Scott Fitzgerald, H Rider Haggard (though I did come across one edition of 'She' where the authorship is given as Henry Haggard). In bibliographical contexts I generally use a single Author column with the full name by which they are...

My American partner and I once built a database of enslaved persons for a museum in the USA (she, an archivist by trade, did the research, I built the app). In the source material an enslaved person was often referenced by their first name only, and there were varying forms of this in many...

I would favour modelling Editions by a separate table referencing a Drawings table. That way attributes which are common to all editions are recorded only once, in a row in the Drawings table, whereas attributes which are not common to all editions are recorded in rows in the Editions table...

Having separate FirstName and LastName columns in a base table will generally be preferable as it allows a person's name to be returned in whatever format you want in a particular context. (FirstName + " ") & LastName would be used in most contexts, but in the RowSource of a combo box for...

Take a look at the attached demo file. A key feature of this is that the passwords, answers to users' security questions, and users' Windows user names are hashed. Such data should never be stored as the original text values. The demo allows each user to be granted different permissions to...

The following is an example of a query which returns a count of distinct values, in this case employers of contacts per city. It does this by means of a subquery in the outer query's FROM clause. The subquery includes the DISTINCT predicate to return only one instance of each each set of...

You should not repeat the names in the Voucher Log table, as this introduces redundancy and the risk of update anomalies. All you need in the Voucher Log table is the VeteranID foreign key column. In the subform you can then bind a combo box to that column, setting it up as follows...

The attached file illustrates the use of the functions in the following module. To return the accounting year for any date call the AcctYear function, passing the month and day of the month when the accounting year starts into the function as integer numbers, and the date for which the...

In the attached demo file I've added a Reset Password button to the login form. Clicking this opens a dialogue form at the currently selected user's record. In this form, supplying the correct answer to the user's security question, which along with the answer can be set by the DBA in the Edit...

Calling the Refresh method causes a form to show any changes to the data in a bound form's recordset to be reflected in the values shown in a form. To save a bound form's current record before opening a report by means of a button on the form the code in the button's Click event procedure...

You say you have code in the AfterUpdate event procedures of the controls in the form. I assume that this code writes the data in the controls to one or more tables. I'd suggest that you place breakpoints at the head of these procedures to enable you to step into the code when the procedures...