Search results

Many years ago a client decided to implement a well known online crm system. I was involved with integrating it with finance, commissions and hr systems. I discovered that if you knew the login details (of a sales person for example), you could not only access the data from excel, that access...

Yes - and knowing that, there are steps you can take to prevent it - not saying how as a potential hacker may be watching 😀 and it can start be hacked but further up the difficulty scale How secure you want to make it depends on your security requirements. No system is totally secure - even web...

It is likely your new boss will want a 'rolling' view of currently active products If you add an inactive flag, I would make it a date rather than a yes/no field. That way you mark as 'inactive over two years go' with a date two years ago, 'inactive in the last two years' with a current date...

I will be interested to know how you will manage your provision of information accessed by a hyperlink and how you expect them to update the data around product recalls etc.

I agree I tend to just use sql rather than importing to effectively a temporary table. But totally agree that if multiple tables are to be appended to, you need to start with the primary table(s) first to identify new primary keys.

ID is not a good suffix for primary and foreign keys - but fine for other ID’s that are just a field in a table such as a membership ID. Better to use PK and FK suffixes - avoids this problem and you know which ‘end’ of the relationship each field is Still a possible issue if you have a query...

Change the ! to a dot

I was in my phone and just copy/pasted parts of your code - which might have missed something Assuming you are only using one table, or if multiple tables in your query and field names are not repeated in those tables, you don’t need to specify the table name! (Which should be a .) and since...

Try this Wanted: iif([tblDiscsOtherLabels!fldIgnore]=True,"No", IIf(([tblDiscsOtherlabels!fldDiscNo]=0 And [tblDiscsOtherLabels!fldRecordingID] is null,"Yes","No"))

I use some controls that (appear to) rotate to show a different value and one that shakes if a duplicate value is entered (rather than a msgbox) I also have forms that grow/shrink rather than than just appearing/disappearing Just to provide a visual clue that something is happening and draw...

Not sure if you have now got ideas but here is one. If your family member has a pk that is linked to fks in various tables you can use a simple delete query for each table to delete records with that fk. You could have an admin table to list the tables that would be affected The same table...

but it would enable him to steal from the taxman in much the same manner as mentioned by GPGeorge. And what happens if you delete 3 orders, and can only replace 2 before the tax man cometh?

Just one further twist which may or may not be relevant. If an order comes in for 20 of product X and 10 of product Y. Product X is in stock and is despatched and invoiced immediately, product Y is despatched and invoiced later when back in stock. In this case you have two invoices for one...

What is the rationale for requiring the invoice numbers are contiguous so you have to fill in the blanks? And why delete an order once it has been invoiced? It is presumably then in your financial system and would be ‘cancelled’ with a credit note. Or you would have a deleted flag of some sort...

That code probably needs adjusting to not create a new number if the field is already populated - on a reprint for example perhaps because the original can’t be found or a printer failure

There are issues, hopefully they will be resolved soon. Main bugbear for me is sql using an aliased query created in Monaco is not always recognised as valid in the QBE

But I’ve just undeleted it

Short answer is I don’t know 🤔

See this link- you can check all your api calls https://gist.github.com/KallunWillock/11d2e4d1e4476970f8f82a495eeb4dc6

Hwnd should be longptr as I think should findwindow. Not sure about iswindow you haven’t shown the type Also need to change any dims where you are assigning hwnd