Search results for query: *

Oh and thank you Mark... It did exactly what you said it would. You and Chris totally saved me this morning. I thought it was all set only to see it had bombed out after I walked away.

Chris, You were absolutely right that it would always get the first record's dealer name! When my export bombed this morning I was gutted. I was hoping someone had responded to this post seeing my error. Thanks for the additional information too. It really helped me understand things much...

I was able to get it working by doing the following: 1. GO TOP when I select the file (If I don't it pushes out hard coded dashes and curcounts.qty for all but 1 file.) 2. Added the list_no field which is the unique identifier from curcounts.list_no instead of t3temp.Matchdate Such small...

I'm trying to export each unique list in a table and have them export separately with the correct qty of records displayed in the filename. I have a field called list_no to scan into a temp table for the count qty... It's not exporting properly though. One file looks okay and the other...

Hi Andy, The field (column) names in both tables are the same but my permanent template has less fields/columns (72 vs 189). The csv does have header rows. I'm used to working in foxpro so I don't have any issue importing records from one dbf to another one as long as the field names are the...

I have a permanent template with zero records. Every time I get a new file from my client I push the csv file to sql and my end game is to import that file into my permanent template then export back to csv format in the same field layout all the time. In Foxpro I just type 'Append From...

This was so easy after I read the different changes I could make.... The RENAME function did it all in one pass.. The naming of the files is always the same, the locations are on the same drive and the files are never going to overwrite another so this was a perfect solution. I was even able...

Wow there is a lot of info to digest here... I'm going to work on this tonight and will update on final working version in the morning. BTW, I have VFP9 - I'm just a very old "manipulator of code" so I still use some really old code. Oh and I'm a 'her' :)

Going crazy here.... If I type in the physical location it works... using the below... *!move *export* e:\working\jobs\52990-t3\ - works lcmove = "e:\working\jobs\"+clist_no (doesn't do anything when i use the move command but doesn't crash) !move *export*...

So I was hoping this code would work but it doesn't. It compiles okay but doesn't do anything.... I've used /N and nothing. Didn't have the word 'to' originally. Didn't seem to matter. Any advice? I can type the command in DOS by naming the file and giving the physical path and that...

This is simplistic and wrong but I'm trying to move the files instead of copying them if possible. I'm doing it all by hand right now. **** SIMPLE BEGINNING ***** @ 11,5 say 'Enter Job Number for Return NCOA file: ' get CLIST_NO READ CLEAR SET SAFETY OFF SET TALK OFF lcprefix =...

I can delete the contents of the zip field if with a !isdigt() command but I need a little more now. I need to keep canadian records which have an alpha numeric zip so I can't make my zip field numeric. I need a command that allows me to delete the contents if there is a character in the field...

The original creator must not have had a full version or they had a lesser version that I do anyway. Mine is Acrobat 2020. Don't think it was out when this form was created.

Just in case someone else sees this... Someone else designed the PDF Form and I added some fields. Those fields were the only ones that imported from Excel back to my local PDF. I copy/pasted each field and moved the new form field up to it's proper location, deleted the original field and...

nobody?

here is the pdf on it's own...https://files.engineering.com/getfile.aspx?folder=13d2af53-003b-4990-9d11-2194fa4a9108&file=Dealer_Name_1_-_MAR_2021_-_Post_Sales_Rpt.pdf

I have Acrobat 2020 full version because I create a lot of forms and edit PDF all the time. Someone wrote a program for me that looks at my spreadsheet then updates the info back to a master PDF then creates an interactive PDF file for each record. When I open the PDF files locally only a...

I've been doing this for 25+ years. Mostly data processing and trying to streamline processes with programs (probably ones you helped me write :) ) I've had to change usernames on here for some reason about 10 years ago. i think my original was just eboughey.

That worked perfectly Mike.... I was just using some similar programming from something I wrote years ago but it's not nearly as neat and clean as this! Oh and I didn't know about the brackets or I would have certainly used those. Thanks so very much! I'd been working on this for 2 days...

I want the job number which is a variable to update in the .bat file but I've not been able to do it. I tried to strtofile() but it takes it literally and puts alltrim(listno) instead of the job number. Can I run some type of 'update' command for a text file? I can't find what I'm looking for...