Recent content by Netherby

Thanks. Works perfectly.

Hi, I am dealing with numbers with 9 digits after the decimal point such as 0.156943882 I would like to be able to format the number with gaps every three digits so it looks like 0.156 943 882 Can anyone help please? Thanks

Hi, I'm using a Windows 10 tablet with a built in camera and Access 2010. I'd like to be able to press a button on an Access form such that the camera is activated and takes a picture. I've no idea whether this is possible or where to start. Can anyone help? Thanks in advance.

Nothing is easy with Mircosoft! I'm due to upgrade to Office 2010 in a few weeks so I think I'll live with things until then.....I remember what happened when one of my colleagues went for a reinstall! Many thanks for everyones comments.

It's interesting the chart appeared immediatly on Access 2010. I'm running 2003. I tried a requery as suggested but no success.

Hi, I've attached a copy of my database. There's a chart in the form called frm_position_chart but when I open the form the chart contents are not displayed. I have to click on the chart then click off it to get it to display. I've tried some VBA to requery the form and the chart but I still...

lameid, Yes, I tried setfocus but no success. Setting the chart focus didn't work and I them moved the focus to another control and that didn't work. Cheers

Hi, I have a form that has a chart control on it When I open the form the chart appears blank with no data being displayed. If I single click on the chart then click on another control on the form, the data is displayed. I open the form using VBA then set the chart RowSource but I can't get...

lameid, Fantastic, you've solved it. I save the printer with the report as you suggested and I now get everything in perfect color. Many thanks.

Hi, I'm using Access 2003 and have Acrobat installed as a printer. I use the following code to print a report but the resulting pdf file is always in black and white even though I use colour fonts in my report. I've set all my Acrobat options to colour manually wherever I can. Set...

Many thanks MajP

Hi, I'm trying to hide an Acess 2000 form using the following but the form won't disappear. frmName = "StartUp" If SysCmd(acSysCmdGetObjectState, acForm, frmName) <> conObjStateClosed Then Forms!StartUp.Visible = False End If I can step through the code OK without error but the form stays...

Thanks PHV. Unfortunately the report CurrentView property is only available from Access 2007 and I'm working with 2003. Any other ideas?

Hi, When I preview one of my reports, I would like to see a couple of extra fields that will not appear when I actually print out the report. If possible, I'd like to avoid having two separate reports. Is there an elegant way to do this? Something like the 'DispalyWhen' property that can be...

Hi, I have an application that takes info from my database, processs it and then places a bitmap image on the clipboard. I know the image is there because I can manually paste it into Word or PowerPoint. What I want to do is to get VBA to save the image as a bmp file so I can then use it in...