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

New Record



 
 
Thread Tools Display Modes
  #1  
Old May 10th, 2010, 04:15 PM posted to microsoft.public.access
desertbird
external usenet poster
 
Posts: 3
Default New Record

I have a simple form created on "Transfer#" table that has a Order#, Date,
Total$.

My users enter the Order# then press a button that updates the Date and
Total$ on the "Transfer#" table and then prints a report of Order from the
"Transfer#" table. The Date and Total$ are pulled/queried and updated from
another table.

The records do not update until my user is on a new record in the form.

How can I get the Date and Total$ to update while the user is still on the
current record they just entered?
  #2  
Old May 10th, 2010, 04:37 PM posted to microsoft.public.access
Dorian
external usenet poster
 
Posts: 542
Default New Record

Try:
If Me.dirty then me.dirty = false
This should force update of the current record.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"desertbird" wrote:

I have a simple form created on "Transfer#" table that has a Order#, Date,
Total$.

My users enter the Order# then press a button that updates the Date and
Total$ on the "Transfer#" table and then prints a report of Order from the
"Transfer#" table. The Date and Total$ are pulled/queried and updated from
another table.

The records do not update until my user is on a new record in the form.

How can I get the Date and Total$ to update while the user is still on the
current record they just entered?

  #3  
Old May 10th, 2010, 04:39 PM posted to microsoft.public.access
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default New Record

desertbird,
Do a
Refresh
in your button code after you've updated the field values.
That will force the values to be written to your table, just before the
report is opened.

Also, I would suggest not using any special chgaracters in your object
names... such as Order#, or Total$, and Transfer#. These characters have
meaning in Access, and while always "bracketing" might prevent a problem,
it's best to avoid them altogether.
Also, make Total a bit more meaningful...
Try OrderNo or OrderNum... or SalesTotal or CashTotal... or
TransferNo... etc...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"desertbird" wrote in message
...
I have a simple form created on "Transfer#" table that has a Order#, Date,
Total$.

My users enter the Order# then press a button that updates the Date and
Total$ on the "Transfer#" table and then prints a report of Order from the
"Transfer#" table. The Date and Total$ are pulled/queried and updated
from
another table.

The records do not update until my user is on a new record in the form.

How can I get the Date and Total$ to update while the user is still on the
current record they just entered?



  #4  
Old May 10th, 2010, 04:53 PM posted to microsoft.public.access
desertbird
external usenet poster
 
Posts: 3
Default New Record

Thanks for the reply. Where to I put the If statement? I am a very rusty in
Access.

"Dorian" wrote:

Try:
If Me.dirty then me.dirty = false
This should force update of the current record.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"desertbird" wrote:

I have a simple form created on "Transfer#" table that has a Order#, Date,
Total$.

My users enter the Order# then press a button that updates the Date and
Total$ on the "Transfer#" table and then prints a report of Order from the
"Transfer#" table. The Date and Total$ are pulled/queried and updated from
another table.

The records do not update until my user is on a new record in the form.

How can I get the Date and Total$ to update while the user is still on the
current record they just entered?

  #5  
Old May 10th, 2010, 06:55 PM posted to microsoft.public.access
desertbird
external usenet poster
 
Posts: 3
Default New Record

Thank You for all the tips and suggestions!



"Al Campagna" wrote:

desertbird,
Do a
Refresh
in your button code after you've updated the field values.
That will force the values to be written to your table, just before the
report is opened.

Also, I would suggest not using any special chgaracters in your object
names... such as Order#, or Total$, and Transfer#. These characters have
meaning in Access, and while always "bracketing" might prevent a problem,
it's best to avoid them altogether.
Also, make Total a bit more meaningful...
Try OrderNo or OrderNum... or SalesTotal or CashTotal... or
TransferNo... etc...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"desertbird" wrote in message
...
I have a simple form created on "Transfer#" table that has a Order#, Date,
Total$.

My users enter the Order# then press a button that updates the Date and
Total$ on the "Transfer#" table and then prints a report of Order from the
"Transfer#" table. The Date and Total$ are pulled/queried and updated
from
another table.

The records do not update until my user is on a new record in the form.

How can I get the Date and Total$ to update while the user is still on the
current record they just entered?



.

 




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 07:38 AM.


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