Search results

Oh they were saved. Working - form closed - opened - working - form closed - open - working - form closed - open - .......not working. In this context, yes, pants mean crap :) M.

Saying that, after all that, and working fine, just started messing up again. I think the bottom line is, the chart/graph control is a bit pants!

Played with this quite a bit, producing a separate example was problematic. Ended up translating dates/times in to a simpler integer value (it didn't need to be visible) and recreating the graphs from scratch. Bingo. Think it was gremlins! Thanks :)

Hi there I have a problem with the chart/graph object. It's embedded on a form, and the data within can change quite a bit in scope and scale (date ranges could be 1 minute to 1 year, values might be 0-10 or 0-10000 or more. So I nee the axis to scale automatically. I set a row source to...

Hi there. Right this might sound a little complex, not too sure how to word it so I'll give it a go. Note although I reference reports below, the scope of this goes somewhat beyond just reports. I have a `communications engine` that has been written in an access DB that I look after. It...

Rough guess, different compression levels are being used - is there another property you can set for jpeg quality/compression?

There is a workaround you can use in some situations... I have a `main menu form`, which includes a semi-transparent .png which covers 1/4 of the screen, a coloured rectangle behind that (allows dynamic colouring of said logo after accounting for transparency in the image ;)), and a series of...

I had just the same problem with a certain query I was trying to export. In my case, it was due to the name of a field in a query - it was supported in access as a field name but was obviously not allowed when exporting. If memory serves me correctly (not with my DB at the moment), access...

Many thanks for all that LPurvis - your a star! Will read/digest and try :) Martin

That bit there - checks to see if a connection can be established without actually pulling anything down. Let's me pre-check things like if a user has permission to connect to a database and ODBC link is working (and handle any failure if theres a problem) before we even think about linking...

I supose the short answer there fore is, it doesnt look like there will be much of a problem - just the slog of going through all code and updating as relevant! :) I just don't want to go about doing it one way, to find out that method is actually a couple of years past its sell by date on the...

Hi all! Ok today for the first time I get the chance to finally look at office 2007 and upgrading my access db from 2002 (our entire workplace is upgrading to 2007 and our db is going with it) The access itself is used mainly as a front end to a back end ms sql 2005 database, with a...

Thats awful :( Noticed in the article it says `since a routine surgery 5 years ago went horribly wrong` - surly thats a case for compensation etc.? Any football stadiums or the like near by? A family friend has a little girl with a medical condition that they are fundraising to try and help...

Sir - that is spot on information, may thanks :) I thought (hoped) it was a bug, and wasn't just me going mad! Many thanks for the code snippet to. Martin :)

The same thing happens for every record in the recordset First time you look at that field when viewing a record, its value dissapears! (and as shown by the video, you don't even need to have any code access the variable to do it, access can do it all by itself :cool:) Martin

Theres nothing much more to see really. So many variations of trying this have been tried. But anyway.... (A couple of names have been changed in the code for security reasons :rolleyes:) Dim wrkODBC As Workspace Set wrkODBC = CreateWorkspace("", "admin", "", dbUseODBC) Dim conPubs As...

Hi there all! Ive a strange one someone may be able to throw some light on..... We have a recordset, and every time we access a certain field in that recordset, the data in that field dissapears/null's The data is sourced from a linked table (odbc) to an ms sql 2005 server. We've tried...