Search results for query: *

zapnotes or notesmedic are 2 utils designed to help you here. ije.

thanks all I have it working with: Set oRecordSet = CreateObject("ADODB.Recordset") oRecordSet.Open SelectSQL, Conn message= oRecordSet.fields("filepath") this works fine, but does not cater for situations where it finds no records or multiple records. That is the...

thanks PH - i am not quite I understand ( due to my inexperience I am sure! ). Would you have a simple example you are able to share? Many thanks ije [afro2]

I am trying to assign the results of a a SQL select statement to a variable, but the result is always blank ie it appears no value is returned. I am only a casual vbscripter and thought someone could assist? Below is the code I am using, which at the moment I would be happy to have the...

I have a program that uses 2 parameters. I start the program at a command line like "script.vbs value1 value2" In the script I use the following syntaxt to extract the parameters: val1 = cstr(wscript.arguments(0)) val2 = cstr(wscript.arguments(1)) However, my parameters are now...

yes the open save using Word worked a treat. I still have to test on Citrix where it is also used, but from previous experience, it "should" be fine. many thanks ije.

Hello, i require a method adoptable in VBScript to automatically convert a given RTF file into a TXT file. Does anyone have suggestions or proven methods? many thanks ije

thanks for responses - i accept that this is not the ideal solution, but due to customer lockdown on file shares, we can come up with no other alternative. I was hoping for a simple example of how to insert into the table. I imagine it is similar to ( my psuedo code here...) insert into...

Hoping someone can help.....I need to insert via VBScript a PDF file into a SQL table. I have not done this, and need to create the table, and the script to do the job. The table it is going into will have 2 fields - a text field to desribe the attachment, and the attachment field. Of course...

hello, I have a report ( CRD 8)that has two subreports, which are connected vai leftouter joins to the main report table. Each subreport adds up some numbers and totals them, and I can display the total for each subreport OK. However,in the report footer, I wish to add up the two different...

excellent!! that worked great! thanks a lot. As you know this so well, maybe you can assist a little more....in some fields I need to put the date forward, say 10 days to act as a target date? Is there a way to do this, taking into effect times when the additional 10 days will also take it...

I am inserting into SQL db - not sure what you mean by it being easier to do it there? I can isolate the date parts OK, just cant return it to the text field with dashes between the elements returned....

i need to insert into a varchar field the current date, but in yyyy-mm-dd format. I thought I could do it using datepart(yyyy,getdate()) & '-' & datepart(mm,getdate()) & '-' & datepart(dd,getdate()) or even datepart(yyyy,getdate()) + '-' + datepart(mm,getdate()) + '-' +...

i thought I might pose this in another way.... currently to supply a value of 100 to the Crystal report promt "selectcallid" i use the following piece of code: Case "selectcallid" .SetCurrentValue("100") What I would like to do is change the prompt...

For a while I have been using a vbscript to generate a crystal report, providing the input for the single discrete prompt required. Now I need to provide the input for a few other prompts, which are range values. Currently this is the code I use to provide the prompt input ( full code at end...

no there is only one mobile phone field....i ended up doing it this way: Dim conn, insertSQL Dim mob1 mob1 = replace("0455-555-555","-","") Set conn = createobject("ADODB.Connection") conn.open "dsn=sms;uid=sa;pwd=;database=sms&quot...

...an extension of what I need to achieve the first objective!! As this script is used to insert rows in a table used to send mobile phone sms messages out of, i need to remove dashes of mobile phone entries. When I try the following script I get "The name 'mob1' is not permitted in this...

Ok this is not a new topic really, but an extension of what I need to achieve the first objective!! As this script is used to insert rows in a table used to send mobile phone sms messages out of, i need to remove dashes of mobile phone entries. When I try the following script I get "The...

thanks ralphtrent! I needed both parts - mainly the connection bit though...many thanks for the example!

Hope this is simple for the experts out there... I need to create a VBScript file that will insert a row into db on SQL 2000. There is a System ODBC connection available if that is easier pointing the database in question Details are be: ODBC Datasource Name: SMS Type: SQL 2000 Table...