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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I create a Macro to Purge information in an Access 2000 Table
Thanks, I'll see if this will work. I may just run the query once a week instead of daily. Jim- oopa
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do I create a Macro to Purge information in an Access 2000 Table
Our cart system is written is ASP, as a backend to Adobe GoLive, hosted on a Windows 2003 server. The age of the Order recorded is by mm/dd/yyyy. So, can I use: DELETE * FROM Orders WHERE [MyOrderDate]<Date()-3- oopa
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do I create a Macro to Purge information in an Access 2000 Table
Yes, the IP claims he can .exe the macro on the server side as long as I create the Macro. Jim- oopa
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do I create a Macro to Purge information in an Access 2000 Table
I am using Access 2000 as a backend database which stores customer information for online purchases. I want to create a macro, which will autoexec, to purge all information in the Orders Table older than 72 hours, each day. The Orders table contains 46 fields. I've tried search engines for...- oopa
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
