Search results

it must be a function rather than a sub. try: Debug.Print Me.EdgeBrowser0.ExecuteJavascript("document.getElementById('SupplierModel_TotalClaimForGlassesOrContactLenses').value")

I'm not sure I understand your requirement completely, but try it this way: SELECT GrantsT.GrantURN, GrantsT.OrganisationName, GrantsT.CountryID, GrantsT.Status, GrantsT.StatusDate, GrantsT.ProjectStart, GrantsT.ImpactDue, GrantsT.Received...

Remove the semi-colon after .ExecuteJavascript

Debug.Print Me.EdgeBrowser0.ExecuteJavascript; "document.getElementById('SupplierModel.TotalClaimForGlassesOrContactLenses').value" ^...

Please reference Post #26. I never said that you shouldn't use EXEC, just that you do not have to use it, which was the information given by Dalski. That said, for me, EXEC is an unnecessary SQLServer-ism. No compiler will pick up if it's mis-typed and can lead to an avoidable point of failure...

Hi George, You don't need to preface sp's with EXEC to get them to execute on SQLServer. As an example, I have a sp called sp_describe() which mimics 'DESCRIBE TABLE ...' in MySQL - you pass the name of a table as a param and it returns field names, datatypes etc. So in Access I create a...

You don't need to use EXEC or GO

What does this mean?

Happy New Year! I'm loathe to tell you how to do this because I feel that I will be loading the gun with which you will shoot yourself in the foot further down the road! You need to concatenate your Tempvar values into the SQL string: ' ... TempVars!Name = .Fields(INum2).Name...

Sorry, I'm not thinking very clearly!! 😬 Increasing the detail height will not work here because it is a continuous form, and you will only see one record (the others will be below)

Actually, it doesn't look like you have a subform control. I'm not sure why you have only one row displayed unless you have filtered the RecordSource, ????

Then add a similar expression for the subform control

Try this in the Form_Resize event: Private Sub Form_Resize() Const w As Long = 28440, h As Long = 11835 With Me ' Set the inside width to exactly 28440 twips If Not .InsideWidth = w Then .InsideWidth = w ' Set the inside height to exactly 11835 twips If Not .Detail.Height...

The real question is why you need to store this info in a table (counted) when the SELECT query you use to populate it will always give you the answer in the first place, and is less likely to be out of date.

The trick is to look at the answer in SO, not just the question

so was i

I see this advice trotted out regularly, and I would suggest it's unnecessary. If anything, it risks ascribing meaning to the PK of a table which it shouldn't have - the only job of the PK is to be a unique identifier for each row of a table. Note how often folks get their knockers in a twist...

None of the code in the answer in that thread is Excel specific

Hmmm... I seem to remember there was also an Isaac who behaved much the same on UA and was also banned. :unsure:

I'm not sure Ron's suggestion is the answer. If the customer is null you should fall through to the Else anyway. I'm on my phone and can't see your image very clearly. Are you sure the subform has AllowAdditions property set to False? Could they be adding a new record via the navigation buttons?