472,791 Members | 996 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,791 software developers and data experts.

open form multiple times

101 100+
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
5 7462
mshmyob
904 Expert 512MB
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
billa856
101 100+
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
254 Expert 100+
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
Here is a link that may help


Managing multiple instances of a form:
http://allenbrowne.com/ser-35.html
Feb 13 '08 #5
mshmyob
904 Expert 512MB
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

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

Similar topics

1
by: Konstantin | last post by:
Can someone help me figure out a way to open a form only once in an MDI app. I have an MDI app that contains several forms. I use each form depending on the type of document that the user needs...
8
by: alanstew | last post by:
With the body tag calling out 'window onload', a function with a 'window.open' fails at the 'window.open' line. If I cut out the body tag, the function executes as normal. At first I thought it...
55
by: Steve Jorgensen | last post by:
In a recent thread, RKC (correctly, I believe), took issue with my use of multiple parameters in a Property Let procedure to pass dimensional arguments on the basis that, although it works, it's...
1
by: Brian Shafer | last post by:
Hi, I am using a mdi form and a treeview with a toolbar controls. On the tool bar I have a button to open a form that had IE control on it. This form I want to be able open multiple times. How...
4
by: kschneider | last post by:
Assume there's a form with it's action attribute all set to post to a URL, but without a submit control. Form submission is done via a link and I want to prevent the classic "double submit"....
6
by: Bob Alston | last post by:
Looking for someone with experience building apps with multiple instances of forms open. I am building an app for a nonprofit organizations case workers. They provide services to the elderly. ...
6
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I am thinking about doing this since I got several cases that some of our internal users open more than one browser at the same time from our server. When one of the transactions was not...
13
by: robert.waters | last post by:
Do you have your users rely on the windows taskbar to manage/navigate between the forms they have open, or do you provide another (more robust) method? Does anyone use a custom navigation system...
14
by: SimeonD | last post by:
Hi I have an access database called Sales.Mdb In vb.net 2005, I'd like to open it. Which I can do. What I can't figure out is how to figure out if Sales.Mdb is open already. If so, I want to open...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.