Hi,
I have a directory storing images.
How will I be able to write a SQL script to save the images into a table,assuming the DataType of image is 'image'
Thanks
Hi all,
thanks for the recommendations,
however problem still surface..
My system is not a dell system, and the registering of the dlls don't work either..
Did a spyware scan also...
Now awaiting for results of the virus scan...
I have encountered this error while trying to log into windows xp:
"A problem is preventing windows from accurately checking license for this computer. Error Code: 0x800700b6"
System restore did not help
What could be the reason?
Thanx
Hi all, i have the following code to pass parameter into my Access DB to call a query.
Can i at the same time add statement in vb to sort recordset?
eg i wan to sort by StDate..?
Public Function Get_Reconcile_Qry(tmpdb As Connection, tmpStDate As Variant, tmpenddate As Variant, tmpAccCode As...
I have a datagrid that contains records
I have been trying to use firstrow property by but always run into "Invalid bookmark"
What i want to do is:
1) Having a text box to accept input string
2) Search the datagrid recordset and highlight all
possible matched records from the input...
I am look for the 2 following VB activeX controls
1)Listbar control
2)I don't know what control is that or whether it exist or not. I like some kind of calender grid that each grid represent a day. Each grid cell can display date on top left hand corner and some notes at the center. Please...
I am using Assess db with vb.
my db is secured with a password
My coding is as below:
dim crxreport as new crystalreport1
dim crxtable as craxdt.database
for each crxtable in crxreport.database.tables
crxtable.setsessioninfo "","password"
next
my problem is eventhough i...
I m using v8.5 for my crystal report viewer & my code is something like this:
Dim app As New CRAXDDRT.Application
Public Report As CRAXDDRT.Report
Dim db As CRAXDDRT.DatabaseTable
Set Report = app.OpenReport("c:\tmp\jdb\r1.rpt", 1)
For Each db In Report.Database.Tables
db.Location...
initially the provided solution provided by IT2003 works, but then recently i changed server n then my crystal report cannot run in VB again.
The message is "cannot open server", even i pass the server name as a variable name.
How can I solve this?
i appreciate tat Reebo99 has provided me a link for my question.
however if i m just installing on a standalone pc, no multiple access, no network?
do i still need to obtain a lisense?
I have packaged up my program into setup.exe with necessary crystal report's ocx and dll.
My concern is tat I will not install any crystal report editing software into the client.
Does my client still need to buy any crystal report lisense in this case when only my installed program runs...
I have created a toolbar button with style tbrDropdown and some buttonmenu buttons under it.
When i click on the dropdown arrow , the buttonmenu appears.
I like to know if I am able to code in the way / or set properties of my toolbar button that when I click on the toolbar button itself the...
I am using crystal report control to link vb & crystal report.
In my crystal report development, I used database "a".
however when i try to load the report using vb, my database is "b", n it loads database "a" data.
please advise why is this the problem and wat are...
hi, i have encountered this problem before but have yet got any one to solve it also.
I went to crystal clear to take a look in march issue but it seems not published.
pls advise
ahhuang
I have run into this problem when trying to run the report.
In my Access or MS SQL database, there wasn't any field length constraint. However when i put the field into the report, the field name was trimmed off.
I like to know the maximun field length and in my case, is there any way to change...
I was currently upgrading my program from usage of MS Access to MS SQL, however while trying to convert all reports to link to MS SQL, i run to the following problem:
In my Access DB, my tables & fields are named in the way that there are spaces in between. When i test to convert 1 report...
Hi,
I am upgrading from Access to MSQL database but i am unable to convert the following query into procedure.
Please advice on how this statment can be amended to be accepted by MSQL
Thanx
UPDATE [INV Items] INNER JOIN [INV Item Location] ON [INV Items].[INV ITEM Id] = [INV Item Location].[INV...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.