I posted this question under "Lookup fields - Yes or No?" but I fear the question is nested too deep in the thread and no one will see it. I am trying to...

If you have a DB setup with a main table linked to a one-to-many table. Is there a way to delete a record from the main table and have all the one to many...

Hello, We have two tables in a query and joined on ID for a one time data project and we need to delete some records from one of the tables. We are using...

Hello, I had a form linked to a table that contained a delete button that allowed the user to delete the current record. Eventually I wound up splitting...

Dear All I Have been here a few weeks trying to get a attendance database up and running. I have had a lot of help so far. Duane Hookum helped me on...

Running Access 2003 on Windows 2000. I have developed a database, no data in it yet. Once I was almost finished with my basic design, I had to change the...

Hi everybody, I get a little problem maybe one of us can help me, Every day I' get a download a "Shorts Report" of every number parts, and this file in .txt is...

Is there a way to determine a table relationship, gather information about the relationship in order to recreate it later. I'm appending data to some tables,...

Hi Just want to get some feedback what is better business practice - for a record to be deleted or just flagged as inactive? I'm working with Insurance...

Excuse me for posting this to this group but I couldn't decide where else to post it. At some time in the past I used custom queries to call values for...

I am having a problem in which records seem to "disappear from a table, but only occassionally. Then I noticed KB article # 287756, in which it states if the...

One I run the make query table I was being asked to click YES, YES, YES. I was able to eliminate the last 2 YES questions but can not get past the " The...

I am trying to delete a record from a table. The record is auto-number and indexed with no duplicates permitted. When I try to delete the field I get...

So here is my question. I'm building a rather simple db consisting of a parent child and child table in a one-to-many relationship (based on the Parent's ID...

Hi, I need to be able to delete duplicate records in a table. The problem is that i would need to run this constantly. I know about the procedure of...

Hello, I have an MS-Access 97 database, that I am cleaning up. Are there examples of VBScripts or VBA code, I can use to delete duplicate files??? Better yet,...

Access suggests that one can delete a link to a table without deleting the table itself. I have never been able to do this. I cannot export an .mdb...

I am seeing old file names for databases that I have already deleted. How do I delete those names? Note: I have already deleted the source files.

Hi, in a ac2003DB occurs next problem. On a head-sub form and when they do delete a record in the subform the primary key suddenly will be removed of the...

I have a folder with some 6,000 jpegs and a datadace with some 2,000 entries. The picture filename and database id record match. How do I match the two...