Search results

Need to clarify why there is a whid in the product table - the implication is any given product is unique to a specific warehouse - and you only need to filter on the whid in the product table. Otherwise you would have a many to many join table

Since IP security is your main concern, suggest forget access since you are concerned that someone, someday will have an illegal app to convert pseudo code back to readable code. Don’t forget access is a rapid development tool - you can get something up and running in a fraction of the time...

12500 is a tiny number of records and if indexing is involved might even increase the overall size

You think they will go to that extent?

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?😀😀