Search results

simpler solution is instead of binding text box directly to underlying SQL use a formaular, so if the field you want is called 'field', type '=[field]' into text box then you can change textfromat to RichText.

Many thanks, I am slightly embarrassed that I din't think of that, trying to be too clever.

I presume you have checked the control is still there? and that is unbound? Do you know if the line of code below is functioning (comment out the line not working to check) Have you move the code from the form to a module? I'd have a go at deleting control and recreating it. Something must...

Hi, hope this is clear. I am trying to write a query for a school time table database, this is a simplified version of what I am attempting which hopefully gets to the problem. table data is - tbl_lessons lessonID subject dayID unit staffID 47 Current affairs M1 1 1 3 48...

Yes, thanks you are certainly onto something there. The other thing that seems to make a difference is having a query that is saved as a query rather than having underlying SQL in the page itself (which is my prefered way of working as it means less files to navigate). I think I have enough now...

Yes the ControlSource, when set to a single field that is a short or long text field in table I am allowed to switch Text Format from 'Plain' to 'Rich' however if the ControlSource is a string concated in SQL (e.g. "<strong>" & tbl.fieldName & "</strong> AS txt " it will not let me change Text...

If anybody is following this I have found an old form I created that allows me to do exactly what I want, but I cannot for the life of me see what the difference is, I have checked in detail all the form property setting and the text box setting... but whatever I do when ever I try on my new...

That's just a typing error on my post - that aside I can't set text box propery format to RTF if source is a concated string, only if is a single long text field from a table. However I believe I have stumbled across a solution. Which I'm now checking and will post what I find if it works.

I have a table which has several text fields that I want to concat together in SQL with some formatting but after I have set the data source of text box to the concated string it will not allow me to set the format to RTF. So the text is unformatted and format tags are shown as plain stings...

That's a very broad question, you need to home in on the piece of code that you are having difficulty with. If you are not already familar with the debugging environment then do a google search on VBA debugging, this link is an okay start but a bit basic...

Glad, to help, I use this forum a lot but mostly using other peoples help rarely able to give it.

Try this Me.AskAudience_SubForm.Form.Filter = " Text6 = " & Me.QuestionNoLookup.Value the filter need to be a string so you need to concat the bit you know the exact text for ("Text6 =") with the variable which looks like it come from control QuestionNoLookup Hope that helps

Many thanks for this, I run a relatively small but complicated database with lots of tables with lots of queries and joins. Typically I need to pull out names from personel tables and join to other records. The primary key in the in personel tables will always be indexed but currently the names...

Have an "on change" event. something llike this If me.cmbx = "Date" Then Me!txtBox.BorderColor = Red Else if Me!.cmbx = "Name" Then Me!txtBox.BorderColor = Blue Else if.... If the there are lots of variables you maybe better off with a' Select case' type thing. These two...

Many thanks for everyone's help and apologies for my tardy thanks. I did eventually solve the problems Doc_Man's surgeon analogy was spot on. The main problem came down to one of users being a more efficient and triggering an event before she'd finished selecting her choice from a combo-box so...

Many thanks for quick input. Defiantly not the user, definately something on her laptop. She is pretty limited what she can change as she doesn't have admin rights. What is so odd is that it is 2 very specific actions that are problematic (there maybe more unknown), as far as I can tell...

Hi I have a fairly complicated database, I have about 12 different users using the same clone of the front end accessing the same back end on a server. One user (and only one user) is experiencing several unique problems. At least half my others user are using the same model Laptop with the same...

Hi been using the version colincliff posted for a few months and all was going well - but it only works for part of year (Jan to August), this is because the amount you need to add onto difference betwen DOB year and current changes - on colin's version you get a different school year on 31st...

Thank-you moke123 and ridders for your quick replies, I think I'll use the Jstreet relinker as it is ready made just tested it and it seems to work like a dream.

Hi I have a split database I use to manage my school's timetable. What I want to be able to do is work on new timetable while still being able to access and tweak current one. The easiest way I see to this is to able to switch between different backends. This is effectively what I am doing at...