Search results

You have not understood my question! I am building the report using vba It gets built on the fly The user cannot right click etc!!!but I want to be able to put code into the report which will execute itself when the report is opened Thanks!

I am creating a report using code, however I want the report to have code in its on format event. How can I write code which will insert itself into this event on the report once it is created? Alternatively could I have a piece of code that is automatically inserted into every report created...

Is there any way i can loop through all controls on a form/report and delete them. I have seen a thread about this and I think Pat explained it needs to be done backwards but I'd appreciate it if anyone has achieved this to show me the code. I keep on getting an error that the count is more than...

OK thanks for this . Will try it out but will take me a few days Thanks again

Woula appreciate the code if you could.It will take me ages of trial & error! Thanks

I would like to create a control on a section of a report whichwill sum all the odd records and another to sum all the even ones. Any ideas? Thanks

I don't think you realize the complexity of my situation the table looks like this John Jan05 50 John Jan 05 100 jill Jan 05 100 john Feb05 250 john Mar05 200 jill feb05 150 jill feb 05 200 jack feb05 600 jack feb05 200 My report should look like this...

Just out of interest , do you total monthly for all tasks or break it down into each task for each month Thanks

16 views and not one reply?!!! Just pushing it up Thanks

Ok I have not got much time so I am just dumping the code with a few words of explanation. My field names are listed in an external ini accessable using function profilegetitem (do a search on forum) [report1] Output=Preview;Print Caption=Summary List orientation=landscape text0=lname...

I have just been involved in creating reports dynamically on the fly. I loop thru the variables and add them and their labels, set their width, alignment depending on their type, add an image, sort all on the fly. If you're interested still I can post my code although it may not all be relevant...

My table consists of 3 fields,student,date,value. Each time a student pays, its value is recorded along with the date (as a serial number). I now wish to produce a report listing the student names across as headers (there are not more than 10) and then calculate 2 summary values for each month -...

Any further with this? I am in a strikingly similar situation! Thanks

I am using .orientation=acPRORlandscape to design my report using vba in Office 2003. It works fine but is a member of MSAccess11 Object Library and so does not work in office 2000. My question is so what did they do beforehand was there some other way of coding the orientation of a report? Thanks

Such as? reading them off tables? Why must everything in access be governed by tables? (polite question) The ini is maintained by the designer not the user

As the form opens it reads an ini to know how to populate those combos. Each line is a different combo. The program is generic. All thats different is the ini. What do you mean 'prevent headings from being selected'? and how do I display them? Thanks

Its not an external table. Its one line of an ini which gets pasted straight into the combo control as values . Since its separated by semicolons, each part becomes a different row in the combo!

I am very careful with database rules. actually this list is populated with an external ini file but I respect what you say Pat Thanks for your remarks!

Thanks for your replies! So is access just not as powerful as other programs? I was sure I could imitate it! :(

I have seen a combo made in delphi which looks like this when the dropdon arrow is selected STATIONS Waterloo Euston Liverpool St AIRPORTS Heathrow Stansted Gatwick only the lowercase ones are selectable. If the user selects STATIONS he gets a messagebox telling him its only a heading and...