CashRegister and Advanced Filter files

[steverat]

Hello, Sorry to bother you,
I have a Cash Register simulation file. Cash Registers are the most plentiful job in the US. This file could be used to train people.
I also have and Advanced Filter, using your spreadsheet as a database. You do not have to have all the field names in the output in this file.
Say you have 40 field names, and only need 3 in the output. I found paste special to be much faster than query visible. I turned off autoinput (autocomplete) and everything worked better. Hopefully the files are useful.
Hopefully it does not have too many bugs. Sadly copy paste does not always work so b is still beta. For advanced filter use a for all in output area, and s for some fields in output area In cell c6 in sheet4. Part of the problem in b beta is i typed in a space before field names. Field names in the sheet must be left justified. I am a bad typist. a and s work fine. You can try b (beta) but it might not work for you.

Also CodFrmx is my attempt to modify to CoBoForm add in. You can not run this with coboDataForm Add in. If i get time i will change the sub names so you can run both. CoBo did all the hard code so I did some of the easy code.
Thank You
steverat

[Obi]

Hello steverat,

nice to hear from you. You are certainly refering to this viewtopic.php?p=513041#p513041 "Advanced Filter" thread also, and I have to say to you shame and fame.
It seems you have great programming knowledge and facilities, but I tried out a little with your Advanced Filter /AFVersions at that time and I have to say to you:
four of the five you can put and throw them into the trashcan.
But this fifth version, i tried out and it never made me any data mismatch! Brillant programming, in my view. Everything with the clipboard, clearContents, with <> is o.k.. I can even filter the colo(u)rs of the data sets. Absolutely reliable, I found out. It was surprising to me, because in the other versions there are bugs. A vagabunding message box opened, for example, sometime. But also have to state that I didn't use paste specials and edit backwards in that fifth one. So to other users: perhaps better stay away from these 'tools/features', and the filter, as you said also, should always be 'a', which is the default.
Again, the last version 'AFDataBas11' is absolutely reliable to me. I would say the output is faster than Google most of the times!! (I guess the only thing I missed was a wildcard.)
Please excuse my English; Greetz Chris (& don't take my post too seriously )

[steverat]

Here is my version of Advanced filter with Regular Expressions. AFDBase17re.it works with .* at beginning and end. Also included is my Base file gpia to demonstrate how My codfrmx file above can send data to and from a Base file. The programing word is toDb and fromDB .
thank you,
from steverat