Opfriskning af min hukkommelse

Maybe something like this

Dim a As Variant

a = Split("C:\Path\File.txt", "\", , vbTextCompare)

MsgBox a(UBound(a))

not sure how you woul dget the extension or full path from using split though

Not quite - it is possible to give a parameter that indicates which filepart you want to return

I am beginning to wonder if it was in the good old TurboPascal it was possible to do this :-)

http://www.vbexplorer.com/VBExplorer/SourceCode/vbs_fd.asp#tip4

Det går lige op for mig, at du måske ikke kan bruge det link til noget ;D - brug det, eller ignorer det hehe :)

fjappe> Det er jo sådan set de 3 gamle metoder til at finde det på - det er dem jeg bruger allerede.
Jeg ville gerne have en hvor jeg kalder med et absolut filnavn og så en parameter for hvad jeg har brug for.

(jeg har TotalAccess analyzer til at køre på en DB lige nu - det tager alle kræfter ud af denne maskine så jeg dårligt kan skrive her)

Skal ærligt indrømme at jeg intet kender til vb, eller access(udover det man lærte i skolen ;D ) - så bare afvis mit svar, jeg håber du finder en løsning... hvis den da findes? :P

Hi Hugo
"..det tager alle kræfter ud af denne maskine .."
maybe its about time you replaced that 386 with a new one :o)

TotalAccess analyzer:
Do you have other componenets from FMSinc? they also have a mailing program. You might be able to use it to get get out of having Outlook/Express installed.

I have an AMD Turion 64 1.8 GHz with 1 GB memory and it still pulls resources as nothing else.
I have just made the code documentation and now I have to go and cut a small forrest to print the 1116 pages :-)

I have some other components as well but not the mailer. (I have Analyzer, Sourcebook and codetools - but I never got the mailer when I was at Jamo and now I can't afford it :-)  )

what version do you have?

Analyzer 2003, Sourcebook 2003, Codetools 2000 (no need to update)

you can also use th efile system object for doing some of the things you want

Dim fs As Variant

Set fs = CreateObject("Scripting.FileSystemObject")

MsgBox fs.GetExtensionName("c:\some\path\goes\here\file.txt")
MsgBox fs.GetFileName("c:\some\path\goes\here\file.txt")
MsgBox fs.GetBaseName("c:\some\path\goes\here\file.txt")

MsgBox fs.GetDriveName("c:\some\path\goes\here\file.txt")

Will try that and return later.

dont have one for the path.

Maybe fs.Path if the path exists

SplitPath er en Windows-funktion, så du skal vide hvordan man bruger Windows-funtioner i
Access.
Søg på Internettet efter "SplitPath access" og du finder bl.a. denne her:
http://www.mvp-access.com/juanmafan/wizhook/splitpath.htm

Bortset fra det er på spansk så ser det da rigtigt ud :-)

Terry> jeg har arbejdet videre med dit forslag og har fået næsten det jeg ønskede. Så smid et svar for points.
Ved du forresten hvordan man kan lave det som der er i standard Access funktioner, at når man skal indtaste parametre, så vise de mulige med gult?

Not quite sure I understand what your after Hugo. Can you explain a little more?

When you type the name of a function, say docmd.OpenReport "rptTest" and then when you type the , you get a list of possible choices.

Well I've never tried this before but it works :o)

Enum SecurityLevel
    IllegalEntry = -1
    SecurityLevel1 = 0
    SecurityLevel2 = 1
End Enum


Function security(sl As SecurityLevel) As Integer

End Function


Now if you start entering the function you will see the list in the Enum. Obviously if you have other paramaters which are just normal data types then they only have the one posibility

Oh and thanks

You may find this link usefull Hugo. I havent tested it so I have no idae at all if you can.
Mail using MAPI which it seems can take attached files.

http://www.eksperten.dk/spm/755369