Search results

Hi, I've been away from Access for a while but now I'm back in action :) . Maybe I'm rusty from the lack of practice but I think this one will be hard to resolve. So here it is: I have a form in datasheet presentation and when I double-click on a record, I need to open another form. This I...

I have a sub-form open in continuous mode. So, I see a repetition of the form because there's more than one records active. What I would like to know is the total height of the form. Not the height of the sub-form frame. Just the height of one record would also be ok since I will only have...

I would like to know how I could order the main form by a subform field. Any ideas on the subject will be appreciated. JCA

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 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...

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...

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...

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...

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...

I have two tables, one with a list of clients with there annual consommation of a product and another one with the categories of clients per range of consommation. So, if a client take 2000 liters per year, he's a client type AB. Cause in the other table, all client between the range of 1500...

Hi, I have a database with a lot of clients and there agent. I've made a report which print a letter for all the client of the agent I have selected. So there's a letter per client. What I want to do is a list of all the client that the report gave me so I could see all the clients on a few...