data entry form

**drunkenneo** · 10-02-2013, 12:59 AM

I am making a database, where 10 to 20 users will be entering data.

I have queries
1. I am planning to create a form with which user will be directly entering in the table, will that b right?
2. If 2 or more users will open form its own side does they all will be entering in same row number?
3. Whatwill be the best of these,by insert query or directly to form?

Please help me with my queries.

**June7** · 10-02-2013, 01:19 AM

1. That is alright.

2. Users are opening the same file? This is not advisable. Should split the db and each user run their own copy of the frontend that links to one backend.

3. Forms can bind to table or query object or build SQL statement right in the RecordSource property. I use all three methods.

**drunkenneo** · 10-02-2013, 02:38 AM

For you 2 answer, yes they will be working on same table, but of course there will be fe and be and the user were linked to the table. What does ot mean by split the db?

**June7** · 10-02-2013, 03:08 AM

Split db is a frontend and backend as you said there will be.

No, users will not be entering new record in same row.

data entry form

Thread Tools

data entry form

Similar Threads

Proper Data Entry form/subform design when data goes to multiple tables.

Duplicate data message for a data entry form

Data Entry Form

Data Entry form look help

data entry form

Posting Permissions