Search results for query: *

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.

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...

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...

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...

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...

Hi, I have a union query that combines two sets of names together. It works well and my SQL is as follows SELECT tblName.LastName FROM tblName UNION SELECT tblName1.LastName FROM tblName1 I'd now like to add the name 'Smith' to my query result and have tried the following and several...

I have two memo fields per record. In a report I have set the CanGrow property of each field to Yes and want to position the top of the second field a litle bit below the bottom of the first field after the first field has grown. How can I do this? Thanks.

How can I examine the contents of a memo field and count the number of vbCrLf characters? Thanks.

Hi, I have a piece of code that lets me use one database, MyDB1, to look at a second database, MyDB2, and then allows me to get various field properties such as field type, validation rule, validation text, etc. What I do is: Set db = DAO.DBEngine(0).OpenDatabase(".......\MyDB2.mdb")...

Hi, I have a database that will be given to people working out in the field. To help me deal with any errors I'd like to get a message box to indicate the name of the procedure in which the error occurred as well as the standard error number, description, etc. Can anyone tell me how I can get...

I need to import data from a text file into Access but the problem I have is that the application that generates the text file saves it with a .res extension. The code I'm using is DoCmd.TransferText acImport, , "tbl_import", "C:\zzz1.res" but I get an error message saying 'You cannot import...

I'm using DoCmd.OutputTo to output the contents of a report which contains one memo field to a textfile. It works well but with one problem; each line of output text has a space in front of it, i.e. if the access report had Apple Banana what I get in the text file is Apple Banana My...

I have a table called tbl_Runsum with a date field called 'when' and a field with a sales figure called 'value'. What I'm trying to do is sum the sales for each day and then look at the running total as the date progresses from the first date in the table right through to the last date. My...

I've written a database in Access 2003 using an Access 2002 - 2003 file format. I've then created an MDE file and distributesd this file to users. The users who have Access 2003 can run the database without a problem but those who have Access 2002 cannot run the database and get a message that...