Recent content by s0ccerdude

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 found the following solution at http://www.microsoft-accesssolutions.co.uk/disable_mousewheel.htm Private Sub Form_Load() ' Turn the MouseWheel Off Dim blRet As Boolean ' Call our MouseHook function in the MouseHook dll. ' Please not the Optional GlobalHook BOOLEAN parameter ' Several...

Collen- You're answer almost does the trick. However, when I limit the text field to 5 characters and set the input mask as recommended: "\0000", I can only enter in 3 digits for each record. For instance: 0124, 0023, 0007, etc. This input mask makes the first digit a zero and then only...

Thank you for responding. However, I'm not sure that I understand. In the design view for the underlying table, I've tried limiting the text field to 4 characters and setting the input mask to "0000". When I try to enter in new numbers, the field defaults to "____" (i.e. 4 x "_") and I...

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

Well, you pointed me in the right direction dhookom. After much trial and error I've come close to figuring this out on my own. Thank you.

Thanks for the reply THWatson! This is exactly the answer I was lookin for.

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?

Thanks GoDawgs (Kevin)! I used the function just as you suggested as an expression in a query. Got the desired results!

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

Thanks rmiley and bcastner. I did as bcastner advised and downloaded Karen's freeware at http://www.karenware.com/powertools/ptdirprn.asp. It works great and saves me the work of entering dos commands in the command prompt! However, I tried you code rmiley and it worked as well, so thanks...

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