Recent content by Crash_Pie

Hi RG Basically this option stops the Property Sheet from appearing in Form View. I discovered recently I had accidentally left this option set to All Views on some forms which meant users could see the form property sheet when I didn't want them to. I managed to turn this property off (set...

:confused:

Hi Firstly, sorry if this is already answered elsewhere in this forum, I've searched for a couple of nights and can't find the answer (how do you search when some words are disallowed?). Anyway, the real question: We use Access 2003 at work and I design/modify our database using Access 2007 at...

Hi thanks for the reply. I don't know if your suggestion would have worked because I have just fixed the problem using another method I found on a different forum. Here is a copy/paste of what I followed to fix it: First, log on as a new Windows user to the computer to see if you have the...

Hi, did you fix this? I have just started using 2007 and have the same problem - can't use/see the property sheet. I'd be interested to know if/how you solved the problem. Thanks

Hi all I have a database containing information about students. On one of my forms the user selects a course number and student name and then a subform (based on a select query) displays other information about the trainee. Instructor comments etc. At the moment whenever someone scrolls down...

That was short, thanks.

Hi, is it possible to have an image go across or over the border in a report? Eg, can it go over the Report Header/Page Header boundary? I'm trying to make my report look "smart" and every time I drag the image over the boundary it automatically moves up, forcing extra space into the Report...

Hi Chris Thanks for the reply. I got to thinking after reading your post and solved the problem. I still had the image frame set to embedded not linked. It was frustratingly obvious, so now I have the photos working using the second VBA example above. Thanks again. Crash

I forgot to mention that I have tried the code in both the header area and the details area and it made no difference.

Hi I have made a report based on a query that looks at student results. I'm trying to display a photo of the individual student in the Student Header that corresponds to the records being displayed. I have tried two different approaches with code in two different locations and receive...

Thanks Ken Worked a treat! :)

Hi all I have an expression in a query which is checking a list box on a form. If the list box is empty (is null), then I would like the query to search on the highest (maximum) value in the specified field (CourseFK), otherwise it will look for the value in the list box. Expr1...

Thanks very much for the pointer, that was indeed the source of my problem.:D

Runtime error 3326 - Recordset is not updateable Should I be trying to update the table directly and not via the form?