Search results for query: *

Hi alvechurchdata 1. No, I’m not using AutoIncrement data type. Just normal coding like creating another table that is called repnum and has a field ‘rp_num’ as I mentioned (replace rp_num with rp_num +1 ) earlier. The record is stored in separate table (tnfjob.dbf). 2. You got the point. I...

Mike Sorry for not explaining clearly. 1. Yes, I created the textbox and name it as 'refno' for auto-numbering. (See the image) 2. Create another new table 'repnum' to have the next running no for the refno textbox. rp_num is the field name of the repnum.dbf. So, I put replace rp_num with...

There is a textbox named 'refno' for auto-numbering purpose. I want to make this textbox visible and display next number when opening the form. repum - table to store numbers which is next to the existing no in the same line. rp_num is the name of field in the repum.dbf. tnfjob - table to...

Hi all experts, I write the code as below. What I see the result is CN0609 on the report designer when running the form. How to set the serial numbers running according to every month. For example, the df_ref (on the report designer)would be CN060901, CN060902, CN060903, etc when printing out...

danfreeman, Thank you for your valuable post. The result is 'CN0609' as what I want to see. Anyway, I do have a problem with the last running serial nos. Now re-writing the code to make the serial nos refreshing from 01 according to every months. For eg, if it is month of Oct, need to set the...

The error that I faced is "Function argument value, type, or count is invalid." In the Trace view, it points to seek alltrim('CN' + right(str(df_date),2) + right("00"+alltrim(str(month(df_date))),2) + str(dbfnos.dn_no+1)). [ponder] Think of re-writing a better code. Thanks millbear Just a...

Hi The error is like 'long string'. Thanks millbear Just a Beginner! Need help badly.

Hi Mike Sorry, i forgot to ask the question earlier. Originally, the result is 01 when running this line as below. seek alltrim(str(dbfnos.dn_no+1)) To achieve the new result is CN060901. So, i added the following code as below. seek TRIM('CN' + right(str(dtoc(df_date),4),2) +...

I'm trying to write the code to get the desired result: - CN060901, CN060902, etc...? CN060901 stands for:- 06 - Year 09 - Month 01 - Serial number (dn_no from the ".dfbnos" table) dbfnos is the table of the auto-numbering, starting from 01. dn_no is the field name in the table (.dbfnos). if...

Jim Yes, I did refresh it. Thanks millbear Just a Beginner! Need help badly.

[thumbsup] jim for this code. When I key in any job no (in yellow field), the data on B/L no is displayed. But the problem is ... that it cannot displayed again when i keyed in another few more job nos.. Wondering why... [ponder] Thanks millbear Just a Beginner! Need help badly.

Hi all I purely have no idea where i go wrong. I'm trying to get the datas (such as CHEVSINSMZ 100,CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102, etc) from the table (.dbf) display and then trim into "CHEVSINSMZ 100 & 101 & 102 itself. [upsidedown]...

[morning]Anyone can help to spot the mistake? [ponytails2]

I have modified jrajesh's suggested codes a little into my form. Jt_hblno is a part of the table (.dbf)in the form. It is like something that contains CHEVSINSMZ 100,CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102, so on in the column... So, I have edit this line as below. ~~ InputString=...

Griff Call me April.. :) I'm answering jrajesh.. I will try compiling suggested codes and let u know if it can work or not... [blush]

Click Invoice. I key in the company code and then enter to the Job no: field. All the details including CHEVSINSMZ 101, CHEVSINSMZ 102,or any words are displayed.. So I'm not sure if i remove the input string "CHEVSINSMZ", the form will work or not.

InputString= "CHEVSINSMZ 100, CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102" Is it possible to work if i rewrite the existing code to InputString= "" ? The purpose of my form is only searching for any job no. All the details including BL no will be displayed itself.. There is no exactly...

Here is entire code as u requested. (-: local i, lchar, lnum, jn, lcnt, ltmp, lncargo, pono, ordrno, hblno1, hblno2, k, tmp, lhbl dimension lcargo(12) dimension lpono(12) dimension lordrno(12) dimension arr[2,25] ex = 0 vess = "" with thisform.pf.pg1 .xdf_bl.value = "" .xdf_bl2.value...

I have tried both tsh73 and griffms's suggested code. The result is " (1) & & " Sorry to confuse you earlier. I have added simple description : Invoice. As you see the yellow box - Job No:, I enter any job no to call out and all the details will be displayed. I'm struck with the B/L no field...

It seem not working on my form. BTW, what version you are using foxpro software?[upsidedown]