3 questions regarding access development

I am new to access development, please bear with me if these questions
sound trivial.

I am creating an Access application using link tables. My database
resides in MSDE. I have created multiples tables such as schools,
teachers, etc in MSDE.

1. This is my first question: In order to show user friendly data, I
have created a form displaying queries to display the schools/teachers
information. How do I use the same form to edit/add new data?. When I
open the form which displays the school data, I get a message, "The
Recordset is not updatable"

2. If login and access control is created for the application, is it
possible to display different switchboard automatically and also
capture the username in a field.

3. How do I create autogenerated number for the ID fields since this is
a linked table whenever new records are created.

Thanks for any input.

re: 3 questions regarding access development

On 23 Jan 2006 05:04:29 -0800, "Fendi Baba" <effendi@epitome.com.sg>
wrote:

1: This error message can have several causes. Your underlying table
needs to have a Primary Key. You typically cannot use outer joins,
union queries, or totals queries, nor would you typically need those.

2: Sure. The details depend on how you're logging in. Assuming you
created your own login form, after successful login you know who the
user is. Store this in a global variable (say g_strUserName). Then in
the Switchboard's Form_Open you can use this information to display
differnent things:
if g_strUserName = "Tom" then
some_control.Visible = False
end if
You can also write code like:
Me.txtUserName.Value = g_strUserName
to display the user name in a textbox.

Autonumbers in MSDE are created by setting the Identity property of a
field. When you later insert a record, a new value is automatically
created for you.

-Tom.


[color=blue]
>I am new to access development, please bear with me if these questions
>sound trivial.
>
>I am creating an Access application using link tables. My database
>resides in MSDE. I have created multiples tables such as schools,
>teachers, etc in MSDE.
>
>1. This is my first question: In order to show user friendly data, I
>have created a form displaying queries to display the schools/teachers
>information. How do I use the same form to edit/add new data?. When I
>open the form which displays the school data, I get a message, "The
>Recordset is not updatable"
>
>2. If login and access control is created for the application, is it
>possible to display different switchboard automatically and also
>capture the username in a field.
>
>3. How do I create autogenerated number for the ID fields since this is
>a linked table whenever new records are created.
>
>Thanks for any input.[/color]

re: 3 questions regarding access development

Thanks for the tips.

re: 3 questions regarding access development

"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote >

2: Sure. The details depend on how you're logging in.

The FAQ at http://www.mvps.org/access includes two API references that can
be used to avoid addition "logins", the one at
http://www.mvps.org/access/api/api0008.htm returns the Network Login Name,
and the one at http://www.mvps.org/access/api/api0009.htm returns the
current computer name.

Unless you are very, very careful to handle every error, it is unwise to
depend on storing user identification in Access variables. Variables can
lose their content in the event of an unhandled error, with varying
consequences depending on how you employ them in your application. It may be
better to store the information in controls on a form whose Visible property
you have set to False.

Larry Linson
Microsoft Access MVP