databases, beginner

[spandex44]

hi!
I don't really know anything (barely anything) about working with mdb databses. All I know how to do is load databases, display tables in a grid, and sort them using SQL code. I wanted to know three things:
1)When I sort items (numbers) in a table, how can I get the bigger numbers to show at the top, rather than the small numbers?
2)How can I write to databses in run-time?
3)Will my program be able to run on a machine that doesn't have Acces installed?


------------------
Regards,
Alexander McAndrew
VB Zone
http://gsenterprise.server101.com

[jritchie]

Ok don't know about 1

but
2) Gee how do you want to do it. Bound, un-bound etc. l generally use the un-bond approach, try something like

rs.addnew
rs!Key = Key field Data
rs!Fld1 = Name
rs!Fld2 = Address
rs.update

Can email you an example of handling databases if you want (jritchie@genauto.com)

3) Yes, when you build your distribution disks the Jet database dlls are loaded, therefore you don't need Access

[venkatraman_r]

Hi Friend,

Answer for you first question is really, simple. When you create ur fields in the table, you can set the sort order to "Descending", and this help you. Hope this is what you need.

Good Luck and Regards, :) :)

Venkat.

[spandex44]

Thanks both of you. Jritchie, can you please send me whtever you offered to send me to:

gs_enterprises@hotmail.com

Thanks again.

------------------
Regards,
Alexander McAndrew
VB Zone
http://gsenterprise.server101.com

[spandex44]

Thanks both of you. Jritchie, can you please send me whtever you offered to send me to:

gs_enterprises@hotmail.com

Thanks again.

------------------
Regards,
Alexander McAndrew
VB Zone
http://gsenterprise.server101.com