Search results for query: *

ok, thanks for the comments and advice. I never realised I had to be so disciplined when writing a simple word document. Thanks again.

That looks really great! I just tested it though and seem to be a couple of bugs.. The following gave 11 words The cat. Sat on the. Mat Then this gave 12 The cat. Sat on the. Mat. Then 13 The cat. Sat on the. Mat. So seems to be adding another count for full stops and paragraphs. Do you...

Hello, I am writing a document, and I have a word limit. I want to know how I can count only the words which are marked up in the "normal" style. I have not found a way of doing it, so thought a quick macro would be a possibility. I am using MS Word 2000. Any help much appreciated

yep, much better solution. many thanks

All, Is it possible to replace the following Access message with something more human. Or even better for no message box to appear at all. "The field <My Field Name> cannot contain a null value because the required property for this field is set to true. Enter a valid value in this field. Cheers

All, How do I go about closing an application or stopping a process via vba? I basically want VBA to close an open instance of a program without the users needing to have any intervention. Cheers

...Access applications stall. Does this change what the cause of the problem might be? Here is the timer code by the way Private Sub Form_Timer() '*** Sub: Form_Timer '*** Form: frmMain '*** Description: function that runs on timer. '*** Primary function is...

All, I am trying to implement a small application in MS Access 2K on Win 2K. It consists of 3 forms (1 of which has a timer event that runs every minute), is not multi user, and sits directly on the C:\. It does interact with the networked drive to output text files to a certain directory when...

Is there any restriction on the number of files written to a network directory? I am building a tool that creates text files. 500+ users across the office will have access to the tool and in theory they could all write a new text file to the lan directory at the same time. Will this cause a...

Is there any way to retrieve the owner of a folder. I can easily get file details but the information you can retrieve for folders seems limited. Any help much appreciated Cheers

All, I have a small app, built in MS Access that has a front end. In order to keep the front end up to date on each machine, I have a desktop short cut that points to a VBS file that will copy the latest version of the front end to their machine. The problem however is that they are often...

All, I have an access db which I want to remove the right click menu, or at least disable the close option it provides, from the task bar. I need to do this to stop users right clicking the app on the tasbar and selecting close as this will bypass a close event on my form. Any help much...

Run function is perfect! Thankyou very much

Not sure that would work for me as I could be adding to the list on a regular basis. If there is no way of running the code directly using the "Call" method, I will create a new macro for each function and use the macro function "RunCode" Thanks

Hi all, I have a listbox on a form which lists names of functions in a module. I want to use the "Call" method to run the function selected from the list box. I have tried Call Me.ListScripts but it doesn't work. Any help would be greatly appreciated. Many Thanks

Tried it. I get Application defined or object defined error. I am using Access 2000 and Win2000.

I want a form to open up, resize to the one that opened it and appear in exactly the same location. I'm finding this ridiculously hard to do. I can open the form and use DoCmd.MoveSize 1000, 1000, Forms("Form1").WindowWidth, Forms("Form1").WindowHeight This sets the correct size of the form...

I worked around this very annoying problem using the following method. Dim S As String S = Me.Dialog Dim X As Integer With wks Range("A1").Activate For X = 1 To SF_count(S, vbNewLine) Range("A" & X) = SF_splitLeft(S, vbNewLine) S = SF_splitRight(S, vbNewLine)...

All, I am having a nightmare with the following piece of code. Me.Dialog.SetFocus Me.Dialog.SelStart = 0 Me.Dialog.SelLength = Len(Me.Dialog) DoCmd.RunCommand acCmdCopy When it executes the last line (DoCmd.RunCommand acCmdCopy), instead of copying the text select from the control "Dialog" on...

Hello all, I would like to know if windows places a lock on text files that are being copied from a shared network drive? i.e. if john smith starts to copy a file to his local machine at 10:00 am and the file is 20meg and it takes 2 minutes to complete, is the file locked for those two minutes...