I was wondering if there was a FW-function to detect the codetype.
Search found 1102 matches
- Mon Feb 15, 2021 2:18 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: barcode check
- Replies: 3
- Views: 4252
- Mon Feb 15, 2021 10:36 am
- Forum: FiveWin for Harbour/xHarbour
- Topic: barcode check
- Replies: 3
- Views: 4252
barcode check
Hi,
In by program, the customer can scan barcode's and create automatically invoives, scan customer cards, print labels,...
Normaly it's EAN13, but a costomer of mine have scanned a barcode on an article something like '0WTU118C02699'.
How can I determine what type this is?
In by program, the customer can scan barcode's and create automatically invoives, scan customer cards, print labels,...
Normaly it's EAN13, but a costomer of mine have scanned a barcode on an article something like '0WTU118C02699'.
How can I determine what type this is?
- Fri Jan 29, 2021 3:49 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: COPY FIELDS TO with variable
- Replies: 3
- Views: 1400
Re: COPY FIELDS TO with variable
João, I know that is the format, but I wanted to store the fields in a variable, because, I want the fields, depending of the content of a database. That was not working with the command. I found a solution with __dbCopy vvelden := { "NTWKNUM","NODENUM","MODNUM","S...
- Fri Jan 29, 2021 1:58 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: COPY FIELDS TO with variable
- Replies: 3
- Views: 1400
COPY FIELDS TO with variable
Hi, If I do copy fields NTWKNUM,NODENUM,MODNUM,SLOTNUM,NAME,PTDESC,KEYWORD,NODETYP,POINT_TYPE TO c:\temp\tpsdoc.dbf it's working like expected. Now I want the fields coming from a variable like this vvelden = "NTWKNUM,NODENUM,MODNUM,SLOTNUM,NAME,PTDESC,KEYWORD,NODETYP,POINT_TYPE" copy fiel...
- Wed Jan 20, 2021 6:12 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Copy Complete sheet op excel to another workbook
- Replies: 9
- Views: 3585
Re: Copy Complete sheet op excel to another workbook
Anton,
Thank you. It's working very nice.
Thank you. It's working very nice.
- Wed Jan 20, 2021 6:12 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Copy Complete sheet op excel to another workbook
- Replies: 9
- Views: 3585
Re: Copy Complete sheet op excel to another workbook
Anton,
Thank you. It's working very nice.
Thank you. It's working very nice.
- Wed Jan 20, 2021 3:56 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Copy Complete sheet op excel to another workbook
- Replies: 9
- Views: 3585
Re: Copy Complete sheet op excel to another workbook
There are 4 Sheets.
I allready tried with 0 and 1, but the same error.
I allready tried with 0 and 1, but the same error.
Enrico Maria Giordano wrote:Does exist the Sheet number 3 in oExcel? The first is 0, if I remember correctly.
EMG
- Wed Jan 20, 2021 3:42 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Copy Complete sheet op excel to another workbook
- Replies: 9
- Views: 3585
Re: Copy Complete sheet op excel to another workbook
Thank you,
Unfortunately I get an error:
Unfortunately I get an error:
- Error description: Error Excel.Application:SHEETS/16389 E_FAIL: COPY
Args:
[ 1] = O Object
Enrico Maria Giordano wrote:Try something like this:
EMGCode: Select all
oExcelInput:Sheets( "Network" ):Copy( oExcel:Sheets( 3 ) )
- Wed Jan 20, 2021 2:25 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Copy Complete sheet op excel to another workbook
- Replies: 9
- Views: 3585
Re: Copy Complete sheet op excel to another workbook
Hi,
In VBA it's like this
How can I convert it to FWH?
In VBA it's like this
Code: Select all
Sheets("Network").Copy Before:=Workbooks("Map19").Sheets(3)
- Wed Jan 20, 2021 12:31 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Copy Complete sheet op excel to another workbook
- Replies: 9
- Views: 3585
Copy Complete sheet op excel to another workbook
Hi, I want to open 2 excel-files, and want to copy a complete worksheet to the other excel-file. How can I do this? One excel is object oExcel, the other oExcelInput with this code I can copy it oExcelInput:Sheets(oExcelInput:Worksheets( 'Network' ):name):Select() oExcelInput:Sheets(oExc...
- Thu Jan 14, 2021 3:21 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: CMIMEENC (pdf-file to mime)
- Replies: 1
- Views: 859
CMIMEENC (pdf-file to mime)
Hi, A want to add a PDF-file into a xml-file with mime (base64) encoded. How can I add this? If I use CMIMEENC('C:\Users\Marc\Documents\Factuur 20210005.pdf') then the text 'C:\Users\Marc\Documents\Factuur 20210005.pdf' is converted. Can I use memoread()? Does this also read the special characters o...
- Tue Jan 12, 2021 4:02 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: conditional formatting excel
- Replies: 9
- Views: 2368
- Tue Jan 12, 2021 3:26 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: conditional formatting excel
- Replies: 9
- Views: 2368
Re: conditional formatting excel
Hi, I'm using this FormatConditions, and it's working fine, but now I want to use instead of for example testing if the content is "Tekst" like this oCond1 := oRng:FormatConditions:Add(xlCellValue, xlEqual, "Tekst") I want to compare it with another field. Using oCond1 := oRng:Fo...
- Sun Jan 03, 2021 2:09 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Peer to Peer, NAS and NTX -> CDX
- Replies: 41
- Views: 12765
Re: Peer to Peer, NAS and NTX -> CDX
I also have a Synology DS218 that I use for the backups. I see that this can also be used as server ? I have several clients that use a Synology NAS as server. I have to say that then all are converted to SQL. On a Synology NAS you van install the MariaDB package, and it work very nice with FW :D Y...
- Sun Jan 03, 2021 10:39 am
- Forum: FiveWin for Harbour/xHarbour
- Topic: Peer to Peer, NAS and NTX -> CDX
- Replies: 41
- Views: 12765
Re: Peer to Peer, NAS and NTX -> CDX
I also have a Synology DS218 that I use for the backups. I see that this can also be used as server ? I have several clients that use a Synology NAS as server. I have to say that then all are converted to SQL. On a Synology NAS you van install the MariaDB package, and it work very nice with FW :D Y...