ms access question?

Question

I am currently doing a project where I created a Microsoft Access form/database to collect data for Stormwater Data (i.e. manholes, catch basins, culverts/pipes, ditches, etc.).

However, I have numerous inputs that do not need to show the whole time.

For example, if you pick that the shape of a culvert is a circle, you will be prompted for the diameter of the pipe, so on and so forth.

It has been years since I have used MS Access and need to be refreshed on how to program for Access.

Any sites of programming "codes" would be greatly appreciated as well as any expressions you have for the described statement above as I cannot seem to get it to work the way I want it to (I can only get it to work if all of the inputs show at all times).

Thank you in advance and I hope you can give me some great input!

Answer 1

It sounds like You want to create a custom form and then put the options you want behind them as unbound options. This makes it easier and then once you have the options you want you can save the data to the tables. What this does is allows you to customize your form to pull the data you want and then save it as you see fit.



A good place to learn stuff is just by going to Microsoft's website and they have How-To's on there site. Some are good and some not so good but if you search you can find some basic info. Anything beyond that you would have to take someone's example and then mold it to your needs.

Answer 2

The dossier is propietary ergo I suppose you'll handiest run it utilising MS Access. You can nevertheless browse it and edit it with a application known as "MDB Browser", google that. You too can hyperlink to and question the information furnished you may have the proper drivers established.

Answer 3

Use copious amounts of queries. Rather than trying to get the data direct from a table get it from a query, even if the query is only one field. I tied myself in knots until I realised this and it's even more important if you are putting VBA code behind an ActiveX control.

Answer 4

Check out the Microsft knowledge Base.

You can dwonload the sample DB "Northwind" to review what it can do & how to do it.