newbie to access

[dave]

hi
i m newbie to access and developing application to maintain and operate
normal database.
i m designing form and that uses tables of current table.
i m just wondering whats the best approach to coding considering future
customization.
should i use DoCmd , DAO or ADO...right now form use the current db tables
but in future
it may use external sql data.
another thing is form navigation, should i use in built properties (like
lookup wizard and bound controls) or
write own code to populate fields and navigation code..
i tried using looking wizard and also set record navigation property true
but didnt feel comfortable as i could hardly
understand the code and unable to customize...
can anyone help me pointing right direction? i dont want to approach short
way even its easier and i m not able to customise
or cant understand..
thank you
dave

 

[Larry Daugherty]

Hi Dave,

The general rule is "one issue per thread". That way, people can get a clue
from the subject line as to whether they want to look in.

"Shall I be an astronaut or can I play here in the sandbox another half
hour"? Your questions are all over the map.

I suggest starting with an "Access for Dummies" level book or "Access
[YourVersion] Step by Step" and get acquainted with access. Start trying to
use the product and get acquainted with it. Continue to lurk the Access
newsgroups.

HTH