Search results

Re: Daily file import timestamp shift solved Thanks All, AOB's advice has gotten me through this one. And i learned something new. JB

Thanks, It seems to work. Now I'll have to try and understand why so I'll know how to use it next time. Here's what it looks like. Dim strPathFile As String, strFile As String, strPath As String, strTodaysFile As String Dim strTable As String Dim blnHasFieldNames As Boolean ' Change this next...

:confused: I have a daily file to import. If I hard code the entire file name my code works. My problem is getting around the daily name change of the file. The owner has an automated process that creates the file so the name every day is slightly different due to the timestamp. Here's an...

Thanks, I'm going to try to minimize the session screen. I think that would be the easiest fix.

I have a module that opens an Attachmate Session, then prompt the user for input to continue the logon process. The problem is the Input box opens behind the Attachmate window. Is there code to bring the Input box forward? Here's the part of the module that opens the Inputbox. when I step thru...

Thanks Wayne, That did the trick. JB:):):)

Discovered changing WRITR to PRINT removes the "" but the spacing is off PR 08974 0008180 0714352 BANE 26 110 W10292584 2.00 A JB Not Top 300 PR 08974 0008180 0836783 PIERCE 26 110 8540395 1.00 A JB PR 08974 0008060 0015917 SERNA M 26 110...

I found this code that appends new data into an existing text file. But I need the format to be Tab Delimited instead of CSV. Any help would be greatly appreciated. Here is a sample. The first line was in the table. The second was appended. line 1 PR 08974 0008180 0836783 PIERCE 26 110 8540395...

Pat, I think I found a fix. As my Tech Part use table is created for each tech, the auto number field is in the create table statement. So then when my usge query goes out to cature the top used parts for that tech (DESC) the auto number will rank the parts. I found a query that will analyze...

Thanks for the reply I just find it hard to understand if I sort records by desc or asc order and attach a position number to that result, it could be wrong. Is there a margin of error in Access? I found a site that was talking about a Recursive quick sort query. I think it's something that...

Here is a sample table with three techs Top parts listed

Sorry the table did not copy correctly.

Thanks for the reply I understand I can't change the table. I want to query it for let's say the top 50 parts for each technician. But I need to know each parts exact rank that was assigned by the autonumber field when I built the table. In the past I ran into mis sorts where the highest used...

In my table I have one column that lists part usage (number) in descending order. I have a second column with an auto number for ranking. So my highest used part ranks as number one. Is there any way to verify the sort order on my usage column is descending as my rank number increases? The...

I created a Test table1 with Parts Numbers A thru K. I assinged a use value of 10 to 0 one for each part number. I then created a make table2 query with the same criteria of DESC on part usage. I inserted my position column. I ran this sequence thru the looping module. First run 1600 no...

Thanks Again GW for replying. I understand what your saying, but I use other tables and pull data out with sort criteria and it always come out with the highest values listed first. Those tables are being created directly in coded modules. I just don't understand why the query doesn't do the...

Here's a sheet with two results from the same query on the same table

Then I confused? what's the point of the order by clause? Shouldn't my new table be created with the highest Usage part always first?

MS, your second example is exactly correct.

Thanks, the line at the bottom was a table that didn't copy in. I created a module to run my query in a loop and capture the Usage number and Position number after each run. Here's what I would see in the result table 878 1 878 1 157 1 22 1 The source table was the same and never changed...