Recent content by anthonys

OK - after much hair pulling it turned out the issue is caused by the installation of 2003 runtime or 2003 full access. I had to uninstall office 2010 and reinstall it.

Having looked at it some more i think it might be caused by 'Protected View' when the template opens. Does anyone know how to switch on 'enable editing' from code? cheers ant!

Thanks for the tip but it is still not actioning the code, it steps through with no errors but word is not not opening and the mailmerge is not sending the email. Any other tips, it's bugging the hell out of me!!

Hi I have a legacy system that i wrote a few years ago that worked fine with office 2003 but we are planning an upgrade to office 2010. The application included a emailmerge button that performed a word mailmerge in the background. With office 2010 the code just steps through not appearing to...

I’m struggling and I know I doing something stupid!! If I try the following SQL to return the date 30/04/2009 I get ‘error converting 30/04/ to int’. SELECT DATEADD(YEAR,-1,'30/04/' + DATEPART(Year,GETDATE())), Obviously I could just type 30/04/2009 but I want it to dynamically calculate...

I have an issue i would be grateful for some assistance on. I have a function that has a fieldname passed into it (relevant code below). i then want to use that fieldname to reference it on a form but it does not accept it. What am i doing wrong?? Any suggestions will be greatly...

Fixed problem by recreating the ODBC connection and reinstalling ODBC drivers, thanks for all your help!

- The problem is that the pop up box to select the primary key is not popping up. - The primary key in SQL is a unique Rowid but it still is not working

When i link a SQL table to MS Access using ODBC the UNique Record IDentifier is not popping up. Does anyone know a way i can manually set this, or force it to pop up, as at the moment i can't add any records to my database? Thx in advance Ant

You need to look up the concept of Left and Right Outer joins, for example d23 INNER JOIN MP ON d23.MP = MP.MP This query will only return records from d23 where there is a related record in MP. If you have 270 records in d23 and only 200 have a matching record in MP you will only return 200...

Basically you need to first establish the latest conversation for each job (bottom select) and then use the results of that query to restrict your main query Something like this.......... SELECT DISTINCT J1.Field1, J1.field2, C1.Field1 etc....... FROM Jobs AS J1...

You could also look into using a smart client front end. http://en.wikipedia.org/wiki/Smart_client This has the benefit of providing communication over HTTP whilst giving the developer desktop application (fat client) functionality. We have developed a couple of these and they went very well...

Are the 2 offices on the same network? Do they have a shared drive that you can put the files on? Do they have a terminal services system (citrix for example)? If you answer yes to any of these questions then you should be able to do something, if all three are no then you are going to...

I don't mind answering your questions and respect that you want ot learn as you go along. I would recommend that you research the use of sub forms to create you customer->orders form. I would also recommend that you look at the sample databases installed with MS Access (Northwind and Orders)...

If you want to store the actual value you will need to change the "bound Column" property of the combo box. The datasource probably has 2 columns, column 1 is the ID and column 2 is the value you want to store. If you change the bound column to 2 it will store the description instead of the...