Search results for query: *

I need to create a View that:- (a) Initially shows all records (b) Provides a facility for the user to type in a date range (i.e. From: 01-Jan-01 To: 31-Jul-01) to narrow down the number of records displayed. Does anyone know how to do it or better still are there any example databases out...

I need to create a view that:- (a) Shows all records to start with (b) Provides a facility for the user to type in a date range (i.e. From: 01-Jan-01 To: 31-Jul-01) to narrow down the range of records displayed. Does anyone know how to do it or better still are there any example databases...

FinnMann Try using this subroutine:- Sub DAO_SQL_Search() Dim db As Database Dim rst As Recordset Dim strSQL As String ' Open the database Set db = DBEngine.OpenDatabase("c:\program files\microsoft office\office\samples\NorthWind.mdb") 'In the line...

Thanks "strongm", that's exactly what I wanted. Cheers matey.

Thanks a lot for replying John but I didn't just want a standard toolbar, I wanted one that looks like the one in the main view of Access 2000. It is usually situated on the left hand side. There is a similiar in VB6 IDE which has a grey command like button with General on it and then you can...

Does anyone know how I get a toolbar in my VB program that looks similar to the one used in Access 2000 (i.e. the one that has tables, queries, forms, etc in the heading)? I have seen a similar toolbar in another VB app. Obviously I don't want my toolbar to have the same heading as the Access...

Database was originally not secured but I've added user-level security to it. Now having trouble getting the DB grid working. I notice the data control has now property to add a security group to it. Looked at various sites but still can't get it working. Most seem to hint at ADO but don't...