Recent content by Martynwheeler

So, I discovered that if I type a space into the hyperlink property it gives me the hyperlink formatting (with mouse pointer as hand) and I can handle the click in code.

Thanks, I liked the way the hyperlink looked, but I guess i can reproduce that. I also just discovered you can call a macro with a hyperlink in which you can handle errors. Pity I can't just handle them in vba. I can call a module but not sure how that would work.

I have a form with a hyperlink to another form. If the called form has no data it will redirect to another form (all handled in the form_open event). However, because the link has now redirected it throws the warning message as the second form opens. If i click ok, then everything is fine...

Thanks Larry, I will take a look

Here is my finished design. I went with a solution from (https://bytes.com/topic/net/insights/594455-row-numbers-alternate-colors-continuous-form) to save any temp tables etc. It all seems to work. Any comments or obvious design flaws would be useful. Thanks again for the useful forum, Martyn

thanks for this, was trying to avoid temp tables but I may have to bite the bullet

Yes, students can be studying multiple subjects. There would be multiple classes for a given subject within a year group

I will give it a try

I was hoping to use the check box to control the source of the textbox. Unchecked it should show the question and checked it should show the answer.

Thanks for the link. I was thinking that the cross tab would be just the question and answers. No worries. I think it might be simpler to do it all in vba. I could populate an array with the query results and process everything in the form.

No each student is assigned to one class (group) in 12 and another in 13. I think I have a working system now. I am getting colleagues to test it next week

Hi, I have a database of questions. I would like to display 5 randomly selected questions from a category on a form to display to the user (in fact this would be displayed on the whiteboard to a class). Here is the sql that I am using: SELECT TOP 5 tblQuestion.questionID...

I am interested in your statement: "If not, you can find it and renew the reference to it (GetObject)". I have the filename saved, can it be assigned to the TBE object? I am struggling to achieve this Set TBE = GetObject(Forms("frmHidden").txtTempBEFullPath.Value, "Access.Application") throws...

I quite agree that errors should not be the norm. They were just cropping up while I was learning and testing your code. I will make sure that they are handled properly in the finished version

Thanks again for your help with this. I now have all my temporary tables in the tempdb. The only thing I have noticed is, while testing, if encounter any sort of error the TBE object is lost. Is this normal? I guess that I could do as you suggested and always check the TBE object is not...