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.D efaultValue = """" & 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.OpenRepor t "Load Sheet", acPreview, , "[Load_ID]= " & "'" &
Me![Load_ID] & "'"
to print my Load Sheet from the subform.
Any information would be appreciated.
Thanks,
Chad 5 2440
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********@hot mail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.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.D efaultValue = """" & 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.OpenRepor t "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.OpenRepor t "Load Sheet", acPreview, , "[Load_ID]= '" &
Me.Parent.Form![Load_ID] & "'"
HTH,
Bruce
Thanks for the information. That worked great.
Chad
<br***@aristotl e.net> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.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.D efaultValue = """" & 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.OpenRepor t "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.OpenRepor t "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 line page header,
three lines of detail (name address etc)and a footer.
On previewing or printing the report it inserts a blank three line
detail...
|
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 report. I've tried experimenting
with the Can Shrink property to no avail. Any tips on eliminating blank
lines the right way would be much...
|
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 length, when i try to move my
cursor there,it will not allow me to move the cursor in that blank
space.
I noticed this problem appears only when the...
|
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 dotted line around
them so the receptionist can easily cut them out. The report is setup with
columns so that 6 columns fit across a page. 12...
|
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 character, not at the left margin) Now press Enter.
It does insert a blank line, but it also moves your cursor 6 characters to
the right, so that it is no...
| |
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 the field and click my mouse on it
the cursor is just after the "I" in "HI"... that is, no blanks were added
to the field. However, when I create an...
|
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 a database which I need to examine. This user is able
design/preview all reports on a certain database.
When I copy the database to my machine, I...
|
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 source
I mean long or short in detail section is vary.
The problem is, when the detail is more than 25 line
it will give blank area below the...
|
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, which has the final total of the running sum box in it. I am setting the txtTotal box to store the Nz value of the running sum, so if it is null,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |