Search results for query: *

Thanks for the speedy replies... I've managed to import the data into Access and randomise the data there using a query based on Rnd(), which gives the same results, just on a larger scale (i.e. more records). Thanks very much for your help Phooey

The data will end up in a large csv file for use by LoadRunner. I'm currently using the RAND function to randomise the data, but will not be able to do this when the number of input csv files grow beyond the scope of Excel. Looks like Access may be the way to go. Thanks Phooey

I've been amending an Excel spreadsheet used for data conversion to be used in Stress Testing. Not my choice, I will admit, but the solution I've inherited. As a last step, Excel opens up all csv files found within a directory and copies the contents to another sheet, appending to the bottom...

Make sure that you install the Access 2000 Runtime files to a separate directory to the current MS Office installation.. Example: All Microsoft Office apps by default install to C:\Program Files\Microsoft Office\ Therefore, your current MS Office installations will exist in the avbove...

Write code to call SendLotusNotes. Recipients is an array containing all of the people that you're mailing to. Subject is the email subject. BodyText is whatever you're putting in the message body. Attachment is optional and is a file path. SaveIt is optional and is a boolean (True or False)...

personnally, I like to use the http:// format as it works across all apps. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.

Look through the Access help files. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.

You could try, because I'm sure that the same object sending functionality exists... If you're working in 2000, try Tools/Database Utilities/Convert Database/To Previous Access Version. This will create an Access 97 version of the database. You may have to test this to ensure that all of the...

Forgive me, I'm getting a little confused at the moment. The process you're trying to describe is: User sends email to central location. Central location automatically sends out an email refer to Word document in some way. User fills in Word document. User send word document back to central...

have a look at http:/www.lotus.com if you're looking for specifics. HTH Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.

Redirecting people to an FTP site is too technical? How? If you include a link sent from a response agent, the link would be directly to the document itself, which would automatically ask for a place to save it to. All the user then has to do is fill in the details and send it back. Is...

Do your users currently run a Notes database, or is this a project startup. Just wondering, because I may have an idea. Settting up a Web enabled database is not that much work. As long as you get the HTTP server and stuff right then all you need is a domino database with HTML in the forms. A...

The other option would be to just do: <a href='mailto:andrew.j.harrison@cgey.com'> Click here to send me an email </a> Where my email address is could be replaced with a field in order to create a dynamic email link. Hope this helps.. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known...

Why not just use an agent to create an email object and attach the Word document to it in LotusScript? This would then be fired off when the specified email has been received. Hope this helps. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.

I don't see why not, but the code you're looking for would be in Access. It'd be along the lines of creating a mail object in access and sending it. Windows may handle the default email package, but you may have to launch a Notes session in code. Have a look in the Access forum for more...

You could also download the NotesSQL ODBC driver and perform the required SQL actions using MS Query in Excel or link the tables in Access. This may prove worthwhile, but you won't have instant results. If you take this method then each view will effectively be a 'table'. Therefore if you only...

You don't use HTML much then? Have you tried mailto:blah@blah.com? As in: <a href=mailto:andrew.j.harrison@cgey.com>Click here to mail me</a> Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.

You could try exporting the document as a Rich Text File and use Word to open it. I can't promise fancy styling, but it may just do the trick. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.

Yep, you're on the right track. Relational Databases are, for want of a better word, relational. Domino databases are based of documents, kind of like an email storage system. That's the way I look at it and it helps me. As Domino databases do not have a relational architecture, most of...

I was under the assumption that DECS is installed with the rest of Domino Server. It's only loaded when you ask for it. Either that or it's on the CDs. Sorry it's a bit of a lame reply Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.