User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 403,087 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,144 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Showing results 1 to 40 of 114
Search took 0.01 seconds.
Posts Made By: davidcairns
Forum: Database Design Jul 3rd, 2007
Replies: 4
Views: 929
Posted By davidcairns
Re: want a search facility

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...
Forum: Database Design Jul 2nd, 2007
Replies: 4
Views: 929
Posted By davidcairns
Re: want a search facility

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 what...
Forum: Oracle Jun 28th, 2007
Replies: 4
Views: 4,276
Posted By davidcairns
Re: how to create an auto-increment process?

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...
Forum: Visual Basic 4 / 5 / 6 Jun 28th, 2007
Replies: 4
Views: 6,324
Posted By davidcairns
Re: VB Runtime Error 429

You haven't included a control in your project that isn't available on the target machine?
Forum: Visual Basic 4 / 5 / 6 Jun 27th, 2007
Replies: 6
Views: 1,117
Posted By davidcairns
Re: .vb and .bas beginner

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...
Forum: Visual Basic 4 / 5 / 6 Jun 26th, 2007
Replies: 6
Views: 1,117
Posted By davidcairns
Re: .vb and .bas beginner

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)) = Form1.txtA.Text Then
Forum: Visual Basic 4 / 5 / 6 Jun 26th, 2007
Replies: 6
Views: 1,117
Posted By davidcairns
Re: .vb and .bas beginner

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...
Forum: Visual Basic 4 / 5 / 6 Jun 6th, 2007
Replies: 9
Views: 1,110
Posted By davidcairns
Re: ADO programming

Firstly have you checked that the connection is being established correctly, secondly what is the error
Forum: Visual Basic 4 / 5 / 6 Jun 6th, 2007
Replies: 3
Views: 443
Posted By davidcairns
Re: Explaining A few lines of code

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...
Forum: Visual Basic 4 / 5 / 6 Jun 6th, 2007
Replies: 9
Views: 1,110
Posted By davidcairns
Re: ADO programming

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...
Forum: ASP Jun 4th, 2007
Replies: 1
Views: 795
Posted By davidcairns
Re: redirect asp pages with the help of asp pages...

Use the onClick event of the radio button

see here

http://www.w3schools.com/htmldom/event_onclick.asp
Forum: Visual Basic 4 / 5 / 6 May 31st, 2007
Replies: 2
Views: 2,156
Posted By davidcairns
Re: File association in vb6

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.
Forum: Visual Basic 4 / 5 / 6 May 30th, 2007
Replies: 1
Views: 1,045
Posted By davidcairns
Re: Assigning Arrays

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.
Forum: Visual Basic 4 / 5 / 6 May 15th, 2007
Replies: 8
Views: 1,036
Posted By davidcairns
Re: Manipulating a String that contains HTML source

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...
Forum: Visual Basic 4 / 5 / 6 May 15th, 2007
Replies: 8
Views: 1,036
Posted By davidcairns
Re: Manipulating a String that contains HTML source

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...
Forum: Visual Basic 4 / 5 / 6 May 15th, 2007
Replies: 3
Views: 1,112
Posted By davidcairns
Re: Help with MS HTML Object Reference

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 (the...
Forum: Visual Basic 4 / 5 / 6 May 15th, 2007
Replies: 8
Views: 1,036
Posted By davidcairns
Re: Manipulating a String that contains HTML source

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...
Forum: Oracle May 14th, 2007
Replies: 3
Views: 1,532
Posted By davidcairns
Re: Oracle Help Needed

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 part...
Forum: ASP May 6th, 2007
Replies: 2
Views: 1,955
Posted By davidcairns
Re: Arrrgggghhhh... Radio Buttons are the bain of my life! Can someone please help.

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...
Forum: Visual Basic 4 / 5 / 6 May 4th, 2007
Replies: 8
Views: 821
Posted By davidcairns
Re: How the hell

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...
Forum: Visual Basic 4 / 5 / 6 May 4th, 2007
Replies: 4
Views: 797
Posted By davidcairns
Re: Help ReadAllText at specified interval

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 :)
Forum: Visual Basic 4 / 5 / 6 May 4th, 2007
Replies: 8
Views: 821
Posted By davidcairns
Re: How the hell

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 by...
Forum: JavaScript / DHTML / AJAX May 3rd, 2007
Replies: 6
Views: 3,418
Posted By davidcairns
Re: List Of countries in the world

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...
Forum: Visual Basic 4 / 5 / 6 May 3rd, 2007
Replies: 1
Views: 1,612
Posted By davidcairns
Re: Multiplication table

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 times,...
Forum: DaniWeb Community Feedback May 3rd, 2007
Replies: 123
Views: 9,381
Posted By davidcairns
Re: Rep Points.

You might want to post a link that isn't to a mods only forum
Forum: HTML and CSS May 3rd, 2007
Replies: 2
Views: 2,543
Posted By davidcairns
Re: Button Select Checkbox

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"...
Forum: JavaScript / DHTML / AJAX May 3rd, 2007
Replies: 4
Views: 1,978
Posted By davidcairns
Re: Upload file without User Interaction

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...
Forum: Visual Basic 4 / 5 / 6 May 3rd, 2007
Replies: 3
Views: 1,039
Posted By davidcairns
Re: connecting vb with word ....

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...
Forum: JavaScript / DHTML / AJAX May 3rd, 2007
Replies: 5
Views: 840
Posted By davidcairns
Re: help me please

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...
Forum: JavaScript / DHTML / AJAX May 3rd, 2007
Replies: 5
Views: 840
Posted By davidcairns
Re: help me please

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

var trimmed = str.replace(/^\s+|\s+$/g, '');
Forum: Visual Basic 4 / 5 / 6 May 3rd, 2007
Replies: 4
Views: 700
Posted By davidcairns
Re: Creating Directories

Unfortunately SHBrowseForFolder doesn't have that capability, you could always write your own using the drive and directory controls.
Forum: Database Design May 3rd, 2007
Replies: 3
Views: 934
Posted By davidcairns
Re: I need some advice

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...
Forum: Visual Basic 4 / 5 / 6 May 3rd, 2007
Replies: 4
Views: 797
Posted By davidcairns
Re: Help ReadAllText at specified interval

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...
Forum: Visual Basic 4 / 5 / 6 May 3rd, 2007
Replies: 1
Views: 363
Posted By davidcairns
Re: Some help please

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...
Forum: Visual Basic 4 / 5 / 6 May 3rd, 2007
Replies: 8
Views: 821
Posted By davidcairns
Re: How the hell

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
Forum: Visual Basic 4 / 5 / 6 May 3rd, 2007
Replies: 4
Views: 969
Posted By davidcairns
Re: Help with fstream operations.

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 =...
Forum: Visual Basic 4 / 5 / 6 May 2nd, 2007
Replies: 3
Views: 1,723
Posted By davidcairns
Re: VB backup and restore program

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 also...
Forum: Visual Basic 4 / 5 / 6 May 2nd, 2007
Replies: 1
Views: 2,165
Posted By davidcairns
Re: copy excel file

Try this

Private Sub EMail_Click()

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

DoCmd.OutputTo acOutputForm, "frmGlobalAdjustment", _
acFormatXLS,...
Forum: Visual Basic 4 / 5 / 6 May 2nd, 2007
Replies: 3
Views: 1,039
Posted By davidcairns
Re: connecting vb with word ....

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
Forum: Visual Basic 4 / 5 / 6 May 2nd, 2007
Replies: 3
Views: 1,723
Posted By davidcairns
Re: VB backup and restore program

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.
Showing results 1 to 40 of 114

 
All times are GMT -4. The time now is 1:33 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC