Search results

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

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

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

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

I'm linking to an Oracle table via ODBC (I'm doing this 'manually', not through VBA code). There is a field in the Oracle table of type VARCHAR2(100). MS Access has taken it upon itself to assign a data type of MEMO to this field instead of TEXT. This is very limiting - there are things that MS...

Hello, I'm fairly new to MS Access (2003) and I'd like to know how to execute Procedures/Macros automatically to a predefined schedule. Does anyone know of any good Tutorials or articles on this?