Search results

Hi Gina, Thanks for the advice, I was just being idle, I shall now have to go into work. Kind regards, Eddie

I want to work on SQL Server tables located at my work place at home using Access. My question is; is it possible to link SQL Server tables on a server to my lap top computer using ‘Remote Desktop’ or will I need to install Access onto the server and if tables can be linked using Remote Desktop...

Hi spikepl Many thanks for the advice its working perfectly now. Kind regards Eddie

I'm strugling getting the module to work. I've created a test database with two tables: tblOldTable and tblNewTable with the fields as named in the example, however when I try to run the code it stops highling the following line: strSelect = "Select ClientID, ClientName, ClientAddress From...

I have a database that contains a single address field with each line of the address entered onto a different line e.g.: 1 West Way Southampton Hampshire What I need to do is to migratate this to a new database that has a field for each line eg: Address1 Address2 Address3, etc. I need to...

Many thanks for your help, it really is appreciated it is know working perfectly. Kind regards, Eddie

I have a memo field in a table into which I have imported 2000 records these however appear formatted with paragraphs starting on a new line. Because I’m exporting it into a third party application I need to remove the carriage return to make the text one continuous string with no line breaks...

Many thanks for all your help, I really do appreciate it, it’s now working fine. Kind regards, Eddie Mason

Many thanks for your help I'll give the function a try this morning. It is just unfortunate that writers of the software allowed only a maximum of 40 characters in each of three separate fields, rather than one field of 120 characters. Kind regards, Eddie Mason

Firstly splitting the field will not cause a problem with over-run on the last field as there are no more than 120 characters in any of the 8,000 records. But yes you are absolutely correct it would be so simple to just to adjust the field size in the application to 120 characters and the...

I agree that I could split a field very quickly using a query, but this would mean that I still had to go through the resulting fields manually. To explain this if the record 1 in field [Description] was: "The Create Wall Mounted WC Pan is a stylish pan that when combined with its elegant...

Many thanks for your help on this, but it does not appear that this is possible to do. Especially as there are approximately 8000 records that need splitting; 'mid' approach would have to go through each record twice and cut and paste individualy each part completed word into the next field...

I need to split the field because I need to export it to computer package that although giving you three fields to enter a description in, each field is only 40 characters in length. Kind regards, Eddie Mason

Hi JDraw, Thank you for your help, but I'm strugling to see how I move the words to three separate fields? Kind regards, Eddie

I have a table with a text field [Description] that’s 120 characters long; what I need to do is to divide the text in the field into a maximum of 40 character chunks. So the first set of complete words up to 40 characters will be placed in [Desc1], the next complete words up to 40 characters...

I now get a message saying "Microsoft Access can't start because there is no licence for it on this machine". What it does not do is allow me to put in the licence charactors. Kind regards Eddie Mason

Until recently I kept a dedicated computer with Windows XP professional operating system which had my copy of Access 97 loaded onto, it which I still retain for some legacy systems. Unfortunately this computer has now died and when I tried to load Access 97 onto my current computer which has...

Until recently I kept a dedicated computer with Windows XP professional operating system which had my copy of Access 97 loaded onto, it which I still retain for some legacy systems. Unfortunately this computer has now died and when I tried to load Access 97 onto my current computer which has...

Hi David, Many thanks for your help; the solution you gave works brilliantly. Kind regards Eddie

I’m using Access 2003, each year I archive the last years back end database and then start a new back end database. From time to time I want to review an archived database and what I do is re-attach the tables, which is time consuming. Is there a way that I can select the back end database I...