Search results for query: *

Thanks for the help, guys. I'm going to try the suggestions you've made and see where that gets me. Skip, believe it or not, yes, that is all I'm trying to do. It's kind of similar to populating the blank cells of a pivot table with the value in the cell immediately above, but an upside down...

I should also mention that I have Automatic Calculation selected in my formula options and I tried pressing F9 after dragging the formula and it STILL does not put in the correct values. The correct values are there only when I enter the formula into each individual cell. Kelly

I created a function within Excel VBA called FindNext(). When I enter "=FindNext()" into each individual cell, I get the desired results. However, if I enter "=FindNext()" into one cell and then drag the formula down a column, the column is populated with the first correct result, all the way...

PHV you are wonderful and amazing! Thank you! Kelly

Thanks, just tried it.. didn't work. Great idea though. Got my hopes up. :) Kelly

Greetings. I am getting a peculiar error (in my simple mind) sporatically with some code. I am attempting to take an Excel report, via Access VBA and format it according to a customer's specifications. The code seems to work fine when Excel is not open previously, but if the user has an Excel...

Thanks, CMP, have a star! :) Just one minor change - 'Close the JIT file objWkb.Close If blnSpawned Then objXL.Quit Set objXL = Nothing Set objWkb = Nothing Need to set objXL = Nothing after the If blnSpawned line otherwise the thing bombs on "objXL.Quit". But otherwise lovely and gets...

How do I turn off the Excel alerts before I "Get" the object (file) that I want to use? Kelly

I'm so embarassed, I forgot to copy that part! Dim objXL As Excel.Application Dim objWkb As Excel.Workbook Set objXL = New Excel.Application 'Turn off excel warnings objXL.DisplayAlerts = False 'Open the JIT file Set objWkb = objXL.Workbooks.Open(txtJITReportFile) Set db = CurrentDb()...

Hi all, hopefully this is an easy question, seems like it should be but I don't know the answer! [ponder] I have some Access code which opens an Excel doc (referenced in a text box on a form) and imports the document into a new table. Easy enough. I don't need or want to see the Excel...

Sorry guys, should have done a little more research before posting. I found this: "You can also set a reference to excel in Access, and then use the application object to turn off the warning in excel before doing the import. Dim objXL As Excel.Application Dim objWkb As Excel.Workbook Set...

Hi all, I am working on an Access database for a customer. There is a main form where the user selects a location of a file, clicks a button and the file is imported into a table in the database. This file has extension .xls. So, I used the following code to import it...

Does anybody know what the file Y!Msgr\merlin.log.old is? How is it created/updated? There is also another file in the same directory simply named "merlin". I do not use Yahoo Messenger so does this mean somebody else was using my PC and installed the program onto it? I do not see any program...

Hey guys, I decided just to take each of the dates/durations and convert them into a field for days, a field for hours and a field for minutes in Access. Then I will get a grand total for each duration in minutes so that I can calculate percentages. A little tedious, but at least then I'll be...

Thanks for the ideas. Unfortunately I've put a lot of effort into developing this Access model and with a deadline looming, I don't know that I have time to recreate the wheel. I will keep it in mind for future reference though. Cheers. Kelly

Thanks again for your help, guys. I am doing a project for a transportation company. I need to import an Excel spreadsheet into Access and combine the data with some other sources. One component of this is to measure the idle percent for a driver's truck. I am given the drivers "road" hours...

Skip, Thanks for your thoughts. Everything you're saying makes sense, however I still cannot do what I'm trying to do. Let's say I have the two dates I referenced in my post in Excel. I can add them to obtain a value of "919:04:00". Viewed as a date, this total is "2/7/1900 7:04:00 AM"...

Hi all, I am importing an Excel spreadsheet into Access and need to make basic calculations on some date fields. Seems easy enough, but some of the formatting gets lost when I import from Excel to Access and I'm not sure how to keep it how I'd like. The date fields in Excel are formatted like...

Here's something odd, when I try to go the Import Specification route, I get an error message 3625 saying that the Import Spec does not exist. I spelled the name correctly and see it, but yet... it's not there? Kelly

I am attempting to import a series of text files programmically into a single table in Access 2007. The text files are semicolon delimited. The first line contains the field names but does not have any text qualifiers. I receive the error "Field: 'DriverNum;DriverName;CapacityType;' doesn't...