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...

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

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...

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...

Create new table using another tables data as field headings Hi I need to create a new table, for the field headings I want to use the data in another table. The only way I can think of is exporting to Excel, transposing, then importing back into Access, but I would prefer to keep it in...

Hi Can anyone help me with why this expression in a query keeps returning an error. Expr2: IIf(IsError(MonthName(Mid([tbl_NewPRDdetails]![Month],3,2))),MonthName(Mid([tbl_NewPRDdetails]![Month],4,1)),MonthName(Mid([tbl_NewPRDdetails]![Month],3,2))) I am trying to return the month name...