A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data Refresh



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2010, 07:38 PM posted to microsoft.public.access.forms
tonkaplayer
external usenet poster
 
Posts: 17
Default Data Refresh

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.
  #2  
Old April 20th, 2010, 09:15 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Data Refresh

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.

  #3  
Old April 20th, 2010, 10:03 PM posted to microsoft.public.access.forms
tonkaplayer
external usenet poster
 
Posts: 17
Default Data Refresh

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.

  #4  
Old April 20th, 2010, 11:06 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Data Refresh

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" wrote in message
...
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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.