D
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
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