Front end- back end form question 1

[DajTwo]

I am new to the concept of front end and back end, so I am sorry in advance for my questions.

The back end has all the tables
The front end has a link to each of the back end tables.

For this question: 2 tables [tbl_cust] and [tbl_x_cust] with each table having an Unique ID.

I require a form that will allow the user to
1) Select the Unique ID from the tbl_cust from a drop down
2) Display the contents of tbl_cust for READ ONLY
3) Display the contents of tbl_x_cust for READ AND WRITE

How should I connect the form's field?.. I tried a query but I cannot update the fields, directly to the tables?, then wont I have a problem with multi users? an update query for the read/write fields?

I just need an indication on how to proceed. I would really appreciate..

Thanks

 

[CharlieT302]

Access is a multi user dbase, allowing over 200 concurrent users; at least in theory. Attaching a form to a table or table link does not alter this. Although, you should attach to the link in the front end.

In form design, you can use the combo box wizard to create a drop-down menu that obtains a value (Cust. ID) from another table and then store the value in a comparable field in the table attached to the form.

As for Read ONly. (assuming you are talking about an entire form) This is best handled through user-level security, whereby you can determine which objects can be opened by specific users. YOu can define one set of users with read-write and another with read only priveleges.

In Form design, on form properties, there are three properties: Allow Additions, Allow Edits, Allow deletions which can (sort of) be used for the same type of thing, but they can also interfere with code attached to form controls.

 

[DajTwo]

Charlie,

This is exactly what I needed. Your def shows 'Instructor' and you are exactly what I needed.

One FUP question on this. You assumed that the READ ONLY and READ WRITE fields (which are located on different tables) are to be on different forms.

Is it possible to have the field from both tables on the same form (and not on a sub form?). The visual presentation of a subform does not suit the function of the form.

Thanks in advance

 

[Remou]

It is recommended that you attach your forms to queries, rather than tables. If the query that you built is read only, then there is some problem with the query and you should post the SQL.

A query joining the two tables is the best way to have data from each of the tables show on the same form with out a subform. The alternative is DLookUp (which would be read-only, but would also be slow). Control properties can be set to locked and / or enabled and these properties can be changed via code at runtime.

Note that Access security has been dropped in Access 2007.

 

[DajTwo]

Thanks a lot, I will try this .. .


I may need more help..

 

[CharlieT302]

What is tbl_cust and tbl_x_cust?

How do they relate?

A multi-table query is designed to create a single dataset out of many. Each must be related to one another is some fashion. It sounded to me as if you wanted to display a cust id and have the data from the other table filter to match it. Was this incorrect?

Also, you stated:
"The visual presentation of a subform does not suit the function of the form."

If it is purely the aesthetics that are troubling, you can alter the format of the subform to remove all borders, and effects. By doing so, no one will ever know that some of the info is on a subform. Place the main form in design view and, with a single click, select the subform. You should see sizing handles around the form. If you ss a black dot in the upper left corner where the rulers meet, you clicked once too many times. Then pull up properties and turn off the desired effects.

Enable/Lock properties. Remou had a good point. Each control can be locked to prevent its editing. However, be aware that the Enable function, if turned off, will "gray out" your fields making them hard to see.

Hopefully this helps

 

[DajTwo]

Thanks a lot again..

All is well and works well. With your ideas, tht form does exactly what it is supposed to do.

Thanks!!!