473,289 Members | 1,945 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Report Blank When Cursor is on Blank Line?

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
Nov 13 '05 #1
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.

Nov 13 '05 #2
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.

Nov 13 '05 #3
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

Nov 13 '05 #4

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

Nov 13 '05 #5
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

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
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...
5
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...
0
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...
3
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...
3
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...
2
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...
12
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...
1
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...
2
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,...
2
isladogs
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...
0
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"....
0
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...
0
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...
0
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 =...
0
isladogs
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...
1
isladogs
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...
0
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...
1
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)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.