Search results

Yes that does the trick (y) It also opens up the Double click event, as I'm already using that on the record selector to do something else :)

Are you able to post an anonymised version of your DB with some sample data?

You might find this Course a valuable investment (especially if you can get it whilst it's on sale), as if memory serves me correctly, I think it does address similar scenarios to what you are trying to do. I worked through it earlier this year and found it really useful in taking my coding to...

You can not (re)open a form that is already open If product has been delivered to a client, that record (movement) is still valid, as the delivery did take place Given the above, the rejection should therefore be taken as a new (record) movement. It is going to a new destination, isn't it? It...

If the form is already open, then you will see nothing happen. It sounds like what you really want to do is create a new record partially populated with the items rejected from the current record?

Sorry my bad 🥵 I know I wrote continuous form, I should have said Datasheet. You are correct, in continuous view the form does not behave as I described I've attached a DB

I believe that the normal behaviour of a continuous form, is that when the Record Selector is clicked the focus moves as the mouse button is depressed. All good (y) What I am trying to achieve is to open a (filtered) pop-up form that is based on the record that has been clicked. I am using the...

Thanks that did the trick (y)

I must be missing something very basis as the following is throwing a Runtime Error 13 Type Mismatch Dim rst As Recordset Set rst = Me.RecordsetClone On the Set command The code is in the On Click event of a button

I've found this VBA course at Udemy.com really useful (y)

Just a quick update, I've been working through the course and am just over the halfway mark. So far I've found it really helpful in consolidating and expanding my knowledge (y)

If you have imported data that has originated in a non-English-speaking country, you will find that words containing accented characters might not get picked up in searches or that filters fail. This function can be used to search a string and replace such characters with standard Latin...

Thanks, I'll keep that in my pocket for the next time :)

Thanks. I'd just found something similar. I'm still curious though, why the mismatch?

I know that's correct, as I just did a test. But according to all the tables I've found say ASCII code 131 = â ( letter a with circumflex accent or a-circumflex ) ASCII code 159 = ƒ ( Function sign ; f with hook sign ; florin sign ) Which confuses me to no end 😵

Thanks, I was afraid the answer would be something like that

I'm working on a routine to strip out accented characters from a string and replace them with standard Latin characters. The code does pretty much what I'm looking for, except that it doesn't seem to discriminate between upper and lower case characters. The code looks in part like; Select...

Thanks for your comments peeps (y)

Thanks, @Uncle Gizmo. I personally quite like face to face learning, even if you do go over stuff you might already be familiar. I very much agree with you on the having a project approach. I'm thinking that given the low cost of the Udemy course, I might just give it a whirl, as A) it's very...

Not sure if this is the appropriate place to ask this question. If not (mods) please move it :) I'm just wondering if anyone has any feed back on Udemy in general and in the above course specifically? At AUD 19.99 (down from AUD 124.99 for the next 5 hours) I don't see a downside given that...