Search results

As has been noted in the AccessForums.net forum and here you have an Access table masquerading as a spreadsheet. If that's what you want why not use Excel? In a relational database the correct way to model such data would be to enter each transaction in a separate row in a table. With a...

Is the PIN ID column shown in your screenshot a concatenation of two separate columns, or is it an actual column in the Pins table? What I would expect with a simple one to many relationship like this would be the following tables: Connectors ....ConnectorID (PK) ....ConnectorName ....etc...

It's much the same as when you run the query in the user interface, and it warns you that a certain number of rows won't be inserted for a stated reason, in this case a key violation. In the example I posted for the OP I tried to keep things simple, but I have to confess that it's not great...

Tom, I deliberately omitted the dbFailOnError constant in my earlier reply to the OP. This allows additional trainees to be added to a training session by executing the procedure again for that session. The errors which are raised on those rows which attempt to insert a trainee who has already...

Did you try the amendments posted by MajP? I think you just need to change the assignment of the concatenated string expression to the strSQL variable in Post #13 as follows: strSQL = "INSERT INTO TrClassesT(JR_ID,TrnDate,TrnType) " & _ "SELECT AFD_ID, #" &...

The second # sign delimiter around the date is missing. It should be: JR_ID, #" & format(me.TrnDate,"mm/dd/yyyy") & "#,'" & me.TrnType & "'" PS: For consistency with the rest of the string expression you might want to use a pair of contiguous double quote characters, "", to represent the...

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