Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Re: help with docmd, "Form"

Discussion in 'Information Technology' started by tina, Nov 10, 2005.

  1. tina

    tina
    Expand Collapse
    Guest

    please don't multi-post. it wastes server space, and wastes the time of
    people who may work to answer your question in one newsgroup - not knowing
    that it's already been answered in another newsgroup.

    if you really feel you must post to more than one group (rarely necessary),
    then cross-post, by putting both newsgroup addresses in a single message. if
    you post a message in the "wrong" newsgroup, either stick with it for a day
    or two - because you may get help anyway - or at least post a follow-up
    message in the thread as a courtesy, to say that you're abandoning it, so
    people won't waste time on it.

    hth


    "Madhusudhan" <gurumum@email.uc.edu> wrote in message
    news:1131592325.974999.219900@f14g2000cwb.googlegroups.com...
    > Hi
    >
    > I am new to Access & VB and have a question I hope you can answer:
    >
    > I have around 10 forms that merely display current record contents and
    > allow changing current values of fields or adding a new record. Each
    > form represents a separate entity (user1, managers, rooms_and_equipment
    > etc. )but in essence, the basic processing of data in the forms are
    > pretty much the same.
    >
    > So I'm trying to centralize the common functionalities like saving a
    > change, finding a record, deleting a record etc. In trying to do so, I
    > find myself clueless when it comes to handling the DoCmd object and its
    > properties which seem pretty ubiquitous in access,vb code.
    >
    > Example:
    > 1. The following code is at the form level. I want to put the main
    > functionality in a sub in Main()
    > and just call the corresponding function from this form. Can you please
    > show me a sample of how I go about that?
    >
    > Private Sub cmd_Save_Conf_Click()
    >
    > On Error GoTo Err_cmd_Save_Conf_Click
    >
    > DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
    > acMenuVer70
    > gRecordSaved = True
    >
    >
    > Exit_cmd_Save_Conf_Click:
    > Exit Sub
    >
    > Err_cmd_Save_Conf_Click:
    > MsgBox Err.Description
    > Resume Exit_cmd_Save_Conf_Click
    >
    > End Sub
    >
    > 2. I see the usage of "Form" ( IsNull(Form.[conf_id]) ) to refer to
    > active form in certain places and "Me" in others. WHats the difference
    > between Form and Me?
    >
    > 3. Whats the difference between the . and the ! used to refer to
    > members of a form?
    >
    > Thank you,
    > Madhu
    >
     
  2. Loading...


  3. Papa Jonah

    Papa Jonah
    Expand Collapse
    Guest

    that didn't help me - especially since I don't know where the other post is.

    "tina" wrote:

    > please don't multi-post. it wastes server space, and wastes the time of
    > people who may work to answer your question in one newsgroup - not knowing
    > that it's already been answered in another newsgroup.
    >
    > if you really feel you must post to more than one group (rarely necessary),
    > then cross-post, by putting both newsgroup addresses in a single message. if
    > you post a message in the "wrong" newsgroup, either stick with it for a day
    > or two - because you may get help anyway - or at least post a follow-up
    > message in the thread as a courtesy, to say that you're abandoning it, so
    > people won't waste time on it.
    >
    > hth
    >
    >
    > "Madhusudhan" <gurumum@email.uc.edu> wrote in message
    > news:1131592325.974999.219900@f14g2000cwb.googlegroups.com...
    > > Hi
    > >
    > > I am new to Access & VB and have a question I hope you can answer:
    > >
    > > I have around 10 forms that merely display current record contents and
    > > allow changing current values of fields or adding a new record. Each
    > > form represents a separate entity (user1, managers, rooms_and_equipment
    > > etc. )but in essence, the basic processing of data in the forms are
    > > pretty much the same.
    > >
    > > So I'm trying to centralize the common functionalities like saving a
    > > change, finding a record, deleting a record etc. In trying to do so, I
    > > find myself clueless when it comes to handling the DoCmd object and its
    > > properties which seem pretty ubiquitous in access,vb code.
    > >
    > > Example:
    > > 1. The following code is at the form level. I want to put the main
    > > functionality in a sub in Main()
    > > and just call the corresponding function from this form. Can you please
    > > show me a sample of how I go about that?
    > >
    > > Private Sub cmd_Save_Conf_Click()
    > >
    > > On Error GoTo Err_cmd_Save_Conf_Click
    > >
    > > DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
    > > acMenuVer70
    > > gRecordSaved = True
    > >
    > >
    > > Exit_cmd_Save_Conf_Click:
    > > Exit Sub
    > >
    > > Err_cmd_Save_Conf_Click:
    > > MsgBox Err.Description
    > > Resume Exit_cmd_Save_Conf_Click
    > >
    > > End Sub
    > >
    > > 2. I see the usage of "Form" ( IsNull(Form.[conf_id]) ) to refer to
    > > active form in certain places and "Me" in others. WHats the difference
    > > between Form and Me?
    > >
    > > 3. Whats the difference between the . and the ! used to refer to
    > > members of a form?
    > >
    > > Thank you,
    > > Madhu
    > >

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page