left, right and mid function 1

[whistler1]

could somone help me to find the problem
everytime I use the left, right or mid function
I get an error: 'Can't find project or library'
does anyone know what the problem could be?
here's the code I use

jj = Mid(dat, 7, 4)
mm = Mid(dat, 4, 2)
dd = Mid(dat, 1, 2)
datum2 = dat(jj & mm & dd)

it stops at the first Mid-function

 

[whistler1]

ok, managed to solve one problem
there was a "/" that had to go
did that with a replace
but now i have to be able to put the year (currently at the back) to the front and the day (currently at the begin) to the back
is this possible to do this without the left and right function?
is so, how?

 

[BiggerBrother]

Try using:

datum2 = format(dat, "yyyy/mm/dd")

BB

 

[whistler1]

I think there is something wrong with Visual Basic
format-function doesn't work either
strange thing is that formatnumber does work
but i can't reinstal VB because i don't have the progrm here
its from my boss and he has the cd at home
and it could take a while before he remembers to bring it with him

does anyone know something else that could help me?
i would really like to have this program finished by the end of the day

 

[whistler1]

i really need to fix this problem
this is the last problem i see, and i want it done today
so can somebody help me?
the date is coming from an excel-sheet

 

[johnwm]

Don't expect support or sympathy from anyone here if you're running a pirate copy of VB!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[whistler1]

i'm on a pc at my work, my boss has the original cd, but he took it home with him, and has't brought it back, he installed it on my pc because he knew about my knowledge of VB
that's also why he asked me to finish his program, because he couldn't go any further with it
so it ain't no pirate copy, i don't own it, but its for my boss and he bought the original

 

[zemp]

For formating dates you can also use the following function,

datum2 = FormatDateTime(dat, vbShortDate)

This formats the date according to the system date format.

zemp

 

[whistler1]

thx that worked
a star fot zemp

 

[whistler1]

thx
problem solved
a star for zemp

 

[ALSav]

Hi,

I am encountering the same error 'Cannot find project or library' when I use Mid() Str() and other common string functions. Did you ever find out what was causing this?

All help welcome
regards

ALSav

P.S. I am not using a pirate copy either

 

[petermeachem]

You have a missing reference. Check them, should be marked as such.

http://www.accuflight.com

http://www.lettersdirect.co.uk

http://www.ourhouseinportugal.co.uk/

 

[ALSav]

The same references are checked in his copy as in mine

thanks for replying

regards

ALSav

 

[bjd4jc]

They may be checked but do any of them have the lable MISSING: in front of them?

Also, as a side note, try not to double post in the future. You revived this thread and then posted a new reply in thread222-1143383. Please post any more replies into the new thread.