Search results

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

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

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

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

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

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

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

Hi all, I have a combo box who's Row Source Type is set to Table/Query and who's Row Source pulls 2 columns of data from an existing table (UserID;UserName). I would like to set the first row on the combo to "*;Select All" and follow this by "UserID;UserName" for all users in the table. I've...

I have a fairly simple report which is populated from one table (TAB1). The records in this table have several fields containing employee id's. I would like to reference each instance of employee id in each record to an employee table (TAB2) and display their names in the report. The obvious...

Has anyone experienced problems when opening shared databases following the installation of Adobe Acrobat? I have Access 2003 shared db's which are accessed by users via a desktop shortcut. Adobe seems to force the db to attempt to open with exclusive access resulting in an error. I know how to...

Hi folks, I built a database earlier this year which involved users importing date based data. The destination data tables are linked tables connecting to a MySql database. To avoid duplicate data, a DCount is performed on the destination table's date field for dates equal to a given date...

Hi folks, I'm trying to build a pro-rata annual leave calculator based on the starting date of an employee. I have it working but it's rounding the result to the nearest whole day. HR have asked that it calculates to the nearest half day. By way of an example, an employee who started earlier...

Hi folks, I'm trying to read some records from an SQL database. One of the fields is an integer field though the data corresponds to a given date and time stamp. When the data is viewed through the vendors application it uses C++ to convert the integer to a legible date and time. The C++ code...

I've used dlookup to seach 1 field against a given criteria. The dlookup should produce multiple string returns. I want to store these returns in an array and later feed the contents of this array into a listbox. It's important that I have the array between the table and listbox so simply...

Hi folks, Another problem I'm hoping someone can help me with. I have a table with two columns. The first contains a list of employee id's (one for each employee in the company) and the second contains the employee id to whom the employee in col1 reports to. I would like to build a form with...

Hi folks, I'm trying to establish a connection to a MySQL db and populate a listbox with data from a table in the db. I'm trying to trigger this on loading the form. I haven't done this before as I've previously used linked tables. This time around I've been asked to avoid DSN linked tables...

Does anyone know how to requery a listbox within a subform? A popup form allows me to make changes to the underlying record source of the listbox. When I close out of the popup and return the main form I would like the list box within the subform to display the record updates. I've tried the...