Search results

one of the things I have done in the past is use a python script. The script is encrypted and hidden away in the access front end. It is then decrypted and executed as an when required.. All executed in memory, so no files on disk, even for a second or two. You can use ADO and DAO to communicate...

Why are you joining on the warehouse table? You only use w.whid as a criteria? You could just use p.whid You might find group by provides better performance than distinct or distinctrow. Although I would question the need for any of these Assigning a recordset over a recordsource is unlikely...

Which brings into question- why use a tempvar? Curious to know what the purpose of exercise is

Struggling to understand the point of your question - what has protecting intellectual property to do with calculating an order total? It’s hardly a difficult calculation And if you are talking protecting stored procedures, protecting from who?

Happy New Year - 2am in UK, temp -2C , finished with Jools Holland and a great mix of musical talent

Rumour has it that Elon Musk and Bill Gates are creating a new drug for penis enlargement it's called ELONGATES. And it cures a condition called Microsoft

Perhaps you have development backups you can compare with?

The format hh:mm can only show a maximum of 23;59. One more minute and you are into another day 1-00:00 Time is store as the fractional part of a Decimal - midday=0.5 So you will need a function to convert the day part (the value before the decimal point) See your other thread below

Yes - works for pdf’s

We’ll have to see - the link reminded me of the ‘127’ hack. But still has a limited range of file types that can be displayed. In preparation I’m in the process of updating my apps to convert all files to pdf before viewing in the edge browser- justification to my clients being these are more...

let’s wait and see - if the OP required the blank rows on a printout for users to write additional data for later input I can understand it - the blank rows might contain a line as a delimiter. But that does not appear to be the case here.

Try using the original web browser control. My experience of using the edge browser control for displaying local files has not been good - very slow and often doesn’t refresh. I’ve given up using it for local files - works fine for websites

What if enough do that there is insufficient room for 20/26 records? No mention has been made of using cangrow/shrink

Still don’t need the counter, just the group footer's ForceNewPage property as suggested a number of posts back - if that creates more than the 20 or 26 rows required, just increase the height of the page footer

Why not use the force new page property? https://learn.microsoft.com/en-us/office/vba/api/Access.Section.ForceNewPage

Merry Christmas- any one for humbugs?😀😀

You also have the functions choose and switch

why convert to vbscript when it is to be deprecated? if you are using a .accdb as a loader app you could use something like Select case SysCmd(acSysCmdAccessDir) like "C:\Program Files\*" case true 'access is 64bit 'install 64bit accde case false 'access is 32bit...

yes it's 0 x 0cm so cannot be seen - but needs the visible property as true to be able to receive the focus. It's a method I use when I need to do something to a control that has the focus - simply move the focus elsewhere. GF is just a name which means 'Got Focus' or 'Gets Focus'.

My example does, but can run in any app that uses vba such as excel or word - the other thing you need to consider is whether the app is in a trusted location (for the app that is running it) otherwise the code won’t run