Search results for query: *

Golom, Thank you for your quick reply. There is not an "On Error GoTo 0" in the Combine procedure but you did point me in the right direction. In the Combine error handler, when writing to the log it was writing: Error.Number & ": " & Error.Description It should be: Err.Number & ": " &...

I have done some searching on the Internet and on this forum to see if I could find the answer to this without much luck. I may not be using the correct verbiage, so if this is answered already I apologize in advance - would you please direct me to the answer in that case. Using Access 2003, I...

Charlie, I have a piece of code where I filter and delete based on a number of criteria. Here are the relevant lines: w.Columns.AutoFilter Field:=2, Criteria1:=vntWebIDFltrs(i) w.Rows("2:" & Selection.End(xlDown).Row).Delete shift:=xlUp where w is dimmed as a worksheet and...

Paul, From a VB ref: Step 1: write the NewEnum function procedure (as Nikki has shown in her code - it must have the square brackets and leading underscore as shown) Step 2: With the insertion point in the Function NewEnum statement, open the Procedure Attributes dialog box from the Tools...

tcl, It almost sounds to me like what you want to do is load up a Dictionary object with a number of key/item pairs and then reference each value by it's name...? It's the VB version of the associative array: you give the name (key), you get back the value. Just a suggestion. Good luck. MM

tcl, I am not an expert in this area, but I cannot quite tell if you are trying to iterate through the private data members of a user-defined class or through a collection. If you are trying to generate a list of all the values of the user-defined class, I am not aware of any command/function...

Apollo6, You may already be doing this, but are using the 'quit' method? for example: obj_Access.Application.Quit ' or sometimes just obj_Access.Quit set obj_Access = Nothing It seems to work (xl97). HTH MM

Gilliam1, If you don't want it all, you can always use the 'permanently delete it' option. thats what I do... MM MM

SBendBuckeye, I had a similar issue in Access97. However, my issue was getting information from text files (.csv to be exact). In the transfertext method you can indicate a Specification Name - basically a set of rules on how to import the data. This way, I was able to indicate that certain...

frosty, Is there any reason you can't just add the formatting to the spreadsheet when you create it? That way you don't have to go back and add it 5 rows at a time. I would simply record a new macro and add the formatting - the system will give you all the parameters. To adapt it, simply...

Ennes, Use the 'InputBox' function. The help pages can guide you through how to implement in your macro... MM

pkmoore, Not sure this will help, but this is how I would approach it. Using Access' DoCmd.TransferSpreadsheet command, import your whole list into a temp table in Access. Then run the SQL/query for the whole table at once. You should then be able to export all the query results (again using...

I had a few extra minutes and did a little more digging... First, you need to make sure you have added the 'Microsoft Scripting Runtime' library. You can do this through your References under "Tools". Once this is done, I was able to run this snippet of code successfully: Sub...

MrMeReturns, It sounds like what you want is an associative array (what Perl users call a hash). What this does is sets up an array where the subscripts are strings instead of numbers. According to the help pages in excel97 VBA, this is available as a 'Dictionary Object.' I have never used...

robcarr, I got the same results with the above code (I added the end if statement). I did switch the line in the if statement from: Worksheets("Daily Data").Cells(Match.Row, 2) _ = Worksheets("sheet1").Cells(i, 15) to: Worksheets("sheet1").Cells(i, 15) _...

Rob, Assuming the above is the code you are using, what results are you getting when you execute? MM