Search results

I have a report with multiple lines in the detail area and I put some code in the on format section to put the line in gray if a certain condition is meet. So, I can have a gray line, some white lines and another gray line. Now, I would like to do the same thing with a sub-form. My form is a...

I see what you were saying but I can't use this solution cause I need the sum of the page and you can't have a sum in the footer

No, why would I set it to no ?

My only problem with Pat's first solution is that when I have let's say 25 lines, the last 5 lines go to the next page which is good. But on that next page, there's not enough data to fill the whole page. So, all the sums goes up to the middle of the page. But I've made a solution that is...

There's nothing wrong with Pat's suggestion. Except I must code some VBA and I'm the only one here doing VBA and I'm leaving the company for a couple of months soon. So no one will be able to support the db after I leave. But I think I can make some simple enough codes so it will be easily learn.

It's a good idea but how can I make a query that returns only 20 values ?

I can't do that cause everything must be automatic. Each page of the report must be uniform cause it's printing bills.

I would like to know if there's a way to limit the number of line a report show per page. Like, if I have 30 items and I want to see only 20 items per page. Then the total for that page and the next 10 items on another page and the total for only that second page. Is it possible ?

I would like to know if there's a way to send more than one attachement in a e-mail with DoCmd.SendObject ? Right now my code looks like that: DoCmd.SendObject acReport, Attachement, "Snapshot Format (*.snp)", EMail, , , Subjet, Text, True But with this code I can only send one report at a...

But it won't give me the empty grid look cause my grid is made with the border of each field

I developped a bill system for my company and everything is working great but now they want the access program to print the bill. The bill is working good but doesn't look very good. My problem is that each bill doesn't have the same amount of item on them. So the bottom section, where the...

Thanks for your help Rich It's such an obvious and easy way to do it I don't know why I didn't tough about it myself I guest sometimes you have it and sometimes you don't :cool: JC

I would like to know if there's a way to always make sure certain fields will be in a dynamic query ? Like, I have a dynamic query which list the transactions a client made during a certain period. The column header is the month of the transaction and the value is the volume in that month. So...

PearGI: The flaw is if it's a linked table the attributes is not zero and it's not hidden.

I'm trying to know if a table is hidden in my code but the attributes value is not set to 1 for hidden even when the table is hidden. I check it like this: If dbRecherche.TableDefs(i).Attributes = dbHiddenObject Then But it doesn't work, no table has the dbHiddenObject attribute. When I try to...

Hi everybody, I have a new challenge for you since I received a quick and good answer last time. In the same BD where I have a list of all the BD on a drive and everything in the BD (Like the tables, forms, ...), I would like to make a form that shows the result kinda like the main window of...

Your right, my bad I was writing DoEvent with no 's', no wonder it was not working... I don't even know why I wrote it wrong, I'm always using it in VB. Thanks again for the reminder.

DoEvent is not a function VBA has, I don't know if you can call it with an external librarie. Anyway, I've found a way to do it with a simple VBA function: DoCmd.RepaintObject acForm, "FormSearch" It's not elegant but it works.

Hi I've made a code that scan a specific drive retrieve every access database path on this drive to a table. Since the drive is quite big, the code takes some time to execute. So I created a form to show the progress to the user saying something like "Current BD: 17/265" but when I change the...

Check to make sure your joins are ok. Look in your tables to see if every items as a link on the other tables. Take one of the item which is not returned by your query and verify if he is linked in every tables in the select.