Hi,
I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.
FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.
TIA,
Brian
2  4265 
On 3 Aug 2006 12:39:17 -0700, "gh****@gmail.c om" <gh****@gmail.c om>
wrote:
>Hi,
I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.
Create a Report, with the fields laid out in whatever format you wish.
>FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.
Simply create an ad-hoc query, and base your report on that query.
Does the subform have different FIELDS - not just different data -
based on the query?
John W. Vinson[MVP]
John,
I had tried your suggestion. Unfortunately, MS Access does not allow
reports that are greater than 22 inches in width. My 50 columns need
the report to be atleast twice as wide.
And no, the fields in the sub-form do not change based on the query.
Only the data changes.
Thanks,
Brian
John Vinson wrote:
On 3 Aug 2006 12:39:17 -0700, "gh****@gmail.c om" <gh****@gmail.c om>
wrote:
Hi,
I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.
Create a Report, with the fields laid out in whatever format you wish.
FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.
Simply create an ad-hoc query, and base your report on that query.
Does the subform have different FIELDS - not just different data -
based on the query?
John W. Vinson[MVP]
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ivan |
last post by:
I have a form (CustomerImfo) that has a subform within it (order). Within
that subform is another subform (OrderDetail). That subform (OrderDetail) is
displayed in Datasheet view. When I am entering customers and their
respective orders, the first order entered is fine with the "tab" field
orders correct. On the second and subsequent orders, when I go from the
Order form to the subform "OrderDetail", the curser goes to the wrong field...
|
by: wayne dooley |
last post by:
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a subform
to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully, except
I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back...
|
by: Matthew Wells |
last post by:
I have a a parent form with a subform. The parent form has two command
buttons to change the subform view to single form view and datasheet view
respectively. I can't seem to get this to work. There is a menu item to
switch to datasheet view, but it won't go back to form view. The only way I
see so far is to open the subform by itself in design view, change the
default view, save & close, then set the sourceobject property in the main...
|
by: Richard Sherratt |
last post by:
I added a new field to a table in the tables database. In the code
database, I added a new column for the new field to a datasheet
subform. I opened it in datasheet view and moved the column to the
position I wanted it. No records are returned by the form's query (it
has a "Where ID = -1" clause and the GoToRecord proc on the main form
changes the subform's recordsource).
When I opened the form and started adding data to the subform,...
|
by: Smartin |
last post by:
Using Access 97
I am trying to create a form that allows for user entry of search terms
and displays a table of results. I thought I could accomplish this using
a subform but it isn't quite doing what I want it to do.
What I have so far:
Fields to enter search terms
Subform bound to a query
| | |
by: Ken Mylar |
last post by:
First a quick background on the form:
I have a form that is normally viewed in Single form mode. It has a
subform on it that is in datasheet view. The main form is for work
orders and the subform is for parts used on the work order. On the main
form I have a LaborTotal (from main form), PartsTotal (from subform)
and TotalCost (which is Labor + Parts). All works fine as is.
Now to the question:
I have a button on my main form to browse...
|
by: Don Do |
last post by:
Help
I built a form/subform/subsubform setup using the access forms
wizard. I have a table1 = parent, table2 = child, table3 =
(grandchild?). There will be multiple records in table2 that tie to
table1, and multiple records in table 3 that tie to table2. Both on
"1 to many" joins.
Each of the forms are bound to the fields in the respective tables.
The subform & subsubform are datasheet view. When I enter any data, I
|
by: Christina123 |
last post by:
Currently working with Microsoft Office 2000 and whatever version of Access came with that.
I am developing a database to track the comings and goings of shared tools.
Everything works splendidly except I have printing issues, primarily I have no idea what I am doing.
I have a form that contains the date and the info of the person doing the ordering as well as a subform that has the serial number of the part, the description and storage...
|
by: sconard |
last post by:
I have a subform in datasheet view that is the result of a complex vba custom query with a number of parameters. I would like to place a button on the parent form to print the datasheet view as a report or generate a report from recordset that created the datasheet view. I do not see the ability to create a report from a form. How is this best achieved?
Thank You
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
