Moving to the NEXT ROW in a Grid 2

[jmueller]

Hi Everyone,

I'm trying to program an inventory receiving program. Using a Handheld Scanner, inventory is scanned. First the item number and then the quantity... after the quantity is scanned, I need the cursor to automatically move down to the 1st column of the next row. (I'd also like this to happen after the Enter key is pressed on the keyboard).

I've been reading other similar threads on this subject and have tried everything people have recommended but nothing is working!

Does anyone have a sure-fire way of making this happen? I can't believe it's this difficult. There must be an easy solution. Anybody? Please help.

Thanks.

Jack

 

[EzLogic]

I use a Listbox instead. I validate the Qty, The existance and everything that goes with the entry and then I display in the listbox( Or add ). After the user is done, I take the content of the listbox and dump in the table.

This way, the user can edit/delete/add items and the databases is not touched yet.

I tried the Grid., but it is hard to implement (I think) any verification before saving.

For instance, if you are scanning Serial number and you do not wish to scan duplicates, you can manage to do so this way and only add if the function returns .t.... or something like that.

Let me know if you want me to elaborate more on how I did mine.
And it works perfect!

Another reason I did this is because most of the items that my system uses are Serialized items.
For instance, you might have a phone (MOtorola) and you wish to scan all the ESN (Electronic Serial Number) for that Particulare phone,
so you would select the Item (from a search screen), Enter the Qty, and Then the system will ask you to scan the amount you wish to add (which will go into the listbox)..



Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[jmueller]

Thanks Ali, I will take your advice and replace the gridbox with a listbox. I just might ask you to elaborate later if I have any problems. For now though, i'll just continue trudging forward best I can!

Jack.

 

[EzLogic]

You're welcome buddy!!!!!

I am glad i can help!

Just let me know if you wish for me to elaborate!

Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[jmueller]

Okay Ali, please elaborate! I've spent so much time trying to get the grid to work and now i'm pretty much starting over with the listbox and i'm simply out of steam! I would really appreciate any elaborating and/OR perhaps you have some sample code or project with a listbox in it?

Hope you get this.

Thanks again,
Jack

 

[FoxEgg]

I think that this link might provide you some answers

How to move the cursor at Grid to next row when pressing Enter?

thread184-473158

John Fox

 

[jmueller]

Thanks John, that worked EXCEPT it seems to only work when you have existing lineitems already existing. What i'm attempting to do is create an entry screen (or grid), meaning, I initially append one record, the user then enters the first inventory item where upon completion of that lineitem, another blank record gets appended and the cursor is moved down to the next line in the first column. Is this possible?

Thanks,
Jack

 

[jmueller]

Mike, I think I managed to figure a solution out. Don't believe I can spell it out though due to mental retardation brought on by 2 days of figuring this thing out. Seriously though, I appreciate your effort here. I've been trying to get around the necessity of pressing the down arrow key because the data is being entered with a scanner, not a keyboard so I need to have the cursor automatically jump down to the next row after the previous one is completed (for quick data entry). I managed to figure something out with the help of Thread 184-473158 which was offered up by John Fox (aka FoxEgg).

Thanks to all!

Jack

 

[jmueller]

Oops, I added the above message to the wrong thread... sort of. I have 2 "related" questions out there. Mike responded to the other one! I must now go and get my medication! Thanks John!

 

[FoxEgg]

Don't believe I can spell it out though due to mental retardation brought on by 2 days of figuring this thing out.

Many thanks for the kind words.... and just to correct your medical terminology here....

"mental retardation" does NOT come on with 2 days of working on VFP... technically that would be called a "VFP psychotic episode..." (VFPPE) But there is some good news .... (and don't worry)....... like the rest of us, you DO HAVE "Mental retardation" because you ELECTED to work with VFP...

The difference is that the latter can be helped with Tek-Tips Psycho-Therapy.. the former incurable and recurrent.

JF

 

[Mike Gagnon]

FoxEgg

The difference is that the latter can be helped with Tek-Tips Psycho-Therapy.. the former incurable and recurrent.

And you being in the medical field and a VFP programmer on the side, would make you the perfect person to diagnose this. (The sign for "down-unda&quot


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[monikai]

you are Tek-Tips VFP Medical Guru (TTVFPMG) !

Monika from Warszawa (Poland)
(monikai@yahoo.com)

 

[jmueller]

Thanks for all the therapy... It's a great feeling to know that i'm not retarded after all... just psychotic. At least I know where I can come for a little peace. Thanks.

 

[FoxEgg]

Thanks for the stars... I am very grateful ... prior to this post I had 1 (ONE) star... now its a bloody meteor shower.

Thanks to all...

FoxEgg