Search results

Hi, I wander if anyone can help with this problem- I've found no solution thus far. This post is linked to http://www.access-programmers.co.uk/forums/showthread.php?t=70645 the issue is as follows: I calculate a summary report from an original report; the data is entered into a table from the...

Hi! I wander if any of you pro's can help a semi- frustrated monkey? But that's not the big question. The big question is: IF one selects multiple records in a datasheet, so say 6 or 7 are higlighted. Could one use the selection set to loop through every query in that code? Basically I need...

Hi! I wander if any of you pro's can help a semi- frustrated monkey? But that's not the big question. The big question is: IF on selects multiple records in a datasheet, so say 6 or 7 are higlighted. Could one use the selection set to loop through every query in that code? Basically I need...

Surely this must be a fundamental problem, has anyone resolved it? I have a report, which using the MS Support method I create a TOC (Table of contents) by populating a table. However the TOC table doen't populate unless I view every single page of the report and it get's it's chance to format...

Is there any way of resizing a text box from code so that you can handle the height of a textbox for different values? I.E. (But this doesn't change the height at all it seems!!) Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) if [text75] = "HellO" then...

Hi, I have a report with two levels of nested subreports. On the lowest level subreport I have some prices. I need to total these prices right at the end without subtotalling the subreports. Have tried this in main report footer with textbox...

Hi, Mucho gracias if you pros can help me! I've only completed 1 year of a degree... I have a many to many table relationship that I have resolved with another table- therefore I now have two one to many relationships, fairly standard stuff. Basically I need to list items under a schedule. So...

Hola! Everyone who reads this thread will likely find this the easiest thing in the world to do... In VBA I have coded to create a new word document. Now I need to make this document I've just crated the active document, so that I can add some text to it. Does anybody know any code that could...

:eek: Hi, I'm using access that handles some data and at the end of it all produces a ws mord document including pictures etc. I'm OK at VBA and am using to access functions of word. But I need to use the OfficeCodeBehind class which allows me to use the ThisDocument member. The only thing...

Hi, This is an intriguing one- and never thouroughly solved on this forum? I have a continuous form with records PK- [item_ID]. when this [item_ID] = "hd" it needs to make visible a yes/no control: [new] ..... BUT.... just on that one record on the continuos form, not on all of them! I can...

THIS IS IMPOSSIBLE! subtotalling Hi, I have another problem a stupid monkey like myself cannot solve... I have a report that shows a Schedule- with items on it. Only one schedule is shown at a time, although there are many in my database. The report is grouped by schedule ID (though not...

THIS IS IMPOSSIBLE! page subtotals Hi, I have another problem a stupid monkey like myself cannot solve... I have a report that shows a Schedule- with items on it. Only one schedule is shown at a time, although there are many in my database. The report is grouped by schedule ID (though not...

Hi, I wander if anyone can help? Multiple web searches have turned up nothing! I would like to call a sub that is defined in form1. However, I am trying to call it from another form: form2. I.E In vb if use this code: call sub1 It says no sub defined, beacuse I'm calling it from form2. (The...

Hi, This post has been asked but never resolved so I'm trying again?? In order to ensure that only one record can be added on a form, I am wanting to diasble moving onto another new record. I've tried setting the cycle property and have deleted the navigation buttons etc. But using the wheel...

People of this most excellent form, I have been racking my brains and seraching high and low to try and figure this one.... All I'm trying to do is cancel the creation of a new record on a form when it is detected that a text box has a null value. The bit I'm stuck on is getting the record to...

Hi all! I'm wandering if anyone could provide a solution to this problem?? I'm trying to use VBA to create a menu so when you start up an .mdb database it loads a global, custom menu. The custom menu only has three items on it each of which will refer to a function in a module. I've tried all...