473,836 Members | 2,294 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

open form multiple times

101 New Member
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 7659
mshmyob
904 Recognized Expert Contributor
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 New Member
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.microso ft.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 Recognized Expert Contributor
http://support.microso ft.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,...Rea dingX

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
Tetelestai
34 New Member
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 Recognized Expert Contributor
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.microso ft.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
462
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 to see, i.e. for documents of type A, I use form A, for type B, form B, etc. Each document has a unique number. I need the app to only show one document at a time, i.e. ifthe user tries to open doc. 1 of type A, then open form A and load doc 1....
8
2471
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 was the entire function failing, but I tested with alerts and found that it was only the 'window.open' that fails to execute. The function is being called by a link, and I suspected some problem with the body alink/vlink but after cutting that out...
55
4687
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 not obvious how the code works if you don't know the intricacies of the Property Let/Get syntax. Likewise, I dislike (and code to minimize the use of) the VB/VBA syntax of returning a value by referring to the function name as if it were a...
1
2437
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 can i do this? Brian
4
2740
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". Ignoring the server side of things, does anyone see any holes with the following script? It seems to work, but I'd appreciate other eyes on it. Maybe a try/catch/finally wrapper of some sort to be sure the link is re-enabled in the face of an...
6
2664
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. so far I have built a traditional app, switchboard, forms, etc. Part of this app is to automate the forms they previously prepared manually. After the app was built and works just fine, I find out there are several case managers using MS word...
6
2415
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 completed finished, the second browser jusk pick up some session variables from the first browser and process right after that. It messed up everything. I was thinking about use remote_addr, but it seems not working since we are behind the...
13
3556
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 (like keeping a selectable list of open forms in a listbox/commandbar/ breadcrumb trail etc.)?
14
4641
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 that instance. Any ideas how I would do this? Thanks
0
9657
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10823
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10532
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10577
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10243
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9359
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
4443
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4003
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3103
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.