Search results for query: *

Chadt: you seem to be getting hung up on my MCSD status. The point is that I know all about Crystal reports, including the version that is on the CD. The version of CR on the VB 6 CD is v4.6 which does not allow data to be passed to the report from a disconnected recordset. The reason I need a...

Crystal 8.5 may be the key, but it is way too expensive for the company that I am working for. With the rand dollar exchange rate Crystal sells for about R30000 and then we still need to buy user licences. Thanks but no thanks, Crystal just will not do. Any other ideas?

Hi Guys, I am trying to get a reporting tool for printing reports. The reporting tool needs to have a good Designer interface as well as be able to get data from a disconnected recordset. Output to PDF would be an advantage. If anyone knows of such a tool please could you respond to this post...

Thanks Guys, your answers have been great. I have however opted for SQL DMO. Just reference the SQL DMO object and you have the power of SQL Server including Scripting at your fingertips. What I meant when I said part of the PK was that I had one PK but it was a composite Key comprising of more...

Thanks for your answers. I am aware that you can use the Enterprise Manager, however I am writing a VB program to do this automagically. Users without knowledge of SQL will receive a listing of the tables they want to modify, they will then tick the ones they are to be modified and then Generate...

I need to script a table through code so that I can add fields to the table. eg. If I have a table like this: Field1 int (Primary Key) Field2 char(18) Field3 char(3) I need to generate a script that looks like this: Create Table Blah ( Date...

When opening an Excel Spreadsheet within the Web Browser it gives us the following error: Method 'Calculation' of object '_Application' Failed The code that causes this error is : Application.Calculation = xlManual Any help with this error would be appreciated.

I use the following code to encrypt and decrypt text strings. I then save them into the registry but you can save it into your DB in a text field. Use your encrypted string against this same function using exactly the same key and it will decrypt it. Private Function EncDec(byval strString As...

Hi Guys, I am in a bit of a bind. I need to send an e-mail message using outlook from VB. Easy you say? Well heres the problem, I need to send this e-mail using a form which I have designed using the standard mail form as a template. It doesn't even have to be an automated send, it can open up...

Hi There, Thanks for the posts so far. We have sorted the problem with CDO NTS now. The problem was that two days ago the server that we had to use for a SMART Host, was disabled. As soon as the operations guys gave us the IP address for the new server, the mail started working perfectly. Thanks...

Thanks for the reply. We have figured out that the reason why I couldn't get CDONTS working is because the SMTP server is not set up correctly. I have no idea how to set this up but it keeps placing the mails into the badmail directory. I am running this whole thing on an NT server and our mail...

Hi There I am using the following code to send an e-mail in VB. It works 100% except that I need to send embedded HTML. If I send embedded HTML then it actually shows the tags. I saw some sample code to send HTML using CDONTS but I cannot get CDONTS to work at all on my pc. Thanks in advance...