Recent content by JoeGKushner

Okay, after some messing around, I've managed to get it to work to a point that I'll have to fine tune the actual import steps to verify that the file is similar enough every day that it doesn't decide half of what's in there is garbage. Thanks for the extra eyes everybody! If someone can...

On a daily basis, I am importing a file whose name changes every day. It's based on when the time the creation date for the file finishes so it's DDOPHEE_201512310613.TXT one day and DDOPHEE7_201512310620.TXT another day. I was wondering if I could use VBA through a Module to look in the...

I'm trying to clean up a file from a legacy system that is no longer supported. I can remove all the unwanted data by testing the first cell. If it's X, Y, or Z, delete it. Then there are lines that are children of parents. I want to put the parent in front of the child. I'm marking a 'helper'...

On a database I've inherited in Access 97, that has worked for months with no problem, all of a sudden I'm getting a run time error 1004 application-defined or object defined error. It happens at the bottom of this code. Code Private Sub AM_Top_25_Click() DoCmd.SetWarnings False...

I have inherited a module that looks at the weekday (date). If it's Monday, it runs one query, if it's Tuesday, it runs another. Can I put the criteria itself directly in the query or should I just keep it 'simple'? I say 'simple' because after it runs, it's exported to Excel, and it takes the...

We allocate products to orders. When we do this, it reserves the inventory. We also receive inventory throughout the day so the opportunity to increase fill rate increases as the day goes on. To handle that, we have a report that shows the order, product, and the inventory. However, we also...

That was the problem. I 'fixed' it by throwing another snippet of code in. If Rst.AbsolutePosition > -1 Then 'Move to the last row Rst.MoveLast 'Now get the count pCount = Rst.RecordCount 'If you want, you can now move again Rst.MoveFirst '---- 'Continue...

I have a database that had some code that enabled the user to click a button and it would take information from one Access query or table and paste it into specific locations in Excel. This is important because the last worksheet has specific formatting in place. If it didn't, I'd just use the...

Long time Access user. I'm one of those people who likes to paraphrase the old quote that Microsoft got Access right in the 97' version and have been trying to go back ever since. Use a lot of ODBC links to different data sources in daily work mainly for reporting and data analysis. Lots of...