Type: Posts; User: Shaikh.Riyaz.a
Search took 0.03 seconds.
December 7th, 2009, 12:09 AM
You can use scriptControl to excute the string or use ebExecuteLine API.
But I guess, this API doesn't work in compiled environment. So better go for scriptControl.
December 25th, 2008, 01:04 AM
Have a look at CallByName function or as suggested by dglienna use script control.
August 18th, 2008, 03:57 AM
I think crystal reports or data reports will be good option.
August 6th, 2008, 04:10 AM
You can check the existence of lock file for word!
July 19th, 2008, 02:09 AM
You can generate barcodes using crystal reports.
You just need special fonts for that purpose.
July 16th, 2008, 10:10 AM
I still dont understand where is the problem!
July 11th, 2008, 12:17 AM
Will using INNER JOIN syntax solve the problem?
Is there any difference between query written by me and yours?
July 10th, 2008, 07:41 AM
Change the appearance of picture box on pic_MouseMove and Form_MouseMove events.
July 10th, 2008, 07:27 AM
Can you attach your database here? (of course if possible)
or list few records from both records which you expect to come in output.
July 10th, 2008, 03:38 AM
I have filtered data for ProductItem.
"AND P.Scope = '" & frmPurchaseReport.cmbScope.Text & "' " & _
"AND P.Date = #" & frmPurchaseReport.dtpRDate.Value & "#"
July 10th, 2008, 02:48 AM
Where have you written this public function,
in class module or in standard module?
If it is in class module, check whether the class is accesible outside your library or not!
July 10th, 2008, 02:41 AM
Your query should be like this.
rs.Open "SELECT S.Scope, S.RF, S.RevisionNo, P.[Date], P.Scope, P.ItemName, P.ItemCode, P.QtyInStock, P.QtyOrdered, " & _
What you have done so far?
It is better to use FileSystemObject.
Here is one example:
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
'This will return 'DS0008.jpg'
I didn't get this in your query.
s.Scope=p.Scope=" & "'" & frmPurchaseReport.cmbScope.Text & "'
To start with, this is good.
Whatever you have written seems correct.
I think you have to use '#' for filtering date column in access.
Making the date field as string will not allow you to sort that column on date basis.
If you are writing the values cell by cell then convert date values to double
and put it in excel and later...
Not very clear what do you want but this may be helpful.
Use this to write to text file
frFile = FreeFile
Open "C:\Test.txt" For Output As #frFile
Print #frFile, txtData.Text
Set the container property for control.
Following code will add frame and option button to form
and will set the container of option button as frame.
Private Sub Form_Load()
Dim fr1 As...
Keep the datatype as image in SQL server
This is the code to save the file to server :
Dim strm As New ADODB.Stream
strm.Type = adTypeBinary
I can just guess that 'Format' is a function in VB.
Click Here to Expand Forum to Full Width