Search results for query: *

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

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

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

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

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

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

Completely new to web programming although after reading my way through a few ASP scripts I can see it will be simple to pick up. But can anyone tell me what tools exist for lazy people like me to write the code. I'm used to an Access VBA environment, does anything like this exist for...

Hello all, A really annoying problem which I have always been to lazy to enquire about before is the resizing of datasheet columns. Is it possible to have all columns resize so that all contents of a field is displayed? Basicly the same as double clicking the column header. Cheers

Hello All, Is it possible to create a new module and define its contents from an already existing module? The background to the question is as follows. I am currently automating lots of reports. I have a table in a single database to hold variables (passwords to applications, paths to...

Hello All, I am writing a business objects report in freehand SQL that connects to an Oracle data warehouse. I need the report to refresh every weekday. On Tuesday I need it to include data for fri sat and sun. On Mon Wed Thur and Fri I need the report to look for data from 2 days ago. I can...

Hello All, I can't believe there isn't a way to email a shortcut to a file? I have produced a database that I want a number of people to know the location to, but I also want them to push them into setting up a shortcut to the database. I thought it would be possible to create a shortcut to the...

Hello. I am building a balanced scorecard for the members of my department. It consists of a main form with a sub form on it. The main form has unbound text boxes for the manager to enter the dates and name of the agent they want to report on, the subform then displays the report for the...

Hello All, I am looking for a way of writing a single module that will loop through all the forms in my database and append code to all controls that are enabled text boxes. I have basicly built a calculator system. Each calculator form has a number of unbound text boxes for variables to be...

Is there any reason why when using a DAO.Recordset to update/add a table record, I can only get the first line of a notes field to append to the memo field in which it should be going? The enter key behaviour of the notes field is new line, and its a normal text box. The code is as follows...