Search results

Thank you, suddenly all the issues I've been having with this make sense:-) For the benefit of others with similar issues, the Registry path is: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\ (might be a different version number in place of 12.0).

I have developed a database in Microsoft Access 2013. I wish to install and run that database on another machine on which I have already installed the MS Access Runtime. In order to allow the database to run correctly on the target machine, I need to add two Trusted Locations - one for the...

The error number was 2950 (which has been covered earlier in this thread). The 'execution error' message is the one I always get whenever an unhandled exception occurs in the Access Runtime environment. The problem has gone away now that I've installed MS Office 2007 Professional on the target...

Thank you for this. Now that I've added a Trusted Location, my application opens without the initial 'Are you sure you want to trust this Publisher?' message. As soon as my application tries to execute any code which the Microsoft Access Runtime deems 'suspicious', however, the program just...

Yes, I've already seen this, thank you. Long story short: doesn't work for me. I'll persist with trying to produce an application which works with the Package Solution Wizard for now.

Thanks Dale, that got me a bit further. Now I can open (some) forms and look at basic data. It would appear, however, that if a form attempts to execute any code which is outside of that form, then the application will simply close down with a bland "Runtime error" message. For example, the...

Thank you for your reply. Unfortunately, once the pop-up error message, and a subsequent error message, have both been dismissed, the application simply closes, so there is no opportunity to use any menus.

Hello, when I launch a newly installed Access 2007 runtime database, a pop-up entitled 'Action Failed' is displayed indicating that AutoExec could not be executed due to Error Number 2950. Error number 2950, according to http://support.microsoft.com/kb/931407, arises when the application is not...

Glad to help:)

In your code: For I = 1 To LngCnt - 1 If Me.Controls.Item(I).Tag = "CHK" Then If Me.Controls.Item(I).Value = True Then strsql = strsql & ", " End If End If your aim is to add a comma delimited list of table column names to strSql. There are two problems with the above...

I'm a little confused by the SQL: strfrom = " FROM [tempImport].SALCLV" Should it be: strfrom = " FROM [tempImport]"

As far as I can tell from the documentation (http://msdn.microsoft.com/en-us/library/aa243374(v=vs.60).aspx), the same syntax applies no matter how many dimensions there are.

This works for me: function analyzeCell(strArray() As String) Here's the code I used to test it: Sub startHere() Dim strNamesArray(3, 3) As String Dim strTemp As String strNamesArray(2, 2) = "Fred" strTemp = fetchArrayItem(strNamesArray, 2, 2) MsgBox strTemp End Sub...

Spikepl, many thanks once again for your help. Using double-brackets got rid of the error message. It took a while to get the whole thing working because the vast majority of references on the web suggest that the second argument of getDetailsOf should be 26, whereas on my system it is 31...

Many thanks to Spikepl for the useful link. I'm trying to get the sample code working in MS Access 2007, but am getting an error message "object variable or With block variable not set". I've created references to Microsoft Internet Controls (SHDocVw) and Microsoft Shell Controls and Automation...

I'm trying to populate a table with the file paths and dimensions of images (jpg, gif & png) found in a specific (Windows) folder. I'm using a Scripting.FileSystemObject to obtain the list of file paths, but I also need to get the dimensions of each image. I was hoping to programmatically...

I'm trying to create an image object programmatically, but I get "ActiveX component can't create object". Here's the code: Dim objImage As Access.image Set objImage = New Access.image Can anyone tell me why this is happening, please? I'm using Access 2007.

I have created a split form in MS Access 2007. The Form's Current event checks if one of its text boxes contains a negative number: if it does, it sets its forecolor colour to red, otherwise it sets it to black. It's about as simple as context-sensitive formatting gets. The only way I can get...

Thank you:)

I'm using MS Access to connect to two external databases. I need to programmatically pull data from one database and copy it to the other, without copying it to local MS Access tables first. My first effort involved (manually) creating links to the tables in the source and target databases...