By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,050 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

open form multiple times

100+
P: 101
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.
Feb 12 '08 #1
Share this Question
Share on Google+
5 Replies


mshmyob
Expert 100+
P: 903
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.
Feb 12 '08 #2

100+
P: 101
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.
Feb 13 '08 #3

jaxjagfan
Expert 100+
P: 254
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.
Feb 13 '08 #4

P: 34
Here is a link that may help


Managing multiple instances of a form:
http://allenbrowne.com/ser-35.html
Feb 13 '08 #5

mshmyob
Expert 100+
P: 903
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.
Feb 15 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.