Recent content by colmtourque

Sadly that is not a realistic option for numerous reasons. I have to build a fool proof solution that accounts for far to many fools for the big stick to fix. It sounds like there is a way I would love to hear it or be pointed in the right direction.

On the other note I just realized a big part of the problem. While there are headers they are sometimes all over the place (it's a long story). They could be in row 3 or in row 7. Let me start from scratch here and explain the idea here. We get dozens of files in from many different companies...

How would I do that? Sorry, I have not delt in VBA or access for some time. I've been during pure sysadmin and some sql but my vba is VERY rusty (and it was never great to being with).

I'm letting the user map the fields, it's really the only way. Kind of like the way you do an import of a csv into outlook, except not quite as pretty. once i have it in a nice format I'll post it, right now it's barely alpha. How can I display excel data in a subform based on a file chosen...

Display an Excel File I'm rather lost here and was recently thrust back into the world of access and vba. Any help would be appreciated. I'm trying to create a database that I can use to import any number of different excel files of many exceedingly different formats and merge them into one...

No it does not work

Sorry, I have browed a bunch of pages looking for this, and I have it working halfway but I can't figure out the other half. I have a form with a combo box and a button and then a subform. I want to requery the subform based on the combo box. OK, so far easy have that working. The problem is...

I must have mistated Not the top 3, but the top 3 Numbers in each column, as in lets say one column is 10 20 30 8 50 7 I would want 50, 30, and 20 shaded and only for that column, not the rest of the row. Make more sense.

I have a report that shows ids, names and 6 rows of numbers. as such Record 1: ID LName FName Total1 Total2 Total3 Total4 Total5 Total 6 Record 2: ID LName FName Total1 Total2 Total3 Total4 Total5 Total 6 Record 3: ID LName FName Total1 Total2 Total3 Total4 Total5 Total 6 Record 4: ID LName...

Thanks If anyone is looking to soemthing like this. It appears that this works Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, 8, "Table1", "M:\teststuff\mtd.XLS", True, "Sheet1!b1:q48" 'DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Table1"...

This is what I currently have Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, 8, "Table1", "M:\teststuff\mtd.XLS", True, "Sheet1!b1:q48" 'DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Table1", "M:\teststuff\mtd.XLS", False, "Sheet1!b5:q48" DoCmd.OpenQuery...

And I believe this just got a little more complicated Sorry, I think I need to explain a little more. I thought this would be easy and that I was missing something simple. I am actually importing and excel spread sheet into a table (was able to get that far). So far I have a button that runs...

Thanks, but one other question How do I use this as part of a query? Or do I call it from a macro? Sorry, not the best with modules, I've only learned to use them recently.

I am trying to search a field to find every value that is between ( and ) is there a way to do this?

Found Something else As a note I also found this Option Compare Database Option Explicit Const ExcelImp = "Import.xls" '------------------------------------------------------------------------------ ' Procedure: subImport ' Author: Dave Swanton ' Purpose: Read in new data from an excel file '...