Search results

To illustrate how to do it I've attached a simple little database, whose model is: The way it works is that you first select a session from the drop down list of the combo box at the top of the form, or you can type in the date for a new session not yet in the list. This causes the form's...

The SQL statement which you are assigning to the subform's RecordSource property does not include the TrnCnt column to which the check box is bound, hence the error. I'm puzzled by your methodology, however. In a situation like this I would normally expect the subform to be bound to a table or...

Well, it has to be called something. Like many object names given by Access it is meaningless and should be replaced with an informed choice of name. Leaving all tables with a key named ID obscures the semantics when you write complex SQL statements involving multiple tables. In my career as...

You cannot legitimately reference the keys of multiple tables with a single foreign key column, other than when modelling a type hierarchy, where referencing the key of a (super) type in effect references the key of its subtype via the one to one relationship types. In your case there are...

1 and 2 would be prevented by applying the CHECK CONSTRAINT I described to the table.

As Ron Paii said in post #13, the fundamental problem is the lack of enforcement of data integrity. Preventing the insertion of a new row in the Contracts table where a Customer is deceased cannot be enforced in the physical model per se, as any attempt to do so would require the deletion of...

You also need to click the command button to execute the code in its Click event procedure which undertakes the search. It works exactly as intended for me. One change I'd suggest would be to change the cboQueries control's RowSource property to: "FILENO";"File Number";"FIRSTNAME";"First...

You don't say why you would want to list the reports, but if you want to present users with a list of reports from which they can select one or more to open, then rather than listing the report names, which might be rather cryptic to a user, you can list their plain English Description...

Funnily, in my time in Oxford in the late 60s/early 70s I never stumbled across any bodies on the river bank, or found a corpse in a college room.

That's to be expected. If you want to trigger the AfterUpdate event procedure in a situation where the control's value is already the one you want, then you would either have to drop down the list and select the value again, or type the value again into the control without dropping down the...

Fair cop, guv. I'll come quietly!

In the UK the relevant thresholds are: £10,000+: Deposits in this range, especially cash, have a high likelihood of being flagged for scrutiny. £25,000+: Deposits of this size are almost certain to be flagged for review, and you will likely have to prove the source of the funds. £50,000+...

In post #27 I said: The one reservation I have is restricting the rows returned in the combo box's list to those marked as merit list or successful within the last year. In time this would exclude candidates in earlier applications from the list and their rows in the subform would appear...

I made clear that that is the the case in the context of the OP's question, because the column returned by the subquery is part of a candidate key, and therefore cannot be Null. Because the OP was unaware of the NOT IN predicate until now, I was alerting them to the possibility of it failing in...

As it stands, with my amendments, your form only allows prices to be increased. The form below is from one of my demo files and allows proces to be either increased or decreased by means of an option group. The options values are 1 for increasing prices, and -1 for decreasing them. The code...

I think the following is what you need: 1. Format the txtPrices control as Percent. 2. Change the CheckStatus control's Click event procedure to: Private Sub CheckStatus_Click() Dim strSQL As String 'make sure any unsaved changes are saved to avoid conflicts: DoCmd.RunCommand...

I agree that a JOIN should be the first choice. I was really comparing the (NOT) EXISTS and (NOT) IN predicates.

You could change the RowSource of the CandidateID combo box in the subform to: SELECT VacancyCandidate_Tbl.CandidateID, [CandidateLastName] & ", " & [CandidateFirstName] AS Candidate FROM Candidate_Tbl INNER JOIN ( Decision_Tbl INNER JOIN VacancyCandidate_Tbl ON...

The NOT EXISTS predicate is very efficient provided that SELECT * is used in the subquery as this allows optimal use of the indexes. Mathematically the underlying difference between the EXISTS and IN predicates is that the former is an operation of the relational calculus, whereas the latter is...

It occurs to me that you might be tempted to enforce this by applying a CHECK CONSTRAINT to the table. However, that would preclude the possibility of a candidate being appointed to one position, and, at some future date being promoted to another position. When recording a candidate as...