Search results for query: *

Any idea why this construct dosn't work? If Thisform.optiongroup1.Value = 1 Thisform.optiongroup2.Value = 2 Endif

How to overcome 254 character limit importing CSV or excel files? I have a table, I need import CSV with a few columns that are about 1000 characters long, maybe creating 4 fields for each, but how to split them?

I have a local folder that gets PDF files and depending on their file names I need to have them printed to a specific printer. Example: c:\print\pr1.pdf -> printer_1 c:\print\pr2.pdf -> printer_2 c:\print\pr3.pdf -> printer_3 ShellExecute leaves Acrobat open after printing: lcFile =...

Is it possible to create compound index with different orders: field1 asc + field2 desc + field3 asc?

What's the best solution to zip and unzip files/folders nowadays?

Is it achievable in vpf or better do it outside? I've been doing it outside for a while, it is fully automated and works fine, but I don't want to rely on third party and wanted to check what's on the table.

Is it possible to export DBF without extra spaces that fill up to field length? Trying to get CRLF characters right after my data: and not(used- copy to "name" sdf):

Is it possible to change this query to have blanks instead of .NULL. values: Select t1.*, t2.ends, t2.imbc, t2.ord, t2.csz; from table1 t1 ; left Join table2 t2 ; on t1.unirec=t2.unirec ; into Table currentfile2.dbf Or may be even a better way to accomplish this, what I am trying to do is...

I know there many topics/solutions out there dated all the way from 2007 and I've already spent hours and hours going through them without any luck finding that works well. Some of them will import all the data as memo records, others will have 600-1500 lines of code and when I run them, I get...

I have a question - I have 2 tables with the different fields and one unique key field(id) in both those tables and I need to merge all those 2 table's fields based on that id key field, number of records(rows) should stay the same, only the number of fields(columns) should change. Forgot to...

Does anyone know how to move fields fast in browse view? Example: I added a new field in the table with 200 fields and as result I get it the last when I browse that table and I need to move to be the first one. It takes a while dragging it by hand. And moving it in table designer->fields...

What's the best way to pull one list from another? Have 2 tables and need to copy complete lines and delete them after: table to be pulled from 50K: janet john john jack joe joe list to be pulled 20K: joe jack

Converting from barcode39 to data matrix, barstring="1234567890asdfghjkl", any suggestions on easiest implementation? Thank you

Have five related tables with one-to-one and one-to-many relationships, is it better to unite one-to-one ones together for cleaning and performance purposes? right now, it is a little bit confusing, having quite a few commands done with "tableX.fieldX" addressing. Any good resources(samples...

Have DB with 100K records with multiple memo fields each field have variable data, need to replace all "red" with "blue" in each record including memo fields. Any quick solutions?

Need help writing code snippet for Modulus 10 check digit with weights of 7,5,3,2. As shown below: Thank you!

I have table, that I am sorting to by several keys(zip+recnum+..), but when I using commands like "replace next 20...", it applies those changes to the records from initial order before sort. So I came up with workaround- saving those tables to txt files after sorting and reopening them again...

How to import data to dbf from text *.DAT file, tried "append from ? sdf", but it is confusing users with it's .txt extension. FOPEN() can't make it to append to dbf.

Trying to run external application, but all I get is that MS-DOS window blink once, here is my code: cXFile = "C:\Program Files\abc\xyz.exe" Run &cXFile

If Substr(Alltr(field1),1,1)='#' Or Lower(Substr(Alltr(field1),1,2))='rm' Or Lower(Substr(Alltr(field1),1,2))='sp' Or Lower(Substr(Alltr(field1),1,3))='apt' Or Lower(Substr(Alltr(field1),1,3))='lot' Or Lower(Substr(Alltr(field1),1,3))='bld' Or Lower(Substr(Alltr(field1),1,3))='pmb' Or...