Search results

thank you both for the replies. I don't know why I was thinking that the import spec would write over the existing data. Cough..Cough...Hack...Ohhhh, I think I'm catching SARS. Thanks again.

I'm using Access2k I created an import specification that isn't working right. I'm trying to import a tab-delimited text file and write over an existing table. What is happening is it's appending the data to the existing table instead of writing over the table. When I created the import...

If I follow you correctly you could just use a unmatched query with the larger table as 1st table in query and smaller table as 2nd table in query. The result of this should give you everything in table1 that does not exist in table2. Then you can append the results of this to you other table...

Thank you for your quick reply Travis. I think I may just go back to my backup database before I split it. The only people using the dbase will be me and a couple other co-workers and most likely none of us would need it at same time so considering this I may not really benifit much from...

I've recently split a database and when I try to run one of my subroutines I get the following error: run-time error 3611 "Cannot execute data definition statements on linked data sources." The line this is erroring on is: DoCmd.RunSQL ("ALTER TABLE WizardCatsLayersFile ADD COLUMN SiteId...

I may be wrong but can you set the On Change event property or maybe the After Update property with your own error handling message? I'm not sure if it would disable the default access error message but maybe its worth a shot. HTH

Thank you both very much for your help. Let's see if I get this straight. I am indeed using SQL on the fly many times in the database so this is the primary cause of my bloat then?. This is an example of one of my functions that I run: Function EditWizardCatsLayersAndCarFilesCombined() 'This...

I'm suffering from a terrible case of bloated database. I'm using access 2000 and the purpose of this db is to import several text files and perform a series of functions to modify some of the data on them. The tables in question are typically between 4000 to 12000 records. The database is...

I'm not the access guru that you all are so I'm not sure if this is something you've tried but I use this in one of my databases and it works great. Public Function Pause(NumberOfSeconds As Variant) On Error GoTo Err_Pause Dim PauseTime As Variant, start As Variant PauseTime...

Thank you very much for your reply. It seems to have worked in removing the relationships, although I inadvertently deleted some tables that I wanted but that's ok because I just copied the tables over from the backup database I made before removing the relationships from the original database...

I found this link on this site and was wondering if this is what I need to do to clear all the relationships in my database? Sounds like it but wanted to check to be sure. Thanks. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=6115&highlight=msysrelationships

I'm running Access 2k and I built a database and did not set up any relationships to begin with. I got vba code and queries working for my program and one day I was messing around with the relationships window trying to learn how to set up relationships and I hosed things up. The problem I'm...

Thanks a lot Jon. It's the stupid obvious solutions that really kill me.....aaarrgghhhh!!! Much appreciated! :)

This is driving me nuts!!!! I'm using Access 2k and I can't get replace function to work. I tried using: Replace(sExpression, sFind, sReplace) but whenever I use the parenthesis the text turns red. The only syntax that Access accepts is: Replace sExpression, sFind, sReplace The code runs...

The DoCmd is not an object. You can't use the With statement on the Docmd. This ought to work: With CodeContextObject .cboPostCode.Visible = False .cmdGrout.Visible = True .cmdAddTileProduct.Visible = True .txtCustomerID.Visible = True .txtSurname.Visible = True lstDetails.Visible =...

I think I found a possible way to do it programmatically. I can take the source text file and create a schema.ini file on the fly for it. Then use the schema.ini file as my import spec. Sounds like more work than I care to do though. I guess that option is there for the future but I may just...

Thanks Doc_Man. It's not that big a deal if I was to import the table manually each time but was hoping that I could automate it on a form. You say that it may be possible with VBA? Is this difficult to do? Off the top of your head do you know of any examples of this? Thanks.

I was wondering if its possible to create an import spec that would import a designated tab-delimited text file which would have a randomn # of fields on each import. I'd like to just set an import spec to import file -with tab-delimiter -1st row as header -all fields as text -access assign...

I got it working. Thanks again RichMorrison. I took a few steps back and re-thought my problem and came up with this solution (with the help of another post on this forum). MTX = recWizardCatsLayersAndCarFilesCombined![MTX] Freq = recWizardCatsLayersAndCarFilesCombined![Freq] SQL = "SELECT...

I'm not sure If I'm on the right track or not but from my confusing original post I was trying to say that I want to filter out Table1 to find the recordset WHERE Table1.[MTX] = Table2.Field(0) And Table1.[Freq] = Table2.Field(2) From this recordset result I want to take Table1.[Channel] and...