I know that you can make a cross tab query and get the fields as headers but
it makes the form or datasheet unusable, ie cant add any data in the
resulting fields. Is there a way of making a table with fields, from another
table, that can then be used as headers so you can use the resulting fields
for data entry. I only need this for forward planning and the data entered
would be changed regularly, but not continually added to. I also would like
to be able to change the headers occassionly without having to go behind the
scenes, so to speak, to do that. ie from the users perspective.
Hope can understand what i am alluding to here!
Thanks for any help.
1  1419 
You can do change the header of the fields by changing the Caption op the
field.
If you using the caption of a field as header text, you can change the
caption in the report.
In the report you have to write VBA code under the event "By printing".
There you have to open a table and some coding to change the caption.
Example
me.Field_x.capt ion = Rst1.Field_x
The content of Field_x from record set 1 will be placed in the caption of
Fieled_x from the printed table.
I hope this will help you little.
Regards,
Simon
"John M" <jo*****@bigpon d.com> schreef in bericht
news:xx******** ******@news-server.bigpond. net.au... I know that you can make a cross tab query and get the fields as headers
but it makes the form or datasheet unusable, ie cant add any data in the
resulting fields. Is there a way of making a table with fields, from
another table, that can then be used as headers so you can use the resulting
fields for data entry. I only need this for forward planning and the data entered
would be changed regularly, but not continually added to. I also would
like to be able to change the headers occassionly without having to go behind
the scenes, so to speak, to do that. ie from the users perspective.
Hope can understand what i am alluding to here!
Thanks for any help.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: googleboy |
last post by:
I didn't think this would be as difficult as it now seems to me.
I am reading in a csv file that documents a bunch of different info on
about 200 books, such as title, author, publisher, isbn, date and
several other bits of info too.
I can do a simple sort over the first field (title as it turns out),
and that is fine as far as it gets:
|
by: ramas |
last post by:
Hi,
I am new to PHP scripting and i am trying to connect to a soap server
(as mentioned below) using the SOAP extension comesup with PHP. Now my
requirement is to add my HTTP header fields along with my SOAP request,
so that the SOAP server will receive it and does some high level
processing. Is it possible to add our own HTTP header fields in PHP?
If i use the header() function to add the field into the HTTP header
and it neither...
|
by: thebit |
last post by:
Hello,
How is it possible to update the field properties that have been
inserted into the header and footer of a MS Word document.
myolAppDoc.Fields.Update only seems to update the properties inside
the body of the document.
Would there be any specific differences if the document had been
sectioned (i.e. different headers/footers for each section).
|
by: Carsten Hansen |
last post by:
Suppose I'm using an implementation where an int is 16 bits.
In the program below, what function is called in the first case,
and what is called in the second case?
Also, if there is a difference between C89 and C99, I would
like to know.
I have tried with different compilers, and I see some differences.
Before I file a bug report with my C vendor, I would like to
know what the correct behavior is.
struct S
|
by: Flanman |
last post by:
I have an ASP web form that I want to populate fields based on the first
field choice. Example I have 4 fields item, price, delivery, availability. I
have all these items setup in an access table. When a user chooses an option
from the item drop down, the price, delivery, availability will then
populate. I have already made my connection to the database, and created the
drop down for field one from the choices. How do I now populate the...
| | |
by: =?Utf-8?B?U2FtZWVrc2hh?= |
last post by:
Hi,
I want to write a simple .net program to open a URL, fill in fields, and
click on a button to submit it using .net 1.1 framework.
Can someone help in suggesting the libraries I should use?
I tried using javascript, however, I am not able to make javascript wait for
the page to completely load, before trying to access and fill fields on the
page. Hence resorted to .net, but not finding the right library to use.
|
by: KNN |
last post by:
I have created a report in access 2003 using a query. Used some of
the fields to display under page header. Used others to display under
group headers and used the remaining under detailed section.
When I export the report using excel format, work sheet includes a
header row with names of all the fields used, but data for only those
fields appearing in the detailed section.
Is it possible to export data from all the fileds used in...
|
by: Ken Newman |
last post by:
I have a SOAP Header that has different XML fields in the request and response.
I instantiate one Header class for the Request and Response SOAP Header and using XmlIgnoreAttribute and bool fields to activate/de-activate the XML tags that are included or absent in each Instance.
My problem is how to declare the SOAP Header in the Web Reference file to support unique classes for the inbound and outbound SOAP Headers. When the wsdl was...
|
by: johnporter123 |
last post by:
Does anyone have a method of importing a large "FLAT" CSV file into access. The file has well over 255 columns (Fields). Before anyone flames me over normalization, I do not have access to the source DB for the file and the CSV file has the data I need, but it is buried in this huge text file output from another Compan'y database. The purpose of getting it into Access is so that I can adjust it to 1st normal form, and recompute the tables in...
|
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: 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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
