Prev: Filter Frustration
Next: Automatic control names
From: tonkaplayer on 20 Apr 2010 14:38
I have a table with several fields, but in particular
Student Number (test)
Last Name (text)
First Name(test)
Grade(text)

These fields show on my form called Parking form. These fields are locked. I
wish to allow the users to add/edit fields. So I have a cmd button that opens
a new form called add/edit new student form. There the user can edit or add
a new student then return to the main form. The problem is when you add a
new student. That student will not show in the parking form unless you do
shift F9. I assume a requery command is needed but I cannot figure out
which filed, form, property setting, or correct syntax to use. I would
prefer to autmate this and not have user use shift F9. One user will never
figure that out. I have the same problem with adding a new make and modle of
car. But I assume I can modify the first answer to fix the same problem
there. Thanks for the help. If u need more infor let me know.
From: KARL DEWEY on 20 Apr 2010 16:15
Try using the OnCurrent event to run a macro to Requery.

--
Build a little, test a little.


"tonkaplayer" wrote:

> I have a table with several fields, but in particular
> Student Number (test)
> Last Name (text)
> First Name(test)
> Grade(text)
>
> These fields show on my form called Parking form. These fields are locked. I
> wish to allow the users to add/edit fields. So I have a cmd button that opens
> a new form called add/edit new student form. There the user can edit or add
> a new student then return to the main form. The problem is when you add a
> new student. That student will not show in the parking form unless you do
> shift F9. I assume a requery command is needed but I cannot figure out
> which filed, form, property setting, or correct syntax to use. I would
> prefer to autmate this and not have user use shift F9. One user will never
> figure that out. I have the same problem with adding a new make and modle of
> car. But I assume I can modify the first answer to fix the same problem
> there. Thanks for the help. If u need more infor let me know.
From: tonkaplayer on 20 Apr 2010 17:03
I have an event procedure in oncurrent in form Parking Sticker with the
following:
If Extrasticker = True Then
Sticker_Number_Two.Visible = True
Date_of_Issue_Two.Visible = True
Year_of_car_two.Visible = True
cbomaketwo.Visible = True
cbomodeltwo.Visible = True
Color_Two.Visible = True
License_Plate_Two.Visible = True
Memo_Two.Visible = True
Label90.Visible = True
Label23.Visible = True
Label35.Visible = True
Label86.Visible = True
Label87.Visible = True
Label41.Visible = True
Label43.Visible = True
Label93.Visible = True
Else
Sticker_Number_Two.Visible = False
Date_of_Issue_Two.Visible = False
Year_of_car_two.Visible = False
cbomaketwo.Visible = False
cbomodeltwo.Visible = False
Color_Two.Visible = False
License_Plate_Two.Visible = False
Memo_Two.Visible = False
Label90.Visible = False
Label23.Visible = False
Label35.Visible = False
Label86.Visible = False
Label87.Visible = False
Label41.Visible = False
Label43.Visible = False
Label93.Visible = False

How would I go about adding the macro or comands. I have tried using
me.requery in the oncurrent and it does not like that???

"KARL DEWEY" wrote:

> Try using the OnCurrent event to run a macro to Requery.
>
> --
> Build a little, test a little.
>
>
> "tonkaplayer" wrote:
>
> > I have a table with several fields, but in particular
> > Student Number (test)
> > Last Name (text)
> > First Name(test)
> > Grade(text)
> >
> > These fields show on my form called Parking form. These fields are locked. I
> > wish to allow the users to add/edit fields. So I have a cmd button that opens
> > a new form called add/edit new student form. There the user can edit or add
> > a new student then return to the main form. The problem is when you add a
> > new student. That student will not show in the parking form unless you do
> > shift F9. I assume a requery command is needed but I cannot figure out
> > which filed, form, property setting, or correct syntax to use. I would
> > prefer to autmate this and not have user use shift F9. One user will never
> > figure that out. I have the same problem with adding a new make and modle of
> > car. But I assume I can modify the first answer to fix the same problem
> > there. Thanks for the help. If u need more infor let me know.
From: Jeff Boyce on 20 Apr 2010 18:06
If your table has students, and their (?current?) grade, don't you have to
go through it each year and update their (then-current) grade?

Are you using the word "grade" to mean "Freshman, Sophomore, ..." or "A-,
B+, ..."

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"tonkaplayer" <tonkaplayer(a)discussions.microsoft.com> wrote in message
news:9BEBD709-C6E7-482B-B8DA-C1663D0054DB(a)microsoft.com...
>I have a table with several fields, but in particular
> Student Number (test)
> Last Name (text)
> First Name(test)
> Grade(text)
>
> These fields show on my form called Parking form. These fields are locked.
> I
> wish to allow the users to add/edit fields. So I have a cmd button that
> opens
> a new form called add/edit new student form. There the user can edit or
> add
> a new student then return to the main form. The problem is when you add a
> new student. That student will not show in the parking form unless you do
> shift F9. I assume a requery command is needed but I cannot figure out
> which filed, form, property setting, or correct syntax to use. I would
> prefer to autmate this and not have user use shift F9. One user will never
> figure that out. I have the same problem with adding a new make and modle
> of
> car. But I assume I can modify the first answer to fix the same problem
> there. Thanks for the help. If u need more infor let me know.


 | 
Pages: 1
Prev: Filter Frustration
Next: Automatic control names