Recent content by WelshJohn

Ah ok. I'm using Access 2003. There must be a way for me to include images without them inflating the size of my database. Can anyone guide me to a solution? Still looking for a way to do this.

Thanks for the reply. To do this the picture would have to already exist, which would mean me creating an image in form design. The problem with me doing this is that every time I am adding another image the size of my project increases dramatically. It seems that it is storing the images within...

Thanks for your reply! I'm still getting an error - Microsoft Office Access can't open the file 'Application.CurrentProject.Path & "\Images\image1.png"' I typed directly into the picture field: 'Application.CurrentProject.Path & "\Images\image1.png" The folder is entitled Images, is in the...

Hi! I am trying to link an images (.png) onto a form. I have a folder of all the images I want but I want the path to be relative. So that if I move the access file and the images folder to a new location, it will still work. In the properties for the image, It works fine as...

Pat, I just got it working. You were right about the Report needing a the field to be bound somewhere. What I was doing wrong was I was putting a the bound field in the Report header section, as it was the ReportHeader_Print sub where I needed the field. As soon as I bound the field in the...

Yes, intellisense links to the field when I type Me. And when linking the control source on the report, I type Uk it picks up on the field from the query. I have successfully linked about 30 other fields on the report in a similar way. When I type Me.JobNo it works like expected. I'm starting...

Right, I just got home and tried that and It didnt work. I made a bound text box to UkasJob, and then tried in the report header print sub to print Me.UkasJob. It didnt work. Thought we had it aswell then. Any other ideas? Any way I can trick it?

Hi, I've been having this problem for a while now so I really had to seek help for it. Basically I have a Report based on a query. The query has about 40 fields across 2 tables. The query has a criteria limitation based on the Job No on one of the tables. Everything else works fine. The Report...

Hi! I am a new member to. I'm a self employed programmer working in the UK. Fairly new to Access and I've been using this website a lot in the last few weeks. See everyone around!