Recent content by Dave_cha

Access 2007: Enable Macros on Startup - Solution I'm afraid the help menu wasn't much help aside from highlighting the option via the trust center. I have figured it out though. The change required is registry based so I've added the following lines to my startup script... Dim ChangeReg Set...

I typically use Access as the frontend to backend SQL/MySQL databases. One area I would like to see improved on is the ability to quickly switch a set of linked tables from Prod to DR to UAT to Dev etc. At the moment it a cumbersome process which requires a DBA to manually change each linked...

Hi, Has anyone figured out if it's possible to enable vba macros on startup using a script? In Access 2003 I used application.setoption to tweak a number of application parameters though I'm not sure if I can use this to enable macros in 2007. I know that I can manually enable macros through...

Hi, When giving users access to an MS Access database, I always publish a shortcut to the database in a shared network directory. The properties of the shortcut are typically as follows... "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp...

Hi, I currently use Access as a frontend with linked tables to a MySQL backend. I'm need to be able to build a single string containing the field values from several records. In other words I need to be able to gather employee id's and surname's based on variant criteria from an employee...

Thanks. Will give that a go.

Hi. Thanks for the reply though unfortunately I've previously tried these options without success. Editing the Connect field in Msysobjects would in theory do the trick however this field doesn't allow edits and I can't find a way around this. Also, when creating a DSN linked table, certain...

Hi, I have several Access db's setup, all using linked tables back to a MySQL db server on the network. So effectively, MS Access is the frontend with MySQL providing the backend. One problem I've always had when modifying existing MS Access frontends is that I'm typically having to work with...

Thanks Peter, that worked perfectly. I don't suppose you've ever connected to a MySQL db from Excel? :) Would be nice to lookup the employee name from the ID. Dave

Does anyone know if and how I can insert the pc logon ID into an excel cell each time the user opens the excel file? Various users will have access to the file so the current user's details will have to replace that of the previous user. Thanks, Dave

Thanks for the reply Modest. I tried your suggestion as follows but am getting an error... Dim strFormName As String Dim ActiveFormObj As Form LetActiveForm() = "[Forms]![FRM - EMP NEW ADD]" strFormName = GetActiveForm() 'Retrieves Active Form as string Set ActiveFormObj =...

I'm trying to define a session object based on a form name which could then be refered to from another form. So far I've been able to declare the form name as a string when FORM A opens using the following code... LetActiveForm() = "[Forms]![Form A]" Module used...... Option Compare Database...

Thanks Jon...that worked perfectly. Dave

Hi folks, I have a mailling solution in place which builds a list of recipients from a listbox on an open form. I'd like to modify this to remove the form from the equation and build a list directly from a table. I will need to have the option to filter the records pulled from the table as the...

Hi folks, I'm trying to execute a DTS package on a local MS SQL server with the click on a button on an MS Access form. Does anyone have any code which would do the trick? I managed to find the following but I'm getting a "User-Defined Type not defined" error on 'DTS.Package' on line 1...