on current in report? - Microsoft Access / VBA

bbdata

what would be an equivalent of OnCurrent event/Forms , in detail
section of the Report?
i have a subreport with just one (visible)field, bounded to a query.
subreport is in detail section of main report. i want to display all
the records in the query if the value of field X in main report is 1,
and just one record from the query ( with an invisible field in
sbReport set to 2), in any other case.
can i change recordsource for subReport for every record in Main
Report?

Nov 13 '05 #1

Subscribe Reply

2340

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The equivalent to OnCurrent event is the section's Print and Format
events.

I don't believe you can change the Recordsource of a subreport while the
report is running. You can link the subreport to the main report by the
Link Child/Master Fields properties. Read the Access Help article
"About subreports" for more info. Help Contents hierarchy is (Acc
2002):

Reports and Report Snapshots
Advanced Reports
Subreports
About subreports

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkHH2YechKq OuFEgEQLwygCgjY x5SQTvAojAwWMkl 4mW8y6dv8gAoNO5
t4aAof7T+Z+J1Na YCEDidzYG
=yAHW
-----END PGP SIGNATURE-----
bbdata wrote:

what would be an equivalent of OnCurrent event/Forms , in detail
section of the Report?
i have a subreport with just one (visible)field, bounded to a query.
subreport is in detail section of main report. i want to display all
the records in the query if the value of field X in main report is 1,
and just one record from the query ( with an invisible field in
sbReport set to 2), in any other case.
can i change recordsource for subReport for every record in Main
Report?

Nov 13 '05 #2

lesperancer

but you can have 2 subreports linked to your report and make one or the
other visible

Nov 13 '05 #3

bbdata

le*********@nat pro.com wrote in message news:<11******* *************** @l41g2000cwc.go oglegroups.com> ...

but you can have 2 subreports linked to your report and make one or the
other visible

ok im trying that right now and its not working well.
it is switching to not visible, but for ALL records.

is there any way you can manipulate ANY property of the control( field
)in detail section of the subreport, based on the value of any other
control in that same section in the subreport, or in the main report?

description: i have report which should list all active deals. one of
the fields is VendorName. deal can have multiple vendorNames, so i'm
usig subform to print all of them.
problem is, some of the deals have a Contract assigned to only ONE of
the vendors. in that case, i dont want to print all of the listed
vendors, just that one with the Contract assigned.

so theres another subreport, which pulls out just vendors with
contracts.

what was i doing, i was checking the value of contract flag in
subreport for
vendors with contracts, and if its flagged, i set the other subreport
-all vendors- , to not visible. checking in detail_format event of
subform.

that sets subreport to not visible in ALL of the records, regardless
of contract flag, if any of the deals has a vendor with a contract.

same thing if i set just one field on subreport to not visible.

any workaround?

Nov 13 '05 #4

Similar topics

8814

Select current record ability

by: Tony | last post by:

I have a form in access that has 5 fields for a certain record: 1)Date mailed, 2)Date received, 3)Date completed 4)Foreign Content amount and 5)record number. If the foreign content (FC)is >15% of the invoice amount (inv amt.on another form) then I want a my report to run automatically for the record I am on in the current EC Input form when I enter in the foreign content amount. I have a query built for the report. Currently, when the...

Microsoft Access / VBA

4580

Query current record

by: Michael Israel | last post by:

I am new to Access. I have a form with a single record. The keyed field is PropID (number). I want to run a query from the form that will have the current value of PropID be the variable in the criteria of the query. The intent being the query returns the values of the current record of the form for a report. So, I want to code a pushbutton to run that query with the current keyed field value as the criteria and then open a report...

Microsoft Access / VBA

7249

Print report based on current record

by: Rosy | last post by:

I am attempting to use the following code to print a report based on the current record in the form. Users bring up the record with a parameter box and then can make changes to the sub-form on the main form (main form is locked). I use this same code for another form/report and it works. The only difference is the parameter. The one that works opens to all records and then the user uses the filter by form. I don't want them to do that...

Microsoft Access / VBA

5476

More than one CURRENT TIMESTAMP in a PROCEDURE

by: Brian Tkatch | last post by:

I have a PROCEDURE that test other PROCEDUREs. Timings_Call ------------------ Id Group Name Text Timings_Log

DB2 Database

2051

Make a Report Display the Current Record in a Form

by: ZinksInk | last post by:

How do I make a report display the current record open in a form? This seems like it should be a simple issue however I am strugling to figure out what code SQL / Querry I should use to do this. I have orders for skylights orginized by invoice. As we track production different reports need to be printed out. I want to beable to click on my report such as "Print Welding Tag" and have this insert the current Invoice number to the report. ...

Microsoft Access / VBA

3451

Report the current filtered records from a Form

by: melnhed | last post by:

---Report the current filtered records from a Form--- Hello All, I've seen this topic discussed before, but the solution described then doesn't work in my particular case. My Config: Access 2002 front-end using SQL Server 2000 (MSDE actually) via ADP/ADE Access Data Project.

Microsoft Access / VBA

3039

Report the current filtered records from a Form (in an ADP project)

by: radio1 | last post by:

---Report the current filtered records from a Form (in an ADP project)--- Hello All, I've seen this topic discussed before, but the solution described then doesn't work in my particular case. My Config: Access 2002 front-end using SQL Server 2000 (MSDE actually) via ADP/ADE Access Data Project. I have a form (containing about 80 fields) on which I allow the user to apply field/form filters -- this works fine.

Microsoft Access / VBA

4333

Repeat value of previous record field into current corresponding field

by: roveagh1 | last post by:

Hi I've been using the 2 year old link below to repeat values from previous record field into current corresponding field. It's worked fine for text but the last piece of advice was to use the same logic for a date field. i.e. theValue.defaultvalue = "#" & theValue.value & "#" I can't get this to work for some reason and I can't figure out why. Can anyone out there help? Thanks Repeat value of previous record field into current...

Visual Basic 4 / 5 / 6

45958

Open report based on current record...

by: magmike | last post by:

I've created a report for the purpose of printing a one page summary of a record. Of course, when I created the report, it gives me a page on every record. Can I create a button to open that report with just the results of that current record? And how do I modify the report to accept the buttons command? Thanks!

Microsoft Access / VBA

2145

E-mailing current record on form

by: easydoesit | last post by:

Hello all, I am looking for a way to be able to enter data into fields on a form, then be able to e-mail a report that shows only that record. This is what I have thus far: At the end of my Form, I have a Command Button. Right now the Command Button has an On Click... to basically E-mail a Report. Here is my Visual Basic code for it:

Microsoft Access / VBA

8330

Changing the language in Windows 10

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,...

Windows Server

8850

Problem With Comparison Operator <=> in G++

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...

C / C++

8746

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

8626

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7355

AI Job Threat for Devs

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...

Career Advice

6178

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5649

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4175

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4334

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET