Recent content by Malcy

Brilliant. Thank you very much. Worked a treat.

I have a string which is a combination of numbers and letters. I want to extract the end digit (always a number), or, if it is greater than 9, then the two digits. The format of the string is along the lines 18G003-2-4 (they are agar plate codes for refining fungal cultures). So I am trying to...

Thanks guys Running a repair on Office did the trick. Had horrible feeling there were legacy issues coming out to bite me but all now appears OK. Odd one though since never happened to me before like that! Malcolm

Hi Hope someone can help since this feels a disaster. I rebuilt my main PC as Windows 8 Pro yesterday following getting caught out by a suspected rootkit that must have sneaked in over weekend. Ended up doing full format of the disc and virgin install which got rid of problem. Everything went...

Thanks guys Found it. I had forgotten to bind the checkbox to the relevant field in the table. As soon as I did that then it started to behave as I expected!! I guess I still need a few more coffees this Monday morning to kick brain into gear :-)

OK Thanks guys. Not sure I can upload since even my test data is sensitive. Fundamentally when a volunteer is entered (usual contact details ++ etc) their areas of specialisation need to be recorded. So I have a separate table holding fundamentally the Volunteer ID and the Specialisation ID as a...

An append query adds all records from tblSpec and also the volunteer ID comes in from the form so each record in the temporary table has a volunteer ID, a spec ID and a yes/no field. This table (via a query) populates the sub form. And yes, tick one they all get ticked even through there are say...

I need to be able to apply various specialisation criteria to a volunteer record. There are currently about 50 possible options but list will expand. Already have separated this particular aspect into tblVol, tblSpec and tblVolSpec so data is normalised. I thought of continuous sub-form based on...

I am trying to set up flexible dynamic search facility. User can enter one of four search fields (name, phone, email, postcode). I am catching the query using a criteria like [Forms]![frmContactMatch]![txtPostcode] This works fine for perfect matches but client now wants to be able to search...

Try setting up a continuous form and put the customer details in the "Header" section of the form then the detail for the actual orders in the "Detail" part of the form. Put your close form command button in the "Footer" section. The query will always show the customer details on each line since...

Thanks but I do think it was to do with the append query since the code now runs as sweet as a tin of syrup! Not sure if that is the right analogy but I am happy as Punch now!

OK, an update following further exploration. Prior to trying to edit the recordset I had set up a procedure to clear down a table using a SQL statement and then append valid records using an append query. I eventually twigged that this was in some way locking the table that was used to create...

Hi and thanks for getting back All in Access 2007 .accdb files (front and back end) Have gone through the "corruption" route and happy that this is not the case. It is something specific to do with that rstEc recordset. Currently also exploring other ways I can do everything I need to do to see...

Just to say thanks for help. I have now managed to work my way through formatting the individual parts of the email using vaguely remembered HTML. 27 or so test messages and I got it looking acceptable :-) Malcy

Another wee glitch. I am trying to edit a DAO recordset that is correctly Dimmed and Set but when I try to run it then it falls over. Dim rstEc As DAO.Recordset Dim rstAct As DAO.Recordset ' Define constants Const CR = vbCrLf & vbCrLf Const QUOTE = """" ' Set the connection...