Search results

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

I have seen several hints about how to do this, but I have not found a good answer. Sorry my vna coding sucks, do web and some VB but little vba. I am trying to import an excel spreedsheet that has blanks in some rows as well as a lot of pretty formating, such as some lines are centered etc...

Thanks Honestly before I'll do that I'll export what I want into excel and drag. Then import it back. Same thing but probably a little faster. Why? Because I'm in need of a unique field on which to key the database and it does not have one. The duplicates are not fully duplicates, but the...

I have a table with some 2 thousand records. I would like to number about half and then have any duplicate records numbered the same. Is there any way to do this using an append query. Thanks in advance.

THANKS!!! thanks to your help I made it work Dim CountN DoCmd.OpenQuery "Query1" CountN = 0 Do Until CountN = NumberofPeriods.Value CountN = CountN + 1 DoCmd.OpenQuery "Query2" Loop One question more and that should be it. is there and echo off command and to refresh a form is that...

Think I have it started dcx693: I actually meant an append query, sorry. I'm using access 2000 and I'm doing the work straight within access. Here's is the db layout: ClientQuery (holds the number of years (NoY) to compound interest) AccountTable: Holds original account values TempTable...