Search results for query: *

All, Currently I have numerous date columns in various tables that all use the following input mask: "99\->L<LL\-00;0;" What i would like to do is force the user to use the day-month-yr format (only in Canada)which is currently left to either day or year first. Was thinking the easiest would...

I have over 30 tables with mixed date formats any easy way to standardize all to the "yr-mmm-dd" format? I have several tables with over 10000 records and several date columns. I'd hate to have to do this manually, is there a routine that anyone knows of that looks at the date value and...

Why does the date "yr-mmm-dd" change to "dd-mmm-yr" when clicked on a date in the tables, there was a thread I saw on this problem in the archives but no solution or fix was given, anyone know why that is? My regional settings are set to yr-mm-dd.

I am rather frustrated with some date issues I have encountered lately, I inherited these 2 databases that have several date fields, all specifying "Medium date" with some also having the input mask as "99\->L<LL\-00;0;" and some as "99\->L<LL\-00;0;_" and some others with no input mask...

I have searched for some time for a solution or reason why I am unable to split a (inherited) database we use here @ my company. It haS multiple users and never been secured,runs wide open for all, you can imagine the problems we run into. So I decided it was time to bite the "database split"...

Hi all, Am running a Access 2K version in Win XP and suspect due to someone leaving the database open over the weekend.....duh.... Now we cannot open the said database anymore without being pestered by this meaningless dialog box: The yellow triangle ok box which states file not found from...

Anyone know how to delete the recently used email addresses that show in the insert hyperlink window in Word? I think this is a really stupid feature as I do not want my letter recipients to see any other email adresses. Using Word 2002 (10.4219.6714) SP3 on Windows XP thanks

Hi all , I have been trying to show my project view to start at the begin date instead of showing the non active time period of two months prior, don't understand why and cannot seem to modify this view in the Gantt chart view. When I change to calendar view it starts at project beginning of...

Hi all, Have limited VBA capability and have gleaned the following code from various sources and it sorta works. I am trying to have the fileSaveAs dialog forced to save to the users desktop, iow the default path showing up should point to the user's desktop instead of the last foldr used to...

Hi all, I have a macro that runs on the Sub Document_Open to try to remind the user to save the document (Word 2002) before they start editing it. I have found the following code that does this nicely, however I would like to disable the "Cancel" button and have the dialog window point to the...

Occasionally my Word document which contains some macros and formfields appears to loose a bookmark, which is the starting/trigger point in the protected document to add some rows to a table. Of course when the bookmarks is not there the macro pukes. Most of the time it works but then somehow...

This is really continuation from "thread707-926686". The code I am using now sort of works but still pastes in the wrong location and have not been able to correct that. Also it erases the bookmarks from the actual Word document and therefore only works once and not indefintely. And last but not...

Was just reading the ref'd thread on MouseMove event for Active X buttons and tried it but seem to be only functional in one of the two "associated" buttons. (ie when they are in the same table cell in a Word userform) What I mean is that when one is clicked the other un-clicks. suspect that may...

Sorry, but I am relatively new to this VBA macro business and would like to have a hyperlink activated with clicking of the "option button click() sub" Is this possible and how do I go about this? I have a Word form with several functions built in and in the button click macro I would like to...

User form in Word2002 of Office XP macro using Active X buttons does not work with Office 2000 versions. Even though same VBA 6.3 is installed. Get "Method word or data member not found (Error 461)". Short of upgrading and synch'ng all PC's is there a workaround for this?

I am still desperate for a solution to this, the following code does not seem to do it. Private Sub OptionButton1_Change() If OptionButton1.Value = True Then Application.StatusBar = "Option 1 is selected" End If End Sub Private Sub OptionButton2_Change() If...

On a Word form I have replaced the [COLOR=red]checkbox form field [/color red]with the control toolbox [COLOR=red]option button[/color red]. My problem I have no idea how to have context sensitive help info displyed on the status bar at bottom of page like was the case with checkbox. any...

I have the following problem and hope you can help me. Designed a Word form with both formfields, checkboxes and Active X radio buttons and more. Have a number of macros doing things etc. based on user inputs. With formfields I have added a bit of context sensitive help info showing up on the...

Hi again, I have found and modified the following code to suit my needs but the "Unload Me" keeps frustrating me. Don't really know whether or not I need it either. It appears to work OK without it but as it was there intially am wondering why??? Appreciate any help with this I am more curious...

Hello again, Am struggling with additional problem within the same routine , when the table is added it contains the previous row's text input. thought the following would clear it but it does not ActiveDocument.FormFields(1).TextInput.Clear I think I need to identify the specific row but...