If it's all just in HTML then google or live search are your best options. You're only really going to improve on that if you build a full application rather than just the website. It's a lot more...

Hi Rob,

First off I need to know how you are storing the trainer details, are they in text, xml, html or a database (Access, MySQL, SQL Server etc)

If you want to put them in a database then...

It's definately Oracle. The first statement there is not actually valid, it's just describing the existing table for you The next one creates an incrementing sequence, however I would never use a...

You haven't included a control in your project that isn't available on the target machine?

Class modules are used to define objects. They can be very usefule to encapsulate a lot of related information. I suggest you look into object oriented programming to learn more about them. Forms...

The easiest way is to use the IsNumeric function

If IsNumeric(Form1.txtA.Text) Then

or see if the output from the Val function matches the text

If CStr(Val(Form1.txtA.Text)) =...

Hi Smiles,

First of all, you have created a function with no return value and you are not using the return anyway. VB allows you to do that but you shouldn't anyway. Change the funtion header to...

Firstly have you checked that the connection is being established correctly, secondly what is the error

This is just the declaration of a windows API call. The library is gdi32 (usually found at c:\windows\system32\gdi32.dll) and contains a number of functions usable within your code. One of these...

If you don't want to use a control (I never use one) then simply add Microsoft ActiveX Data Objects 2.1 Library in references. Then use the ADODB.Connection and ADODB.Recordset objects.

See here...

Use the onClick event of the radio button

see here

http://www.w3schools.com/htmldom/event_onclick.asp

I'm assuming you're referring to the exe file produced when you compile your project. The project can be given an icon in the project properties.

You are absolutely correct, fixed arrays cannot be assigned as a whole but dynamic arrays can. If you wish to assign a fixed array you have to do it one element at a time.

HTML documents these days are just XML using one of the HTML DTD's. Fully formed XML HTML documents use the XHTML DTD's, while the HTML 4 documents use non standard things, like no end tags on some...

heres some of the basics for option 2 (option 1 requires you to parse the XML document with whatever you wish to use). Note depending on how flexible the format is you may have to be a lot more...

instr can be used for both your problems.

Syntax: INSTR([start], fullstring, findstring, [compare])

start is an optional integer parameter that specifies which character to start the search at...

Or you could determine what doctype the html uses (xhtml strict would be ideal) and use an XML parser to cycle through the nodes.

Having said that if the html is always that simple the instr and...

I'm not going to do this for you but I will give you some starters

1. You don't need a function as using the - operator returns the answer in days: returndate - duedate > 7

2. For the first...

The main problem with this sort of thing is asp is that you don't have data types for variables. That means whenever you do a compare to determine which radio button to select you must cast the...

I don't actually know for sure but if I recall it's something like this. It takes a best guess based upon two factors, heirarchy and position on the form. So at the top level it will cycle through...

That looks like VB.Net code, I think you need to get over there to get those guys to answer, or better yet get a mod to move this one.

Sorry, but if I get it wrong it won't help you any :)

Cheers JB, beaten to it again

The way we always did it was to start from the last control on the form and enter 0 for the table order. By doing this any control currently set to 0 gets increased...

You're going to have to source the list from somewhere, ideally this would be a web service, but I haven't managed to find one yet :(

edit - drat, beaten to it!

edit again - found this one
...

Hopefully this gives you an idea :)

If you are looking to output multiple tables then the best way is to use two nested For Next loops, the outer one having an iteration for each table (eg 1...

You might want to post a link that isn't to a mods only forum

You have to write javascript on the buttons click event to set the checkbox. As well as this the checkbox should be disabled like this
<input type="checkbox" id="yourname" name="yourname" value="1"...

Are you actually saying you don't want to use ActiveX to do it? because uploads can be done without that by using an input of type="file" and a form enctype="multipart/form-data".

Doing this...

I don't personally use Crystal so I can't help you with that one. I tend to output to an office application, rtf or pdf. As for printing a form, do you just want to print out the image or present...

Str is you string variable, a string is an object with a number of properties and methods, one of which is replace. The messy looking first parameter to replace is a regular expression in javascript...

javascript doesn't have a native trim function, however this way does work

var trimmed = str.replace(/^\s+|\s+$/g, '');

Unfortunately SHBrowseForFolder doesn't have that capability, you could always write your own using the drive and directory controls.

1. If you are concerned about a security issue with authentication details you should limit access to the user table to the authentication and new user routines and use a view which exludes these...

First off if you want to run it on a timer use the timer control, then set the interval to 100ms and call the code that looks for the file in the timer event.

Try that out and get back to me with...

You can get more controls in VB6 by adding them from the tools menu. I don't have the application in front of me at the moment but it will be the menu item next to references. You can also build...

By tabs do you mean
1. Tab order - the order the fields are selected when pressing the tab key
2. Tables of data
3. Cigarettes

Assuming you still have the text file with the computer names in it you need to use my bit of code in the .vbs file


Set objFs = CreateObject("Scripting.FileSystemObject")
Set objFile =...

DTS - Data Transformation Services
It ships with SQL Server since version 7, it can be used for a number of tasks including moving large volumes of data around and backing up databases. You can...

Try this

Private Sub EMail_Click()

Dim objXL As Excel.Application
Dim objWB As Excel.Workbook

DoCmd.OutputTo acOutputForm, "frmGlobalAdjustment", _
acFormatXLS,...

Include a reference in your project to the Microsoft Word object library, then use the word object to open the document and interact with it

You would be better off using SQL server utilities for backup and restore, You could probably build a DTS package to perform the operation for you.