Search results

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?

Not quite sure where to put this one, as I don't know if it is a query issue, coding, or just form design? I have attached a cut down copy of my database and the problem lies with when I try to update a date field in the subform. To replicate the error, open the mainform, choose "Daily" &...

Well there you go, I've made it work - of course it is totally different to what I originally planned but now it's even better! Thank you very much for your patience and guidance Bob with helping me see the light! It's fantastic knowing that there are people like you on here willing to share...

Ahhh a light bulb is turning on somewhere.......... I think I've grasped what you've said, (And yes it does seem as though I had the completely wrong idea of how to use tabbed subforms) now can I ask how do I implement it? Should I convert the foreign key text boxes on the main form to combo...

Hi Bob That kind of sounds like what I was trying to do in the first place. I have moved all of the fields for the faults table onto the main form, with the other tables data on their respective subforms. What I need the database to do is for every maintenance fault logged (Tbl_Faults)...

Hi again Thanks for the advice, I really do think I've designed the structure wrong. I'll keep on experimenting and see what I come up with. Cheers