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

Multiple instances of Form - help me with Allen Browne's Sample

P: 6
Hi,

I have uploaded "ClientMultiSample2k.zip" at ...

http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/2_AssistanceNeeded/ClientMultiSample2k.zip

The file is basically Allen Browne's sample. I have tried to get it
customized for me.

frmClient:
-=-=-=-=-
The modification I've done to this form worked good. But when I added
a line on Current event its showing me run time error # 2450.

FYI : If its opened it directly it works, BUT when I try to open it
thru frmMain - there comes the problem.

Any help is appreciated.

Regards,

Ozair - Learning & Loving Ms-Access.
Jun 5 '08 #1
Share this Question
Share on Google+
6 Replies


NeoPa
Expert Mod 15k+
P: 31,261
You really need to post the question as a question. Expecting someone to download and look at your database is not reasonable.

This also puts the extra work on their shoulders rather than you taking responsibility for it (which is not very respectful when you're asking for help). Please ask the question properly if you're still interested in getting assistance.

-ADMIN.
Jun 5 '08 #2

P: 6
You really need to post the question as a question. Expecting someone to download and look at your database is not reasonable.

This also puts the extra work on their shoulders rather than you taking responsibility for it (which is not very respectful when you're asking for help). Please ask the question properly if you're still interested in getting assistance.

-ADMIN.
Hi NeoPa,

I apologize for not being able to follow the rules of this forum.
Of course I still need help, but to me it does not seem so easy to
explain what exactly I need.

Anyway thanks for your attention to my post.

regards,
Ozair - Loving & Learning Ms-Access
Jun 6 '08 #3

NeoPa
Expert Mod 15k+
P: 31,261
Ozair, I didn't post that simply to tell you off. I was expecting you to select and post the relevant part of the issue so that anyone reading it doesn't need to go off looking elsewhere and downloading a potentially destructive file.

You seem to be saying that you're not able to do this, which I find confusing. It is a basic part of asking for help - especially on a forum. If this is true then I sympathise, but I don't think there's much we can do for you in those circumstances.
Jun 6 '08 #4

P: 6
Hi NeoPa,

Your fear makes sense but I and most of my fellows do the this on the MS-AccessProfessionals forum at yahoo.

We have enough confidence in each other - I can realize that I am newbie here so you might consider me a spammer which I do not mind.

But if you still have something to help you need to download the file which I am talking about. For a trustworthy website (at least for me is) www.allenbrowne.com

I am using his sample for managing multilple instances of a form.

what I've wanted to accomplish is.
- A continuous form (frmMain) that has records of customers.
- Another form (frmClient) sort of detail for the customers in single form view.

- From the frmMain I wanted to open instance of frmClient filtered on a record
selected in frmMain.

- leave both the forms opened.

Then I will select some other record in frmMain and try to open
frmClient - the same way I did earlier.
This will create another instance of frmClient
with new record while the previously opened frmClient still shows its own record.

- It all works well.
- Then I added on current event of frmClient
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Current()
  2.     Forms("frmClient")!Address = Forms("frmClient")!ClientID & Forms("frmClient")!Surname
  3. End Sub
there comes the problem.
but fortunately another MVP Bill Mosca the moderator of that Yahoo group
suggested me this....
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Current()
  2.     me.Address = me.ClientID & me.Surname
  3. End Sub
may be I need to stick with the group / forum where people know me and they have a little trust in me.

Any way I am still thankful to you since you're helping Access community.

very best regards.
Ozair - Learning & Loving Ms-Access.
Jun 7 '08 #5

NeoPa
Expert Mod 15k+
P: 31,261
Ozair, there are many reasons why rules are made up. I don't want to go into any detail here, but if you're really interested I'm happy to explain any rule you may find confusing.

I wouldn't presume to criticise how other forums run themselves (however my views may differ from theirs), but we make our own rules here obviously.

As a new member you must surely realise that we have no reason to trust you (none to mistrust either). Maybe, after some more interaction we may get to trust you some more, but we still would not encourage you to post your questions without phrasing them clearly in the thread, as that would give very little value to the thread. Who wants to search for a solution only to find it only makes sense when you go to the trouble to download (with associated exposure) a linked question.

PS. We trust www.allenbrowne.com here right enough.
Jun 9 '08 #6

NeoPa
Expert Mod 15k+
P: 31,261
Multiple copies of the same form is possible, but quite complicated and easy to trip up on. I would have suggested exactly the same change that Bill did. In fact, I would go further and suggest that you change any code that you have with explicit references to the instance of the form the code is related to, to use Me. (or sometimes Me!) instead.

Referencing particular instances (only relevant when multiple instances are opened) involves (to the best of my recollection - I don't really play there much) derivatives of the name. Forms("FormName") only references the default instance - whereas, Me always refers to the instance associated with the code.

I'm assuming from your last reply that you now have what you need? If not, let us know what your problem(s) is.
Jun 9 '08 #7

Post your reply

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