Search results

Thanks for the clarification Namliam, very helpful. I am still wondering though why my ambiguous code worked fine under Access 2003. M.

RG - many thanks for that - adding DAO as suggested has fixed the problem. Just so I understand the fix, can you please explain why adding DAO has solved this - what disambiguating means in this context. It would also be interesting to learn why this was not required when I was using an earlier...

Hi. Hope someone can advise. The code below is an example of a larger set of code blocks used to populate a complicated report. It used to work fine in Access 2003, but after upgrading to 2007 it no longer works – and I haven’t changed anything since it worked fine. I get a Run-time error 13...

Thanks Gemma-the-husky. I have resorted to suppressing the error - but I hate not knowing why it is happening! It actually is in the CUrrent event, not the Open event as per my original post :-)

Its something to do with the point at which the sub is run. Just tested and the code works fine when EXCEPT when OIPENING the form.

Thanks MStef - do appreciate yopur help - but its a pretty complex database, and it would be difficult to trim down. For IPR reasons I'm not able to send the whole thing out unfortunately.

Okay - have done - but it makes no difference. I'm sure my If statement is correct.

No - there's nothing wrong with that. Other code - not shown above - within my IF statement to hide/show fields executes correctly when I comment out the line in red.

MStef - the field ForecastGen is bound to a Yes/No field "Gen" within my "Projects" table - the control source of my parent form.

Hi - I'm getting the dreaded error 2448 "You can't assign a value to this object". (Have reviewed the forums but can't find an applicable solution.) This occurrs when I try and asign a value to a control in the parent form of the current subform: Private Sub SetForecastWarning() If...

Hi I maintain a multi-user Access database split into front and back ends. The front end contains some rather complex reporting systems. I would like to create a simple web-based front end to this database for users to enter data, but also need to permit a couple of administrators to access...

Thanks Wazz - that's a good idea. As Gemma-The-Husky mentioned, though, the fact that fonts are proportional means that the length of my 'truncated' strings would be irregular. Missinglinq - thanks - and appologies for not being clear. I did not mean 'truncated' in the formal sense. Rather, I...

If I have a text box which is smaller that the text it displays, any idea how to indicate that what the user is seeing is truncated, e.g. by putting '...' at the end? Many thanks Mat

Sadly not that simple. My report has to look like a completed form, and must include tables which - if no data - look like they are simply not filled in. My subreports hence "build" sections of these tables so must return at least one blank row. I am strictly constrained by what my output must...

Hi Bob - indeed your solution seems a lot more elegant - so thanks for that. However, it does touch on an issue I have as mentioned in another active thread. Basically, these are subreports and when opened from the parent report, the On Activate event is not triggered (problem with the On Open...

How do I create a dummy group?

Thanks guys. The above ideas do add a blank row, but the problem is to add a blank row ONLY when the query returns nothing else. The reason for this is that - in some reports - it is neccessary to have something in place within a subreport, to preserve the overall report formatting. Otherwise...

They do not comprise a "Group". If you know how to make them into a goup, let me know. I tried Format/Group, that that type of group does not have any such options associated. M.

Hi. I have a set of report elements which I would like to keep together - NOT breaking across the page. These report elements comprise some boxes, lines, labels, a couple of unbound fields, and a subreport. They are hence of variable size according to the number of records in the subreport. I...

Hi. I'm using the VB below to return a single value from the "Response" field of a query, (where ID number = 55, which is fed into the query through the parameter "Item"). The result is then written to a subreport unbound field "checkl55". This works absolutely fine when I open the subreport...