Data updation & viewing

[sachin.shelar]

Hi All,


I am new to Access progrmming...i made some database systems in excel but not that much comfortable with MS access
I am doing a project for Fuel management..in that i ahaving some challanges which as below
1) I want a form where user will enter or select the Vehicle no from combo box and the other releated details should come automatically (requirement is that user should not be connected to database for preventing him from seeing other records)
2) in this form only user will enter the data ( which is also not connected to database) and only after clicking add button the program will update the data in the database ( may the tables are more than 2 )

If u answer me in detail manner it will be more useful as i am not that much confidant about Access

Also u can recommand any book or site with tutorial

Thanks in advance

[June7]

Are you saying the database is split design? Frontend with queries/forms/reports/code and backend with data tables? If you are not setting links to the backend, will have to use VBA code to establish connection and retrieve data with recordset and then set values of textboxes with data from recordset. This will require a LOT of code to retrieve data and to save data. Much easier to set links and control what users can see on forms. It is possible to secure the files so users cannot get to the table links. A forum thread is not appropriate venue to try learning such broad requirements. There is much more involved than can be accomplished in a few lines of step-by-step instructions.

Search the Access Help for topic 'Introduction to Programming in Access'.

Might also check this publication: Access™ 2007 Programming by Example with VBA, XML, and ASP by Julitta Korol, Wordware Publishing, Inc.

Search the net for 'programming unbound forms in Access'.