Search results

I have a simple query that I use to list Engineering Changes raised in any particular month, and until last month it was working fine. When I try to list changes raised in March, however, the query returns no results, yet I know a large number of changes have been raised. The query contains two...

Is it possible to to set up a table in an access DB that records response times for opening the DB, navigating between forms etc? I have a number of users based on a remote site and they are complaining about how slow the database runs, claiming it is unusable. When I visit the site and access...

This link may help: http://www.access-programmers.co.uk/forums/showthread.php?t=67168 JQS

I'll give that a try.

Snoko Thanks for your help so far. This obviously isn't as straightforward as I thought! I know I could get around the problem if I added another field to the table, probably a YES/NO field called 'Superseded' or something like that. Then I could filter on that field. I'm trying to keep data...

Snoko I followed your advice, and now the query returns only the record with the highest change issue. What I wanted was a complete list of change records showing only the latest issue for each (if that makes sense). Is there some way I can extend this method to show the latest issue for every...

I've got a table in my Engineering Change database with the following fields: ChangeLink ChangeIssue Remarks The table contains multiple Change Issues for each Change Record. What I'm trying to do, as part of a query that pools data from multiple tables, is display only the latest issue of a...

This is a shortened version of a problem I posted in the General Forum a week or so ago but have had no response to. Maybe I'll have more luck here. I'm using the following code to delete backup files older than ten days: Dim checkFile checkFile = Dir(MyBackupPath & "\*.zip", vbDirectory) '...

I'm new to access and began work on my first database a couple of months ago. This site has been a great help, and up to now I've been able to find all the advice I need by searching the forums. However, I now have a problem that doesn't seem to be covered in previous posts. I'm using the...