Recent content by CJ_London

not tested, but if you want to set the filter in the open event, try setting the filteronload property to true (shouldn't need filteron=true). At the time of the open event, there is no data to filter, that only becomes available in the load event

How do you verify that? By hovering over the rs!age in the vba? and why when you said this?

The key word here is ‘format’. SQL users the underlying value ( what it is) not the formatted value (what you see), which is why you should never format fields at the table level. Dates are actually stored as a form of double number, the part before the decimal point is the number of days since...

Is 4/12 the 4th December or the 12th April

I don't use anydesk but It works for me - no delay - see attached

I modified your code slightly and set tab stop to no - this now works for me. Must admit, the browser control seems unwilling to swap between a web address and a local file. I suspect there is probably something in the control settings that might fix that

Thanks for the input, sounds like it shouldn't be a major issue for the client

this is in the context of Excel, not Access. And I'm dealing with a client who is very cautious about change :) precisely - the client has a perpetual licence - it cannot use functionality (LET for example) introduced in a later version A bit more context - the new feature works fine on my...

Any advice appreciated. My client asked me to add in some additional reporting facilities to an excel file and not to use macro's. Basically, the requirement was to click on a value to display the records that relate to that value (easy in Access, not so easy in excel). I used the excel LET...

Probably 2010 32bit, I would give 2007 a miss. On another thread you mention you are using XP, I don’t know but this might have an impact on your decision

No. It is just a maximum for the short text datatype. It will take up 2 bytes per character plus (I seem to recall) 2 bytes to define the length When a record is updated, it is rewritten to disk, leaving a ‘gap’ where it was originally which is why the db grows. Compacting rewrites the records...

Sorry, now not at all clear what you are trying to achieve. Perhaps show some example data (doesn't have to be real, just relevant) and use it to illustrate what you want to achieve.

Left join your source table to your destination table on a unique value or group of values to identify uniqueness. Then set a criteria on a destination table field to is null. This will exclude records already imported Convert to an insert query if not already done No need for a popup form

I’m certainly interested 😀 Teams and PowerShell open in startup when I reboot - even when I remove them from startup, they return.

Wow - looks like you’ve moved it a long way forward - will take a look when I’m back at my pc