Print selected records from combo - Microsoft Access / VBA

I have a mainForm with a subForm
On the main form i have a combo with March 04, April 04 etc, you
select a date and the subform shows all records for the selected date.
I can print a selected record, how ever i want to print all the
records for the month selected.
Can anyone advise please
Regards
DD

Nov 12 '05 #1

Subscribe Post Reply

2171

Larry Linson

It is just a matter of extracting the Year from the date and constructing
the appropriate WHERE clause for the Report's RecordSource. It does require
some VBA.

The Year function extracts the year from a date, for example, try this from
the immediate Window to test.

? Year(#03/15/2002#)

If the records are to be selected from a date field, then you'll have to
extract the Year and put the criteria on that calculated field.

Larry Linson
Microsoft Access MVP

"DD" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...

I have a mainForm with a subForm
On the main form i have a combo with March 04, April 04 etc, you
select a date and the subform shows all records for the selected date.
I can print a selected record, how ever i want to print all the
records for the month selected.
Can anyone advise please
Regards
DD

Nov 12 '05 #2

Similar topics

Print from date selection

by: DD | last post by:

I have a mainform with a subform. The main form as a dropdown box "chooseDate", in the afterupdate event i requery the subform so all records with the same date are viewed. Now i only want to...

Microsoft Access / VBA

Print all records after choose by combobox

by: DD | last post by:

I have frmMain and fsub you choose a month from the ChooseMonth combo and all the records for that month are nopw visible in the fsub I know print with the following Where and only recieve the...

Microsoft Access / VBA

Print Selected records from DropDownBox

by: DD | last post by:

I have a mainform with a subform. > The main form has a dropdown box "chooseMonth", in the afterupdate event > i requery the subform so all records with the same date are viewed. > Now i only want...

Microsoft Access / VBA

Print selected records from combo

by: DD | last post by:

I have a mainForm with a subForm On the main form i have a combo with March 04, April 04 etc, you select a date and the subform shows all records for the selected date. I can print a selected...

Microsoft Access / VBA

Subform won't show data selected from Combo Box

by: Donna Sabol | last post by:

I have a form (frm_MAIN_RPT) that contains a combo box (Combo6) & subform (dbo_REQ_subform). The combo box is used to select the "cost center" data that will be displayed in the subform. From...

Microsoft Access / VBA

How to synchronize current record in the form with value selected in a combobox ?

by: Zlatko Matiæ | last post by:

There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...

Microsoft Access / VBA

Print multiple records from criteria selected from a combo box

by: ndeeley | last post by:

Hello, I need to create a command button to print a report in Preview mode using the criteria from a combo box. The combo box is unbound and holds a list of clients. I need the user to select...

Microsoft Access / VBA

Changing Record using value selected in combo box

by: copewithit | last post by:

Hi all, I'm trying to modify a record (in this case the name associated with the record) to a new name selected by the user in a combo box. Right now I have Single Form with a subform in datasheet...

Microsoft Access / VBA

Print multiple records from a Form into a Report

by: Dave | last post by:

On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++