Recent content by Teknologik

Hello, I have created a Module which is used to amend the data type of a table from a number to Text 30. This is the code used. Public Sub ChangeDataType() Dim dbase As DAO.Database Set dbase = CurrentDb dbase.Execute ("ALTER TABLE [FM 1 Cref Make] ALTER COLUMN [CALL_IN_REF] text(30);")...

Nanscombe that worked. Thank you.:)

I'm trying to remove anything after the - or / can this be achieved in a query and not a module? Thanks for your help

Hi, I'm trying to seperate out multiple characters from a free text field. Expr1: Left([RefNo],InStr([RefNo],"-")-1) But the problem being that I want to exclude - or /. Is there anyway of achieving this? Thanks

The data comes from handheld device so it isn't imported the gps is taken automatically.

Look up the Mid and Left functions; as these values are fixed length there will be no need for Instr to find delimiters. Brian Thanks for the reply Brian. In your opinion would something like this work? 52.25844,0.614368333333333,6,1.7,FALSE,FALSE Latitude: Left([GPSDetails],8)...

Hello, I require to break up a GPS reading into Longitude and lattitude but can not work out a way to do it. i have a GPS reading 52.25844,0.614368333333333,6,1.7,FALSE,FALSE What i want to do is split it into two fields one for Lattitude and the other longitude in a query. For...