Recent content by Notiophilus

  1. Notiophilus

    Solved Parametrised query: "type conversion failure" when inserting dates, e.g. Now()

    Thanks! I didn't say, but I'm actually using this in a LogError function, so time of day is quite helpful.
  2. Notiophilus

    Solved Parametrised query: "type conversion failure" when inserting dates, e.g. Now()

    YEP, I'd forgotten the .Execute. Like an eejit. Many thanks!
  3. Notiophilus

    Solved Parametrised query: "type conversion failure" when inserting dates, e.g. Now()

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

    Trying to simplify update/insert in two linked tables

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

    Trying to simplify update/insert in two linked tables

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

    Trying to simplify update/insert in two linked tables

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

    Trying to simplify update/insert in two linked tables

    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]...
  8. Notiophilus

    Subform cannot be referenced when placed in a hidden footer - why?

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

    Subform cannot be referenced when placed in a hidden footer - why?

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

    Subform cannot be referenced when placed in a hidden footer - why?

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

    Subform cannot be referenced when placed in a hidden footer - why?

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

    Bypass Form_BeforeUpdate validation when switching to a subform

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

    What do the events Form_CommandExecute, CommandChecked, CommandBeforeExecute etc actually DO?

    Hm, that makes sense - some of the links I found were for Access 2003, so ¯\_(ツ)_/¯ Thank you both for indulging my curiosity!
Top Bottom