Search results

Thanks for the info, Pat. However, there is no relationship at all between these two tables (other than what I created in the query's design view). Neither is a parent or child table. I've tried using a delete query to delete the matching records in Table A, but I can't figure out how to...

I have two tables (same data but slightly different attribute structure) with a one-to-one relationship (the join field is "ID"). There are 69 matching records in these tables. How can I delete these matching records from table A, while leaving them alone in table B? I'm confused because I...

I have a query that I manually export as a dbf file (i.e. right-click and export). I manually export because I export to a unique directory each time. However, fields in the query that are of type string always get exported with a length of 255. Is there anyway in SQL that I can set the width...

Thanks for replying. I created a date/time field in the access table. So should I run an update query and update the date/time (using the date and time functions) every time data is appended? If so, won't this simply update every record in the table to the same date and time? Am I...

If I import a text file and append it to an existing table (using the TransferText method), is there a way to undo the append if there are errors? For example, if a user tries to import a text file with an incorrect structure, sometimes data will still be appended to the existing access table...

I'm new to programming, and was trying to copy some code from a text book using Access 2000. Dim dbs as Database Dim rst as DAO.Recordset When I try to write this code, there is no "Database" class that shows up, nor is there any "DAO" "dot" anything, which of course leads to many errors...

Thanks. Thanks for the code... it works perfectly. :)

Is there a way to loop through each table in your current database, and check each name? The reason I'm trying to do this is to see if there are any import errors from a "texttransfer" method I run, which appends data from a text file a user selects to a table in my database. I know that if...

Is there an easy way to import text files into a database? I've seen some sample code using the "transferdatabase" method, but the list of possible "database types" doesn't seem to include text files. I'm just a newbie so if anyone can just point me in the right direction it would be most...

Thanks ducker, that worked perfectly.

Is there any way to customize Access to disable query pop-up messages, such as "You are about to modify 400 records..." or "You are about to delete a table..."? Is this possible either at the application, database, or macro level? Thanks in advance.