prakashleo
Last Activity: Dec 18 '07, 10:42 AM
Joined: Dec 28 '06
Location:
-
-
version - vb 6.0
dtp1 and 2 are datepicker control names
tmp = "#" & DTP1.Value & "#"
tmp1 = "#" & DTP2.Value & "#"
txt_from.Text = tmp
txt_to.Text = tmp1
Set rdostr = cn.Execute("SEL ECT ITEM_MASTER.ITE M_NO, ITEM_MASTER.INT ERNAL_DESC, ITEM_MASTER.UOM _CODE, ITEM_MASTER.FLA G_NO, ITEM_REFERENCE. ORGAN_REF_CODE, ITEM_REFERENCE. ORGAN_CAT,... -
Runtime error TOO FEW PARAMETERS, EXPECTED 1
hi ppl!
here i'm getting an runtime error (Too Few Parameters, expected 1) while executing a query with vb which is running perfectly while executing from msaccess. pls pls help me in solving this. its littlebit urgent.
here the queries;
executed in msaccess,
SELECT ITEM_MASTER.ITE M_NO, ITEM_MASTER.INT ERNAL_DESC, ITEM_MASTER.UOM _CODE, ITEM_MASTER.FLA G_NO, ITEM_REFERENCE. ORGAN_REF_CODE, ITEM_REFERENCE. ORGAN_CAT,... -
ya i tried it now and it works thank u
and one more thing i am going to save this in ms access database before that i have to validate wheather each lines ended with comma or fullstop in that textbox because i have to cut the lines with less than or equal to 70 characters and it should be meaning full.
please help me to do this
thank uLeave a comment:
-
ya i tried it now and it works thank u
and one more thing i am going to save this in ms access database before that i have to validate wheather each lines ended with comma or fullstop in that textbox because i have to cut the lines with less than or equal to 70 characters and it should be meaning full.
please help me to do this
thank u...Leave a comment:
-
thank u for ur reply
how can i set the textbox to non-proportional fontLeave a comment:
-
moving to next line in multiline text box after reaching 70char
hi to all
I am using vb 6.0
I want to move to the next line in the text box after reaching text length 70 characters can any one help me -
In this code rs2(1) and rs2(3) recordsets shows null values because i am using memo fields for those in ms access database
Private Sub showitemvalues( )
Set rs = cn.Execute("sel ect * from template_master where matgroup_id=" & txtnounid & " order by temp_sorted")
Set rs1 = cn.Execute("sel ect count(item_id) from item_master where matgroup_id like '" & txtnounid & "'")...Leave a comment:
-
problem in moving the memofield of ms access into vb recordset
hi to all i am using ADODB.Recordset in vb and i have some problem when i tried to move the text in the memofield of ms access database to the recordset.
while running at first it moves to recordset but suddenly it disappears and showing null value in recordset.
No activity results to display
Leave a comment: