473,669 Members | 2,480 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to add two command in detail section of datareport

1 New Member
my shabpe String is given below
but it is not working
Expand|Select|Wrap|Line Numbers
  1. sqlw = "SHAPE {SELECT * FROM labour_main}" _
  2.             & " AS RsMain APPEND ({SELECT * FROM labour_child1}" _
  3.             & " AS RsFamily RELATE reg_no TO reg_no) AS RsFamily," _
  4.             & "({SELECT * FROM labour_child2}  AS RsReg" _
  5.             & " RELATE reg_no TO reg_no) AS RsReg"
  6.  
  7. and code of report is
  8. Private Sub SetSection1()
  9.     Sections("Section1").Controls("TEXT2").DataMember = "RsFamily"
  10.     Sections("Section1").Controls("TEXT17").DataMember = "RsFamily"
  11.     Sections("Section1").Controls("TEXT18").DataMember = "RsFamily"
  12.  
  13.     Sections("Section1").Controls("text2").DataField = "relation"
  14.     Sections("Section1").Controls("text17").DataField = "name"
  15.     Sections("Section1").Controls("text18").DataField = "age"
  16.  
  17.  
  18.     Sections("Section1").Controls("TEXT19").DataMember = "RsReg"
  19.     Sections("Section1").Controls("TEXT20").DataMember = "RsReg"
  20.     Sections("Section1").Controls("TEXT21").DataMember = "RsReg"
  21.     Sections("Section1").Controls("TEXT22").DataMember = "RsReg"
  22.     Sections("Section1").Controls("TEXT3").DataMember = "RsReg"
  23.  
  24.  
  25.  
  26.     Sections("Section1").Controls("TEXT19").DataField = "reg_date"
  27.     Sections("Section1").Controls("TEXT20").DataField = "bank_cash"
  28.     Sections("Section1").Controls("TEXT3").DataField = "amount"
  29.     Sections("Section1").Controls("TEXT21").DataField = "bill_no"
  30.     Sections("Section1").Controls("TEXT22").DataField = "payment_mode"
  31. end sub
  32.  
  33.  
Jan 23 '12 #1
1 1464
Mihail
759 Contributor
I am not an expert, so I can't be sure, but... what is the SHAPE word in the SELECT clause of SQLW ?
Jan 24 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
15038
by: dixie | last post by:
I know I've asked this question in the last week, but no matter how hard I look, I can't find it. So I'll type it again. Is it possible to set the height of the detail section of a report using vba? I want to be able to set the height in a table and have the detail section adjust to that height, no matter what it is really set to. Is that feasible, or is it no. If so, what is the syntax for setting the height of the detail section of...
2
1759
by: Vinayak Shanbhag via AccessMonster.com | last post by:
Hi, I have the following problem ------------------------------------ I am displaying the multiple records in MS Access Detail Section. Each row has Command Button called "Store". I need to enable or disable this button based on the status of the record that is avaibale in the field called "Status" in the same row. Ho do I do this To summarize the above problem Detail Section =============== Row1 >> Field1 Field2 Field3 <Store>...
1
5757
by: Tom | last post by:
In the Developers Handbook, Getz provides a way to create a survey report that displays either a line, Yes/No or multiple choice for each question. It's done by placing three controls (one for each type of answer) in the report's detail section and then making the control appropriate for each question visible in the Format event of the detail section. Can this be simulated in a form? There's no Detail Format event for a form but can it be...
4
1599
by: Lyle Fairfield | last post by:
I had a Sproc which returned a field called Details. I had the Form Wizard create a continuous form with the Sproc as the RecordSource (as a shell for me to modify). I renamed the Details textbox to txtDetails. Except I didn't. I grabbed DETAIL from the pulldown and renamed it to TxtDetail.
4
5923
by: 2D Rick | last post by:
In Access2003 and XP. My forms detail section hides behind the header when I scroll down to see controls off screen. This is similar to freezing a pane in Excel. I'd rather this did not happen but can't find the property that controls this. When the form first opens some of the controls are behind the header and scrolling is required to see them. Help, thanks, RICK
4
3152
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates hundreds (perhaps even an infinite loop...I have to break the system to stop the report generating) of pages. While I'm not 100% I think this may have something to do with the detail
2
4080
by: trgpham | last post by:
hi, I have a few records displayed in the Detail section of the continuous form, and a line of comment at the bottom of the screen in the Form Footer section. However there is a wide gap between the last record in the Detail section and the comment textbox in the Form Footer. How can I make the Form Footer section displaying just after the last record in the Detail section? Thanks in advance!
10
11748
by: sara | last post by:
Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines. It seems the simplest thing is to run the code (see below) once with the detail section showing, and a second time hiding the detail section. I can't figure out the code to do that and don't see it posted.
7
13381
by: NJonge01 | last post by:
Hi, I'd like to produce a report that basically looks like an excel printout. Description: Profile Print Report Detail Section with 3 bordered text boxes all text boxes are 'abutted' against each other (where one ends, the next begins) all text boxes have the 'can grow' property set to yes. Detail Section with 'can grown' = yes
2
4440
by: emckesso | last post by:
Hello, I need to create conditional formatting of a text box in the detail section of a report. The formatting is based on multiple parameters that are stored in a query. For example, pretend that = 50%, = 80%, and = 90%. I will check in the report against (from the query, but currently stored in a text box on the report via a Dlookup - textbox name is still ). If is less than then I want to compare the value of (another report...
0
8465
marktang
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...
0
8383
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,...
0
8658
tracyyun
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...
0
7407
agi2029
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6210
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5682
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();...
0
4206
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...
0
4386
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2032
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.