Search results for query: *

I'm soliciting this community's help for suggestions on making my code better. My current code does function properly, but I'd like to make it more efficient and not so large. The code listed below has been edited to only include a sampling of the case statement. The total code has 20 cases and...

The following is a small scale of a data set I have in Excel: Country State City Count Date U.S. New York Albany 200 2/4/2013 U.S. New York Albany 200 1/6/2013 U.S. New York Albany 200 12/31/2012 U.S. New York Buffalo 10 4/10/2013 U.S...

I need to create a ranges for a data set that changes everytime a report is run. The columns are a consistent order and count. The range would be based on the value in column B. I can work with A1 or index format. Here's an example of the data: A B C D U.S. New...

I have a worksheet that has multiple columns with similar data. The data is related by a pair of columns, so I need to search one column for a parameter then return the information on the same row in the next column. Here's a sample of the data: TYPE NAME TYPE NAME Subject Robert...

I'm attempting to loop through each cell in a column and complete a vlookup for each value. My syntax doesn't seem to be correct, because I get a 'run time error 1004' on the vlookup line everytime. Any help would be appreciated. Sub CalcAging() Dim aCol As Long Dim aCell As...

I am attempting to copy all unique values from a specific column on a worksheet titled "Raw_Data" to a a worksheet titled "temp". This was working for a bit, but due to raw data input columns varying for multiple reports, I can't place a static column such as "I" in my code for the advanced...

I know this is probably a simple solution, but it is eluding me. I have an Excel worksheet where dates are in column C. In my code, I have inserted a blank column D. I'd like to calculate the difference between each date in column C with the current date (in number of days) and place it on the...

I have script that allows users to select a folder (using a Windows API function) that contains their desired Excel files each consisting of one worksheet only. The worksheets are then compiled into seperate worksheets in a new workbook. The script works as it should, but I want to rename the...

I have a table that populates in a subform with the following fields: Filepath (memo) File (text) Select (True/False - Checkbox) What I'm trying to accomplish is to allow the user to multi-select checkboxes without having to click (or spacebar) on each record. So that if there are 30 records...

I'm trying to create a basic report from a worksheet that has more detail than needed for the recipient of the report. The report is then sent as the body of the e-mail(not an attachment). Here is a generic view of my data (first row is headers): Job Reference Task1 Task2 Task3...

I'm using a computer for the sole purpose of connecting to my work network via VPN. I actually connect to my work computers via a SSL GUI once connected to the VPN. In essence this computer is a thin client. What I want to know, is what are the bare minimum ports that need to be open?

I am running Vista 64bit laptop and I'm attempting to add a printer connected to my XP desktop. I am able to see the printer, but when I connect to it it says I don't have the appropriate driver. I downloaded the specified driver from HP's website, but it's still not working. Any help that...

I have an older RIM Blackberry that I need to have data transferred to my PC. I've found several sources that point to using Blackberry's software development kit v2.1, but that program is no longer available. Does anyone have any idea how to get this program or perhaps another method of getting...

What I'm attempting to accomplish is to automate a process of looking in a certain directory and combine all of the documents into one. Some quick notes: -For each document, the data that I need will always reside on page 2. -The parent directory will always be the same, but the subdirectory...

I've used the module below in VBA for Access successfully. Now, I need to do something similar in VB. I'm using Visual Studio 8 and have very little experience with it. The problem I'm running into is that it does not like the syntax for my "Set" declaration. Any thoughts would be appreciated...

I've used the module below in VBA for Access successfully. Now, I need to do something similar in VB. I'm using Visual Studio 8 and have very little experience with it. The problem I'm running into is that it does not like the syntax for my "Set" declaration. Any thoughts would be appreciated...

When I try to run setup for VSE 8.0, I get to the point where is says that I have to unistall VirusScan Online (my previous McAfee). It opens a window that states: Navigation to the Webpage was canceled What you can try: *Retype the address The install locks up at this point. So I tried to...

Does anyone know of any kind bluetooth device that uses SATA instead of USB?

When I run the following code, I get "'Run Time Error 3061' -Too few Parameters. Expected 3". The line that I get the error on is noted below. Any help is appreciated. (Code courtesy of PHV) Private Sub Command272_Click() Dim DB As Database Dim objWord As Object Dim rs As DAO.Recordset 'Open...

I'm wanting to create a report in Access based on the results of the recordset I ran in VBA. Here is the rundown on the necessaries: The SQL is pulling from a table named “tblINF_Main_Table” based on the data entered into a form named “Inv” with the field “SearchCrit_Store”. The form’s purpose...