Search results

For strategy and finesse, I don't think you can go paste curling 🥌

Not before I'd gone all Tonya Harding on you ;)

If there is a way of overcomplicating something, I'll unusually find it

@Pat Hartman I believe that the schema is fine. However, your comment has caused me to go back and look at what is going on, and I do believe that there may be other ways of achieving what I'm doing without running the query, which I will explore shortly. Thanks for the prod :)

Check out this link for the correct syntax for referencing forms, Subforms their controls and properties from various relative location.

So I'm guessing the issue was because [Text12] was being used as part of a WHERE clause. As in all other instances, it was simply providing a value to be inserted into a table.

@arnelgp Bingo 🥳 thank you once again

The following SQL is throwing a 3464 Run time error Data type mismatch in criteria expression 'SQL statment to delete exsiting record(s) relating to current wine StrSQL = "DELETE TBL_WineGrape.WineID, TBL_WineGrape.WineGrapeID " & _ "FROM TBL_WineGrape " & _...

The click function opens an information form, whilst the double click runs an update query. I believe that both @Uncle Gizmo and @Mike Krailo solutions will fit the bill. I've not yet compared the two options as I only downloaded UG's DB just before I went to bed last night.

@Minty I didn't realise Access had that behaviour. Normally I'd just use the double click event, as you suggest, but in this situation I wanted a second option, and figured like most other applications Access could discriminate between a click and a double click

Very nice 👍 I think that will fill the bill nicely :)

I have, or rather had, both a click and double click events on a sub form in datasheet view. On their own, each performed their task as expected. However, when both were enabled at the same time, the Click event was firing in preference to the double click event firing. My understanding is click...

Thanks for that 👍 Now to figure out why there is a mismatch between what I actually coded and what I thought I was coding 🤔

@arnelgp base on the code you produced for me earlier I am now trying to expand that concept. I have a de-normalised table containing grape synonyms eg. Pinot Grigio / Pinot Gris / Grauburg What I'm trying to do is split them into 2 new records (in this case, in others it could be one or...

@arnelgp to aid my self in understanding how your nifty piece of code works, I've added comments to it. I'd be every so grateful if you could take a look and correct anything that I've misunderstood. Private Sub Command4_Click() 'define append query SQL Const APND_QUERY = _...

Oh dear now the Procrastination monkey has come to visit :eek:

Post Script: If I've learned one thing from all this it is the importance of properly normalising your DB from the very start. Even after spending over two day (on and off) struggling with this issue, there is still data that no (sensible) amount of coding would be able to normalise. Lucky that...

Bingo that's done the trick 🥳 Thank you so much for that, I've learned a whole lot from you about using DAO 🥰

That works a treat, considerably faster than my code 👍 However, there seems to be a flaw in the logic of this section of code GrapeOrgStr = !Grape & "" varValue = Split(GrapeOrgStr, ",") If UBound(varValue) = 0 Then varValue = Split(GrapeOrgStr, "&")...

Sorry, that's my bad :sick: Somehow I missed that with my cut and paste :eek: