Trying to insert a date with a parametrised query, but it always fails: "Microsoft Access set 1 field(s) to Null due a type conversion failure..." I've tried inserting Now() - which is what I want - CDate(01/02/2003), 01/02/2003... nothing. I'm sure the answer is really obvious, but googling has...
Sorry, just saw your edit. This does make a lot of sense, and might make updating simpler. How would you ensure that each author has exactly one main pseud - no more, no less? That was my main reason for the structure I posted above.
Thanks for taking the time to answer. I'm trying to revamp...
This is what the relationship looks like. Referential integrity is enforced with cascade update and delete. tblAuthor.MainPseudID is not required; tblPseud.AuthorID (FK) is not required. This may be bad design, I'm not sure; I remember struggling when I first built that part of the database a...
I use bound forms normally but this specific form needs to be unbound. I've used Upserts all of once, but I think I'd run into the same problem, right - having to get the new autonumber PseudID and the new autonumber AuthorID simultaneously?
> scratch that, it's bound to tblAuthor. hmmmmmm why...
I have a list of authors, each of which may go by multiple pseudonyms. One of these is the "main" pseudonym and is displayed in forms, reports etc. (E.g. "JRR Tolkien" is the main pseud, synonymous to "John Ronald Reuel Tolkien" and "hobbitlover1")
tblAuthor: AuthorID [PK, autogenerated]...
Thank you, but as I said, I'm not trying to find a way around the problem - I've already got several ways around it, and there are reasons not to make the recordsource a query - but to understand why Access behaves this way.
Sorry for the delay, busy weekend. I made a small, shitty database to highlight the issue. If there is a comment linked to the current record (Form_Current checks the subform) then the comment icon goes dark.
frmStories_SubInBody: subform in body is hidden, no error
frmStories_SubInFooter...
In Form_Current(),
If IsNull(Me.fsubCommentsContainer.Form!txtComments) Then 'do stuff (where txtComments is a textbox)
or
Me.fsubCommentsContainer.Form!Comment (where Comment is a field in the subform)
To reiterate, this works absolutely fine when I place it (hidden) in the main body of the...
I use fields in the (hidden) footer of a single form to handle validation checks. Recently I needed to include a bound subform, and discovered that
if the subform is placed in the hidden footer, VBA cannot reference it: error 2455, "You entered an expression that has an invalid reference to the...
That's what I said in my previous comment. The subform is bound to tblStoryAuthor (the junction table). And yeah, I'm using NotInList - almost every story I add has a new author, so it would be a pain to have to add each one separately.
...although you definitely have a point here! Since this...