Search results

I do yes. Its a table with about 23,00 entries in.

pic attached

Hi Ken They are all ticked as shown in the picture As i have the office disk with me do you reckon i should pop it in and see about maybe reinstalling the object libraries ? Ashley

Hi Ken That is exactly what i did but i still get the jet engine error. which is strange - and the debug line is highlihted yellow on that line Set rs = CurrentDb.OpenRecordset("DVDIMPORTFROM") Is there something somweherelse i may have a problem with Im using access 2003 but figured...

Thanks Ken my field is called Plot and my table that the text is imported into is called DVDIMPORTFROM it still gives the runtime error 3078 i tried having the table open and moving the focus to it but i thought that wasnt needed for recordset Really sorry im being a pain - thanks so much...

Wow, thanks muchly. I did have the code already in a function module. Clicking the button gives me jet engine error saying it cant find the object Set rs = CurrentDb.OpenRecordset("tblImportFile") obvbiously i called it my actual file - which is called DVDIMPORTFROM Set rs =...

Thanks so much for your help Whats the best way to call the function bearing in mind im automating a lot of this through form buttons / macro and procedure calling. I.e an external text file is imported into a table and then i run a find/replace and several sorting bits all through the button...

Hi i want to righttrim from a field however each record is going to be of different lengths as its full of text. I know the point i want to start as right at the end of the record is a -- character followed by some text. I wish to trim everything after the -- to the end of the record. I...

i.e heres some duff code (what do programmers call mock code again - i graduated 7 years ago with a computer degree and its all like dust in my brain these days) i kinda threw together which obivously doesnt work Set rs = db.OpenRecordset(CDTRACKGROUP) ' Table is CDTRACKGROUP '...

Hi there i have a report which is based on a table. In the table several are of type 'memo' When i export to excel it seems to chop down the amount of characters. Anybody know why this happens and a workaround. I tried exporting to text but it doesnt hold the formatting i need. When i export...

hmm. care to explain. sorry - soemtimes i have gt knowledge in access and can do complex things and then soemtimes i dont even know how to do the simplest of things. i presume you mean in a join query ? in like the sql editor bit of the design. ? rough idea of code id need. edit. a join is...

Hi there im new , been watching and using for help but i need some specifcs. If anyone can help im greatly appreciated. Problem:// Table is called CDTRACKS Field 1 = UPC (barcode) Field 2 = Position Field 3 = Artist Field 4 = Title Ok. If a cd has 10 tracks then there will be 10 records...