Search results

I have a list of email addresses. I want to take the name before "@" and divide it into two if there's a "." or "- " or "_". And to capitalise the first letter of both names. For example, rob-roy@hootsmon.com would be Rob Roy. Hope an expert would show me how. Cheers

Any way of turning the clock back with my new 2007 so I can see the old or what might be termed the 'classic layout' of Access, please?

A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://". Alternatively, be pleased to know the code to concatenate "http://" onto the urls.

A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://". Alternatively, be pleased to know the code to concatenate "http://" onto the urls.

A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://". Alternatively, be pleased to know the code to concatenate "http://" onto the urls.

Strings contain urls. Is there a simple way to trim a url out, please? For example, " www.zzuk.co.uk/cardiff/Ely - 17k - Cached - More from this site - Save " What I would like to be left with is simply "www.zzuk.co.uk/cardiff/Ely"

People have entered themselves in the db in lc and upper and a mixture of both. Is there a way when displaying the names, please, to say in sql that I want them to be 'normal' - ie Peter Plant, Sue Marris, etc even though they are entered as PETER plant and sue marris?

The form that the Users use crunches up a little near the top on their computer. On my screen, it displays as it should. It has 2 subforms. The Border Style is Sizable. Any suggestions for stopping the fault, please, Experts?

Can I use an immediate if function when referring to the EOF. I want to say Iif(myfield, EOF = " ", " | ") ... but I would like to code it the right way. Grateful for advice, Experts.

A crosstab query gives the totals for students in particular classes per the Class they belong to, i e College A – Class1 4, Class2 12, Class3 17 College B - Class1 12, Class2 124, Class3 12 College C - Class1 5, Class2 16, Class3 7 College D - Class1 4, Class2 13, Class3 9 Etc etc...

Dear Learned MoP (as was) Do please look at ... http://www.access-programmers.co.uk/forums/showthread.php?p=405561#post405561 ... and tell me where I went wrong. I've spent hours on it, and tried every variation I can think of. Yours in awe Paul

Why won't this work, Experts, please, either as a module or as a sub attached to the subform's Form_Current() ? If Forms!frmMatrix.frmWorkers.Form!WorkStartDate = " " And Abs(DateDiff("d", LastJobEndDate, Date)) >= 28 Then Forms!frmMatrix.frmWorkers.Form!DailyGrind = "Available" End If

One form, two subforms in a new db. The three work well together, except when it comes to a new record. When I want to input details of a new record, the main form and a subform work ok, but the third subform won't accept anything. Any guidance, please, gurus?

WorkID is a look-up field, so its Data Type is Number. In the same table, DailyGrind is a field with the Data Type of text. I would like to update WorkID with the jobs in DailyGrind. Surely there must be a way to do it, gurus?

Access says No. I don't know why. INSERT INTO tblEmployees (Roots) SELECT Roots FROM tblMain where tblMain.PersonID = tblEmployees.PersonID; Be grateful for guidance.

I want to say update set field1 = field2 But field1's data type is Number and Field2 is Text. (Field1 is fed by a lookup table). Am I doomed to go through the 700 or so by hand, gurus, please?

Is there a popular way to show when records are updated, with something like a text box with Now(), please, Gurus? It needs to be automatically enacted. (A box that they complete themselves gets quickly forgotten.) Then if the Client refers to records changed on such and such a date, I can...

A customer's name is SZEE. Seek him through the SName textbox with Find, and Access can't find him. (Same in the table.) Seek him with a wildcard Sz* and there he is. I've tried it on another machine - also with Access2k - and it's the same. Is it an Access quirk? Is there an answer? (The...

The database for workers works ok from a solitary table, tblEmployees. I want to make it a relational db. I’ve incorporated lookup tables. But I’m lost about what to do next – and if it should be divided further. I’ve studied many tutorials in relationships, but I don’t find one that...

The main form (frmMain) is fed by qryMain. I'd like to put a memo field on a separate form (frmMemoField) to avoid cluttering the main form. Is there a way to ensure that frmMemoField offers the same record currently displayed on frmMain, please, Experts?