Recent content by CJ_London

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

The relevance was to do with your statement you would use code in the popup forms open event to put it where you like - I use the mouse position to give it a 'target' with the intention that it minimises the amount the user needs to move the mouse to respond. You could just as easily place it...

I use a routine to reposition popups close to the mouse cursor - default position is the form appears where bottom left is at the cursor position - it then adjusts if required by left and top to ensure the whole form appears on the same monitor as the mouse cursor so it will be aligned left or...

In the short term 2-3 years, you could install classic outlook instead of new outlook. By then, hopefully ms will provide an alternative or other methods provided by others

Perhaps you have added and removed so many controls over time, you have reached the finite limit - used to be around 700 Suggest create a new form and copy all controls from the old form

Very none pc , these days it’s not women who get pregnant - it’s people🥴🥴

use vba to change the name of the pdf either when it is created or after (use the name function) I use outlook automation to creat the email and the pdf Away from my computer at the moment and that does all that so share your vba code for creating the pdf and I can provide a more focused response

Not really clear of the relationship between the two tables - is one supposed to be a total of the other - and how does 0.00 act as a warning? What if there are no values in the table? You might want to investigate using the format property for the control? For numbers there are 4 states -...

As I said, it is a basic editor and needs further development and that is one of the things that needs addressing - I simply asked chatgpt, it produced the code and it worked as is. I did so as a response in a thread asking about the 'dangers' of richtext. If someone want to copy the html code...

you can also run the html file in a browser if you so wish - can't do that with richtext