Recent content by Mendel

I'll admit that I'm not the most prolific programmer but as far as the deletion of the main table I'm deleting the records, not the table. I apologize for mis-stating the problem in the 1st place. With these suggestions then am I correct to assume that it would work if I did the following...

In short I have code that takes a main table and then copies the data to a backup table. I make changes to the main table. Then I delete the main table and copy the data from the backup table back into the main table. My problem is that after I've copied the data from the backup table back...

Hey that works great. Never knew of that command before. Now that it works it brings up another question. If I have the kill command coded to delete 10 files in a folder it will delete them just fine. However; I will have some cases where only some of the 10 files will exist in the folder...

I'm running an audit program which is analyzing 5 sets of data consequtively. In short I'm running one particular function in which on the second set it gives me an error: "The database engine could not lock the table 'ADJSYSCorrections' because it is already in use by another person or...

I have code written to export some tables to an excel file in a particular subfolder. Is there a way to have code written or something that will clear out or delete any old files from that subfolder before the new tables get transfered into the subfolder? Thanks for any help.

Hi, I have a program in my database that I would like to have run every morning at 7:15. I'm using Access 97 and running on Win 98. I tried using the scheduler program and have it set to run a test macro: "C:\My Documents\newdatabase\one.mdb \x Test" at whatever time and it won't open. Am I...

Nevermind. Something got hosed up with my text files. Boy do I feel stupid now. I think I should go home now and finish off everything in my liquor cabinet.

AAAAGGGGHHHHHH!!!!! Sorry just had to vent a little. I cannot for the life of me figure this out. I'm trying to import programmatically 2 text files and append them. Here is my code: DoCmd.TransferText acImportDelim, "nwkadjcl2 Import Specification", "nwkadjcl"...

Thanks guys I got it working.

Question with the trim function.... I've got a field that read: xxxxxxxxxx ooooo xxxxxxxxxx ooo xxxxxxxxxx oooooo and so on for each record where the length of x is constant but the length of o is varying. I need to Trim off the x leaving just the o. I know there's some code to do this but...

Thanks for the advice. I changed it to read: dbs.Execute("INSERT INTO Table(Field1)" & "VALUES("' & Field1 & '");") Works great now!

Nevermind. I just changed the IGNORE field to IGNORED. Wasn't really what I wanted, but it'll work.

Well I post my code so it can be looked at but my problem seems to stem from this statement: dbs.Execute ("CREATE TABLE PARTDATACorrections(MTX TEXT, IGNORE TEXT, ....);") VBA or Access 97 or whatever the reason won't let me use IGNORE as a Field Name. Is this a reserved word? If so, then why...

My code is comparing 2 tables, a Master Data table and a Raw Data table to find any discrepancies between them. Then I create an output table "TableDiscrepancies" to display the discrepancies. In the beginning of my code I delete a table: dbs.TableDefs.Delete "TableDiscrepancies" and then...

I'm having all sorts of trouble here. In short, I have 2 tables I'm comparing. A Master Data table and a Raw Data table. I'm trying to write code that will start at record(1) on Master table and find the same record on the Raw Data table. Once it finds the record then I want to compare each...