Search results

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...

Thanks for your explanation. The point I am not sure about is if that the TBE object is instantiated in one form (your hidden form in the example) from the class, how do I access this object from another form? Do I have to use a global variable? I realise that I can get the path to the TBE...

hopefully final question. How do I access the db from another form? This is the first time I have used a second database.

Thanks for your help. So, I don't even need the hidden form. I can just create the tempdb from my main form, use the tempdb for temporary tables and it will be deleted when I close my main form. That is very clever

Hi, This looks like a great solution. I have a couple of questions. In the form unload you have this ' Explizit aufräumen bei mehreren TBE ' Verlinkungen For Each td In ThisDB.TableDefs If Left(td.Name, 5) = "tmpT_" Then ThisDB.TableDefs.Delete td.Name Next '...

Looks really nice Larry