Search results for query: *

Hi I have an EIS screen which contains a button. The buttons script exports a file as excel to a hardcoded location. Is there any way to check to see if the file already exists using script? I don't want to use a dialog as the location will never change. Thanks in advance

After further investigation I have discovered I can use MS Script Control (msscript.oca). Thanks anyway...

OK, perhaps I was not clear, I thought I was. I have a VBscript, using VB I want to read through that VBScript (without running it) and get the names of all the functions that are present in that script. I then want to put the names of these functions into a VB combo box. I am fully aware of...

Hi, I am looking for ideas on how to get all the function names out of a VBScript using VB. I want to put these function names in a combo box to display to the user. Thanks in advance

A file along with the program (and I registered it), I also included GAPI32

Yep! Already checked that...any other ideas?

Hi, I am trying to send an email using CDONTS. It works on the development machine but when moved to a test machine it fails "Active X can't create object" and it is failing on the Message.Send line (see code below). The test machine has an SMTP server (Ability Server 2.33) set up in...

Hi I am trying to execute this SQL statement in MS Access: ALTER TABLE Client_Detail ALTER COLUMN Notes Memo Everytime I run it the following error shows: "Syntax error in ALTER TABLE Statement" and the cursor highlights the second ALTER in the query. (I am trying to change the data...

Does anyone know how you can call a method in a .bas module, from a UserControl, passing a combo box (on the UserControl) as one of the parameters? Code so far: .bas module Public Sub LoadProjects(cmbProjectName As VB.ComboBox) End Sub UserControl Public Sub Display Call...

I would like to automate the conversion of an MS Word Document to a .pdf document using Visual Basic. Does anyone know how to go about doing this? Thanks

I would like to automate the conversion of an MS Word Document to a .pdf document using Visual Basic. Does anyone know how to go about doing this? Thanks

I want to save a report that appears in the CRViewer in VB, is there a button which can be added to the toolbox? Or is there another way the report shown can be saved from within VB? Thanks

I am creating an xml file in VB which I have managed to do but I would like to insert a dtd reference so the xml document can be validated at a later date. The line I want to insert is: <!DOCTYPE xx:xXML SYSTEM &quot;xXML.dtd&quot;> Does anyone know how to do this from VB?

I am trying to suppress duplicate values in a report, however the value I want to display comes from another column in the database. I have duplicate values in my query and the two fields that I am interested in are a date and an amount. I want to find the duplicate dates and suppress the...

Thanks rogar and Ngolem, that worked a treat. Your help was invaluable

Hi I am fairly new to this report writing thing and was wondering if anyone could help... I am trying to write a formula which will loop through all the records in the report for a particular field (called ls_percentage) and concatenate these values into a string. If one of these values...

Does anyone know where I can see some examples of Visual Basic code which show how to set the limits in a report?