Search results for query: *

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.

In the file I attached, the first field that has leading spaces is A3 so the A1 doesn't work. I'm using version 2013 excel. I'd love to know how to force the single quote formatting without showing the single quote. There has to be a way to do it, I just haven't been able to figure it out. I...

Right Aligned would trim the space to the right causing a new error.

When I look at the spreadsheet, in the cell I'm creating, it has the single quote showing as the first character and it adds 1 to the length of the actual data. Take a look.

I'm actually using the WorkbookXLSX R30 class. it looks like you are not, at least I can't find that function in the class. When I use the following, the single quote shows up in the first position of the cell. lcExcel.SetCellValue(lnWb, lnsh1, 1, 1, "' 123") result in cell 1,1 ' 123

Griff, can you please tell me how you, programmatically, put that single quote in the cell so it doesn't show up? Please help.

Were you able to figure anything out? I would love to use this class as I've got so much in it at this point. Please help

Griff, can you tell me how you got the single quote not to show up in the screen? Every time I try this, the string begins with the single quote followed by the blank spaces. But I can't get rid of the single quote.