Summary: One quick and easy question (I hope) Using MS Word 2002, how do I tell it to find the most frequently used word in a document and show me the results?...
Summary: I want to use Xml in order to create and modify the UML Template shapes the Visio's Model Explorer - basically creating some sort of pool from which ...
Summary: Since it appears that you are checking values in Column C, you can determine the last used cell in Column C as follows: LastRw = Cells(Rows.Count, "C"...
Summary: I have created an Excel query in Office 2007 to return a specific set of values from within a named range in my spreadsheet (for example, the 6PM temp...
Summary: hello i have a database in which i have a linked spreadsheet. the spreadsheet gets updated using excel on a regular basis (data gets added on to the e...
Summary: to explain more the main database contains many fields and the new table only contains bad emails. I wish to delete all the "record" for the bad email...
Summary: It might be a two step process to query the database....IF you use "GRoup by" in teh query builder that would pick those records that have the same "a...
Summary: When using Office 2003 ClipArt searches are not returning hits from the clipart installed on the hard drive unless you use the clipart organiser. Cli...
Summary: Greetings, after using Word 6 for many years I now have office 2000. When I try to compose labels in the newer version, the cursor defaults to the cen...
Summary: If you just literally want to stack data, rather than create relationships, then use a "Union query". [for eg. Say you have price data for stock X in ...
Summary: I am tring to update a table from a query. I am updating a long interger in the table and the query format is the same. When I view the query, all re...
Summary: Make an append query first that takes all the records from the current table filtered a value less than or equal to desired selected date. We'll call ...
Summary: Hello I need somebody to help me with a date difference statement, Basically I have a table called residential properties and it has a field called '...
Summary: Hi, I'm using MS query to retrieve the information from a Genesis database. The preview pane in query shows all the data (6 fields, a mixture of text ...
Summary: ROUNDDOWN is not used in queries in access as ROUND is the only one used. Are you talking about using VBA script to build an expression? As i have no...
Summary: Use the SQL COUNT function. One call for each name. SELECT COUNT(*) AS [firstname] FROM TableName WHERE FieldName = "Sara" The result will be returne...
Summary: I have set of fields on a form which are the search fields. I enter values in the field and search the table for rows which satisfy the condition and ...
Summary: I checked unter Tools, Options and Tabs like "Enable Drag and Drop" and others that might be related to this problem are all checked in! But today I r...
Summary: Yes you can You can use a select statement based on your table structure to output a file, then load that into a new table. The following SQL statem...
Summary: I want to use macro in access to create a new column in several different tables. These columns shall consist of a prefix that I choose, typically "PM...
Summary: I am trying to use a variable when using my update statement. I have pulled an ID from one table linked to a question, and I want to record the answe...
Summary: We are having the same problem with one PC on the network. Though, I have had this problem with other PC's in the past but they seem to have fixed the...