Search results

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

Thanks guys for the response. If possible I'd prefer to build the solution as a view in MS SQL. I tried the CASE option as you described it FoFa however I receive the following error; "The Query Designer does not support the CASE SQL construct." Thanks, Dave

Hi folks, I have a query which pulls together several other queries. It works fine in Access but I also need it to work on a MS SQL server. the SQL is as follows; SELECT Client.ClientName, Entity.EntityName, IIf([101].[ProductID] IS NULL, [-], [X]) AS TA, IIf([301].[ProductID] IS NULL...

Thanks John. I'll probably stick with the code but it's useful to have the option. Rgd's, Dave

Thanks Seth......I had just worked out a similar solution. Private Sub Form_Load() Dim MinYr, MaxYr As Integer MinYr = DatePart("yyyy", Date) - 5 MaxYr = DatePart("yyyy", Date) + 5 Do While MinYr <= MaxYr Me.Year.AddItem MinYr MinYr = MinYr + 1 Loop Me.Year = DatePart("yyyy", Date)...

Hi folks, I want to populate a drop down combo box with a list of 10 years (current year +/- five years). I can enter them as a Value list but I don't want to have to update the list every year. Neither do I want to allocate a table to maintain a list. Any ideas as to how I can auto populate...