Click here to Skip to main content
15,920,029 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Hi ppl..short question! Pin
User 989707411-Jun-17 9:07
User 989707411-Jun-17 9:07 
GeneralRe: Hi ppl..short question! Pin
User 989707412-Jun-17 1:35
User 989707412-Jun-17 1:35 
GeneralRe: Hi ppl..short question! Pin
Ralf Meier12-Jun-17 1:41
mveRalf Meier12-Jun-17 1:41 
GeneralRe: Hi ppl..short question! Pin
User 989707412-Jun-17 1:47
User 989707412-Jun-17 1:47 
GeneralRe: Hi ppl..short question! Pin
User 989707412-Jun-17 1:50
User 989707412-Jun-17 1:50 
GeneralRe: Hi ppl..short question! Pin
Ralf Meier12-Jun-17 2:04
mveRalf Meier12-Jun-17 2:04 
GeneralRe: Hi ppl..short question! Pin
User 989707412-Jun-17 2:17
User 989707412-Jun-17 2:17 
QuestionTo get the contionus Bill Number Pin
Annapurna anu2-Jun-17 20:18
Annapurna anu2-Jun-17 20:18 
Hii..

I need to know how to get continuous bill numbers, I have a query which gives Bill numbers Continuously for a month but once the month get ends the bill number will start from one again which is not required it should continue with the last bill numbers which was generated in last month...

The Query is...

stQuery = "SELECT MAX(substring(st_bill_no from 9 for 15)) FROM sc_bill WHERE dt_bill_date BETWEEN '" & _
                   Format(FirstDayOfMonth, "yyyy-MM-dd") & "' AND '" & _
                     Format(LastDayOfMonth.AddDays(1), "yyyy-MM-dd") & "'"


Thanks In Advance

AnswerRe: To get the contionus Bill Number Pin
Richard MacCutchan2-Jun-17 22:22
mveRichard MacCutchan2-Jun-17 22:22 
SuggestionRe: To get the contionus Bill Number Pin
Richard Deeming5-Jun-17 8:32
mveRichard Deeming5-Jun-17 8:32 
AnswerRe: To get the contionus Bill Number Pin
jsc4228-Jul-17 7:41
professionaljsc4228-Jul-17 7:41 
QuestionNeed real time list of on/off computers on lan amongst other things Pin
Member 130478152-Jun-17 19:13
Member 130478152-Jun-17 19:13 
AnswerRe: Need real time list of on/off computers on lan amongst other things Pin
OriginalGriff2-Jun-17 19:18
mveOriginalGriff2-Jun-17 19:18 
AnswerRe: Need real time list of on/off computers on lan amongst other things Pin
Dave Kreskowiak3-Jun-17 5:19
mveDave Kreskowiak3-Jun-17 5:19 
QuestionBarcode commands to Zebra printer Pin
Randy Crockett1-Jun-17 13:34
Randy Crockett1-Jun-17 13:34 
SuggestionRe: Barcode commands to Zebra printer Pin
Ralf Meier1-Jun-17 19:41
mveRalf Meier1-Jun-17 19:41 
GeneralRe: Barcode commands to Zebra printer Pin
Randy Crockett2-Jun-17 8:05
Randy Crockett2-Jun-17 8:05 
AnswerRe: Barcode commands to Zebra printer Pin
Richard Deeming2-Jun-17 1:11
mveRichard Deeming2-Jun-17 1:11 
GeneralRe: Barcode commands to Zebra printer Pin
Randy Crockett2-Jun-17 8:06
Randy Crockett2-Jun-17 8:06 
Questionsending message plugins Pin
Member 1322979929-May-17 14:50
Member 1322979929-May-17 14:50 
AnswerRe: sending message plugins Pin
Richard MacCutchan29-May-17 20:49
mveRichard MacCutchan29-May-17 20:49 
AnswerRe: sending message plugins Pin
ZurdoDev2-Jun-17 3:16
professionalZurdoDev2-Jun-17 3:16 
QuestionWanting to use a For Next variable in “xxxx.Rows.Count” Pin
smdevivo23-May-17 16:05
professionalsmdevivo23-May-17 16:05 
AnswerRe: Wanting to use a For Next variable in “xxxx.Rows.Count” Pin
Maciej Los23-May-17 20:55
mveMaciej Los23-May-17 20:55 
QuestionRe: Wanting to use a For Next variable in “xxxx.Rows.Count” Pin
ZurdoDev24-May-17 4:02
professionalZurdoDev24-May-17 4:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.