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
8 13957
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
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?
What is this process 'start a trade'?
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.
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. - 'Public Array to hold Form Instances
-
Public MyFormCollection(1 To 4) As Form_frmTest
- Private Sub Command15_Click()
-
Dim intCounter As Integer
-
-
For intCounter = 1 To 4
-
Set MyFormCollection(intCounter) = New Form_frmTest
-
MyFormCollection(intCounter).Visible = True
-
-
MyFormCollection(intCounter).Caption = "Form #" & intCounter
-
-
DoCmd.RunCommand acCmdWindowCascade
-
Next intCounter
-
-
Forms!frmTest.SetFocus
-
End Sub
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?
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.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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.,...
|
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...
|
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...
|
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...
|
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...
|
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.
...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
| |