Search results

Hi Ranman, Thanks for the quick response. That doesn't seem to work. Nothing is displayed and when I click on the control I get this message. "A problem occurs while Microsoft Access was communicating with OLE server or ActiveX control. Close the OLE server and restart it outside of Microsoft...

I know this has been asked before but I have hit a :banghead: with my searches.We have an old datalogger that stores data into an access table in OLE format. The field displays "Long Binary Data" I presume the stored object is some sort of image file as the datalogger software displays a graph...

Hi JHB, Thank you for your help (again) and quick response. The example, it's a great help. Regards, Poco

First of all, apologies if I am posting in the wrong section. I am not sure if this is a report, VB or query question. I have a database that track projects. Each quarter I have to generate a bar chart showing total number of projects at each stage (there are 5 stages). Then I have to break...

Thanks you JHB. I never thought of that. xl.DisplayAlerts = False was waht I needed Poco

I am stuck with a bit of coding, that should be easy but cant figure it out. I have a module that exports a query to XLSM and another that runs a macro in the XLSM and saves the file as XLSX. All is working but, the file doesn't automatically save unless you click yes. You get the warning "The...

Hi JHB, If I convert your database to an accdr or accde the right click option is not available in access runtime. If I run the accde using Access 2010 professional, I do have the right click option(This is true for my own databases also). My database is deployed on PCs that only have...

It is not available in other databases. I have company information etc. in the database which I need to remove before posting.

Hi JHB, This option is ticked already. I'm not sure if the screen shot will embed properly so I added it as an attachment also. Regards, Poco

Hi JHB, Thanks for getting back to me. Using access 2010 runtime I am not getting this menu, I only get the zoom option. I have tried both accde and accdr. Regards, Poco

Hi JHB Thanks for getting back to me. In runtime there is no print option, just a zoom option when I right click. Poco

Hi, I know there is another thread currently on this, but I thought it best to start a new one. http://www.access-programmers.co.uk/forums/showthread.php?t=284027 I have a very basic database, a query, form and a report. On the form there is a combo box used to filter the form. When you open...

Thank you CJ. I knew it was something silly.

CJ, is this what you are looking for?

Thanks CJ. See picture 1 Poco

It is unless I am mistaken. I have attached a screen shot. Poco

Hi CJ, Thank you for responding. This is something I had previously tried. On the main form frmStockTake I have a toggle button with the following me.qty.form.filter ="[Qty]=0" me.qty.form.filteron = true I get a compile error (Method or Data member not found), I tried...

Hi, I know this should be easy, but I am going wrong somewhere. I have a form frmStockTake and a subform sfrmStockTake. I have several combo boxes on the main form that the user selects to filter the subform via a query. This is working as I want. My problem is I would like to ad preferably a...

Minty, James, Thanks for taking the time to reply to my question. I ended up changing the filed to be required in the table design, so it has crudely got me started. I think James suggestion with a validation rule in the table design might be the easiest option for me. Many thanks, Poco

I am trying to figure out how to validate some data if a user chooses to save a record. On my form I have this as my before update event If MsgBox("Would You Like To Save This New Record?", vbQuestion + vbYesNo + vbDefaultButton1, "Save This Record ???") = vbNo Then Me.Undo My question is...