Search results

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

As a last question, since I have never used BeginTrans etc, to anyone who has used it, did you find any problems?

Many thanks cheekybuddha. I have made some minor changes and I include below the code you provided: Function funDoTransaction() As Boolean On Error GoTo ErrHandler Dim lngDum As Long Dim blnReturn As Boolean Dim blInTrans As Boolean Dim strSQL As String blInTrans = False With...

Thanks. I have seen this. Was looking for an example.

Can ADO be used to handle transactions, where the transactions are committed only if all transactions are executed. I have found examples with DAO.

I have been unable to find a diagram of the ACE structure, as exists for JET.