473,320 Members | 1,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Open multiple instances of a form in MS Access

Is there any way to open mulitple instances of a form in Access? I need my form to be active and open 3 or 4 times during the same session. The only thing I can think of is creating the form everytime. Is there an easier way?
Thanks,
Colin
Feb 26 '07 #1
8 13957
willakawill
1,646 1GB
Hi Colin. Can you describe your problem in terms that are not your solution? i.e. My problem is x, y, z. Not I need to have multiple instances open because that is the answer to my problem and I only need to find out how to implement this. The answer to your problem might be much simpler than you think
Feb 26 '07 #2
I am creating a database for security traders in a financial company. I have created a form that allows the trader to input the number of shares, price, etc... One of those basic no-brainer forms. What I am looking to do is allow the traders to start one trade, leave the form open and start a new trade using the same form but allow each form to operate independantly. Any ideas?
Feb 26 '07 #3
willakawill
1,646 1GB
What is this process 'start a trade'?
Feb 26 '07 #4
Starting a trade would involve pulling up the "Create a new Trade" form then punching in the relavant data ie. price, quantity, etc.
However the time between starting a trade and finishing a trade could be half an hour or so. I would like the traders to be able to leave their original "Create a new Trade" form open while calling up a second instance of the "Create a new Trade" form and start a new trade.
Feb 26 '07 #5
ADezii
8,834 Expert 8TB
Is there any way to open mulitple instances of a form in Access? I need my form to be active and open 3 or 4 times during the same session. The only thing I can think of is creating the form everytime. Is there an easier way?
Thanks,
Colin
An Access Form is nothing more than a Class, and as such new Instances of it can be created. The following code will create 4 New Instances of a Form named frmTest, place them in a Public Array declared as frmTest, Cascade the Form Windows, then make frmTest the Current Form. All this is accomplished via the Click() Event of a Command Button on frmTest. BTW, each Form Instance can de identified by its Caption. Good Luck.
Expand|Select|Wrap|Line Numbers
  1. 'Public Array to hold Form Instances
  2. Public MyFormCollection(1 To 4) As Form_frmTest
Expand|Select|Wrap|Line Numbers
  1. Private Sub Command15_Click()
  2. Dim intCounter As Integer
  3.  
  4. For intCounter = 1 To 4
  5.    Set MyFormCollection(intCounter) = New Form_frmTest
  6.    MyFormCollection(intCounter).Visible = True
  7.  
  8.    MyFormCollection(intCounter).Caption = "Form #" & intCounter
  9.  
  10.    DoCmd.RunCommand acCmdWindowCascade
  11. Next intCounter
  12.  
  13. Forms!frmTest.SetFocus
  14. End Sub
Feb 26 '07 #6
willakawill
1,646 1GB
OK. This is why I wanted in on the 'problem' rather than the fix. Would life not be simpler if each new trade appeared in a listbox and could be clicked to close it?
Feb 26 '07 #7
NeoPa
32,556 Expert Mod 16PB
I think I see where you're going with this one Will, but unless the trades are very simple then I think the multiple instance solution may prove the most practical. I've never had to use it myself and it's a little complicated to set up certainly, but for the operator to select an open trade and update the details I think multiple forms would be required.
Feb 28 '07 #8
Rabbit
12,516 Expert Mod 8TB
I would also think you would want to set Data Entry to yes. I don't know how updates to the table would affect each other.
Feb 28 '07 #9

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

Similar topics

11
by: Ohaya | last post by:
Hi, I'm trying to understand a situation where ASP seems to be "blocking" of "queuing" requests. This is on a Win2K Advanced Server, with IIS5. I've seen some posts (e.g.,...
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...
4
by: Steve Jorgensen | last post by:
Hi all, This is actually not an issue of mine, but one a friend of mine told me about that I was able to confirm. Let's say you want a highly customizable report, so you want to be able to do...
3
by: Hp | last post by:
Hello, Is it possible to have more than one record from the same table open on the screen using forms? If you have an contact list for example and want to check a phone number whilst editing an...
17
by: Barret Bonden | last post by:
As an old programmer just now looking at VB.net I have a question: How does one simply open one form from another ? I don't mean how does one create a new instance of that form , but rather how...
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. ...
3
by: Barry Edmund Wright | last post by:
Hi All, I have an MS Access DB (2003) with frontend on PC (xp) and backend on Server (2003). I can open multiple instances from this PC. I make a duplicate copy of the MS Access DB and put it onto...
4
by: nottarealaddress | last post by:
I'm trying to get my feet wet in VB2005 (our new standard at work after officially stopping new development in VB6 about a month ago). I'm working with a simple sql 2005 table of 50 entries, one...
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: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.