Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
help!! Importxml problem
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...- achan275
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to calculate the date difference between two records?
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...- achan275
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
linking data source other than SQL in Access 2000 Project
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- achan275
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
