tags:

views:

18

answers:

1
Q: 

How To Print A Single Record from a Microsoft Access Form into a Report

Hello!

i'm very new to Access and VB, and im about to print a specific record.. but im getting an error with this code: 

Private Sub printEksternAVR_Click()
DoCmd.OpenReport [Report_AVR Ekstern], acViewPreview, , [Report_AVR Ekstern].Rapport_nr = Forms!Form_AVR

End Sub

My reports name is AVR Ekstern, and the prime key is Rapport nr and the form im clicking the button and viewing the record in, is AVR

i think i misunderstood something alon the way, so i really hope someone can help me out here?

A: 
bob-the-destroyer  2010-10-21 08:21:12
okay Thanks alot, i got it to work :P
Ilizane  2010-10-21 08:26:53
oh, btw, is there any way to "force" my report to print out the "layout" wven if the fields are empty, like in if i only filed some of the data but not all, it would stil print out my supreports? i have liek one report, which is allways there.. and 8-9 supreports where they not allways will be filled, but will be send out to a customer and filled manualy, and the send back ? is there any easy way of doing so? (manualy speaking of a doc,docx,dot,rtf or whatever they can write in - as NOT in pdf)
Ilizane  2010-10-21 08:30:40
You mean if there's no data in those subreports, instead print empty boxes in place of all fields? A certain control property comes to mind, but I can't think of it at the moment and I'm not near my windows machine to test it. Not sure.
bob-the-destroyer  2010-10-21 09:05:06

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL