Recent content by Finks

Not sure if this is possible but I guess this is the place to find out. In a table I have field defined as an Ole Object. When I right click on this field I get the option to Insert Object and then creat from file and I can browse and then select a bmp to store in this field, is there anyway to...

Not to sure but could it be that you're missing the single quotes ' from you whereStr! What if you change it to - whereStr = "[BuyerID] = '" & Me![BuyerID] & "' AND [PropertyID] = '" & Me!PropertyID & "'"

Thankyou to you both for all your help. I managed to resolve the problem by making the forms recordsource = to a table called Machines, this table holds a list of all the machines. Then set the forms filter to the required machines and it only displays graphs for those machines.

Thnx for the response, I just tried as you suggested and it works in that I now only have one chart but now instead of there being a chart displaying monthly totals for each machine I get one chart displaying the totals for all machines. I'll try and explain more clearly - I have a table that...

Yep, zipped it up and it still comes in at 710KB

I can't get the database small enough to attach and I've taken out absolutely everything that isn't relevant to this problem and most of the data.

The form is currently set to single form as it can't be set to contiuous.

Hi all, I've been going round in circles for two days trying to solve this problem so any help would be much appreciated. I have a table def query that produces a table giving monthly totals. I then use a chart on a form to display these totals. The chart works fine (after lots of trial and...

Thanks, that's exactly what I was after.

Does anyone know, or if it's at all possible, to split a forms backcolor (which is stored as a Long) into it's RGB componenets ?

I'm creating a DVD library database for someone and they would like to be able to store a picture of each DVD cover with the DVD details. I have done this by using a common dialoig box that displays all bmp files, the user then selects a bmp which is then stored as an ole object. What they would...