Search results for query: *

I want to be able to do a "find" on Outlook message headers. Specifically, I have e-mails coming from a particular sender and I want to see what other e-mail addresses they might be using by searching my e-mail database for ip addresses found in the header of the culprit e-mails. I'm using...

I have an e-mail that I send out over and over again (Same text everytime just a different e-mail address). I'm using Outlook 2002. I want to able to hit a button that just pulls up the e-mail, allows me to type in a new address and hit send. Is this what an Outlook template is for? Or an...

I have a form that includes a subform. The form records information related to the sale, the subform contain all of the individual sale items (hence, a 1 to many relationship). Problem is: I can't add new sales. I can add new details to current sales. I just can create a new sale. Sorry if...

Minor issue, but it seems to be really odd behavior. . .I have a combo box where I select an ID and other text boxes are updated based on my selection. The text boxes, though, are only populated when the user clicks on a new record (the form is set up as a datasheet). Is there a way to have...

This is probably a lame question for all of you. You guys seem pretty advanced. I was trying to figure out if there is an easy way to create a drop-down box in an e-mail. I know how to easily create buttons. Are drop-down boxes much more advanced? I need a response from employees on a topic...

This worked yesterday and now it doesn't and it's driving me NUTS! I don't remember changing any settings, but maybe I did. . . whenever I click on a taskbar minimized application, it used to bring it into focus automatically. Now it just starts "blinking." So I click it again and I...

OK, don't flame me for this, but I know almost nothing about installing/using Oracle except how to walk through a few steps on the Universal Installer. The only reason I need Oracle on my machine is to use a 3rd party software to view tables and write simple queries (I'm just a business analyst...

I created a simple function that works fine if the function's code is in a module of the workbook. However, I need to be able to use it in all workbooks, so I moved the code to module 1 of personal.xls, but there the function doesn't work. It's as if the function doesn't even exist. What am I...

Currently, if I am viewing one report and I click on a hyperlink to view a CR report, the first report closes and the second report opens. I want to be able to open one report and click on the next report and open that one in a new window (using another instance of Crystal Viewer I'm...

I have an Access database that someone else created and has been passed from person to person. It works fine. I was curious how the guy actually got the data that generated the reports (and I need to use this data also), so I was looking through his queries, forms, etc. I can't figure out...

I have a form that is based on a query that took 15 different parameters and looked up records based on these 15 different values. It's a pretty simple query and it worked fine and was very fast. The results would display almost instantaneously. THEN I got a little brave and I tried to make an...

OK, this drives me nuts and I'm finally going to post this thread on here to see if someone can tell me what I'm doing wrong. I write queries like the one below a lot with an embedded Select. The query works fine; my problem is (and this only happens sometimes which is a source of frustration...

I have 5 parameters - called 1,2,3,4, and 5 - that match to 5 fields in a table. I want to return all records where parameter 1 = field 1 and paramter 2 = field 2 and paramter 3 = field 3 and paramter 4 = field 4 and paramter 5 = field 5. The problem is all 5 parameters may not be populated at...

I'm trying to create CSV files from an Excel workbook. I need to create a file for each worksheet in the workbook, but the number of worksheets varies from workbook to workbook. I know I can open the workbook, count the number of sheets in it and create a Do Loop for each worksheet, I just...

I'm trying to convert an Excel file to CSV and this is the code I have so far: Sub ConvertToCSV(ByVal strFileName As String, ByVal strNewFileName As String) Dim objExcel, objExcel_Sheet As Object Set objExcel = CreateObject("Excel.application") objExcel.Workbooks.Open...

I have a button on a form and I want the user to be able to click the button and browse to a file. I got the open dialog code from here: http://www.allapi.net/apilist/GetOpenFileName.shtml My only problem is that I want the open dialog control's initial directory to start at the last place I...

I'm trying to import a text file using a schema.ini file. Everything works except when I don't specify a specification before the second comma (see below), it uses the default import/export specification. If I put "schema.ini" there, it tells me the file doesn't exists, and if I put...

I'm trying to import a text file using a schema.ini file. Is this the best way to do it? Everything works except it takes out the "\" characters of my path for my schema.ini and tells me the file does not exist. I even tried using chr(92) and that doesn't work either. Any help...

In Access, I need to replace the first line of a text file. It seems the only way I can do this is to add the line I want to be the replacement (the new line) to a NEW file, copy all of the lines in the original file to the new file, and re-name the new file as the original file. This leaves...

Hi! I'm trying to import a text file using a schema.ini file. I want the user to be able to browse for the file and select the file and import it. I've seen the code to browse for the directory and I've seen the code to choose a file and they seem to be very two large and different pieces of...