473,387 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Preivewing selected records in a report

hello all!!!!
i have a program of voucher entry....
there are many records in the table Payment and voc_no is a primary key and auto numbered...
now i want only selected records to appear in my report....
like voc_no 1,4,6 on one day
or 7,8,11 on the other....
how should i do that....plz help me out with my query
May 4 '07 #1
7 1484
Rabbit
12,516 Expert Mod 8TB
How do you determine which ones to view? Does it follow some algorithm or is it up to the user?
May 4 '07 #2
How do you determine which ones to view? Does it follow some algorithm or is it up to the user?
it is upto the user which record to view.... for the time being i am using Between command in my query but that will display all records from X to Y...
i dont want that....
plz guide me if there is a solution to it....
i will be very greatful
May 5 '07 #3
Rabbit
12,516 Expert Mod 8TB
One way would be to have a checkbox in your table so that they can check which ones you want to print, then you can just query for those.
May 5 '07 #4
One way would be to have a checkbox in your table so that they can check which ones you want to print, then you can just query for those.
Isnt there any other option where the user types the record number and it previews the report
May 6 '07 #5
Rabbit
12,516 Expert Mod 8TB
Isnt there any other option where the user types the record number and it previews the report
There is, you'll need to write a sub or procedure that will takes a string in a defined structure and then write a filter statement by breaking down the string to find out which records they want.
May 6 '07 #6
There is, you'll need to write a sub or procedure that will takes a string in a defined structure and then write a filter statement by breaking down the string to find out which records they want.
well i am sorry to ask this but can u plz tell me how will i write the code as i cant figure it out.
May 8 '07 #7
Rabbit
12,516 Expert Mod 8TB
If you have no VBA experience then you'll want to take a look at this tutorial.

If you have experience, then the easiest thing would be to have them enter the records in a strictly defined format. I recommend comma delineated for ease. But I suppose you can use any other delimiter but you'll just have to use replace() to change them to commas. After that it's just a matter of opening the report using the WhereCondition parameter built with In () and the string.
May 8 '07 #8

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

Similar topics

1
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...
2
by: Geir Baardsen | last post by:
Hi! From a listbox I'd like to send only selected items to a report. Items will include: OrderNr,Date,EmployeeNr from tblOrders ZipCode,City from tblZipCodes Name,Adr,ZipID from...
2
by: indrag91 | last post by:
hai, i am using access database. Iam selecting few records based on a condition. For e:g select * from stud where avg>90 and placing these records in a multiselect list box. for e:g if there 10...
2
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...
3
by: wvmbark | last post by:
First time poster... I just found this forum and it appears there's plenty of people here that could make short work of problem that's been driving me absolutely bonkers for months. Every day we...
7
by: KiwiGenie | last post by:
I have a form which lists selected records, there could be anything from 1 record to all records selected. I want to output a report for each record as HTML. I want each file to take its name from a...
1
by: Doug | last post by:
What is the simplest way to make a report where only the records where a field matches a certain date are included, and the user first selects that date (from form or popup)? (I can write the SQL...
5
by: Andrew Meador | last post by:
I have a form (Change Card List by Status) with a check box (cboNOT) and a list box (lstStatus). There is an Open Report button that opens a report (Report - Change Card List) which uses a query...
7
by: Evanescent | last post by:
Hi guys, as the title suggests, I'm facing some problems with the report. I have a form (createInvoiceForm) whereby the user can enter the invoice's details and then click on the Add New Record...
0
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,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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$) { } ...
0
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...
0
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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,...
0
Oralloy
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,...
0
jinu1996
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...

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.