Recent content by PaulSchrum

JDeezy, I have not tried this, but I think you can do what you need simply by using the Shell command: In VBA Shell ("type " & sourceFiletxt & " >> " & targetFiletxt) Please let me know whether or not this works for you. This is my first attempt at helping someone in any Access forum, so...

I've been doing that kind of stuff lately, so I have sample code to draw on. But I have to focus on other stuff right at this moment until later tonight. I will have you something before midnight, Eastern Time, US. - Paul

JDeezy, Maybe my response was a little too sparse, or maybe I am still missing your point. type file1 >> file2 is the shell command. I apologize if I am offending your intelligence, but you populate file1 and file2 with what ever values you need in VBA, then send that command to the shell...

JDeezy, I just tried this to be sure it works the way I thought it did. At the DOS prompt, enter type sourceFile.txt >> targetFile.txt This appends the contents of sourceFile.txt to targetFile.txt. The double > is the keyword for appending. Single > overwrites the previous contents of...

@Guus2005: Thanks a bunch. I will look in to this soon. .dgn extension is Microstation (www.bentley.com, CAD application used a lot by Civil Engineers), which is also VBA-enabled. @vbaInet: Your comments are noted, and thank you very much for them. I hope this fact will not hinder me, but it...

I need some advice. In Access VBA, I want to create an application to do a kind of file check-out/check-in system. I want the file state (checked in, checked out) to be stored directly on the file in the file system. I do not want to use Lock exclussively because other users may have locked a...

In doing some more reading/searching, it looks like the solution is a lot easier than I originally anticipated. Telling the system I want to watch a folder does indeed require multithreading, so that is not happening. I can include the folder timestamp in my data structure. Then...

Yea, figured that, but did not know for sure, so I ask here. Nor have I. That is why I am asking in an expert's forum. I bet it's not. I will wait for more experts to weigh in. I am hoping to get a variety of responses after the new workweek gets under way.

In trying to be terse and to the point, perhaps I did not give enough detail on what I am trying to do. The directory-read process will indeed be very short. This short time-span is not what I am concerned about. I will have a ListBox showing the contents of the directory to the end user...

Hi All, I am using the Dir statement to get info on directory contents. (Thanks to Allen Browne's free information for how to do that.) I realized that when the directory contents change while I have it open via Windows Explorer (say someone else adds a file), Windows Explorer receives...

I was under the impression that this was innoucuous and was only executed once, and that before any part of the function was ever executed. This is easy to fix. That is how I understand it. The logic is off, but it is because I made a mistake when I was trimming my real code down to the code...

All, I have been put on hold on this project for the moment. I am still interested in seeing people's responses. But when I get released from this hold I may have to take (may get to take) an entirely different approach. - Paul

Yes, that is close to what I am doing. It is actually this: do while not rst_customerHistory.EOF startMonth = getMonthNumSince1900fromString("JAN", rst_customerHistory("Year")) endMonth = (rst_customerHistory.RecordCount * 12) + startMonth - 1 Dim ad_aveGallonsPerDay() As Double...

Yes. But the other table is a temp table, which I am using only as a scratch pad for computations. Alternately I could use a dynamic array or a collection for the scratch pad. Because it is a temp table, I write it, use it, then delete all of the rows again, repeat (400,000 times). No. I...

Yea, that's what I thought when I found out I was going to marry it. But unless this structure is the cause of my speed drag-down and the only way I can fix that is by changing the table format, requesting a change from the client is a non-starter. In other words, I did not come up with it...