Recent content by philljp390

yes, i understand what you have written. But im saying this: 20/03/05 <= 15/03/05 That still somehow comes out as true. For example. The records in the table are 20/03/05 - 25/03/05, and i type to search for records between 15/03/05 - 30/03/05. Do you see what I mean?

I have tested your database and your right, it works. I dont understand it though, how can this be?! If you entered to search a start date: 25/02/05 using the following: Start Date Record <=[Forms]![FrmSearch]![TxtEnd] Start Date Record = 01/03/05 How can it still display the result of...

Nice One!!! Ive changed it a bit: Start Date Between ([Forms]![FrmSearch]![TxtStart]) And ([Forms]![FrmSearch]![TxtEnd]) Or ( Forms![FrmSearch]![TxtStart] Between [Holidays]![Holiday Start Date 2] And [Holidays]![Holiday Finish Date 2]) End Date Between ([Forms]![FrmSearch]![TxtStart]) And...

But then what if you did a search for: Start Date = 25/02/05 End Date = 15/03/05 Then the record: Start Date______End Date 01/03/05_______10/03/05 Would not show up. Please help.

Hi all, I have a table with dates in: Start Date______End Date 01/03/05_______10/03/05 I have a form where you type in the start and end dates and when you click the search button it runs a query to display all record that have dates between those typed. The problem i have, is if i were to...

ok, solved by doing: If InStr(1, tblDef.Name, "Customers") >0 or InStr(1, tblDef.Name,"Products") >0 or InStr(1, tblDef.Name,"Businesses")>0 or InStr(1, tblDef.Name,"Contacts") >0 Then Probably not the best way to do it, but it works :D

ok, solved teh Tabledefs part, just needed to tick Microsfot DAO 3.6 in the references. Any ideas on the code part above?

I pasted the code under a button and im getting: "User-defined type not defined" tblDef As TableDef TableDef doesn't exist in my list of variable types

Thanks, this wouldn't be for "users" as such, just to automate the process. Would something like this work: Public Function DeleteTables() On Error GoTo Err_DeleteTables Dim tblDef As TableDef For Each tblDef In CurrentDb.TableDefs If InStr(1, tblDef.Name, "Customers" or...

Hope someone can help with this one.... I want a form to open up and display a list of tables that exist from a pre-defined list. For example: Tables: Customers Orders Products Couriers Pre-defined list: Customers Products Businesses Contacts So as the Customers and Products tables exist...

It seems you can define relationships in the queries which aren't defined in the main relationships. Is that correct?

What im wondering is if the required relationships have all been defined in the queries themselves. Do you actually need the relationships defined in Tools-->Relationships as well?

Yeah i was thinking that, really the relationships should be defined first. Could you explain Referential Integrity please?

I have my database all designed with all the queries and tables. Tables and queries are linked throughout. How important is it then to define all these relationships under Tools-->Relationships Is it really necessary?

ok, it was saying: MISSING: Microsoft DAO 3.5 So i scrolled down and saw Microsoft DAO 2.5 so i selected that and its now working.