Recent content by JohnPapa

Which is the QAT? The two toolbars seem to appear when the Runtime is used.

I attach the whole top part of the screen, when I run the .accde using the Runtime.. There is too much empty space, which does not appear if I run the .accdb from Access.

As can be seen in the attachment, the top of the screen is occupied by the reddish color. Is there a way to remove this?

Yes, good point to remember

This may be a better way. I would change AppPathsKey = 'SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\ACCESS.EXE'; to AppPathsKey = 'SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\OUTLOOK.EXE'; In my case I need to install the correct Access Runtime, so I am not really interested...

Searching for the following works HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\<version>\Outlook In line with gasman

Does not seem to find the specified Registry folder and does not return the bitness

Many thanks, this should do it.

After some further research the following might work. Will test it out. function GetOfficeBitness(): String; var Bitness: String; begin if RegQueryStringValue(HKEY_LOCAL_MACHINE, 'SOFTWARE\Microsoft\Office\ClickToRun\Configuration', 'Platform', Bitness) then begin Result := Bitness...

I believe there is a misunderstanding. There is no problem checking for bitness using VBA. If you look at my original post #1, the question is how to do it using Inno.

Apologies in advance if this is not the correct place to post. I use the following Inno code to install my software. I would like to check if Office is installed and if it is installed to check the Bitness. Based on the Bitness I would like to install either the 32-bit Runtime or the 64-bit...

Hi Pam, I decided to use something along the lines you mention. As I mentioned I have a .accde which is runs and does some preliminary work and if everything is OK it runs the main .accde. Any C and R would need to happen when the first .accde runs. The first .accde cannot have BE tables because...

Very useful. Was looking at something not that detailed as a start.

Are there restrictions in what you insert between BeginTrans and CommitTrans? If for example I define a recordset, loop through the recordset and change values, can these changes get rolled back?

Please see attachment