Recent content by Isolec

All sorted now. Interestingly the missing files were associated with Sage Software and not Access. However Access now works OK!!!!!!!!!! Thanks for all your help

I have added the sgoedit.ocx file but there appear to be others. How do I list these?

Thanks - It looks like I have a broken reference to the file SGOedit.ocx version 1. Lets see if we can repair it!!

Thanks - could you expand slightly on what you mean as references. I take it you don't mean relationships!

Hi Uncle Gizmo - You are obviously quite correct the query functions are identical. Before the old laptop died I was able to copy the database file across to the new machine. However most of the queries fail to work. For instance, I have a simple query to convert upper case to first capital...

Hi all My old lap top crashed yesterday. I was using access 2007. I now have a rubbish windows 8 machine and access 2013. They appear to have changed the query in the latest version. I have loads of them, macro controlled and I desperately need to get reports out. Is there a quick fix without...

Hi Marlan That makes a lot of sense - thanks

Hi All Thanks for all your help so far. I have managed to change the text to date using "CDate(Left([Field1],4)+"/"+Mid([Field1],5,2)+"/"+Right([Field1],2))". However i cannot seem to truncate the year to 2 digits ie. 01/12/14. I thought i could use a mask in the input field but there...

Hi JDraw Because the text field is used throughout the system in tens of queries and reports and i didn't want to change it all. May be that would be best though!!!!

I am using an append query to move data into another database. One of the fields being imported is a date field in text form (20141201). I need it appear in the final database in text form (01/12/14) I have tried using several date conversions and cant get this work. Ideally i need the final...

Probably didnt expain the problem too well. I was appending several hundred records, each with 16 or 20 fields. Initially the append query only shows 16 fields, but does allow you to drop and add further fields as i have now discovered! Thanks

I think i must have a total mental block. Of course that works just fine. Many thanks

Hi Minty. I just can't get more than 16 fields to appear in the append query and i was led to believe that access 2007 had a maximum of 16? Is 16 a default and can i increase it somewhere? Thanks

Hi CJ London, I am using an append query but in access 2007 i seem to be limitted to 16 fields!!

I use an append query to move data from one table to another in access 2007. The table from which the data comes has many fields that i do not append. Up until now, i have always had less than 16 fields per record. However, i now have 20. What is the best way of approaching this. I tend to...