Search results

I have found a need for Keyword Filters to customize the Intelligent Message Filter as used with MS Exchange 2003 / IMF V2. The answer is the Custom Weighting Feature built into the V2 update. After reading the following article I designed a utility to assist in implementing this easily as...

Have you tried using a subreport for the address information block? You could build a query linked to the user on the main record source for this block. This would be easier than revising the IIF statement or select case statement every time you expand.

Try a find and repace routine in your code. This requires processing each record individually. Look for the "/" in the field and replace it if exists.

Have you checked the Form's properties to allow filters?

I have had some issues triggering events as needed. I found this page on Microsoft's Office Website. http://office.microsoft.com/en-us/access/HP051867611033.aspx Knowing when events happen and what happens during these events helped me. I hope it helps you.

Public Sub Update_Mod_Stamp [DateModified] = Date MsgBox "Need to send e-mail to PS" End Sub On the individual controls, paste Update_Mod_Stamp If you do not get results, change sub to function. By definition, the Function in this case is incorrect to use because you are not returning a value...

You could use a subroutine and call it every time you have an update.

OPtion 1: 1. Create a table with user account information. 2. Create a login form that opens with the database. 3. Store the loginID in a hidden field on a dashboard or by setting a global variable then reference this when applying the security. Option 2: Read the username of the person...

Paste your code into the control source property of the text box on your form.

Try to follow my train of though here, sometimes I fail to be copletely clear. Once you have the information you want on the form, you can set up a trigger to append the data to another table. This trigger may be a button or the AfterUpdate Event on the combo box. You may want to update...

I presumed the nature of your inquiry was to recover a lost database where all you had was the .mde remaining. There are only two reasonable causes to make such a request. 1. You honestly lost the original file and need help recovering it. 2. You are attempting to crack / pirate / steal...

You may find your answer here: http://support.microsoft.com/kb/840258 You may also try http://www.[myintranetsite].com/[page1].htm Try using a URL rather than a UNC path to get to the page via your browser.

Use the unmatched query as your source for the Append query. pseudocode: INSERT INTO [table] (field1,field2) SELECT (Field1,field2) From [Unmatached Query]

1. The rowsource property on the lookup tab can invoke a query builder environment for you. Right click the space where your table / query is shown in this environment, select properties and change the Unique values property to Yes. (Alternate: add DISTINCT after SELECT in teh SQL statement)

Try This: Import all of the fields when you crate the table. Import all the fields when you add the subsequent spreadsheets. Once all this is done, remove the field(s) you no longer need from the table.

I use over 20 .mde implementations in my environment. When I make changes or updates, I simply recreate the MDE and copy it over the old one. You may want to consider storing the accde file(s) in a centalized storage area on your network and have the runtime users use shortcuts to those files...

This has been addressed: http://www.access-programmers.co.uk/forums/showthread.php?t=73739

Per http://technet.microsoft.com/en-us/library/cc178973.aspx The user interface for toolbar and menu customizations is removed and replaced by the new ribbon. You may try the Access 2003 conversion tool...

Click the office button. Click the Current Database menu item on the left. On the right, there is a display form combo box. change this to edit the startup. This used to be accessed by navigating Tools | Startup | Display Form / Page

Have you tried the simple solutions? If you deleted the original database that created the MDE, restore the original from backup. If you changed the file extension from .mdb to .mde, change it back.