Search results

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

Thanks It works, however after 7 loops, I get an error message: Record is too Large Any ideas?

Yes, people dont tend to go into specifics, not really crucial to know what the field is called etc when asking a complex question. No need to go down to that level otherwise the question will go on forever!! Thanks KC

Thanks DCB I will give you code a go. Good question, why am I doing this....... I have a dataset, within this dataset there is a field called TimesheetDate. This ranges from 01/06/09 to 12/12/09, but this will change as time goes on. I need to create a final calculation output, which has...

Rabbie I think you are missing the point, when creating a new table the field headings will vary each time, the headings will be derived from another table and I need this to be automated, so a simple Make Table Query will not do. I have no field heading called date, it was just an example...

Re: Create new table using another tables data as field headings It is not as complicated as this. I just need a new table, blank with no records, I will populate the table later in my process. My best bet now is to export Table1 into Excel, transpose Column A in to Row 1 then import back...