Recent content by gbcpastor

I've had this situation several times years ago. What I got in the habit of doing was using a leading zero in my text fields so I would have values that looked like this: 01 02 03 04 05 06 07 08 09 10 11 12 13... That's if I wished to keep the values as text. Otherwise, just use the val()...

Perfect Chris, thank you so much for your help.

I need to mark the first 3 records in a field called TARGET when the field called MAILCODE contains "123ABC" Then repeat the process for each value in the MAILCODE field. Please help!

Hey there, I had this problem in the past. What I was doing was creating a "Character Type" variable in the form. I created it so I could enter in a masked value ("999,999.99"). When I tried to set the valued of the field in my table to the value in the table, it errored out. Then I realized I...

The only info I could get about dBase 5 files was they were used by spinoffs like "Clipper" and others. Access "DBF" files are also in this configuration. Again, thanks for your help.

And there you go. All I had to do is copy it out without memo fields and use type FOXPLUS and it worked great. Thank you Chris and thank all the rest for all the help.

This is the result. I must produce this filetype for the software on their machine.

This is not the old DOS version of dBase. I think they need files for windows ACCESS and they call the file type dBase 5. I tried 2x and FOXPLUS and neither worked. So, I'm still stuck. I'm trying to talk them into a CSV import on their end but I hate going to the client and tell them "I Can't...

I have a client with proprietary software that requires dBase 5 files. I need to export a file in DBF format that is compatible with their system. I don't know what's different about the files but they have to be dBase 5 format.

Thanks to everyone, especially Greg "ggreen61", you have been such a great help and all is working perfectly. God bless;

Greg, thank you so much for all your hard work that I now get to use. This is a great tool for so many that need xlsx reports for clients these days.

Absolutely perfect. Thank you so much. I appreciate all your help.

Sure.

I would have loved to say all fixed. But while it did run correctly, the result was still the same even after the changes you sent. Please let me know if you have any other ideas. (I'm willing to send all I have on this if it would help)

I'm really hoping this will work. Right now, when I run the code, I get an error. I'm not understanding why this is. The class is in the same folder.