Search results

I created a database a while back, not needed to use it for a while. It worked really well but for some reason if I run the database and go to the main data entry page I use and click on one of the predefined search buttons, or the goto last/first record buttons Access will cease to respond...

I have several records that I would like to add a pdf file to. On clicking a button I can get the file to open externally (Adobe reader) but only if the file name is in the code. How would I get it to open the filename that is stored in a form control? This code works Private Sub...

Previously I was adding the images as an attachment but even with reduced quality images the size of the DB was getting big & bloated. I was given the code to get & store the link to the file on my local drive. It all works great except for when I click the 'view icon', it brings up the windows...

I'm trying to create cascading combo boxes but can't get it to work correctly. I've followed the video by Richard Rost where the second combo box only lists the cities based on the state selected in the first combo box. It fails to filter the second combo box list but works in his demo. I...

Hi, I'm using code to go to the next record and warn that i'm on the last record so it doesn't proceed to a new record. The code I'm using works if I put it in the 'OnClick' event but if I try to use the same code in a module it fails. The code is. Private Sub Next_Click() With Recordset...

I have built an Assess database with various forms and in the process of expanding it to cover everything I need to do with it. I'm at the point where before I proceed I need to be able to select a group of record. There are about 30 fields in each record, some of which contain data from...

Hi everyone, Thanks to the admin for letting me join. I've just started with access but have used other database programs in the past. I'm a complete beginner with VBA and it seems that to do any automated task in Access you need VBA. I'm from the north east of England and have used computers...