Recent content by daveinhull

Many thanks isladogs, i'm goinh to be on the road aorund that time which is a pity, but I'll see if I can get in touch. If, in the meantime, anyone else has any thoughts that would be great.

Hi, hope someone can help. I'm trying to use Chart.js through an access Webbrowser and having some problems getting it to work with V3 of Chart.js. I've got it working using V2 of Chart.js, but when I change to V3 nothing is displayed and I get a script error. The java script works perfectly in...

Thought of that but as I'm creating the single statement it is updated changed deleted added as I'm trying to put together the final statement all of which I'm in the text control, hence why I'd going to do it on a character by character basis. It does work rraly well. I'd have to leave the...

Hi, I haven't experienced any delays I was just worried that I might, in fact it works really well. Glad to hear that you haven't experienced delays. I use my app to collect audit results from an audit team and then we consolidate individual findings into a single statement. I often do this...

@isladogs, Yes I did think of that, but the subform is a small part of the overal main form and doesn't really have enough space for a seperate label or text box within it. The popup form is the same size as the subform text control as I'm trying to implement real-time translation into another...

@Galaxiom, My goodness what a faf, but it worked, many thanks Code for anyone else with this issue which worked DoCmd.OpenForm "ChineseText", acNormal Forms!Main.SetFocus Forms!Main.Form!Org_Practice_Findings.SetFocus Forms!Main.Form!Org_Practice_Findings.Form!TxWord.SetFocus I was...

@Galaxiom I agree, but the txWord control which opens the popform does not have its 'On Lost Focus' event fire, nor the 'On Exit' event, so surely it still has focus in some way? Although I have not looked at whether its subform or its main form has the events fired or not. I have tried...

@theDBguy Sorry it wasn't on 'On Got Focus' I was using 'On Enter'. The code is quite simple: DoCmd/OpenForm "ChineseText", acNormal Forms!ChineseText.Form!Chinese = TxWord.Text After this, I was also trying various methods to set focus back to the test box, e.g. me.SetFocus ...or...

Hi all Hoping someone can help. I have a sub form that opens a popup form to display some further information as the user continues to type in the control on the sub form. But the cursor disappears from the sub form cobtrol to the popup control and I have to click the sub form control to get...

Hi, Ok, so I moved the code to a more complicated form and it failed. I now realise that if I have anything in the main form OnOpen or OnLoad or on...anything for that matter it will not work. So, full circle back to closing and opening the form :banghead: Thanks for everyone's...

Hi MHB, Ok, so I put in a loop containing a DoEvents between the .connect= and the .refreshlinks and also a similar loop after the linking and before a .requery but still nothing. Just to be sure I went back and actually put in a breakpoint and slowed everything down. Still nothing...

Hi gemma-the-husky, CJ_London, MHB, Thanks for your comments. CJ_London, I actually found that you just need to put: form.recordsource = form.recordsource subform.sourceobject = subform.sourceobject just after doing the relinking and it works - see code above. You don't even need to put it...

Hi gemma-the-husky (Dave), I did what you suggested and got what I expected. The first message box contained the initial database table name and the second message box contained the new database table name, i.e. the one I change the link to. As I said I have singled stepped through...

Hi Again, Now I'm confused. I changed the code from previous to this where all I do is recordsource = recordsource and SourceObject = SourceObject and it still works. For Each myForm In Application.Forms myForm.RecordSource = myForm.RecordSource myForm.Recalc...

Hi, Ok, so I put a delay (5 seconds) after relinking the tables before doing a requery and nothing happened, no form update. I moved the delay in between the relinking the table and the actual .refreshlinks and still nothing. Good idea but it doesn't seem to address the problem...