Recent content by tekquest
-
T
VBA Delete table module
Dear Pat, I have not been able to add referential integrity, let me explain the databases structure and why RI will never work. there is a main table called "RECTRANS" which holds all the records contract details, then there are 7 child tables, each contain different types of contracts, for...- tekquest
- Post #5
- Forum: Modules & VBA
-
T
VBA Delete table module
Can't do cascade deletes, the initial designer made a big mistake, there is now data in the master table and child tables that are different, it also cant be deleted... So this is really the only way to go.- tekquest
- Post #3
- Forum: Modules & VBA
-
T
VBA Delete table module
Hi all, I have an access database (97) and I have a main table (Rectrans) and several child tables (ADV, CBL etc) Basically, I want to be able to delete records that are more than 7 years old from the last date in the Rectrans table, and any related records in the child tables. Here is the...- tekquest
- Thread
- Replies: 5
- Forum: Modules & VBA
-
T
Select Qry into a Delete Qry
so what is my best option about getting around it and deleting the data? -
T
Select Qry into a Delete Qry
All, I have a select query: SELECT RECTRANS.ContractNumber, Max(RECTRANS.TransactionDate) AS MaxOfTransactionDate, DateAdd('yyyy',7,Max([RECTRANS].[TransactionDate])) AS Expr1 FROM RECTRANS GROUP BY RECTRANS.ContractNumber HAVING (((DateAdd('yyyy',7,Max([RECTRANS].[TransactionDate])))<Now()))... -
T
joint expression problem - query
cheers! mile-o-phile, worked, brilliant! thanks for that!!! :D -
T
joint expression problem - query
guys, when I try to edit queries in my database, i get an error message: microsoft access cannot represent the joint expression transaction.number = tempimport.field1 in design view. * one or more fields may have been deleted or renamed * the name of one or more fields or tables specified in...