same changes in many Forms

[baza01]

Hi!
I have a lot of forms in one database. And I'd like to fill one field in tabele more with this forms.
How can I Add one or more tasks (links to tabele) on many forums at the same time or at one and then copy it to the other.

Thank you!

Robi

 

[KenHigg]

How many forms do you have? In which ways are they similar?

 

[baza01]

I have 44 forums and all are "visualy" the same. The difference is only on properties for forum. there is set filter for some of the person.

 

[KenHigg]

I'm going to guess that you should come up with a scheme to re-use one form rather than trying to manage all of these seperately. What reasons can you come up for not being able to do this?

 

[baza01]

Every user have him oun form to fill table with data . If I understud you well I should change that but how can I than restrict user to see and manage just him oun data in table with 44 diferent users?

Thanks!

 

[KenHigg]

Does each user have him oun table?

 

[baza01]

No, all have the same table. One column is filled with the name of user and through filter in Forum user can see him oun data from big table.

 

[KenHigg]

There are many ways to do this. But maybe the easiest way for a novice would be to place an unbound combo box on the form the lists all the users. Then when the user selects a person in the combo box the form uses that control as a filter criteria... Hope this makes sense...

Look at the last post in this thread:

http://www.access-programmers.co.uk/forums/showthread.php?p=466108#post466108

 

[baza01]

Thank you very much for your time and patience with - like you notice - new user of Access.

Best regards!

Robi

 

[baza01]

One thing more!

How can I restrict use!
Every user have him own username and if one input in tab is the same as usesrname how can I restrict user to manage just him oun inputs. Every user have many lines in table.

Thanks!