Need HELP in Reporting

[davies107]

i am using this database sample by John Big Booty :

http://www.access-programmers.co.uk/forums/showthread.php?t=188663

i need help on how to create report/s in this sample.

i created a report template already (with a command button) but whenever i click the report/print button everything will print, i wanted the report to print to a specific searched item only : example is Australian wine, will only print wine from Australia not the entire database.

and is it possible that ill have a preview report button that will preview the record before printing? much better if its in Excel format.

any help is highly appreacited. thanks!

 

[John Big Booty]

Sorry It's taken me a while to get round to this.

But I think the attached should demonstrate a method of doing what you are after.

 

[John Big Booty]

Added a couple of extra Report Buttons

 

[davies107]

John, YOU are the BEST. i dont know how to thank you.

 

[davies107]

John, again, im having a problem with your database ... i posted a problem about database lagging or slowing down in searching an item ( http://www.access-programmers.co.uk/forums/showthread.php?p=1197259#post1197259 ) but no one replied yet. whenever i search for an item using your database it has CALCULATING in the lower left portion of the screen, it has a loop that calculates all the input while searching, maybe thats the reason why the database is slowing down in giving results or its blinking... i have read in other post:

http://www.access-programmers.co.uk/forums/showthread.php?t=146336

namliam said LIKE (in the Query) function is slow... my question is, are there any functions aside from LIKE? because i believe this command is the reason why it has CALCULATING, without putting it the database is faster BUT i need LIKE or other function because its what i use to locate the columns or assigned value to a specific box.

i hope you get me, im not really good in explaining.

thanks.

 

[John Big Booty]

Sorry, I'm not sure why your DB would be slow searching. You could make sure that all the fields you are searching on are indexed.

I can't see any other way of creating a dynamic search with out using the Like criteria.

 

[davies107]

maybe because of the calculation? not sure though. your database sample has no calculation (i guess) - its mainly for searching only but though it doesnt have it even appears the CALCULATING... i made some testing and came up a conclusion that the LIKE (in query) make it slower.

thanks for the link. will try to read this now.

 

[John Big Booty]

I guess if you are doing calculations in the query that would certainly slow things up as it would be recalculating on every Key Stroke.

 

[davies107]

yes thats my problem. i read in an article about Access on how to speed up its processess, it says there that instead of having the calculation in the Table put it in the Query, so I tested it. but i guess the speed is the same. thats my problem now. whenever i press a key or a letter while searching for an item it starts to blink; that means the database is working it recalculates everything. though its not sooo delayed, its like 1 second only but it is kinda frustrating seeing the database blinks and it is VERY noticeable.

 

[davies107]

Hello John,

My apology that I know its kinda late to react on your previous post here but I just found out that the reporting button you gave me "PREVIEW REPORT CURRENT RESULTS" gives me all the records in the database and not the current results. Example:

Searching for "Australia":

it will only appear records with Australia in it (so obviously number of records will be lessen or fewer), but in your report or sample everything in the database appears in the report.

Thanks.