Results for the access purgeHow to determine if pass end of the month -I have a program that is keeping a history of files in an access table. And every month I need to purge the table. There is a file for each day of the month. How can I tell at run time if the current date is in a new month or still in the same month as the history files. Example RE: Purge records in visual basic - Does anyone know how to purge the data in the database from visual basic. Best way to purge log file - Hi, I have a text log file which store the error occurs in my application. Each error is a line in the log file with this format: <Date Time> <Error Code> <Error description> I wish to purge the log file after certain period of time for eg. KeepDays = 5 da ID's - Hey! How can I know when a Ms-DOS Application launch in by the shell command is done? In this example, I want the program PURGE accomplich is job then the will complete the FOR...NEXT instructions. Ex: [code] Private sub CmdOk_Click() for i = 0 to list1.listcount - 1 cmd$ = Creating a Sub - I'm making a sub which will search a string and remove the specified character. Does this work? Code: Private Sub Purge(NOString As String, Char As Integer) CharPlace = InStr(0, NOString, Chr$(Char), vbTextCompare) Mid(NOString, CharPlace) = Null End Sub I've still yet to put Determining dates - I want to purge files in a directory that are older than a certain date, say January 1, 2004. How do I do this in vbscript? Access Database Compression - We have a real time process and i have to log all the data periodically into an Access database using VB6 as front end for reporting purposes. The problem is that the size of the database increases drastically so i purge the data after 30 days (Delete the records older than 30 days). Packing a dbf file in VB - Hi guys ...here is a challange... I have the need to manipulate some dbf files from within my VB app. One requirement is to pack the dbf so as to purge the records marked for deletion...any suggestion on if and how to go about this. Regards Gerard trouble with counter freezing - Hi i am very new at programing. My program/computer freezes when the count gets to 2, cant even print screen! I use "cmdPurge.Text = CStr(Val(cmdPurge.Text) - 1)" to count.. Here is the code: Private Sub cmdPurge_Click(ByVal sender As System.Object, ByVal e As How long does data need to be kept for - A user of one of my wonderful apps notified me that an exception was being raised. The error is of course handled so the app keeps running. The app stores data in a database and is purged and compacted on a daily basis. The maximum age for the data is can be set by the user as a numbe One difficult question, one mediocre question - 1> Is it possible to make a program that can create executables? If so, how? 2> What's the easiest way to purge a text file of all quotation marks. Thanks purging empty space - What's a good app to use if I wanna purge (zero fill) the free space on my hdd? Warp Pipe Project: I have something to do with it. - Ok. If u didn't purge my latest post in VB .NET forum, u would have known I posted for a LIVE voice chat, just like in messenger. I need a small, small team of developers to help me if you have any free time. If u are interested, just PM me. purge duplicates from text file - how can i search a text file and remove all duplicate entries how to clear clipboard in ms word 2k3 - Im looking for a macro command to purge the clipboard in word anyone know it or where to find it thanks Access Database Manipulation - In my program, I'm going to give users the option to "purge" the database of older records. So, I need the following to work behind the scenes. I'm going to create a "duplicate" database, with the same table structures as the original, however, this database is Auto purge program - Hi all, I am about to create an app which is to run on a server (in the background) and on the first day of a new month it scans the selected drive and deletes any files not created in the previous month. Before i do this i was wondering if it has already been done on here, if [2005] serial port write buffer - timing issue - Hello, I'm trying to communicate with an rs485 device, and was having trouble with the timing. The device uses "stick parity". The protocol defines this as setting the first byte of a packet to mark parity (this is the byte corresponding to the address of the device), a help needed to access messaging queue - Hello, I need to create a VB6 app which would be able to read and clear messages stored in the message queue on a Windows 2003 server. The messages are being created in the queue by a 3rd party vendor application. So far I have been unsuccessfull in finding examples on the web. PlaySound "SND_PURGE" not working on Windows 2K - The SND_PURGE flag for the PlaySound API doesn't seem to purge the .wav file thats currently playing. It works on Win 95, 98. Does anyone know if the SND_PURGE Flag is supported on Windows 2000. Can't seem to find any docs stating this. |