Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ahhuang
  • Order by date
  1. ahhuang

    Save image SQL script

    that would be great! thanks.
  2. ahhuang

    Save image SQL script

    I am using vb.net. however i want it to be independent from any languages because i want run it with stored procedure only. Thanks
  3. ahhuang

    Save image SQL script

    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
  4. ahhuang

    error 0x800700b6 when logging on windows xp

    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...
  5. ahhuang

    error 0x800700b6 when logging on windows xp

    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
  6. ahhuang

    Add Sorting into query

    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...
  7. ahhuang

    Datagrid firstrow

    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...
  8. ahhuang

    Possible to read Tab Delimited text file?

    I have a text file and values are separated by tab. How do i read these values using vb? Thanx
  9. ahhuang

    Looking for VB controls

    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...
  10. ahhuang

    Connect to secure Access session

    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...
  11. ahhuang

    Drill Detail using VB

    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...
  12. ahhuang

    Link MS SQL server dynamically

    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?
  13. ahhuang

    Lisensing to crystal report

    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?
  14. ahhuang

    Lisensing to crystal report

    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...
  15. ahhuang

    Tamper with toolbar

    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...
  16. ahhuang

    Link MS SQL server dynamically

    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...
  17. ahhuang

    Insert jpg from two db fields, logo_path & logo_name

    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
  18. ahhuang

    Field Length Constraint

    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...
  19. ahhuang

    Converting from access to SQL

    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...
  20. ahhuang

    Error to convert Query to Procedure

    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...

Part and Inventory Search

Back
Top