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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Refreshing data



 
 
Thread Tools Display Modes
  #1  
Old July 18th, 2004, 08:56 AM
external usenet poster
 
Posts: n/a
Default Refreshing data

Hi guys,

I have a little database that has a form that operates as a main menu. This
menu opens a form that allows the user to enter data. It does certain
calculations and displays a summary of critical data in a box on the one
side. The calculations are done by a procedure in the form's load event. How
can I refresh, or update, these calculations after data has been added.

I have managed to do it manually by adding a refresh button and running the
calculations procedure when this button is pushed, but this seems to be
cumbersome and duplicates existing procedures.

Ok thanks.

Kenny




  #2  
Old July 18th, 2004, 06:44 PM
tina
external usenet poster
 
Posts: n/a
Default Refreshing data

run the calculations from the form's AfterUpdate event, in addition to the
Load event.
i'm not sure what you mean by your Refresh button "duplicates existing
procedures". did you write the calculations code directly into the Load
event? if so, you should be able to move that code into its' own procedure.
then you just call the procedure wherever you need it.

hth


Kenny wrote in message ...
Hi guys,

I have a little database that has a form that operates as a main menu.

This
menu opens a form that allows the user to enter data. It does certain
calculations and displays a summary of critical data in a box on the one
side. The calculations are done by a procedure in the form's load event.

How
can I refresh, or update, these calculations after data has been added.

I have managed to do it manually by adding a refresh button and running

the
calculations procedure when this button is pushed, but this seems to be
cumbersome and duplicates existing procedures.

Ok thanks.

Kenny






  #3  
Old July 19th, 2004, 04:53 AM
external usenet poster
 
Posts: n/a
Default Refreshing data

You could add a AfterUpdate event for all relevant
fields, calling for the form to requery.

HTH

Chris

-----Original Message-----
Hi guys,

I have a little database that has a form that operates

as a main menu. This
menu opens a form that allows the user to enter data. It

does certain
calculations and displays a summary of critical data in

a box on the one
side. The calculations are done by a procedure in the

form's load event. How
can I refresh, or update, these calculations after data

has been added.

I have managed to do it manually by adding a refresh

button and running the
calculations procedure when this button is pushed, but

this seems to be
cumbersome and duplicates existing procedures.

Ok thanks.

Kenny




.

  #4  
Old July 19th, 2004, 08:06 AM
external usenet poster
 
Posts: n/a
Default Refreshing data

Ok thanks. I actually came right with the on activate event.

I was just silly......I had actually duplicated the code under 2 different
events rather that in one procedure that could be called.

Anyway....thanks.

Kenny
"tina" wrote in message
...
run the calculations from the form's AfterUpdate event, in addition to the
Load event.
i'm not sure what you mean by your Refresh button "duplicates existing
procedures". did you write the calculations code directly into the Load
event? if so, you should be able to move that code into its' own

procedure.
then you just call the procedure wherever you need it.

hth


Kenny wrote in message ...
Hi guys,

I have a little database that has a form that operates as a main menu.

This
menu opens a form that allows the user to enter data. It does certain
calculations and displays a summary of critical data in a box on the one
side. The calculations are done by a procedure in the form's load event.

How
can I refresh, or update, these calculations after data has been added.

I have managed to do it manually by adding a refresh button and running

the
calculations procedure when this button is pushed, but this seems to be
cumbersome and duplicates existing procedures.

Ok thanks.

Kenny








 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie? Do I use Report or Query John Egan New Users 11 June 28th, 2004 08:31 PM
Refreshing data in Excel from a SQL DB Paul D Worksheet Functions 4 June 15th, 2004 09:39 AM
Having both the date and total of series data displayed underthe data Jon Peltier Charts and Charting 0 April 14th, 2004 08:39 PM
How to graph adjacent data in column? bmacwilliams Charts and Charting 1 December 17th, 2003 01:39 AM


All times are GMT +1. The time now is 04:50 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.