Access forms Basics 1

[AGus01]

Hi, I am new to access and Access forms.

I have inherited a database which uses access forms.

Please can you advise how I can view the underlying data behind each and every form. So I can work out a data information flow?

For example I would like to be able to Chart exactly which database tables/queries etc.. are being selected/updated from each and every form page.

Is there a way of switching to a source code view of a form?

I come from a SQL server/web background if this helps?

Thanks for your help in advance. Gus

 

[lars7]

Hi,

Highlight the form, click design, right click on the form and select properties and at the top you will see record source. this will tell you what queries or table the fform is looking at.

 

[PHV]

Have a look here:

http://mdbdoc.sourceforge.net/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[AGus01]

Hi Lars,

Thanks for your help. I can't get this to work. I select the forms Objects from the left hand menu.

I then select the form I am interested in and right click to go to design view.

Once in the form I right click anywhere on the form select properties and am given a menu with a drop down and a number of tabs. None show me the database queries the tabs are Format, Data Other, all.

if this helps?

thanks

Angus

 

[SeeThru]

Click in the very top left corner of the form - you will now have selected the entire form, and the data tab will show the source for the form.

Note the source can be a table, a SQL query string or a saved query. Watch out for queries based on queries!

SeeThru
Synergy Connections Ltd - Telemarketing Services