Printing dirty records

H

Helen

Hi there!
I have an order form where I select which part numbers to
order, and how many I'm ordering. Then I go to a
PackingSlip form where I enter how much each part costs
and how many I'm shipping.

When I finish entering the PackingSlip information, I want
to be able to print that OrderID, so my print button macro
is set up to print rptPackingSlip where OrderID = [forms]!
[PackingSlip]![OrderID].

The problem is that the last row that I enter into my
PackingSlip form doesn't show up on the report with the
new PackingSlip information -- it only shows me the part
and quantity ordered.

I tried adding a SAVE button to each row, and also to the
entire form, but neither of these solved the problem. I
also tried adding a Save action in my macro, but to no
avail.

I think these records are "dirty" and I posted this same
problem in the Forms Programming Newsgroup, and the answer
I received was to set up a If dirty=true, then dirty =
false code at the beginning of my code, but since I'm
doing this in a macro, and have NO EXPERIENCE WHATSOEVER
in coding, I don't know how to translate that into a macro.

Can someone out there please help me?
Thank you!!!
Helen
 
S

Steve Schapel

Helen,

The Save macro action refers to the database object, and is nothing to
do with the data. Instead, use a RunCommand action, with the Command
set to SaveRecord.
 
H

Helen

Did I happen to mention that you're my hero?
Thanks again,
Helen
-----Original Message-----
Helen,

The Save macro action refers to the database object, and is nothing to
do with the data. Instead, use a RunCommand action, with the Command
set to SaveRecord.

--
Steve Schapel, Microsoft Access MVP
Hi there!
I have an order form where I select which part numbers to
order, and how many I'm ordering. Then I go to a
PackingSlip form where I enter how much each part costs
and how many I'm shipping.

When I finish entering the PackingSlip information, I want
to be able to print that OrderID, so my print button macro
is set up to print rptPackingSlip where OrderID = [forms]!
[PackingSlip]![OrderID].

The problem is that the last row that I enter into my
PackingSlip form doesn't show up on the report with the
new PackingSlip information -- it only shows me the part
and quantity ordered.

I tried adding a SAVE button to each row, and also to the
entire form, but neither of these solved the problem. I
also tried adding a Save action in my macro, but to no
avail.

I think these records are "dirty" and I posted this same
problem in the Forms Programming Newsgroup, and the answer
I received was to set up a If dirty=true, then dirty =
false code at the beginning of my code, but since I'm
doing this in a macro, and have NO EXPERIENCE WHATSOEVER
in coding, I don't know how to translate that into a macro.

Can someone out there please help me?
Thank you!!!
Helen
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

does this make sense 3
Adding data to MS Access from csv file 0
VBA word change keys 0
Page numbering with Merged Document and IF statements 1
Images are pixelated when saving to PDF 0
Need Help with Macro Security 1
Macro to Select text from a point given to a specific word 2
Getting 'Type mismatch' error after redesigning form 2

Top