Timothy has attended:
Access Advanced course
Inputting Data to different tables using one form.
I am setting up an empty database for data input, because I don't want to sit down and import from excel for several weeks.
The idea is that I will have several tables with very similar records i.e. all the same fields and data types, but distinct so it is normalised the way I want it (more or less).
If say the different tables contained a different chapter of a book, I would want to direct each chapter to a different table.
What's the best way of approaching this. I was thinking that I have a combo box with all the different table names.
In VBA I would code something along the lines of a string variable (dim As String) being specified by the selected value in the combo box. This string variable would conveniently input into a series of control methods that would point each field at the correct Table e.g. [Tables]![StringValue]![FieldName].
Do you have any worked examples lying around for this sort of thing?
Cheers
Tim
RE: Inputting Data to different tables using one form.
Hi Tim
Thanks for your post and following on from your previous post I better appreciate your position.
Our forum is deigned to focus on specific questions related to training courses that have been attended. When more complex requirements are presented they really do go beyond the scope of what this forum can service.
However your requests are not uncommon as delegates (especially in the case of Microsoft Access) apply their Access knowledge to real world business applications.
This is why we do have a consultancy process to assist with these types of requirements:
1)Identify the key objectives with you
2)Assign the most suitable trainer/consultant
3)Estimate the scope of work required
4)Agree final costing and description of work
5)Arrange suitable dates and development time (if required)
If you would like to look into this further please do contact our enquiries team, info@stl-training.co.uk
Regards
Jacob
