Recent content by kc1

Hi I am having issues with creating a MS Project XML from Access. I have created an XML file from MS Project and imported into Access, this created the required tables. Now, when I create the Project XML from Access that I want to import back into MS Project, the XML is created fine but when...

Thanks for your help I built a new database and the code now works.

Same error as before Complile error: User Defined type not defined

Thanks, please could you tell me what Rferences you have checked? I have Mircosoft XML, 6.0 checked.

'Private Sub btnExportXML_Click() Dim objOtherTbls As additionaldata Set objOtherTbls = Application.CreateAdditionalData 'Identify the tables or querys to export objOtherTbls.Add "internet" objOtherTbls.Add "mokaleme" 'Here is where the export takes place Application.ExportXML...

I'm using 2003 (company won't upgrade). My code is very similar to what you posted. The compile error is flagging up this line Dim "objOtherTables as additionaldata"

Hi I using the CreateAdditionalData method of exporting multiple tables as XML, What reference(s) do I need to add? Thanks KC

Hi All I'm currently building a database that links to both MS Project and Primavera. I've mapped most of the fields but was wondering if anyone has a complete mapping table they could share? Thanks in advance. KC

Appending when getting data from a different database? Is that doable?

I haven't actually written any code yet, I was hoping for some here. What's the easy way then, I'm all up for making things easy?

SOS!!! This is what I want to do, if someone could help me out with the code that would be great. Assumptions: 2 databases 1. DB_FE 2. DB_BE 2 tables, both the same structure in both of the Databases 1. tbl1_FE 2. tbl1_BE Using ADO I want to append all records from tbl1_BE in DB_BE...

Thanks I will give it a go tomorrow. So why did it work with OR when I actually entered the numbers?

Hi All Access Gurus Got an issue with what I thought would be a simple select query. On a form called frmMain, there are 3 text boxes that each contain a number. The query is a group by and sum. I want to only select the records that don't equal what is in any of the text boxes. In the criteria...

2 words..... absolute genius works like a dream many thanks

error 3047 line - DoCmd.RunSQL sqlAlterTable