Search results

How could I doubt you, MoP? Terribly sorry. My fault. It's excellent. Most grateful.

But I have. I must be doing it wrong then. Slapped wrists for me. Sorry, and thanks very much.

Thanks, Mile-O-Phile, but it doesn't seem to work. I want to take any string beginning with the word Tomson - which is among a lot of strings in Field1 - and to have it moved into into Field2. I can extract all strings like that with a select query, of course, but I thought it would be handy...

Can I get a new field in a query to move certain strings into NewField2, IIFLeft[FieldA], 6) = "Tomson", then move it to NewField2, please?

Sorry, MoP, I see the fault. Cheers.

Hi Mile-O-Phile The New Field method has been great to remove "www." from a vast number of urls. But no matter how I adjust the Immediate If, I am left with stragglers such as these www-users.york.ac.uk wwww.computerwoche.de wwww.einet.net wwwnet.nl And oddly enough, this one www.yu...

Very neat. That's really good, works a treat. Thanks very much, MoP. Cheers to you.

About 30k records in the one field of a large database have a four-character prefix that I need to remove. Some records don't have this prefix, and are fine. Is there a way please to trim the strings, by choosing each record in "Field1" that is prefixed by these four characters - "like accs" -...

I see, yes, that makes good sense, thank you. I've been thinking of keeping a collection of code to go back to, which I often do - if I haven't forgotten where the particular piece is now. Keeping a readily accessible collection must be what you experienced people do. I'll follow suit. Many...

And working well, thanks dcx693. I can see that if the file name is changed regularly, this might be a handy code. I wonder what its major use is, please? I mean, when would programmers always use this?

Looks very good, dcx693. Thanks very much. Cheers

Thanks, dcx693. But where will this code go? The code in this instance is, DoCmd.TransferSpreadsheet acExport, 8, "qryQuery", "t:\com\OnLine\Fred\dcx693.xls", True, "" Would you code DoCmd.TransferSpreadsheet acExport, 8, "qryQuery", "CurrentProject.dcx693.xls", True, "" You'll see I'm a...

The spreadsheet I export with DoCmd.TransferSpreadsheet acExport, goes to the same folder that contains the db. The path is a long one. Is there a way to use an abbreviated path please? For instance, an ellipsis takes Dreamweaver to the current folder. (The books aren't helping because I...

Thanks very much for that, MoP. Very impressive, appreciated very much.

Can a hyperlinked field be exported from Access into Excel and appear in Excel as hyperlinked please?

It's naming the fields that is the problem. I haven't found with the TransferSpreadsheet method how to stipulate the fields. A query of course gets round that.

Briliant, mate, thanks very much.

I need to export by code some fields from an access table into an excel spreadsheet. The table has many fields, but I want to export only three or four fields. Is this possible with VBA please?

Hi Wayne Would you just list the queries under the DoCmd.OpenQuery then please? Could you code the queries not to show their warnings as they appear? Cheers

Thanks, Michelangelo, but of course I don't want to do that. I'm sure there's a way I did this recently, only I can't recall how. I appreciate your help. Cheers