My basic question is why does my print report button on my subform print a
blank report when my cursor is on a blank entry line? Here is a more
detailed explanation of my problem.
I have a form that contains shipment destination information and a subform
that contains boxes for that shipment. The main form is a table called
Ship_Info, and the subform is a table called Label_Info. They both contain
and are linked by a field called Load_ID. My report is called "Load Sheet".
I have a button on the subform that prints the records only on that subform
to the "Load Sheet" report. This works great. The subform is a continuous
sheet, so as I add fields, it adds another blank line below to enter another
record. I move from field to field in the form by hitting tab or enter.
When I hit tab or enter, it moves my cursor to the next blank line. If I
hit the "Print Load Sheet" button on the subform while my cursor is in the
blank line, the report is blank. If I move my cursor to the previous
record, the report has all the records on the subform like it should. The
records seem to be savedIs there something I can do so that it will print
the records when I am on the blank line? The records seem to
I am using:
Me!Field_Name.DefaultValue = """" & Me!Field_Name & """"
on a few fields to populate the next field with the same value--if this
makes any difference.
I am using:
DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= " & "'" &
Me![Load_ID] & "'"
to print my Load Sheet from the subform.
Any information would be appreciated.
Thanks,
Chad 5 2411
how about checking whether the line you are currently on is new but not
dirty and then moving to the previous record if it is. Then print.
Sounds good. How exactly do I do that? I need to be able to print while on
the balnk line.
Chad
<pi********@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com... how about checking whether the line you are currently on is new but not dirty and then moving to the previous record if it is. Then print.
Sorry, I should elaborate, I understand the dirty command, but I how to
I move to the previous records? If you have already responded. Ignore
this message.
Thank You,
Chad
ChadDiesel wrote: My basic question is why does my print report button on my subform
print a blank report when my cursor is on a blank entry line? Here is a more
detailed explanation of my problem.
I have a form that contains shipment destination information and a
subform that contains boxes for that shipment. The main form is a table
called Ship_Info, and the subform is a table called Label_Info. They both
contain and are linked by a field called Load_ID. My report is called "Load
Sheet". I have a button on the subform that prints the records only on that
subform to the "Load Sheet" report. This works great. The subform is a
continuous sheet, so as I add fields, it adds another blank line below to enter
another record. I move from field to field in the form by hitting tab or
enter. When I hit tab or enter, it moves my cursor to the next blank line.
If I hit the "Print Load Sheet" button on the subform while my cursor is
in the blank line, the report is blank. If I move my cursor to the previous
record, the report has all the records on the subform like it should.
The records seem to be savedIs there something I can do so that it will
print the records when I am on the blank line? The records seem to
I am using:
Me!Field_Name.DefaultValue = """" & Me!Field_Name & """"
on a few fields to populate the next field with the same value--if
this makes any difference.
I am using:
DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= " & "'" & Me![Load_ID] & "'"
to print my Load Sheet from the subform.
Any information would be appreciated.
When you're on a new record in your subform, [Load_ID] won't have a
value yet and will not have a value until the record is saved. If I
were you I would modify my OpenReport code to use the value of
[Load_ID] from the parent form, e.g.
DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= '" &
Me.Parent.Form![Load_ID] & "'"
HTH,
Bruce
Thanks for the information. That worked great.
Chad
<br***@aristotle.net> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com... ChadDiesel wrote: My basic question is why does my print report button on my subform print a blank report when my cursor is on a blank entry line? Here is a more
detailed explanation of my problem.
I have a form that contains shipment destination information and a subform that contains boxes for that shipment. The main form is a table called Ship_Info, and the subform is a table called Label_Info. They both contain and are linked by a field called Load_ID. My report is called "Load Sheet". I have a button on the subform that prints the records only on that
subform to the "Load Sheet" report. This works great. The subform is a continuous sheet, so as I add fields, it adds another blank line below to enter another record. I move from field to field in the form by hitting tab or enter. When I hit tab or enter, it moves my cursor to the next blank line. If I hit the "Print Load Sheet" button on the subform while my cursor is in the blank line, the report is blank. If I move my cursor to the previous
record, the report has all the records on the subform like it should. The records seem to be savedIs there something I can do so that it will print the records when I am on the blank line? The records seem to
I am using:
Me!Field_Name.DefaultValue = """" & Me!Field_Name & """"
on a few fields to populate the next field with the same value--if this makes any difference.
I am using:
DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= " & "'" & Me![Load_ID] & "'"
to print my Load Sheet from the subform.
Any information would be appreciated.
When you're on a new record in your subform, [Load_ID] won't have a value yet and will not have a value until the record is saved. If I were you I would modify my OpenReport code to use the value of [Load_ID] from the parent form, e.g.
DoCmd.OpenReport "Load Sheet", acPreview, , "[Load_ID]= '" & Me.Parent.Form![Load_ID] & "'"
HTH, Bruce This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bob |
last post by:
Hi,
I am using Access 2000 to print out an address book. I have designed
the report based on a database whose first record is not blank. In the
design there is a one line report header, a onle...
|
by: MX1 |
last post by:
Hi,
I have a report with Name1 and Name2 in the address section . Sometimes,
Name2 is not populated with data via the query that feeds the report.
Unfortunately, the blank line stays in the...
|
by: P K |
last post by:
Hi,
I have an MS Access report which consists of Multiple subreports, when i
export the report to MS RTF format in few cases it leaves a Big blank
space on the sheet which is like 6 inches...
|
by: grlgeek |
last post by:
I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.
I setup a report that will create the labels and put a...
|
by: BradC |
last post by:
I have a big VS 2002/2003 annoyance, and wondering if there is a way to turn
it off:
Put your cursor at the start of an indented line of code inside a function.
(right before the first...
|
by: JohnR |
last post by:
When creating an msAccess db within the Access UI itself the fields that are
text are NOT padded with blanks. For example, if I have a 10 char field and
put in "HI" and then when I come back to...
|
by: mvsguy |
last post by:
I'm an Access noob and apologize if I'm asking a stupid question. The
problem is that I'm unable to design/preview reports on a database.
How do I go about fixing this?
Background -
A user has...
|
by: siomay87 |
last post by:
please help
i have a problem in the ms access reporting,
my report have: page header, detail, page footer and report footer
In listing "detail section", the number of line is depend on the data...
|
by: gazsharpe101 |
last post by:
Hi everyone.
I am working on a report that has a running sum text box throughout the detail section of the report. In the report footer I have a summary in which I have a text box i.e. txtTotal,...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: MeoLessi9 |
last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Aftab Ahmad |
last post by:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
| |