Recent content by KellyK

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