Hello ,
i cudn't get ur question fully... tat Error occured in Runtime? let me know.....
palsonjj
Last Activity: Sep 4 '09, 05:22 AM
Joined: Apr 4 '07
Location: Now Bangalore, India
-
hello Sir,
Thnku .. thn, i'm not goin 2 leave tat way of displaying reports... so CMRHema, plz lead me 2 do tat... thnks in advance...Leave a comment:
-
Hello Hema,
first of all thnku vry vry much 4 ur helpin..... i've d datas within d date...
anyway, i've tried other way. create a query table[view table] dynamically at runtime using "queryDef". . then, call tat table 2 d data environment... nw it'll works .... hoooooooorrrrrr rrrrrrraaaaaaaa aaaaaaayyyyyy.. ....Leave a comment:
-
Dim Mycon As New ADODB.Connectio n
Dim M2 As New ADODB.Recordset
Dim S1 As String
form_load()
S1 = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=" & _
App.Path & "tblSales1. mdb"
cmd_click()
M2.Open "select * from tblSales1 where InvDate>=#" & DTPicker1.Value ...Leave a comment:
-
i've changed tat invdate datatype date/time... nw also same error occured....?? :(...Leave a comment:
-
yes..... i've already added tat......Leave a comment:
-
Haaai, Database s created . but, "Set F(0) = T.CreateField(" EMPNO", dbInteger)" dis line has error --- Type mismatch... ??????...Leave a comment:
-
thnku...
haaai, thnku .... it's workin....... thn, can v create query table using dis same method?...Leave a comment:
-
Yeeeeeeeeeeeeee eaaaaaaaaaaaaaa aaah , it's workin........ ;) ..thnku vry much ..........Leave a comment:
-
mmmmmm.....The followin error occured
" Run-Time Error '3709;
The Connection cannat be used to perform this operation . it is either clsoed or invalid in this contest."...... .. ??...Leave a comment:
-
Haaai, thnks 4 ur replyin... i've 1 more doubt.. wher shud tat table stored ? can v giv any default path?...Leave a comment:
-
S.... u r rite.......Leave a comment:
-
Hello,
first of all vry vry vry thnks 4 ur replyin...
yes, i am using 2 DtPicker ctrl for select a month.. thn, i've two tables Named tblSales1 & tblSales2...
tblSales1 :
InvId-text-Invoice Id--> System Date
InvNo-number-Invoice No--> User Input
CustName-text--> User Input
CustAddress-text-->user Input
InvDate-text---> Date of Sales********* v've to select...Leave a comment:
-
Haaai,
u shud use ALT Key + N .......Leave a comment:
-
table created dynamically
haai,
how to create MS Access Table dynamically in VB? any idea........... ............... -
Haai,
Thnk you vry much... it works... thanks again..
nw i've to show a monthly wise reports which user only select the month.... is't possible using Data Environment r any other idea wit code Plzzzzzzzzzzzzz zzzzzz.........Leave a comment:
-
Haai Evrybody,
Thnk you vry much... it works... thanks again..
nw i've to show a monthly wise reports which user only select the month.... is't possible using Data Environment r any other idea wit code Plzzzzzzzzzzzzz zzzzzz......Leave a comment:
-
Data Report
Haai,
nw only i've joined here....
i've prob wit Data report... mmm.... how to show the last record frm Database to the Data Report? anyone help me plzzzzz?
No activity results to display
Leave a comment: