Recent content by achan275

Yes, I tried using DIR(mypath+myfile) as well as DIR("C:\Documents and Settings\X\My Documents\submission\TODAY\*.xml") and both gave the same result. I almost checked everything, I looked at the reference and everything looks alright. AC

Hi all, I ran into problem with Importxml in Ac2003. I am writing a piece of code to import xml files to an Access database. Here is my code: Private Sub Command0_Click() Dim myfile, mypath mypath = "C:\Documents and Settings\X\My Documents\submission\TODAY\*.xml" myfile = Dir(mypath) Do Until...

Thanks Mike!! The formula make sense to me and i created this formula myself: whileprintingrecords; dateVar crdate; numbervar numdate:={createdate}; numbervar numyear; numbervar nummonth; numbervar numday; numyear:=tonumber(left(totext(numdate),4))...

I need to do a report to tell how many parts are used per repair, while a repair is defined as all of a unit's record entries are generated within not more than 30 days apart. I am thinking of comparing the date of the records within a group(per unit) and see if it is more than 30, but not sure...

Is there a way to link those non-SQL server tables in Access 2000 Project (.adp)? Anyone can show me methods or code on how to do it? Thanks in Advance. AC