open form multiple times

[billa856]

Hi,
My project is in MS Access 2002.
In that I want to open one form multiple times.
I put one button on my main form.
Now whenever I click on that button than form will be open.
Now when I click again on that same button than it will open same form again in seperate window.
But instead of that already open form comes.and so i couldn't open that form multiple times.
Already open form must be remain as it is even if I click on that button to open the same form again.
I want this, bcz I am using this form to enter some readings, taken at half hour time interval,in table.If I couldn't open form multiple times than at the end of day I have to enter the all readings.And it will take time(1 hour) bcz this readings are taken from different line in production area.And in my company we have 30-40 production lines in one room.we have 9 rooms like this.
If I can open same form multiple times than whenever someone taken readings and give me at half hour interval than I can enter it at that time.so my work be in progress every half hour and I don't have to enter all readings at the end of day.

So plz if someone have solution then give it to me.
Thanks.

[mshmyob]

I must be missing something here. If you open the same form multiple times (not that that would work) you would just be attempting to rewrite the same fields over and over.

Maybe your form should be changed to a continuous form so you can enter multiple records on the one form.

Maybe someone else has some other ideas.

Hi,
My project is in MS Access 2002.
In that I want to open one form multiple times.
I put one button on my main form.
Now whenever I click on that button than form will be open.
Now when I click again on that same button than it will open same form again in seperate window.
But instead of that already open form comes.and so i couldn't open that form multiple times.
Already open form must be remain as it is even if I click on that button to open the same form again.
I want this, bcz I am using this form to enter some readings, taken at half hour time interval,in table.If I couldn't open form multiple times than at the end of day I have to enter the all readings.And it will take time(1 hour) bcz this readings are taken from different line in production area.And in my company we have 30-40 production lines in one room.we have 9 rooms like this.
If I can open same form multiple times than whenever someone taken readings and give me at half hour interval than I can enter it at that time.so my work be in progress every half hour and I don't have to enter all readings at the end of day.

So plz if someone have solution then give it to me.
Thanks.

[billa856]

I must be missing something here. If you open the same form multiple times (not that that would work) you would just be attempting to rewrite the same fields over and over.

Maybe your form should be changed to a continuous form so you can enter multiple records on the one form.

Maybe someone else has some other ideas.

http://support.microsoft.com/kb/210248/en-us

Using this info I can open the form multiple times.
But I want to enter details in table.
So when I enter different details in both form(same form open twice) open at a time and save it and check table then it simply enter the details of first open form twice in table.

So I think whatever U said was right, but I don't know how to change form to continuous form, so that I can enter multiple records.

So can u tell me how can I enter details from both form?
Thanks for ur reply.

[jaxjagfan]

http://support.microsoft.com/kb/210248/en-us

Using this info I can open the form multiple times.
But I want to enter details in table.
So when I enter different details in both form(same form open twice) open at a time and save it and check table then it simply enter the details of first open form twice in table.

So I think whatever U said was right, but I don't know how to change form to continuous form, so that I can enter multiple records.

So can u tell me how can I enter details from both form?
Thanks for ur reply.

You can't edit the same record at the same time from 2 instances of the same form. Access will lock the record.

It looks like you should have Columns for:
Room, Line, Time, Reading1, Reading2,...ReadingX

You might want a multi-tab form with a tab for each room. Once you design your data entry form save it 9 times (once per room) and set the room defaults. The data can exist in a single table but the data being entered would be specific to each room.

You can use similar scenerio for your groupings - room was an example.

[Tetelestai]

Here is a link that may help


Managing multiple instances of a form:
http://allenbrowne.com/ser-35.html

[mshmyob]

To switch to Continuous forms change the Default View in the properties for the form on the Tab.

After you do that your form will look like junk. You will have to move your controls around to make it look proper.

http://support.microsoft.com/kb/210248/en-us

Using this info I can open the form multiple times.
But I want to enter details in table.
So when I enter different details in both form(same form open twice) open at a time and save it and check table then it simply enter the details of first open form twice in table.

So I think whatever U said was right, but I don't know how to change form to continuous form, so that I can enter multiple records.

So can u tell me how can I enter details from both form?
Thanks for ur reply.