Search results

Hi all, I've been using WGet.exe and WPut.exe for many years but I always wished there was a similar function to delete files like “WDel.exe” Not having much experience in functions I decided to try my hand at it but would like to some input on my logic please. I hard-coded my domain name and...

Hi all, Thanks a lot for sticking with this one in spite of what seems like a lacking spec from my side. Let me try again by repeating the real life example and then also explaining the sample db (By now the sample needs some cleaning up but I'm trying various things at the moment) The Cashier...

Mmm back to the drawing board it seems. I really did not expect it to be such a challenge... Thanks for your input

I forgot to add that the system is linked to a touch screen and a barcode scanner but to allow for testing without, you will have to use the mouse to click on the keypad and then manually enter '17' and hit enter in the combo box. Single items can be added without having to put a '1' on the keypad

Hi all, I've made some progress with regards to the combo query. Please find sample attached (this is a ripped out version of the actual app which has many more buttons and stuff :) ). Try this: 1. Combo4 is made up of Item 17 and Item 86 2. So if you enter 17 and then 86, both will be...

@jdraw - thanks for the input I also got this query option from a sql guru buddy: The result gives me a breakdown of the items and how many of each which should help with counting the number of combos the items matches Hope to get time to work on this tomorrow

@sneuberg - you are right - the Client wants to rule out mistakes by the Cashier. Yes that is correct yes The method do have flaws like you pointed out but it is also not just relaying on queries. I still have to complete the code that looks at the register table containing the current sale...

@plog - I tried your 1st but it gave me the opposite result, so I created a unmatched query based on that which gave me "Combo4" as the result. This should do the trick - thanks for the reply. @sneuberg - it is for a point of sale system to recognize combinations See post #3 of...

Hi all, In the data below I'd like to display only the ComboCode where both Cnt values are not null. In the example only the 2 "Combo4" rows must display and nothing else. "Is not null" as criteria for Cnt will not do the job ComboCode Cnt Combo1 Combo1 3 Combo1 Combo2...

Thanks Uncle G - I agree - will give it some thought and re-post. In the meantime I'll roll out the app to the Client as is, with the other way of loading Combos as explained. Will then work on this one.

@Uncle - yes you are right - taking it one thing at a time. The qty must still be fixed but let me add to the mix: If you load Item 102 X 3 and say 104 X 3 and 107 X 2 it should result in 2 combos with a remaining 102 and 104. So this is quite a complex task... Thinking of running through the...

This version works better but is cluttered with too many queries and also if you captured eg 102 twice and then 104 and 107, it does the replacement but drops the extra 102 item. The result should be one combo (C1 in the example) but still keep the extra 102 item. I'm probably over...

Hi Uncle - sorry let's go again with a real life example Forget about the sample db for a moment and think about a point of sale system. The Cashier enter a few items of which some (combined) qualify for a "Combo Special" reduce price. As the Items are entered I want to check for a possible...

Hi all, I have a tbl called RegTbl with the following fields: ItemCode Qty And then 2 tables used to setup some 'combos' Combo ComboItems I need to find a way to identify when all Items of any of the combos are matched so I can delete the individual items and replace them with the matching...

Yes I know it's an old post but I was searching for something on a POS system and found this post and decided to assist. I attached a working copy but remember to re-link the tables to the BE I only attached the FE which contained the error. Not having time to find the error, I simply suspended...

@Galzxiom - Thanks - that is exactly the problem I had to overcome. The 2 tabs on either side of the text are in the Excel spreadsheet that is how I import from a 3rd party Payroll software app. It boggled my mind when I tried to get rid of what I though was spaces as you have no real way of...

No sweat Buddy :)

@Mark - thanks :)

Answering my own question thanks to my buddy Google. Replace([Field],Chr(9),"") Cheers

Hi all, I've got a Excel SS with a field that appears to contain a number eg: 0059 with some trailing spaces. I'm trying to get rid of the trailing spaces but trim or replace just don't do it. When I copy the field to a notepad I get a " followed by a <Tab> and then 0059 followed by another...