Search results for query: *

I have a spreadsheet with a column of hyperlinks. I want to proceed down this column by opening each hyperlink one at a time. (note: I want to activate the hyperlink, copy data from the page that the browser opens, close the browser, paste the copied data into a separate spreadsheet, return to...

I have a field in a form where I want users to enter a four digit number. Examples: 0004 (instead of "4") 0027 (instead of "27") 0331 (instead of "331")...and so on. I don't want users to be able to enter in the data incorrectly. I've tried using the input mask tool to no avail. Probably...

I am trying to add an "email" field from a table of contact data. In the contacts table, each record consists of a "first name" and "last name" field. The email addresses for these contacts are predictable. Each follows the following format: first letter first name + last name + extension...

Is there a way to parse query results so that the contents of one field can be distributed across 2 or more fields? In one of my tables, I have a text field that I would like to split up across multiple query fields so that I can sort on the newly created fields. For instance, in the field...

I want to generate reports that will graphically depict queried data. Specifically, I have a map of a given state broken into county regions. My query returns yes/no results for each county. I would like to know if anyone has suggestions as to how I can generate a report that would...

I understand that queries in Access are case insensitive by default. Is there a way to change this so that a query becomes case sensitive? I want to sort out all of the records with "apple" but want to keep those with "Apple". Can anyone provide an easy answer?

I'm trying to use the input mask feature in a query to display a field of numbers in a four digit format. For example I want: 1 to be 0001 42 to be 0042 159 to be 0159, etc. When I try to use "0" as the placeholder when creating a new input mask, I get: 1000 when I want 0001 4200 when I want...

I want to create a delimited document listing each file in a specific folder. I've tried using different variations of the "dir" command in the dos command prompt, but I have not been able to succeed at this task. If it helps, the directory to the folder that contains the documents is...

Is there a way to list all of the contents of particular folder? I would like to import a list into Access and compare to see which files are missing? Any suggestions?

I have a document that contains only hyperlinks to .rtf files stored on my pc. The links are set up as follows: C:\My Documents\Data\1.rtf C:\My Documents\Data\2.rtf C:\My Documents\Data\3.rtf C:\My Documents\Data\4.rtf C:\My Documents\Data\5.rtf... The only way that I've been able to...

I know that Word can be used to search for strings using wildcards. Can it also Replace using strings as well? For example, I know that this can be done: Find what: !*! Replace with: soccer Before Search and Replace: "My favorite sport is !football!." After Search and Replace: "My favorite...

I'm trying to build a macro that will arrange my data into one space-delimited column to be imported into MS Excel. In order to clean up the data, I'm using the search and replace function extensively to remove spacing, insert paragraph marks, etc. This macro will be applied to over 2000...

I encrypted a large number (i.e. 1500) of pdf files with a "master" password in Adobe Acrobat 5.0. I now want to remove the security for each file (the password is the same for each file). Is there a way to do this using the batch processing feature? It appears that I will have to write some...

How would I change the security settings for a number of documents using the batch processing feature in Acrobat 5.0? Here's are the steps that I currently take to perform the desired operation on one document: 1) Open pdf document 2) Navigate to "File" 3) Scroll down and click on "Document...

I'm using several text boxes as page headers (denoting column headings). The text in each box is rather lengthy, so I've changed the formatting to "verticle" so that the headings would fit. This makes for a somewhat messy design that is difficult to read, however. I would like to be...

Is there a way to use the find and replace command to erase all of the text between two symbols? For example: *I want to erase this text* Is there a wildcard symbol that I can use for this? MS Word 2002

I have imported a whole bunch of hyperlinks from an Access 2002 table into my Excel 2002 spreadsheet. These links do not work as hyperlinks until I double click on each cell and then hit enter (this action turns them blue and underlines them). How can I quickly convert these text fields into...

I want to copy data from an encrypted pdf document to an Excel worksheet. The security is set to block content copying or extraction. Only printing is fully allowed. The Document Security screen shows: Security Method: Acrobat Standard Security User Password: No Master Password: Yes...

After importing a number field from MS Excel to Access (2002), I want to change the format in Access to text AND THEN change the format of the numbers so that they are all 4 digits. For example: 0001, 0027, 0203 Instead of: 1, 27, 203 I've messed around with the different options in the...

Are url hyperlinks active in access reports, tables, queries? I have a table that contains thousands of url hyperlinks that are linked to several other tables in my database. While these links look and smell like hyperlinks (i.e. underlined in blue), clicking on them does nothing. My web...