Click here to Skip to main content
15,845,829 members

Comments by InfinityJoe (Top 9 by date)

InfinityJoe 11-Mar-18 3:20am View    
Hello Sir thanks for pointing out, if you dont mind, maybe you can drop a magic for this one within an code/Query sample ? i really needs to wrap up my project asap, but i'm still can't figure it out :)

thanks in advance,
J
InfinityJoe 10-Mar-18 16:20pm View    
oh a bit imagination that what i looking for (this sample of how it looks in Access):

[-] P_ID | P_Name | P_Info (Collapsible)
6 | PName6 | PInfo6
----------------------------
C_ID | C_Name | C_Code
5 | Child1 | Code1
7 | Child2 | Code2
8 |????? <- Add new row into this P_ID/C_ID to fill C_Name & C_Code
----------------------------
[+] 7 | PName7 | PInfo7
----------------------------

InfinityJoe 10-Mar-18 16:06pm View    
Thanks for your valuable Response Mate, that's really brighteen my way :), yes i thought that about concatenate 2 queries into one on this case (and thanks for confirm that it's impossible with direct join of query), but i really needs to make this works as for some reason i needs this engine for my projects most >_<, so would be perfect if you give some quick example for the Query that should i use for make that happen ? (i have checked the link you gave to me but still can't figure it out), i mean just insert new Row to DBChild with new record of C_Name & C_Code in exact location of P_ID after comparing that via VB/oledb form, or another mean to reach "MsgBox("Record Saved!.", MsgBoxStyle.Information) " Line ,and yes will use proper parameters to avoid SQL Injection later on :) , God Bless you man...
InfinityJoe 13-Dec-17 11:27am View    
Hi Mate, thanks for your advice, really appreciate it!, and yes forgot to put "#" on the title last time, but actually i've already added C# for this thread tagline at beginning, btw just fix the title today :)

Cheers,
Joe
InfinityJoe 13-Dec-17 11:25am View    
Deleted
Hi Mate, thanks for your advice, really appreciate it!, and yes forgot to put "#" on the title last time, but actually i've already added C# for this thread tagline at beginning, btw just fix the title today :)

Cheers,
Joe